Submitted by ecrazor1911 on Fri, 06/06/2014 - 06:10
Hi,
I updated MySQL 5.5 server to MySQL 5.6, then this error shown at virtual server creation:
Creating MySQL login ..
.. MySQL database failed! : SQL insert into user (host, user, password, ssl_type, ssl_cipher) values ('localhost', 'main.totalhostin', password('********'), '', '') failed : Field 'x509_issuer' doesn't have a default value at /usr/share/webmin/web-lib-funcs.pl line 1385.
Status:
Active
Comments
Submitted by ecrazor1911 on Fri, 06/06/2014 - 06:23 Comment #1
Resolution:
/usr/share/webmin/virtual-server/feature-mysql.pl - 2492
return "insert into user (host, user, password, ssl_type, ssl_cipher, x509_issuer, x509_subject) ".
"values ('$host', '$user', $encpass, '', '', '', '')";
Then:
/etc/init.d/webmin restart
Submitted by andreychek on Fri, 06/06/2014 - 18:18 Comment #2
Howdy -- it sounds like MySQL 5.6 uses different settings that makes certain fields mandatory.
As a workaround, you could go into Webmin -> Servers -> MySQL Database -> mysql -> users, and set a default value for the fields that are failing (x509_issuer, for example).
Jamie is looking into handling that correctly in the next Virtualmin release.