bacula director (mysql) error in generated conf file

[Marek Haluska]

Description: Ubuntu 11.04
Release: 11.04

bacula-director-mysql:
  Installed: 5.0.3-0ubuntu2
  Candidate: 5.0.3-0ubuntu2
  Version table:
 *** 5.0.3-0ubuntu2 0
        500 http://cz.archive.ubuntu.com/ubuntu/ natty/main amd64 Packages
        100 /var/lib/dpkg/status

Error in initial configuration file /etc/bacula/bacula-dir.conf

I received following log error:

20-Aug 16:46 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula;".
20-Aug 16:46 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.
20-Aug 16:46 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf

And it's really easy to fix it:

> diff /etc/bacula/bacula-dir.conf.orig /etc/bacula/bacula-dir.conf
236c236
< dbname = "bacula;" DB Address = ""; dbuser = "bacula"; dbpassword = "bacula"
---
> dbname = "bacula"; DB Address = ""; dbuser = "bacula"; dbpassword = "bacula"

[Dave Walker (davewalker)]

Thanks for the bug report, looks like a typo has been introduced with the ;.

/etc/bacula/bacula-dir.conf:
dbname = "bacula;" should be dbname = "bacula";

[Foster McLane (fkmclane)]

I had this problem too, has it been fixed?

[Marek Haluska (marek-haluska)]

Problem is not fixed yet, package is still in same version:

# apt-cache show bacula-director-mysql|grep Version
Version: 5.0.3-0ubuntu2

BTW, this is not problem, only typo in ";" position. So after installation just change line 236:

- setup without dbconfig:
   dbname = ";" DB Address = ""; dbuser = ""; dbpassword = ""
   ->
   dbname = ""; DB Address = ""; dbuser = ""; dbpassword = ""

- setup using dbconfig:

   dbname = "bacula;" DB Address = ""; dbuser = "bacula"; dbpassword = "***"
   ->
   dbname = "bacula"; DB Address = ""; dbuser = "bacula"; dbpassword = "***"

[Fabian Köster (maestro-alubia)]

The problem persists in Ubuntu Oneiric 11.10 final.

Version of bacula package is 5.0.3-1ubuntu5

[Kern Sibbald (kern)]

Someone must have fat fingered something because upstream we have never had the semicolon misplaced
as in the above problem.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Launchpad Janitor (janitor)]

This bug was fixed in the package bacula - 5.2.5-0ubuntu3

---------------
bacula (5.2.5-0ubuntu3) precise; urgency=low

  * fix db-common configuration of database name (LP: #830108)

  [ David Stenglein ]
  * improve make_catalog_backup_awk in sqlite3 to dump catalog only once
    rather than for each line in bacula-dir.conf (LP: #614320)
 -- Scott Moser <email address hidden> Fri, 10 Feb 2012 10:04:35 -0500

[Rolf Leggewie (r0lf)]

natty has seen the end of its life and is no longer receiving any updates. Marking the natty task for this ticket as "Won't Fix".

[Rolf Leggewie (r0lf)]

oneiric has seen the end of its life and is no longer receiving any updates. Marking the oneiric task for this ticket as "Won't Fix".