MySQL schema is missing default value

[jesusch]

While trying to setup a fresh director database I go the following error:
ERROR 1067 (42000) at line 33: Invalid default value for 'change_time'
which is caused by this line:
https://github.com/Icinga/icingaweb2-module-director/blob/master/schema/mysql.sql#L41

In the according mysql schema upgrade you did introduce a default:

icingaweb2-module-director/schema/mysql-migrations/upgrade_163.sql

Line 9 in 2fc79e1

MODIFY change_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

I've executed this on a mysql 5.6.10

[Thomas-Gelf]

Thanks for reporting this, to me this looks like a bug in your MySQL version. We'll figure out how to work around this, what operating system (and version) are you using?

[Thomas-Gelf]

Oh, sorry - now I see. You're right, the linked fix addressed only the migration and not the schema file itself. Will be fixed!

[Thomas-Gelf]

This relates to #1840, the fix for v5.6 in 2fc79e1 misses director_activity_log.change_time. The fix involves no schema migration, therefore it qualifies for v1.7.2. Users upgrading from former versions are fine. New Director setups on old systems running MySQL v5.6 are affected.

[Thomas-Gelf]

Fix has been pushed, thanks for reporting this.