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' <will...@perasotech.com>; Wanderlei Huttel <wanderleihut...@gmail.com> 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, 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%2Fgith > ub.com%2Fwanderleihuttel%2Fbacula-utils%2Fblob%2Fmaster%2Fdicas%2Fmysq > l_sql-mode.md&data=02%7C01%7Cerwan%40rigollot.eu%7Cede26fc488cf42e > d9e1b08d795ccb7dd%7C61b429f8f50a44a2aea1286497c97ee3%7C0%7C1%7C6371425 > 78808408610&sdata=T9pBeTToWlSd2KQjybEhwR9aO9sCSWsildlXngSevd0%3D&a > mp;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
