[pkg-bacula-devel] [pkg-bacula-commits] [bacula] 01/01: restore entries for version 9.0.4+dfg-3 to debian/changelog

[Sven Hartge]

On 05.11.2017 21:24, Sven Hartge wrote:

> I remember faintly there was a problem with MariaDB 10.2 and Bacula.
> Something about it being stricter for some Date or NULL values, can't
> remember fully right now.

Ah, here:

Message-ID: <2f5c61e2-b960-3ef7-aca6-d16df2ac49c2 at caerllewys.net>
Date: Fri, 1 Sep 2017 18:51:19 -0400
List: bacula-users
Author: Phil Stracchino <phils at caerllewys.net>

This is correct, it is not a MariaDB vs. MySQL issue, it is a
MariaDB/MySQL *version* issue.  MySQL 5.6 and older allowed DATETIME and
TIMESTAMP fields to have the value 0, which is technically not valid for
those datatypes.  MySQL 5.7 and MariaDB 10.2, as configured out of the
box, enforce validity of DATETIME and TIMESTAMP types, and do not allow
them to be 0 or to contain zero year, month or day fields (since there
is no year 0, month 0, or day 0).[1]


There is a simple configuration fix for this that does not require any
changes to Bacula or your Catalog:

1.  Log into your database.
2.  SELECT @@GLOBAL.SQL_MODE;
3.  SET GLOBAL SQL_MODE='new value';

...Where you get the new SQL_MODE by REMOVING the modes NO_ZERO_DATE and
NO_ZERO_IN_DATE from whatever SQL_MODE you got in step 2.  Or, you can
skip 2 and just set SQL_MODE to something reasonable like
'STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'.

Make sure that you set this both in the running database instance and in
your configuration files, and of course do the same on any replication
slaves.  Make sure you check ALL POSSIBLE config files for the SQL_MODE
setting.  Sometimes you will find it in unexpected places like <data
directory>/auto.cnf.  For safety, restart your database and make certain
that after restart, SQL_MODE is set to what you want it to be.

Once you have done this, you should have no further problems with the
Bacula catalog and zero values.





-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-bacula-devel/attachments/20171105/311c9e71/attachment.sig>