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

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

2020-01-10 Thread Josh Fisher
On 1/10/2020 6:34 AM, Wanderlei Huttel wrote: Hello Erwan First of all, MariaDB is not very recommended for using with Bacula, but you can use for you own risk. This error is it looks is caused by SQL_MODE, that I guess is very similar of MySQL errors. Take a look in the link below:

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

2020-01-10 Thread Erwan RIGOLLOT
Sorry for the 3 mails. I have check in, I can install on Gentoo Bacula-9.4.4-r2 but it's on testing state. It would be better to install this package with Mysql 8 ? Regards, -Message d'origine- De : Erwan RIGOLLOT Envoyé : vendredi 10 janvier 2020 14:25 À : 'William Muriithi' ;

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

2020-01-10 Thread Erwan RIGOLLOT
Oups, I'm sorry. I check the default conf, and I have this : sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" What should I do ? Thanks -Message d'origine- De : Erwan RIGOLLOT Envoyé : vendredi 10 janvier 2020 14:22 À : 'William Muriithi' ; Wanderlei Huttel Cc :

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

2020-01-10 Thread Erwan RIGOLLOT
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, perhaps by mystake, I have to change SQL mode only for mysql. So, you suggest me to configure this in MariaDB: "sql_mode =

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

2020-01-10 Thread Wanderlei Huttel
Hello Erwan First of all, MariaDB is not very recommended for using with Bacula, but you can use for you own risk. This error is it looks is caused by SQL_MODE, that I guess is very similar of MySQL errors. Take a look in the link below:

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

2020-01-10 Thread Erwan RIGOLLOT
Hi all, Happy to new year! So, I have trie with Mariadb Server version: 10.2.29-MariaDB-log. I have restore bacula database before all my update and run update_mysql_tables with success. But, when I start a backup I get this message again : Fatal error: sql_create.c:84 Create DB Job record

[Bacula-users] Issue with config setting "Max Virtual Full Interval"

2020-01-10 Thread Shaligram Bhagat, Yateen (Nokia - IN/Bangalore)
Hi all, I am using bacula v 9.4.4 on Centos 6.4. for disk file based backup. The backup scheme is weekdays incremental and virtual full back-up on Sunday. Job { Name = "blhwsync11" Max Virtual Full Interval = 7 days Accurate = no# With Accurate = yes, even file deletions, move etc