Hello,
Yes, I read the sentences with a problem, and suggested a resolution.
Nothing else.
If you have a patch which fix some bug then you need to report it at
http://bugs.bacula.org/ and attach your patch here. The users group is
dedicated to the support for user's problems.
I'm happy that you fixed the problem yourself. Keep going with Bacula!
best regards
2016-01-28 18:56 GMT+01:00 Michael Munger <mich...@highpoweredhelp.com>:
> 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
>
>
>
> *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>:
>
> 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
>
--
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
