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 = NO_ENGINE_SUBSTITUTION" Or sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" After that, is it better to delete database, restore and update again ? Thanks a lot -----Message d'origine----- De : William Muriithi <will...@perasotech.com> Envoyé : vendredi 10 janvier 2020 13:58 À : Wanderlei Huttel <wanderleihut...@gmail.com>; Erwan RIGOLLOT <er...@rigollot.eu> 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, 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 guess is very similar of > MySQL errors. Take a look in the link below: > https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fwanderleihuttel%2Fbacula-utils%2Fblob%2Fmaster%2Fdicas%2Fmysql_sql-mode.md&data=02%7C01%7Cerwan%40rigollot.eu%7Cede26fc488cf42ed9e1b08d795ccb7dd%7C61b429f8f50a44a2aea1286497c97ee3%7C0%7C1%7C637142578808408610&sdata=T9pBeTToWlSd2KQjybEhwR9aO9sCSWsildlXngSevd0%3D&reserved=0 Surprised he is still using the default sql_mode. I had mentioned it will never work with this mode back on November. Using the mode myself. "sql_mode = NO_ENGINE_SUBSTITUTION" Regards, William _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
