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
michael AT highpoweredhelp DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users