Not sure where to report this, so, please someone reply so I can submit the corrected files.
I downloaded the latest version of Bacula, and compiled from source. After running the various scripts to create the MySQL databases, I got a few errors, but ignored them at first. Then, when trying to run the initial backup that comes pre-configured in the configs, I got this error: 27-Jan 11:39 d8-dir JobId 0: Fatal error: sql_create.c:86 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate,ClientId,Comment) VALUES ('BackupClient1.2016-01-27_11.39.03_06','BackupClient1','B','I','C','2016-01-27 11:39:01',1453912741,1,'') failed. ERR=Table 'bacula.Job' doesn't exist Turns out, the errors (listed below) were causing the corresponding tables to not be created. ERROR 1067 (42000) at line 91: Invalid default value for 'CleaningDate' ERROR 1067 (42000) at line 111: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 145: Invalid default value for 'SchedTime' ERROR 1067 (42000) at line 187: Invalid default value for 'Date' ERROR 1067 (42000) at line 201: Invalid default value for 'CreateTime' ERROR 1067 (42000) at line 225: Invalid default value for 'FirstWritten' ERROR 1067 (42000) at line 321: Invalid default value for 'Time' The problem is the default value for certain DATETIME fields. To fix the issue, I did a find and replace over the make_mysql_tables file: s/DATETIME DEFAULT 0/DATETIME/g Then, I dropped the database, and re-ran these scripts: ./create_mysql_database ./grant_mysql_privileges ./make_mysql_tables The database was re-created, and all is well. As a side note, the instructions for creating the MySQL database is ... well ... lacking. If this was hosted on Github, I would just fork it, add it for you guys, and then submit a merge request. But I don't know how to do that on Sourceforge. At anyrate, Please advise where I send this so that it can be fixed. (I'm happy to submit my files as a patch - I already did the work!). Michael Munger, dCAP, MCPS, MCNPS, MBSS High Powered Help, Inc. Microsoft Certified Professional Microsoft Certified Small Business Specialist Digium Certified Asterisk Professional mich...@highpoweredhelp.com ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users