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