Just a quick note to help narrowing this down: * I'm experiencing this "Field 'StartTime' doesn't have a default value" error on an openSUSE installation ever since it was upgraded to Leap 42.3 and Bacula 9. * The machine in question runs MySQL, not MariaDB, even though openSUSE has deprecated MySQL. * Getting MySQL to run caused a lot of pain, mostly related to systemd. * Your on your own with that. openSUSE answers all requests on that topic with: "We don't support MySQL - use MariaDB." * Luckily on that machine the "no default value" error only strikes when I try to label a new volume. * The few times this has occurred I fixed it by performing the failed database INSERT manually and adding explicit values for all the DATETIME fields.
All from memory. I'll gladly post details next time I get to the affected machine. HTH Tilman On Thu, Aug 2, 2018, at 15:18, Kern Sibbald wrote: > 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 -- Tilman Schmidt til...@imap.cc ------------------------------------------------------------------------------ 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
