[pkg-bacula-devel] Bug#825064: Bacula director does not start silently due to database mismatch

[Klaus Ethgen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Package: bacula-director-sqlite3
Version: 7.4.0+dfsg-1
Severity: grave

The latest upgrade from 7.0.5 to 7.4.0 broke director as it silently
refuses to start. Only starting it manually with -f reveals the problem
that the database was not converted in the upgrade.
   ~> bacula-dir -f -c /etc/bacula/bacula-dir.conf 
   bacula-dir: dird.c:969-0 Could not open Catalog "MyCatalog", database "bacula".
   bacula-dir: dird.c:974-0 Version error for database "bacula". Wanted 15, got 14
   23-Mai 10:34 bacula-dir ERROR TERMINATION
   Please correct configuration file: /etc/bacula/bacula-dir.conf

Usually in the past that was done with an upgrade. It might be fully ok
(for me) to leave that to the user. But then there must be a big note
that it has to be done and no silent dead!

- -- System Information:
Debian Release: stretch/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.5.3 (SMP w/8 CPU cores)
Locale: LANG=de_DE, LC_CTYPE=de_DE (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages bacula-director-sqlite3 depends on:
ii  bacula-common           7.4.0+dfsg-1
ii  bacula-common-sqlite3   7.4.0+dfsg-1
ii  bacula-director-common  7.4.0+dfsg-1
ii  dbconfig-common         2.0.4
ii  debconf [debconf-2.0]   1.5.59
ii  file                    1:5.25-2
ii  libc6                   2.22-9
ii  libcap2                 1:2.25-1
ii  libgcc1                 1:6.1.1-4
ii  libssl1.0.2             1.0.2h-1
ii  libstdc++6              6.1.1-4
ii  libwrap0                7.6.q-25
ii  sqlite3                 3.13.0-1
ii  ucf                     3.0036

bacula-director-sqlite3 recommends no packages.

Versions of packages bacula-director-sqlite3 suggests:
ii  gawk  1:4.1.3+dfsg-0.1
ii  perl  5.22.2-1

- -- Configuration Files:
/etc/bacula/scripts/delete_catalog_backup [Errno 13] Keine Berechtigung: u'/etc/bacula/scripts/delete_catalog_backup'
/etc/bacula/scripts/make_catalog_backup changed:
default_db_type=sqlite3
if [ $# -ge 5 ]; then
   case $5 in
     sqlite3)
       db_type=$5
       ;;
     mysql)
       db_type=$5
       ;;
     postgresql)
       db_type=$5
       ;;
     ingres)
       db_type=$5
       ;;
     *)
       ;;
   esac
fi
if [ -z "${db_type}" ]; then
   db_type="${default_db_type}"
fi
cd /var/lib/bacula
rm -f $1.sql
case ${db_type} in
  sqlite3)
    BINDIR=/usr/bin
    echo ".dump" | ${BINDIR}/sqlite3 $1.db >$1.sql
    ;;
  mysql)
    BINDIR=/usr/bin
    if test $# -gt 2; then
      MYSQLPASSWORD=" --password=$3"
    else
      MYSQLPASSWORD=""
    fi
    if test $# -gt 3; then
      MYSQLHOST=" --host=$4"
    else
      MYSQLHOST=""
    fi
    ${BINDIR}/mysqldump -u ${2}${MYSQLPASSWORD}${MYSQLHOST} -f --opt $1 >$1.sql
    ;;
  postgresql)
    BINDIR=/usr/bin
    if test $# -gt 2; then
      PGPASSWORD=$3
      export PGPASSWORD
    fi
    if test $# -gt 3; then
      PGHOST=" --host=$4"
    else
      PGHOST=""
    fi
    # you could also add --compress for compression.  See man pg_dump
    exec ${BINDIR}/pg_dump -c $PGHOST -U $2 $1 >$1.sql
    ;;
esac
sync


- -- debconf information:
  bacula-director-sqlite3/purge: false
  bacula-director-sqlite3/database-type: sqlite3
  bacula-director-sqlite3/remove-error: abort
  bacula-director-sqlite3/upgrade-error: abort
  bacula-director-sqlite3/internal/reconfiguring: false
  bacula-director-sqlite3/missing-db-package-error: abort
  bacula-director-sqlite3/upgrade-backup: true
  bacula-director-sqlite3/dbconfig-upgrade: true
  bacula-director-sqlite3/passwords-do-not-match:
  bacula-director-sqlite3/db/dbname: bacula.db
  bacula-director-sqlite3/unsafe-director-password-was-changed:
  bacula-director-sqlite3/dbconfig-remove:
  bacula-director-sqlite3/internal/skip-preseed: false
* bacula-director-sqlite3/dbconfig-install: false
  bacula-director-sqlite3/db/basepath: /var/lib/bacula
  bacula-director-sqlite3/dbconfig-reinstall: false
  bacula-director-sqlite3/install-error: abort

- -- 
Klaus Ethgen                              http://www.ethgen.ch/
pub  4096R/4E20AF1C 2011-05-16   Klaus Ethgen <Klaus at Ethgen.ch>
Fingerprint: 85D4 CA42 952C 949B 1753  62B3 79D0 B06F 4E20 AF1C
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
Comment: Charset: ISO-8859-1

iQGcBAEBCgAGBQJXQtAeAAoJEKZ8CrGAGfasf4sMAI/D0DigTNgFZhaa+w+D56Fz
UC0hFe2UMAyf2izU8yQr795rIoQT7ECHGAiMisXol7RluI8a65rAnbjZ+VDk84UA
Oqv/BuPpYHoNf9IEiw/n3Y7StYkAtvSqYLPn2SBw7TtFUf8eQNkVJt4EpAGg3QLd
qJVBNxbpJctMJ9O/kvSC+1VFlyVlAsxN0vNvaAFM9dh5yKI0n5a/5Rhn4xAGWVTa
XqZEHD2K4RHJ61KFCxU65QJo84FWHq8SGacRBN0ZS8V25pulFXwuOjTI25H4lSM0
Fo+I8XmFDyr7rrOB2s6/qM0AshWC7KmZIdZvrOPeocE5UoSzr0UEakQK6lzXomG2
cb6eY6PLucIV/THtsECa2nCwCO2445rG8N2ECOAfZXRqcppF9tOpmOUVWNuoGPY6
InLyOQb8NOFCvc/j/zUY/gqyvfCsIfAJ2W/oERVC/A7ErQAwCET0gCRoB1hRQ5nQ
POHf/hFSOATDfyGi5Ogs5jZpnVHqFG6vfj2w71u19g==
=DatB
-----END PGP SIGNATURE-----