Hello, thank you very much for your patch.
What mysql version are you using? Also, I would like to point out that MySQL is deprecated as catalog backend since Bareos 19. Please do not use mysql in new installations, use postgresql instead. See https://docs.bareos.org/IntroductionAndTutorial/InstallingBareos.html?highlight=mysql#decide-about-the-database-backend Am 10.06.21 um 15:44 schrieb khvalera: > Fix: backup-dir JobId 0: Fatal error: cats/sql_create.cc:96 Create DB Job > record INSERT INTO Job > (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ( > ... > четверг, 10 июня 2021 г. в 14:23:47 UTC+3, khvalera: > > > четверг, 10 июня 2021 г. в 14:23:47 UTC+3, khvalera: > > Made a patch for the mysql.sql file: > > четверг, 10 июня 2021 г. в 12:05:16 UTC+3, khvalera: > > bareos 20.0.1 > > четверг, 10 июня 2021 г. в 12:04:27 UTC+3, khvalera: > > When executing */usr/lib/bareos/scripts/make_bareos_tables --user > root --password*, I > get the following error: > > > ERROR 1005 (HY000) at line 31: Can't create table `bareos`.`File` > (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 55: Can't create table > `bareos`.`RestoreObject` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 104: Can't create table `bareos`.`Job` > (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 178: Can't create table > `bareos`.`LocationLog` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 199: Can't create table > `bareos`.`JobMedia` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 215: Can't create table > `bareos`.`Media` (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 267: Can't create table > `bareos`.`Pool` (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 310: Can't create table `bareos`.`Log` > (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 319: Can't create table > `bareos`.`BaseFiles` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1146 (42S02) at line 328: Table 'bareos.BaseFiles' doesn't > exist > ERROR 1005 (HY000) at line 378: Can't create table > `bareos`.`Quota` (errno: 150 "Foreign > key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 385: Can't create table > `bareos`.`NDMPLevelMap` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 393: Can't create table > `bareos`.`NDMPJobEnvironment` (errno: > 150 "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 401: Can't create table > `bareos`.`DeviceStats` (errno: 150 > "Foreign key constraint is incorrectly formed") > ERROR 1005 (HY000) at line 417: Can't create table > `bareos`.`JobStats` (errno: 150 > "Foreign key constraint is incorrectly formed") > Creation of Bareos MySQL tables succeeded. > > -- > You received this message because you are subscribed to the Google Groups > "bareos-devel" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > bareos-devel+unsubscr...@googlegroups.com > <mailto:bareos-devel+unsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bareos-devel/63bfae92-60d4-4af1-a52d-c81b3eda9d1fn%40googlegroups.com > <https://groups.google.com/d/msgid/bareos-devel/63bfae92-60d4-4af1-a52d-c81b3eda9d1fn%40googlegroups.com?utm_medium=email&utm_source=footer>. -- Mit freundlichen Grüßen Philipp Storz philipp.st...@bareos.com Bareos GmbH & Co. KG Phone: +49 221 63 06 93-92 http://www.bareos.com Fax: +49 221 63 06 93-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz -- You received this message because you are subscribed to the Google Groups "bareos-devel" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-devel+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-devel/3f112de1-5888-2daa-e708-e031782be3c0%40bareos.com.
