[pkg-bacula-devel] Bug#681790: /usr/sbin/bacula-dir: fails to upgrade database when database is on a remote machine

[Enrico Ghera]

Package: bacula-director-mysql
Version: 5.2.6+dfsg-1~bpo60+1
Severity: important
File: /usr/sbin/bacula-dir

When updating from squeeze-backports it asks to upgrade database to version 14 (it was version 12, bacula-dir 5.0.2) 
my setup is to have the catalog on a remote mysql host (for redundancy).
everything was configured inside /etc/bacula/bacula-dir.conf
it was working like a charm.

when installing the newer package it could not complete the dbconfig stuff. (I gave it a couple of tries)
then I decided to stop the scripts and to go on without upgrading automatically.

in /usr/share/bacula-director there is a script named update_mysql_tables
editing it by hand, changing the line "db_name= XXX_MYSQL_XXX" with the real db name and invoking on the command line with options
"-h mysql.mydomainname.com" made the whole thing work.

I think it should read and parse the configuration from /etc/bacula to allow for this kind of setup.
otherwise it assumes (out of nothing) that the instance of the database where the catalog resides runs on the same machine as bacula is installed.


-- System Information:
Debian Release: 6.0.5
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'stable-updates')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.37 (SMP w/8 CPU cores)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.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~bpo60+1 network backup, recovery and verif
ii  bacula-common-mysql 5.2.6+dfsg-1~bpo60+1 network backup, recovery and verif
ii  bacula-director-com 5.2.6+dfsg-1~bpo60+1 network backup, recovery and verif
ii  dbconfig-common     1.8.46+squeeze.0     common framework for packaging dat
ii  debconf [debconf-2. 1.5.36.1             Debian configuration management sy
ii  libc6               2.11.3-3             Embedded GNU C Library: Shared lib
ii  libgcc1             1:4.4.5-8            GCC support library
ii  libpython2.6        2.6.6-8+b1           Shared Python runtime library (ver
ii  libssl0.9.8         0.9.8o-4squeeze13    SSL shared libraries
ii  libstdc++6          4.4.5-8              The GNU Standard C++ Library v3
ii  libwrap0            7.6.q-19             Wietse Venema's TCP wrappers libra
ii  mysql-client        5.1.63-0+squeeze1    MySQL database client (metapackage
ii  mysql-client-5.1 [m 5.1.63-0+squeeze1    MySQL database client binaries
ii  ucf                 3.0025+nmu1          Update Configuration File: preserv
ii  zlib1g              1:1.2.3.4.dfsg-3     compression library - runtime

Versions of packages bacula-director-mysql recommends:
ii  mysql-server           5.1.63-0+squeeze1 MySQL database server (metapackage
ii  mysql-server-5.1 [mysq 5.1.63-0+squeeze1 MySQL database server binaries and

Versions of packages bacula-director-mysql suggests:
ii  gawk                      1:3.1.7.dfsg-5 GNU awk, a pattern scanning and pr

-- debconf information:
  bacula-director-mysql/mysql/app-pass: (password omitted)
  bacula-director-mysql/mysql/admin-pass: (password omitted)
  bacula-director-mysql/app-password-confirm: (password omitted)
  bacula-director-mysql/password-confirm: (password omitted)
  bacula-director-mysql/passwords-do-not-match:
  bacula-director-mysql/mysql/admin-user: root
  bacula-director-mysql/dbconfig-upgrade: true
  bacula-director-mysql/purge: false
  bacula-director-mysql/remove-error: abort
  bacula-director-mysql/missing-db-package-error: abort
  bacula-director-mysql/remote/newhost:
  bacula-director-mysql/internal/skip-preseed: false
* bacula-director-mysql/dbconfig-install: false
  bacula-director-mysql/db/app-user: bacula
  bacula-director-mysql/upgrade-backup: true
  bacula-director-mysql/database-type: mysql
  bacula-director-mysql/install-error: ignore
  bacula-director-mysql/db/dbname: bacula
  bacula-director-mysql/mysql/method: unix socket
  bacula-director-mysql/remote/host:
  bacula-director-mysql/internal/reconfiguring: false
  bacula-director-mysql/upgrade-error: retry
  bacula-director-mysql/dbconfig-reinstall: false
  bacula-director-mysql/remote/port:
  bacula-director-mysql/dbconfig-remove: