On Wed, 1 Aug 2018 12:59:43 +0200 Kern Sibbald wrote: > Please note that we do not officially support > MariaDB -- one prior version has some serious > problems falsely detecting deadlocks. Bacula works > perfectly well with all "out of the box" > installations of MySQL. > > Concerning the error message you are getting, either > this is a MariaDB problem or you are not running > MySQL out of the box
I have MariaDB installed from the official openSUSE Leap 15.0 repository. I suppose that qualifies as "out of the box" MariaDB (but not MySQL?) installation? I really don't know much about the differences between the two. > and you have applied some stricter SQL requirements > which require default values for DATETIME fields. Personally I have not done anything at all. As mentioned I simply have what comes with openSUSE. I am not a DB expert at all. So far I have been using Bacula 7.4.2 with MariaDB for years with zero issues. But the problems began after updating Leap 42.3 to Leap 15.0. > Either remove those requirements (I forget exactly > what they are but they have been reported numerous > times on this list), or you must explicitly define > default values for those fields. Note if you do > define default values, you *must* ensure that the > default value is stored as a zero in the database > (probably 1 Jan 1970). This value of 0 is used by > Bacula in certain cases for Volume table > references. If the value does not default to 0 > Bacula will fail in some places. How do I do all this please? Can you please provide steps as for a layman which ensure that Bacula will work correctly (without failing anywhere)? -OR- (if above is not possible/recommended) Can you provide steps to safely migrate everything to PosgreSQL (preserving current data)? -- George ------------------------------------------------------------------------------ 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
