Hello,
Maybe you can get some help from the list or from bacula-devel. At this
time, I am not yet equipped or ready to start trying to support
MariaDB. It will happen sometime, but not just now. One of the big
problems for me is that it seems it is impossible (at least on Ubuntu)
to have both installed on the same machine -- at least not out of the
box, and trying to switch from one to the other is a veritable
nightmare, because each package leaves little traces that confuse the other.
Best regards,
Kern
On 08/01/2018 05:11 PM, George Anchev wrote:
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
