On 05.05.2018 21:07, Ken Mandelberg wrote: > All is working now, By the way, I wonder if the sql-mode change was > necessary, the update_mysql_table has a whole bunch of DROP DEFAULT for > the time and date columns for Mysql 5.7.
All I can say is: the packages Ubuntu pulled in from Debian are not prepared for MySQL 5.7 or MariaDB 10.2, because Debian does not ship MySQL anymore and MariaDB is still on 10.1, the packages do nothing to adapt themselves or the SQL server. So no wonder you ran into trouble during the upgrade, if Ubuntu did nothing to configure the database you use correctly for Bacula. As soon as Debian decides to upgrade to MariaDB 10.2, the Bacula maintainers in Debian (Carsten and me) need to evaluate on how to proceed to avoid the problems you had with the database. Hopefully Bacula itself will be adapted then, so we don't need to change the global mode of the SQL server, which may be problematic if it is shared with other databases instead of being exclusive for Bacula. Grüße, Sven. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
