Hi Erwan, Honestly, your problem has nothing to do with bacula, its purely database related.
First, if you insist on using mysql 8, you can't use the version you are using. You need at least Bacula Release 9.4.3. This is because you will need this bug fix. Change mysql my_bool to bool as it was removed from mysql - Done on May 2019 Second, the error bacula reported during insert "ERR=Field 'StartTime' doesn't have a default value" is because, previously mysql used to allow null dates. Current sql_mode don't allow that any more. Google on sql_mode and dates and you should get an idea on what to do that suites Gentoo. In short, your pains are all caused by mysql and require just mysql skills to resolve. Regards, William ________________________________________ From: Erwan RIGOLLOT <er...@rigollot.eu> 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'origine----- De : Erwan RIGOLLOT <er...@rigollot.eu> 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 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 will update a Bacula MySQL database from version 12-15 to 16 Depending on the current version of your catalog, you may have to run this script multiple times. Enter password: Enter password: Update of Bacula MySQL tables 15 to 16 succeeded. Enter password: So I try to do backup, and doesn't work : 28-nov. 16:13 obiwan-dir JobId 0: Fatal error: sql_create.c:84 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ('Backup-tardis.2019-11-28_16.13.50_03','Backup-tardis','B','I','C','2019-11-28 16:13:48',1574954028,5,'') failed. ERR=Field 'StartTime' doesn't have a default value I don't understand because the script update_mysql_tables remove default value ?!? Can you help me ? Thanks and have a good day ! -----Message d'origine----- De : William Muriithi <will...@perasotech.com> Envoyé : vendredi 22 novembre 2019 16:41 À : Erwan RIGOLLOT <er...@rigollot.eu>; bacula-users@lists.sourceforge.net Objet : Re: /usr/libexec/bacula/update_mysql_tables 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 Mariadb, which would be my advice as it don't change your plans at all. Also, change the sql mode to match that of earlier versions. Something like this "sql_mode = NO_ENGINE_SUBSTITUTION" Anyway, all this depends on whether you have a backup. Regard, William From: Erwan RIGOLLOT <er...@rigollot.eu> Sent: November 22, 2019 9:50 AM To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net> Subject: [Bacula-users] /usr/libexec/bacula/update_mysql_tables Hello, I have try to update bacula database after update Mysql (8.0.17) and bacula ( 9.0.8-r1). I have get this result and backup don't work .... : This script will update a Bacula MySQL database from version 12-15 to 16 Depending on the current version of your catalog, you may have to run this script multiple times. mysql: [Warning] Using a password on the command line interface can be insecure. mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1067 (42000) at line 3: Invalid default value for 'FirstWritten' ERROR 1060 (42S21) at line 4: Duplicate column name 'VolParts' ERROR 1067 (42000) at line 5: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 6: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 7: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 13: Invalid default value for 'StartTime' ERROR 1067 (42000) at line 14: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 15: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 16: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 17: Invalid default value for 'StartTime' ERROR 1067 (42000) at line 18: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 19: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 20: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 23: Invalid default value for 'LastWritten' ERROR 1067 (42000) at line 24: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 25: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 26: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 29: Invalid default value for 'SchedTime' Update of Bacula MySQL tables 15 to 16 succeeded. mysql: [Warning] Using a password on the command line interface can be insecure. Thanks, Erwan _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fbacula-users&data=02%7C01%7Cerwan%40rigollot.eu%7C06340a6e07e547bf5d6708d77419d87c%7C61b429f8f50a44a2aea1286497c97ee3%7C0%7C0%7C637105526664712506&sdata=DXR8lrMQmSt1ANkQ%2F1HO3GsWMErDp2ACr0urfEBBWMc%3D&reserved=0 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users