The default SQL mode in 5.7 is "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION".
These are good defaults, so I recommend not changing the default SQL mode for the installation, but rather setting a suitable SQL mode in bacula sessions, using SET SESSION sql_mode = '...'. I also recommend that as many of the modes are kept and that only those causing problems are removed. See http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html for more info. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1577858 Title: bacula mysql support requires server configuration changes To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/1577858/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
