Bug#1056395: mariadb-server: debian.cnf [mysql_upgrade] basedir option ignored

[rpnpif]

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

Dear Maintainer,

I think that the archived bug #947553 is not fixed.

# systemctl start mariadb.service
starts MariaDB just fine, but generates a log message:
/etc/mysql/debian-start[nnnnn]: /usr/bin/mysql_upgrade: \
the '--basedir' option is always ignored

The automatically generated /etc/mysql/debian.cnf includes:
[mysql_upgrade]
...
basedir = /usr

However, mysql_upgrade(1) says:
--basedir=path
Old option accepted for backward compatibility but ignored.

This issue is still present in 10.11.5-3 release from SID.

Regards.

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

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

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:
ii libhtml-template-perl 2.97-2
ii mariadb-plugin-provider-bzip2 1:10.11.4-1~deb12u1
ii mariadb-plugin-provider-lz4 1:10.11.4-1~deb12u1
ii mariadb-plugin-provider-lzma 1:10.11.4-1~deb12u1
ii mariadb-plugin-provider-lzo 1:10.11.4-1~deb12u1
ii mariadb-plugin-provider-snappy 1:10.11.4-1~deb12u1
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

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

[Otto Kekäläinen]

> The automatically generated /etc/mysql/debian.cnf includes:
> [mysql_upgrade]
> ...
> basedir = /usr
>
> However, mysql_upgrade(1) says:
> --basedir=path
> Old option accepted for backward compatibility but ignored.
>
> This issue is still present in 10.11.5-3 release from SID.

No, it is not in neither Bookworm nor Deibian Sid / unstable anymore.
This can be confirmed by looking into files at
https://salsa.debian.org/mariadb-team/mariadb-server/-/tree/debian/latest/debian
or testing with a fresh install:

```
± docker run -it -v ${PWD}:/build -w /build debian:sid bash
root@eb0c4013a610:/build# apt update
root@eb0c4013a610:/build# apt install -y mariadb-server
...
Setting up mariadb-plugin-provider-bzip2 (1:10.11.5-3) ...
Setting up mariadb-plugin-provider-lzma (1:10.11.5-3) ...
Setting up mariadb-plugin-provider-lzo (1:10.11.5-3) ...
Setting up mariadb-plugin-provider-lz4 (1:10.11.5-3) ...
Setting up libcgi-fast-perl (1:2.17-1) ...
Setting up mariadb-plugin-provider-snappy (1:10.11.5-3) ...
Processing triggers for libc-bin (2.37-12) ...
Processing triggers for mariadb-server (1:10.11.5-3) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog
based frontend cannot be used. at
/usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)
debconf: falling back to frontend: Readline
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of restart.
root@eb0c4013a610:/build# cat /etc/mysql/debian.cnf
# THIS FILE IS OBSOLETE. STOP USING IT IF POSSIBLE.
# This file exists only for backwards compatibility for
# tools that run '--defaults-file=/etc/mysql/debian.cnf'
# and have root level access to the local filesystem.
# With those permissions one can run 'mariadb' directly
# anyway thanks to unix socket authentication and hence
# this file is useless. See package README for more info.
[client]
host = localhost
user = root
[mysql_upgrade]
host = localhost
user = root
# THIS FILE WILL BE REMOVED IN A FUTURE DEBIAN RELEASE.
```

If you have '[mysql_upgrade]' with anything else than above in your
/etc/mysql/debian.cnf it must be a remnant from some other older prior
install.

[rpnpif]

I download mariadb-server_10.11.5-3_amd64.deb from SID.
Decompress and see that /etc/mysql/mariadb.conf.d/50-server.cnf has
basedir = /usr

Have you the same files?

--
Rpnpif

[Otto Kekäläinen]

On Wed, 22 Nov 2023 at 11:10, rpnpif <rpn...@trob.eu> wrote:
> I download https://packages.debian.org/sid/mariadb-server from SID. I
> see in that /etc/mysql/mariadb.conf.d/50-server.cnf has

> basedir = /usr
>
> Have you the same files ?

If you read my previous message with some thought, you can see it has
exact steps on how to start a fresh Docker container running Debian
Sid and install MariaDB and test it.

If you can reproduce the issue you reported in a fresh environment in
a similar way it would prove the experience you had is not just
because of some custom configuration in your specific environment.

Thanks!

PS. Please use reply-to-all to ensure 105...@bugs.debian.org is
included in your replies.