MySQL Creation Still Fails

Apparently I ran into the same issue as but the recommended patch is not applicable.

Here are the relevant versions and the file length/modification date:

System hostname --- Operating system Debian Linux 9
Webmin version 1.921 Usermin version 1.771
Virtualmin version 6.07 Pro Authentic theme version 19.38
mysql  Ver 15.1 Distrib 10.2.26-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
-rwxr-xr-x 1 root root 94939 Jul 27 05:15

Unfortunately, I was unable to find the original error message after I left the creation log page to locate the Virtualmin version.

Is this stuff in a log file somewhere?

I was able to find this in /var/webmin/webmin.log:

1565046248.506.0 [05/Aug/2019 23:04:08] root somehexstring package-updates update.cgi "update" "packages" "14" got='mysql-common' got='mariadb-common' got='libmariadb3' got='libmariadbclient18' got='webmin' got='mariadb-server-core-10.2' got='docker-ce-cli' got='usermin' got='mariadb-client-core-10.2' got='mariadb-client-10.2' got='docker-ce' got='webmin-virtual-server' got='mariadb-server-10.2' got='mariadb-server'
1565208711.8494.0 [07/Aug/2019 20:11:51] root somehexstring virtual-server mass_disable.cgi "disable" "domains" "1"
1565209229.12408.0 [07/Aug/2019 20:20:29] root somehexstring virtual-server domain_setup.cgi "create" "domain" "" alias='' alias_mode='0' aliasdomslimit='*' aliaslimit='' aliasmail='' allowedscripts='' auto_letsencrypt='0' awstats_pass='/home/somedomain/.awstats-htpasswd' bw_limit='' cgi_bin_dir='cgi-bin' cgi_bin_path='/home/somedomain/cgi-bin' created='1565209227' creator='root' crypt_enc_pass='---' dav_auth='Basic' dav_name_mode='1' db='somedomain' db_mysql='somedomain' db_postgres='' dbslimit='' defip='1' digest_enc_pass='---' dir='1' dns='1' dns_ip='' dom='' domslimit='' edit_admins='0' edit_aliases='1' edit_allowedhosts='0' edit_backup='0' edit_catchall='0' edit_dbs='0' edit_delete='0' edit_disable='0' edit_dnsip='0' edit_domain='0' edit_forward='0' edit_html='1' edit_ip='0' edit_mail='0' edit_passwd='1' edit_phpmode='0' edit_phpver='0' edit_records='0' edit_redirect='0' edit_restore='0' edit_sched='0' edit_scripts='0' edit_sharedips='0' edit_spam='0' edit_spf='0' edit_ssl='0' edit_users='1' email='' emailto='' emailto_addr='' emailto_src='' enc_pass='---' forceunder='0' ftp='0' gid='---' group='somedomain' hashpass='1' home='/home/somedomain' id='---' ip='---' ip6='' ipfollow='' lastsave='1565209227' letsencrypt_renew='2' limit_dir='1' limit_dns='1' limit_ftp='0' limit_logrotate='1' limit_mail='1' limit_mysql='1' limit_postgres='0' limit_spam='1' limit_ssl='1' limit_status='1' limit_unix='1' limit_virt='0' limit_virtualmin-awstats='1' limit_virtualmin-dav='1' limit_virus='1' limit_web='1' limit_webalizer='1' limit_webmin='0' logrotate='1' mail='1' mailboxlimit='' md5_enc_pass='---' migrate='' mongrelslimit='4' mysql='0' mysql_module='mysql' mysql_pass='---' mysql_user='somedomain' name='1' name6='1' netmask='' netmask6='' nodbname='0' norename='' owner='some owner' parent='' plan='0' postgres='0' prefix='somedomain' proxy_pass='' proxy_pass_mode='0' public_html_dir='public_html' public_html_path='/home/somedomain/public_html' quota='1048576' realdomslimit='*' reseller='' safeunder='' source='domain_setup.cgi' spam='1' ssl='1' ssl_cert='/home/somedomain/ssl.cert' ssl_combined='/home/somedomain/ssl.combined' ssl_everything='/home/somedomain/ssl.everything' ssl_key='/home/somedomain/ssl.key' stats_pass='/home/somedomain/.stats-htpasswd' status='1' subdom='' subprefix='' template='0' ugid='---' ugroup='somedomain' uid='---' unix='1' uquota='1048576' user='somedomain' virt='0' virt6='' virt6already='' virtalready='0' virtualmin-awstats='1' virtualmin-dav='1' virus='1' web='1' web_port='80' web_sslport='443' web_urlport='' web_urlsslport='' webalizer='1' webmin='1'


Howdy -- thanks for contacting us!

It's not likely stored anywhere, you may need to try creating a new database -- but it wouldn't hurt to take a peek in /var/webmin/miniserv.error to see if there's anything listed there.

Nothing pertinent in miniserv.error. However, I found this in mysql.error:

2019-08-09 7:50:07 139742549501696 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

I ran mysql-upgrade, deleted the virtual server and recreated it to reproduce the original error. However, this time the virtual server creation process created the MySQL database without errors.

The mystery here is how the MySQL instance got into this state.

Any update??? same here...

MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject) values ('localhost', '........', '', '', '', '') failed : Field 'authentication_string' doesn't have a default value at /usr/libexec/webmin/ line 1476.

This could happen if the MySQL upgrade process didn't complete properly - basically the meta-data tables that store user details were still in the old version's format.