[debian-mysql] Bug#1112499: mariadb-server: ExecStartPost fails with "/usr/share/mysql/debian-start.inc.sh: line 87: MARIADB: unbound variable"

[Patrick Cernko]

Package: mariadb-server
Version: 1:10.11.14-0+deb12u1
Severity: normal

Dear Maintainer,

   * What led up to the situation?
   * What exactly did you do (or not do) that was effective (or
     ineffective)?

when starting the database, the ExecStartPost script /etc/mysql/debian-start fails with

/usr/share/mysql/debian-start.inc.sh: line 87: MARIADB: unbound variable

This happens because 'set -u' is used in check_root_accounts(). The newest version of mariadb-server (for bookworm) now uses '$MARIADB' in check_root_accounts() instead of defined '$MYSQL'.

   * What was the outcome of this action?

I'm not sure, if the the ExecStartPost script missed to do something due to the abort.

   * What outcome did you expect instead?

The script should not abort due to this undefined variable,
Please change back to '$MYSQL' (at least for bookworm's versions).
Thank you!

-- System Information:
Debian Release: 12.11
  APT prefers oldstable-updates
  APT policy: (500, 'oldstable-updates'), (500, 'oldstable-security'), (500, 'oldstable-proposed-updates'), (500, 'oldstable')
Architecture: amd64 (x86_64)

Kernel: Linux 6.1.0-39-amd64 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server depends on:
ii  adduser                3.134
ii  debconf [debconf-2.0]  1.5.82
ii  galera-4               26.4.23-0+deb12u1
ii  gawk                   1:5.2.1-2
ii  iproute2               6.1.0-3
ii  libc6                  2.36-9+deb12u13
ii  libdbi-perl            1.643-4
ii  libgcc-s1              12.2.0-14+deb12u1
ii  libpam0g               1.5.2-6+deb12u1
ii  libssl3                3.0.17-1~deb12u2
ii  libstdc++6             12.2.0-14+deb12u1
ii  lsof                   4.95.0-1
ii  mariadb-client         1:10.11.14-0+deb12u1
ii  mariadb-common         1:10.11.14-0+deb12u1
ii  mariadb-server-core    1:10.11.14-0+deb12u1
ii  passwd                 1:4.13+dfsg1-1+deb12u1
ii  perl                   5.36.0-7+deb12u3
ii  procps                 2:4.0.2-3
ii  psmisc                 23.6-1
ii  rsync                  3.2.7-1+deb12u2
ii  socat                  1.7.4.4-2
ii  zlib1g                 1:1.2.13.dfsg-1

Versions of packages mariadb-server recommends:
ii  libhtml-template-perl           2.97-2
pn  mariadb-plugin-provider-bzip2   <none>
pn  mariadb-plugin-provider-lz4     <none>
pn  mariadb-plugin-provider-lzma    <none>
pn  mariadb-plugin-provider-lzo     <none>
pn  mariadb-plugin-provider-snappy  <none>
pn  pv                              <none>

Versions of packages mariadb-server suggests:
ii  bsd-mailx [mailx]  8.1.2-0.20220412cvs-1
pn  mariadb-test       <none>
pn  netcat-openbsd     <none>

-- debconf information:
  mariadb-server/postrm_remove_databases: false
  mariadb-server/nis_warning:
  mariadb-server/old_data_directory_saved: