I am running Bacula version 2.1.28 (built from sources) on CentOS 4.5 x86_64.
I recently upgraded php to PHP 5.2.3 and subsequently I also upgraded MySQL to version 5.0.45. I hit a few bumps but all-in-all most things are back to normal. Unfortunately bacula is giving me some fits. Before MySQL upgrade I was running bacula 2.0.8 without too many issues. After the upgrade bacula did not work as expected. After trying a few things, I downloaded the latest beta from sourceforge and started over. I used the scripts in the /etc/bacula directory to create the MySQL database and tables, and then the grant permission script to grant permissions. The storage daemon, the client, and the director all start without errors. I kick off a backup job for a remote client and all starts off normal as it did before. The pre backup job runs fine and terminates. Then bacula looks like it is off to the races doing it thing. Unfortunately nothing is being written to the database during the backup, and in the log I get a ton of errors that look like the following: 03-Aug 22:49 firewall-dir: AMD01_FULL.2007-08-03_22.42.29 Fatal error: catreq.c:478 Attribute create error. sql_get.c:1005 Media record for Volume "FULL-0001" not found. 03-Aug 22:49 firewall-dir: AMD01_FULL.2007-08-03_22.42.29 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (8774,1,'C:/path/','filename.ext','A A IH/ B A A A CJ/ A A BGm2w7 BGS3tM BGS3tM A A M','1QMVRHuM+6/LjZpNVY/8KQ') failed: Table 'bacula.batch' doesn't exist There definitely is not a bacula.batch table. Where does this table get created? Do I need to do any special initialization of the database before running the backup job. Is there something with MySQL5 that I need to consider that I did not have to with MySQL4? I did a quick google for Media record for Volume "xxxx" not found and did not come up with anything useful. I am not sure what that error is telling me. I will admit I have not looked at the manual in quite some time as the backups were working fine before the MySQL upgrade. I am hoping someone knows what this error means and can point me in the right direction. Thanks. -- ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
