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

Tue Jul 17 19:50:52 UTC 2012

tags 681790 + moreinfo
thanks

Hi, Enrico!

Thank you for report!

On Mon, 16 Jul 2012 17:45:42 +0200, Enrico Ghera wrote:
> 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.

I see in your report "* bacula-director-mysql/dbconfig-install: false".
But you wrote "when installing the newer package it could not complete 
the dbconfig stuff"

If you didn't use dbconfig for create database, then dbconfig will not 
even try to upgrade database.
So, please, give more info about how you install old version of package 
(use dbconfig or no?) and what dbconfig errors was on upgrading?

It will be usefull for us, if you show your 
/etc/dbconfig-common/bacula-director-mysql.conf and 
/var/log/apt/term.log

>
> 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.

This script is not debian-specific, it come from upstream.
it will be possible to set all database parameters in arguments to 
update_mysql_tables script in next versions of package (>> 
5.2.6+dfsdg-2).

You can ask upstream (http://bugs.bacula.org) for automatically parse 
config in this script.

>
>
> -- 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:
>
> _______________________________________________
> pkg-bacula-devel mailing list
> pkg-bacula-devel at lists.alioth.debian.org
> 
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-bacula-devel

-- 
with best regards,
Alexander Golovko
email: alexandro at ankalagon.ru
xmpp: alexandro at ankalagon.ru