[pkg-bacula-devel] Bug#1104534: bacula-director-mysql: Upgrading 9 > 15 - Database not being converted

[Benoit Panizzon]

Package: bacula-director-mysql
Version: 15.0.3-1~bpo12+1
Severity: important

Dear Maintainer,

As I upgraded some clients to Version 15 I have to also upgrade the director.

Therefore I installed the version from bookworm-backports.

As I understood (and also documented in the README file), during the upgrade of
bacula-director-mysql the database scheme schould have automatically be converted.

This did not happen despite there being more then enough space on the database server.

I started looking for any instructions or scripts to manually convert the database
but the script found on the bacula.org website does not seem to be part of
the bookworm package.

Any hint how to manually convert the database or to figure out what went wrong
greatly appreciated.

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

Kernel: Linux 6.1.0-31-amd64 (SMP w/1 CPU thread; PREEMPT)
Locale: LANG=de_CH.UTF-8, LC_CTYPE=de_CH.UTF-8 (charmap=UTF-8), LANGUAGE=de_CH:de
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages bacula-director-mysql depends on:
ii  bacula-common-mysql                    15.0.3-1~bpo12+1
ii  dbconfig-mysql                         2.0.24
ii  debconf [debconf-2.0]                  1.5.82
ii  default-mysql-client                   1.1.0
ii  mariadb-client [virtual-mysql-client]  1:10.11.11-0+deb12u1

Versions of packages bacula-director-mysql recommends:
pn  default-mysql-server | virtual-mysql-server  <none>

Versions of packages bacula-director-mysql suggests:
ii  gawk  1:5.2.1-2

-- debconf information:
  bacula-director-mysql/password-confirm: (password omitted)
  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/internal/reconfiguring: false
  bacula-director-mysql/remote/host: localhost
  bacula-director-mysql/missing-db-package-error: abort
  bacula-director-mysql/dbconfig-upgrade: true
  bacula-director-mysql/remove-error: abort
  bacula-director-mysql/upgrade-error: abort
  bacula-director-mysql/database-type: mysql
* bacula-director-mysql/dbconfig-install: false
  bacula-director-mysql/db/app-user: bacula at localhost
* bacula-director-mysql/dbconfig-reinstall: false
  bacula-director-mysql/upgrade-backup: true
  bacula-director-mysql/install-error: abort
  bacula-director-mysql/db/dbname: bacula
  bacula-director-mysql/remote/newhost:
  bacula-director-mysql/purge: false
  bacula-director-mysql/passwords-do-not-match:
  bacula-director-mysql/internal/skip-preseed: false
  bacula-director-mysql/remote/port: 3306
  bacula-director-mysql/dbconfig-remove: true
* bacula-director-mysql/mysql/admin-user: root
  bacula-director-mysql/mysql/method: Unix socket
  bacula-director-mysql/mysql/authplugin: default