Hello,
You need to recreate your catalog database. You can't ignore any errors. If
some errors ocurr you need to resolve it first.
best regards
2016-01-27 17:55 GMT+01:00 Michael Munger <mich...@highpoweredhelp.com>:
> 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
>
--
Radosław Korzeniewski
rados...@korzeniewski.net
------------------------------------------------------------------------------
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
