Your message dated Fri, 16 Aug 2024 19:38:26 -0700
with message-id
<CAOU6tADbyVSuJ_VVjoJ=0cq-ow+qm1jjmncobk6doqunnas...@mail.gmail.com>
and subject line Close unactionable issues
has caused the Debian Bug report #1042454,
regarding mariadb-server ignores bind-address
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1042454: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1042454
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
As this issue hasn't had any follow-up for a long time, and the issue
is not reproducible nor actionable, I am closing it.
Feel free to re-open or file a new bug report if you have substantial
additional information or steps to reproduce.
--- End Message ---
