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. > > ------------------------------------------------------------------------------ What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://pubads.g.doubleclick.net/gampad/clk?id=1444514421&iu=/41014381 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
