MySQL Creation Still Fails

Submitted by jabowery on Wed, 08/07/2019 - 15:59 Pro Licensee

Apparently I ran into the same issue as https://www.virtualmin.com/node/64694 but the recommended patch is not applicable.

Here are the relevant versions and the feature-mysql.pl 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 feature-mysql.pl

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 55.55.55.55 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 55.55.55.55 virtual-server mass_disable.cgi "disable" "domains" "1"
1565209229.12408.0 [07/Aug/2019 20:20:29] root somehexstring 55.55.55.55 virtual-server domain_setup.cgi "create" "domain" "somedomain.com" 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='somedomain.com' 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='somedomain@somedomain.com' emailto_addr='somedomain@somedomain.com' emailto_src='somedomain@somedomain.com' 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'
Status: 
Active

Comments

Submitted by andreychek on Thu, 08/08/2019 - 00:03

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.

Submitted by jabowery on Fri, 08/09/2019 - 10:29 Pro Licensee

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.

Submitted by karlen1983@gmail.com on Fri, 08/09/2019 - 14:34

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/web-lib-funcs.pl line 1476.

Submitted by JamieCameron on Sun, 08/11/2019 - 17:52

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.