Ubuntu
bacula package

  1. Bug #1577858
  2. Comment #1

Comment 1 for bug 1577858

Revision history for this message
Norvald H. Ryeng (nryeng) wrote :

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.