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

[Bart Swedrowski]

Hi Enrico,

I'll be looking into this tonight.

Regards,
Bart

On 16 July 2012 16:45, Enrico Ghera <enrico at azimballaggi.com> 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.
>
> 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:
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-bacula-devel/attachments/20120717/9ea69a9b/attachment-0001.html>