[debian-mysql] Bug#1042454: mariadb-server ignores bind-address

[zanyface88 at t-online.de]

Package: mariadb-server
Version: 1:10.11.3-1
Severity: normal

Dear Maintainer,

after upgrading from Bullseye to Bookworm, MariaDB seems to ignore the
bind-address config option.

In /etc/mysql/mariadb.conf.d/50-server.cnf I have

bind-address            = 127.0.0.1

in the [mysqld] section and apparently mariadbd accepted this option:

# mariadbd --help --verbose | grep ^bind
bind-address                                                 127.0.0.1

Nevertheless it actually listens on 0.0.0.0:

# netstat -tlnp | grep mariadb
tcp        0      0 0.0.0.0:3306        0.0.0.0:*     LISTEN      4299/mariadbd
tcp6       0      0 :::3306             :::*          LISTEN      4299/mariadbd


I tried MYSQLD_OPTS="--bind-address=127.0.0.1" in /etc/default/mysql to no avail.


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

Kernel: Linux 6.1.0-10-amd64 (SMP w/6 CPU threads; PREEMPT)
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)
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+deb12u1
ii  libdbi-perl            1.643-4
ii  libpam0g               1.5.2-6
ii  libssl3                3.0.9-1
ii  libstdc++6             12.2.0-14
ii  lsof                   4.95.0-1
ii  mariadb-client         1:10.11.3-1
ii  mariadb-common         1:10.11.3-1
ii  mariadb-server-core    1:10.11.3-1
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.3-1
ii  mariadb-plugin-provider-lz4     1:10.11.3-1
ii  mariadb-plugin-provider-lzma    1:10.11.3-1
ii  mariadb-plugin-provider-lzo     1:10.11.3-1
ii  mariadb-plugin-provider-snappy  1:10.11.3-1
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>
pn  netcat-openbsd     <none>

-- Configuration Files:
/etc/mysql/mariadb.conf.d/50-server.cnf changed:
[server]
[mysqld]
user                    = mysql
pid-file                = /run/mysqld/mysqld.pid
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
lc-messages             = en_US
skip-external-locking
bind-address            = 127.0.0.1
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci
[embedded]
[mariadb]
plugin_load_add = auth_ed25519
[mariadb-10.11]


-- debconf information:
  mariadb-server/old_data_directory_saved:
  mariadb-server/nis_warning:
  mariadb-server/postrm_remove_databases: false
Thank you for using reportbug