You didn’t read the entire thing.
I already fixed it. The problem is the default values for DATETIME in the
provided SQL statements. “0” is not a valid value for DATETIME.
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<mailto:mich...@highpoweredhelp.com>
From: Radosław Korzeniewski [mailto:rados...@korzeniewski.net]
Sent: Thursday, January 28, 2016 12:38 PM
To: Michael Munger
Cc: bacula-users@lists.sourceforge.net
Subject: Re: [Bacula-users] bacula.Job does not exist
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<mailto: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<mailto: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<mailto:Bacula-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/bacula-users
--
Radosław Korzeniewski
rados...@korzeniewski.net<mailto: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
