Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-29 Thread Ian Douglas
On Sunday, 18 March 2018 5:41:14 PM SAST Phil Stracchino wrote: > There's two issues here: > 1. MySQL has historically allowed columns to be declared NOT NULL > without a DEFAULT. This is wrong and has always been wrong (because > you're telling MySQL a column may not be left empty, then not tel

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Phil Stracchino
On 03/18/18 12:14, Josip Deanovic wrote: > On Sunday 2018-03-18 11:41:14 Phil Stracchino wrote: >> As Josip alreadp pointed out, the issue here is not the Bacula update, >> it is the MariaDB update. While MariaDB is diverging from MySQL, >> MariaDB 10.2 does follow the stricter SQL compliance of M

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Josip Deanovic
On Sunday 2018-03-18 11:41:14 Phil Stracchino wrote: > As Josip alreadp pointed out, the issue here is not the Bacula update, > it is the MariaDB update. While MariaDB is diverging from MySQL, > MariaDB 10.2 does follow the stricter SQL compliance of MySQL 5.7. The same goes for Percona MySQL ser

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Phil Stracchino
On 03/18/18 07:29, Erik P. Olsen wrote: > My installation is the following: > > Fedora 27 fully upgraded > mariadb-10.2.13-2.fc27.x86_64 > bacula-director-9.0.6-2.fc27.x86_64 > > I've just upgraded Fedora from 26 to 27 which also did an upgrade of bacula > from 7.4.7 to > 9.0.6 and therefore I r

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Josip Deanovic
On Sunday 2018-03-18 14:35:20 Erik P. Olsen wrote: > Thanks a lot, that did it! I added the statement to my.cnf assuming it > will stick forever. I didn't check sql_mode because I don't know how to > do it. But I suppose it doesn't matter now that bacula works as a dream > :-) You are welcome. Yo

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Erik P. Olsen
On 2018-03-18 at 12:38:39 Josip Deanovic wrote: > On Sunday 2018-03-18 12:29:42 Erik P. Olsen wrote: > > My installation is the following: > > > > Fedora 27 fully upgraded > > mariadb-10.2.13-2.fc27.x86_64 > > bacula-director-9.0.6-2.fc27.x86_64 > > > > I've just upgraded Fedora from 26 to 27 wh

Re: [Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Josip Deanovic
On Sunday 2018-03-18 12:29:42 Erik P. Olsen wrote: > My installation is the following: > > Fedora 27 fully upgraded > mariadb-10.2.13-2.fc27.x86_64 > bacula-director-9.0.6-2.fc27.x86_64 > > I've just upgraded Fedora from 26 to 27 which also did an upgrade of > bacula from 7.4.7 to 9.0.6 and there

[Bacula-users] Issue upgrading to 9.0.6 from 7.4.7

2018-03-18 Thread Erik P. Olsen
My installation is the following: Fedora 27 fully upgraded mariadb-10.2.13-2.fc27.x86_64 bacula-director-9.0.6-2.fc27.x86_64 I've just upgraded Fedora from 26 to 27 which also did an upgrade of bacula from 7.4.7 to 9.0.6 and therefore I ran update_bacula_tables with success, so everything shoul