Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread William Muriithi
Happy new year, > First of all, MariaDB is not very recommended for using with Bacula, but you > can use for you own risk. He can't use mysql 8 with the version of bacula he is deploying, so this instruction will lead him to other issues > This error is it looks is caused by SQL_MODE, that I g

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Josh Fisher
From: Erwan RIGOLLOT mailto:er...@rigollot.eu>> Sent: December 23, 2019 9:41 AM To: bacula-users@lists.sourceforge.net <mailto:bacula-users@lists.sourceforge.net> Subject: Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Hi all, Anyone can help me

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Erwan RIGOLLOT
illiam Muriithi' ; 'Wanderlei Huttel' Cc : 'bacula-users@lists.sourceforge.net' Objet : RE: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Oups, I'm sorry. I check the default conf, and I have this : sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION&qu

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Erwan RIGOLLOT
lei Huttel Cc : bacula-users@lists.sourceforge.net Objet : RE: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Thanks for your help. I am sorry, I have little difficult with english. Today, I have install MariaDB without any change of configuration. In november, I have understand, perhap

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Erwan RIGOLLOT
William Muriithi Envoyé : vendredi 10 janvier 2020 13:58 À : Wanderlei Huttel ; Erwan RIGOLLOT Cc : bacula-users@lists.sourceforge.net Objet : Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Happy new year, > First of all, MariaDB is not very recommended for using with Bacula, bu

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Wanderlei Huttel
ns are all caused by mysql and require just mysql skills > to resolve. > > Regards, > William > > > From: Erwan RIGOLLOT > Sent: December 23, 2019 9:41 AM > To: bacula-users@lists.sourceforge.net > Subject: Re: [Bacula-users]

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2020-01-10 Thread Erwan RIGOLLOT
lls to resolve. Regards, William ____________________ From: Erwan RIGOLLOT Sent: December 23, 2019 9:41 AM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Hi all, Anyone can help me ? Thanks Erwan -Message d&

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2019-12-23 Thread William Muriithi
s@lists.sourceforge.net Subject: Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Hi all, Anyone can help me ? Thanks Erwan -Message d'origine- De : Erwan RIGOLLOT Envoyé : jeudi 28 novembre 2019 16:18 À : bacula-users@lists.sourceforge.net Objet : Re: [Bacula-users] /us

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2019-12-23 Thread Erwan RIGOLLOT
Hi all, Anyone can help me ? Thanks Erwan -Message d'origine- De : Erwan RIGOLLOT Envoyé : jeudi 28 novembre 2019 16:18 À : bacula-users@lists.sourceforge.net Objet : Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Hi William and all, I have a catalog backup b

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2019-11-28 Thread Erwan RIGOLLOT
Hi William and all, I have a catalog backup before update. So I have try this "sql_mode = NO_ENGINE_SUBSTITUTION" because I would like to keep version of my distribution (gentoo). (But if i have to do different, i will do). The script /usr/libexec/bacula/update_mysql_tables run good: This script

Re: [Bacula-users] /usr/libexec/bacula/update_mysql_tables

2019-11-22 Thread William Muriithi
Hi Erwan, Hope you had made a catalog backup before schema upgrade. You can't use bacula 9.0 with mysql 8.   mysql made some change that were only fixed in a later bacula version, think bacula 9.2. So if you have to use mysql 8, please use the latest bacula binaries. Alternatively, use Mari