Bacula apt package error found

[abudhamnhet]

I am a long time reader of this site. I have never made any contributions. I have been working with Linux professionally for many years, but alas, have never had anything worth posting. Well now I believe I do. (hopefully)

Using Ubuntu server 11.04

I spent a good part of today trying to figure out why Bacula, installed from the apt sources, would not start with a mysql connection error. Specifically the director daemon.

The file /var/log/bacula/log described the issue:

10-Oct 16:36 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula;".
10-Oct 16:36 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server.
Database=bacula; User=bacula
MySQL connect failed either server not running or your authorization is incorrect.

The file /etc/bacula/bacula-dir.conf file contains a simple syntax error. Under the generic catalog service section, the line:

dbname = "bacula;" DB Address = ""; dbuser = "bacula"; dbpassword = "mypassword"

needs to be changed to:

dbname = "bacula"; DB Address = ""; dbuser = "bacula"; dbpassword = "mypassword"

See the difference? Well I didn't for a while. The dbname has the semi-colon inside the quotes. I don't know if this happens during the package configuration or if it's how it came.

Just thought I would put that out there if anyone else comes across a db connection error when installing Bacula fresh. I have never reported any bugs yet either, so if anyone has any advice how I can "officially" report this it would be greatly appreciated!

[Rubberman]

Looking at your posts, I didn't see the difference either! At least until you pointed it out! I think this is a good example of how our brains reinterpret visual data to fit our preconceptions. Anyway, thanks for the post.

[atreyu]

Good spotting! I like Rubberman didn't see it either. I just went and checked out Fedora 15's config file for bacula - it is okay.

Check here for bug-posting guidelines for Ubuntu.