From a706f71a12baba37ac6a3648cf22c87d6342bd67 Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Thu, 3 Aug 2017 12:38:41 +0200 Subject: [PATCH] Add doc about TIMESTAMP modes in MySQL --- docs/manuals/en/main/mysql.tex | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/docs/manuals/en/main/mysql.tex b/docs/manuals/en/main/mysql.tex index 4da2bd37..bc6ccb44 100644 --- a/docs/manuals/en/main/mysql.tex +++ b/docs/manuals/en/main/mysql.tex @@ -316,3 +316,11 @@ Bacula otherwise you are likely to get bizarre failures. If you install from rpms and you upgrade MySQL, you must also rebuild Bacula. You can do so by rebuilding from the source rpm. To do so, you may need to modify the bacula.spec file to account for the new MySQL version. + +\section{MySQL Configuration Caution} +\index[general]{MySQL Caution} +Bacula requires that at least one of the TIMESTAMP fields in the +database schema to have a valid value of zero. If you turn on the +{\bf SQL\_MODE} {\bf STRICT\_ALL\_TABLES}, you must be sure that you +turn off the {\bf NO\_ZERO\_DATA} and the {\bf NO\_ZERO\_IN\_DATE} +restrictions or Bacula will not function correctly. -- 2.39.5