mysql server version 8.0.22-0ubuntu0.20.04.3

I have/had remote database connections set up using the mysql module and setting the ip address to 0.0.0.0 on the update to mysql server version 8.0.22-0ubuntu0.20.04.3 this configuaration was wiped and all connections were lost. I tried to reconfigure using the mysql module & resetting the ip address to 0.0.0.0 again, this failed for reasons unknown after saving and returning to the module the ip address was still blank and the only fix was to add the following to /etc/mysql/my.cnf bind-address = 0.0.0.0 this fixed the remote connections and also on returning to the mysql module the IP field was populated with 0.0.0.0 Is this a case of a change of mysql server configuration for this version and webmin is saving data to an incorrect file or a permissions error writing data to my.cnf ?

Status: 
Closed (cannot reproduce)
Virtualmin version: 
613
Webmin version: 
1962

Comments

Where in Virtualmin are you seeing or entering this 0.0.0.0 address?

jimr's picture
Submitted by jimr on Sun, 12/06/2020 - 08:32 Pro Licensee

I see it at servers->mysql server->mysql server configuration top right corner. I altered this to 0.0.0.0 to allow remote database connections to the server and it worked fine .. it was only on update 8.0.22-0ubuntu0.20.04.3 the config was reset to 127.0.0.1 connections then failed .. that said does webmin have a better way of setting up remote db connections rather than getting mysql to listen on 0.0.0.0 ?

Which field did you enter 0.0.0.0 into exactly?

Ilia's picture
Submitted by Ilia on Mon, 12/07/2020 - 03:32

What is the content of the following files:

/etc/os-release
/etc/issue
/etc/webmin/config
/etc/webmin/mysql/config
jimr's picture
Submitted by jimr on Mon, 12/07/2020 - 08:26 Pro Licensee

os-release

NAME="Ubuntu"
VERSION="20.04.1 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.1 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

issue

Ubuntu 20.04.1 LTS \n \l

webmin

path=/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin
passwd_mindex=4
find_pid_command=ps auwwwx | grep NAME | grep -v grep | awk '{ print $2 }'
tempdelete_days=7
by_view=0
passwd_cindex=2
passwd_pindex=1
ld_env=LD_LIBRARY_PATH
passwd_file=/etc/shadow
passwd_uindex=0
os_type=debian-linux
os_version=11.0
real_os_type=Ubuntu Linux
real_os_version=20.04.1
lang=en
log=1
referers_none=1
md5pass=1
theme=authentic-theme
product=webmin
mobile_theme=authentic-theme
webprefix=
logfiles=1
cache_mods=virtual-server
cache_size=52428800
gotomodule=
notabs=0
nomoduleup=
gotoone=0
nowebminup=
nohostname=0
deftab=webmin
realname_seven3regentgardens=tracey
notabs_seven3regentgardens=1
ownmods_seven3regentgardens=bind8 mysql apache webalizer virtual-server filemin passwd proc cron at telnet change-user htaccess-htpasswd mailboxes syslog phpini virtualmin-awstats virtualmin-htpasswd
readonly_seven3regentgardens=virtual-server
realname_ickleh=Ickleh Mail Server
notabs_ickleh=1
ownmods_ickleh=bind8 mysql apache virtual-server filemin passwd proc cron at telnet change-user htaccess-htpasswd mailboxes syslog phpini virtualmin-awstats virtualmin-htpasswd
readonly_ickleh=virtual-server
notabs_nod=1
realname_nod=NoIdeer Software
ownmods_nod=bind8 mysql apache webalizer virtual-server filemin passwd proc cron at telnet change-user htaccess-htpasswd mailboxes syslog phpini virtualmin-awstats virtualmin-htpasswd
readonly_nod=virtual-server
realname_orielhouse=tracey
notabs_orielhouse=1
ownmods_orielhouse=bind8 mysql apache webalizer virtual-server filemin passwd proc cron at telnet change-user htaccess-htpasswd mailboxes syslog phpini virtualmin-awstats virtualmin-htpasswd
readonly_orielhouse=virtual-server

webmin mysql

nodbi=0
mysqldump=/usr/bin/mysqldump
max_text=1000
mysqlshow=/usr/bin/mysqlshow
stop_cmd=service mysql stop
access=*: *
mysql_libs=/usr/local/mysql/lib
my_cnf=/etc/mysql/mysql.cnf
mysql_data=/var/lib/mysql
max_dbs=50
blob_mode=0
nopwd=0
style=1
webmin_subs=0
add_mode=1
passwd_mode=0
perpage=25
mysql=/usr/bin/mysql
date_subs=0
start_cmd=service mysql start
mysqladmin=/usr/bin/mysqladmin
mysqlimport=/usr/bin/mysqlimport
login=******
pass=***********
encoding=
charset=
host=
port=
sock=
mysqld=
Ilia's picture
Submitted by Ilia on Sat, 01/16/2021 - 17:57

I altered this to 0.0.0.0 to allow remote database connections to the server and it worked fine ..

MySQL module configuration has an option for that called Any, right next to where you entered 0.0.0.0.

it was only on update 8.0.22-0ubuntu0.20.04.3 the config was reset to 127.0.0.1 connections then failed

Package manager (apt) upon upgrading MySQL package in particular, when using the console, offers a variety of options on what should be done with the current config files, and if they should be upgraded as well or left intact. The default is to keep current configs but perhaps you somehow managed to select overwrite with the latest configs, which are delivered by upgradeable package. This is the only reasonable explanation I have for this issue and why it was "reset" to the default value.