Hi Enrico,<div><br></div><div>I'll be looking into this tonight.</div><div><br></div><div>Regards,</div><div>Bart<br><br><div class="gmail_quote">On 16 July 2012 16:45, Enrico Ghera <span dir="ltr"><<a href="mailto:enrico@azimballaggi.com" target="_blank">enrico@azimballaggi.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Package: bacula-director-mysql<br>
Version: 5.2.6+dfsg-1~bpo60+1<br>
Severity: important<br>
File: /usr/sbin/bacula-dir<br>
<br>
When updating from squeeze-backports it asks to upgrade database to version 14 (it was version 12, bacula-dir 5.0.2)<br>
my setup is to have the catalog on a remote mysql host (for redundancy).<br>
everything was configured inside /etc/bacula/bacula-dir.conf<br>
it was working like a charm.<br>
<br>
when installing the newer package it could not complete the dbconfig stuff. (I gave it a couple of tries)<br>
then I decided to stop the scripts and to go on without upgrading automatically.<br>
<br>
in /usr/share/bacula-director there is a script named update_mysql_tables<br>
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<br>
"-h <a href="http://mysql.mydomainname.com" target="_blank">mysql.mydomainname.com</a>" made the whole thing work.<br>
<br>
I think it should read and parse the configuration from /etc/bacula to allow for this kind of setup.<br>
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.<br>
<br>
<br>
-- System Information:<br>
Debian Release: 6.0.5<br>
APT prefers stable<br>
APT policy: (990, 'stable'), (500, 'stable-updates')<br>
Architecture: amd64 (x86_64)<br>
<br>
Kernel: Linux 2.6.37 (SMP w/8 CPU cores)<br>
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)<br>
Shell: /bin/sh linked to /bin/dash<br>
<br>
Versions of packages bacula-director-mysql depends on:<br>
ii bacula-common 5.2.6+dfsg-1~bpo60+1 network backup, recovery and verif<br>
ii bacula-common-mysql 5.2.6+dfsg-1~bpo60+1 network backup, recovery and verif<br>
ii bacula-director-com 5.2.6+dfsg-1~bpo60+1 network backup, recovery and verif<br>
ii dbconfig-common 1.8.46+squeeze.0 common framework for packaging dat<br>
ii debconf [debconf-2. 1.5.36.1 Debian configuration management sy<br>
ii libc6 2.11.3-3 Embedded GNU C Library: Shared lib<br>
ii libgcc1 1:4.4.5-8 GCC support library<br>
ii libpython2.6 2.6.6-8+b1 Shared Python runtime library (ver<br>
ii libssl0.9.8 0.9.8o-4squeeze13 SSL shared libraries<br>
ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3<br>
ii libwrap0 7.6.q-19 Wietse Venema's TCP wrappers libra<br>
ii mysql-client 5.1.63-0+squeeze1 MySQL database client (metapackage<br>
ii mysql-client-5.1 [m 5.1.63-0+squeeze1 MySQL database client binaries<br>
ii ucf 3.0025+nmu1 Update Configuration File: preserv<br>
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime<br>
<br>
Versions of packages bacula-director-mysql recommends:<br>
ii mysql-server 5.1.63-0+squeeze1 MySQL database server (metapackage<br>
ii mysql-server-5.1 [mysq 5.1.63-0+squeeze1 MySQL database server binaries and<br>
<br>
Versions of packages bacula-director-mysql suggests:<br>
ii gawk 1:3.1.7.dfsg-5 GNU awk, a pattern scanning and pr<br>
<br>
-- debconf information:<br>
bacula-director-mysql/mysql/app-pass: (password omitted)<br>
bacula-director-mysql/mysql/admin-pass: (password omitted)<br>
bacula-director-mysql/app-password-confirm: (password omitted)<br>
bacula-director-mysql/password-confirm: (password omitted)<br>
bacula-director-mysql/passwords-do-not-match:<br>
bacula-director-mysql/mysql/admin-user: root<br>
bacula-director-mysql/dbconfig-upgrade: true<br>
bacula-director-mysql/purge: false<br>
bacula-director-mysql/remove-error: abort<br>
bacula-director-mysql/missing-db-package-error: abort<br>
bacula-director-mysql/remote/newhost:<br>
bacula-director-mysql/internal/skip-preseed: false<br>
* bacula-director-mysql/dbconfig-install: false<br>
bacula-director-mysql/db/app-user: bacula<br>
bacula-director-mysql/upgrade-backup: true<br>
bacula-director-mysql/database-type: mysql<br>
bacula-director-mysql/install-error: ignore<br>
bacula-director-mysql/db/dbname: bacula<br>
bacula-director-mysql/mysql/method: unix socket<br>
bacula-director-mysql/remote/host:<br>
bacula-director-mysql/internal/reconfiguring: false<br>
bacula-director-mysql/upgrade-error: retry<br>
bacula-director-mysql/dbconfig-reinstall: false<br>
bacula-director-mysql/remote/port:<br>
bacula-director-mysql/dbconfig-remove:<br>
<br>
_______________________________________________<br>
pkg-bacula-devel mailing list<br>
<a href="mailto:pkg-bacula-devel@lists.alioth.debian.org">pkg-bacula-devel@lists.alioth.debian.org</a><br>
<a href="http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-bacula-devel" target="_blank">http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-bacula-devel</a><br>
</blockquote></div><br></div>