Re: [Bacula-devel] Ubuntu 16: make_mysql_tables misbehavior "Invalid default value for"

[Kern S. <ke...@si...>]

For Bacula, the solution is even simpler, simply delete or the DEFAULT 
0.  Bacula does use the value 0, which MySQL unsuccessfully attempts to 
outlaw, and it is absolutely critical to use with Bacula, but Bacula 
will set it itself even if it is not the default value.


On 06/15/2016 10:56 PM, Phil Stracchino wrote:
> On 06/15/16 16:49, Heitor Faria wrote:
>> Hello, Kern,
>>
>> Another Ubuntu 16 issue is running the make_mysql_tables results in error:
>>
>> ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate'
>> ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime'
>> ERROR 1067 (42000) at line 145: Invalid default value for 'SchedTime'
>> ERROR 1067 (42000) at line 187: Invalid default value for 'Date'
>> ERROR 1067 (42000) at line 201: Invalid default value for 'CreateTime'
>> ERROR 1067 (42000) at line 225: Invalid default value for 'FirstWritten'
>> ERROR 1067 (42000) at line 321: Invalid default value for 'Time'
>>
>> The workaround for this is:
>>
>> sed -i s/'DATETIME DEFAULT 0'/'DATETIME'/g /etc/bacula/scripts/make_mysql_tables
> OR, you could replace the 0 with a valid DATETIME default value such as
> '0000-00-00 00:00:00' or '01-01-1970 00:00:00' (the Unix epoch), which
> would be a more proper fix than just removing the default.  MySQL
> started enforcing valid defaults for DATETIME in the 5.6 branch.
>
>