[debian-mysql] Bug#1056120: mariadb-server: debian-start uses obsolate hardcoded /etc/mysql/debian.cnf

[Sebastian Fiedler]

Package: mariadb-server
Version: 1:10.11.4-1~deb12u1
Severity: normal

Dear Maintainer,

debian-start uses obsolate hardcoded /etc/mysql/debian.cnf. The file
will bee removed in the future. When this file exists, I get
"Access denied for user 'root'@'localhost'" with mariaDB Unix Socket Authentication Plugin.

Here is a possible fix:

--- debian-start	2023-11-17 10:22:20.020000000 +0100
+++ debian-start.new	2023-11-17 09:57:04.700000000 +0100
@@ -17,11 +17,15 @@
   . /etc/default/mariadb
 fi

-MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
-MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
+if [ -f /etc/mysql/debian.cnf ]; then
+  EXTRAPARAM='--defaults-file=/etc/mysql/debian.cnf'
+fi
+
+MYSQL="/usr/bin/mysql $EXTRAPARAM"
+MYADMIN="/usr/bin/mysqladmin $EXTRAPARAM"
 # Don't run full mysql_upgrade on every server restart, use --version-check to do it only once
-MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf --version-check --silent"
-MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
+MYUPGRADE="/usr/bin/mysql_upgrade $EXTRAPARAM --version-check --silent"
+MYCHECK="/usr/bin/mysqlcheck $EXTRAPARAM"
 MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
 MYCHECK_PARAMS="--all-databases --fast --silent"
 MYCHECK_RCPT="${MYCHECK_RCPT:-root}"


*** Reporter, please consider answering these questions, where appropriate ***

   * What led up to the situation?
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
   * What was the outcome of this action?
   * What outcome did you expect instead?

*** End of the template - remove these template lines ***


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

Kernel: Linux 6.1.0-13-amd64 (SMP w/2 CPU threads; PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.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.13-1
ii  gawk                   1:5.2.1-2
ii  iproute2               6.1.0-3
ii  libc6                  2.36-9+deb12u3
ii  libdbi-perl            1.643-4
ii  libpam0g               1.5.2-6+deb12u1
ii  libssl3                3.0.11-1~deb12u2
ii  libstdc++6             12.2.0-14
ii  lsof                   4.95.0-1
ii  mariadb-client         1:10.11.4-1~deb12u1
ii  mariadb-common         1:10.11.4-1~deb12u1
ii  mariadb-server-core    1:10.11.4-1~deb12u1
ii  passwd                 1:4.13+dfsg1-1+b1
ii  perl                   5.36.0-7
ii  procps                 2:4.0.2-3
ii  psmisc                 23.6-1
ii  rsync                  3.2.7-1
ii  socat                  1.7.4.4-2
ii  zlib1g                 1:1.2.13.dfsg-1

Versions of packages mariadb-server recommends:
pn  libhtml-template-perl           <none>
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>
ii  pv                              1.6.20-1

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

-- Configuration Files:
/etc/mysql/mariadb.conf.d/50-server.cnf changed [not included]

-- debconf information excluded