[pkg-bacula-devel] Bug#679855: bacula-director-mysql: update_mysql_tables does not use dbname when applying SQL update commands

[Dominik Sommer]

Package: bacula-director-mysql
Version: 5.2.6+dfsg-1
Severity: important

Dear Maintainer,

   * What led up to the situation?

I just updated to the most recent debian testing package, and bacula-director didn't start any longer.
Running it manually (without the init.d script) showed the DB had not been updated (a notice during
aptitude's update process would have been helpful btw). Googling for a solution, I found there's an
update script - update_mysql_tables. Running it untouched, it asked me to set the DB name to update
in the script, which I did. Re-running yielded a couple of "no database selected" errors.

   * What exactly did you do (or not do) that was effective (or
     ineffective)?

Looking into the script, it seems like the db_name parameter is only used for querying the version
information, but not for actually applying the SQL. So I just added the missing
-D ${db_name}
from the first mysql command (line 13) to the second one (line 24).

   * What was the outcome of this action?

The update was now applied successfully and bacula-dir started again.


-- System Information:
Debian Release: wheezy/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable'), (500, 'oldstable'), (400, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-2-486
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages bacula-director-mysql depends on:
ii  bacula-common                    5.2.6+dfsg-1
ii  bacula-common-mysql              5.2.6+dfsg-1
ii  bacula-director-common           5.2.6+dfsg-1
ii  dbconfig-common                  1.8.47+nmu1
ii  debconf [debconf-2.0]            1.5.44
ii  libc6                            2.13-33
ii  libgcc1                          1:4.7.0-8
ii  libpython2.7                     2.7.3~rc2-2.1
ii  libssl1.0.0                      1.0.1c-3
ii  libstdc++6                       4.7.0-8
ii  libwrap0                         7.6.q-23
ii  mysql-client-5.5 [mysql-client]  5.5.24+dfsg-4
ii  ucf                              3.0025+nmu3
ii  zlib1g                           1:1.2.7.dfsg-13

Versions of packages bacula-director-mysql recommends:
ii  mysql-server  5.5.24+dfsg-4

Versions of packages bacula-director-mysql suggests:
ii  gawk  1:4.0.1+dfsg-2

-- no debconf information