Hello,
I am using Virtualmin 5.04gpl on Centos 7.3 with mysql 5.6.35 from official mysql repos on a fresh VPS server.
I get the following error when I create a new virtual server:
Creating MySQL login ..
.. MySQL database failed! : DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/libexec/webmin/mysql/mysql-lib.pl line 317.
and the mysql feature is not enabled by default for the virtual server however if I edit the virtual server and enable Mysql feature for it and then save it, mysql enables properly.
Status:
Active
Comments
Submitted by JamieCameron on Thu, 12/22/2016 - 19:32 Comment #2
So you're saying this only happens at domain creation time?
Thank you Jamie for your reply,
Yes! This is a very strange issue. I have removed all mysql packages and installed default mariadb server from centos 7 base repo and also removed /var/lib/mysql as well as /etc/my.cnf and run mysql_install_db, the issue is still there and it happens when creating a new virtual server (or removing it)
I just found the issue!!
The issue comes from virtualmin-powerdns module! when I uncheck virtualmin-powerdns feature prior to creating the virtual server, the error doesn't happen :)
Submitted by JamieCameron on Fri, 12/23/2016 - 16:37 Comment #5
Ok ... are you intentionally using the PowerDNS plugin, or did you just have it enabled by mistake?
It was intentionally however I've now removed it and switched to bind because of this issue.
Submitted by JamieCameron on Sat, 12/24/2016 - 22:09 Comment #7
Are you sure that use of PowerDNS was the trigger? Because based on the original post, the error happened when setting up a mysql database for the domain..
Yes Jamie, you may not remember this correctly since you developed the plugin about 10 years ago! The plugin uses mysql database and it appears that the functions in that plugin cause that issue. I have tested it several times and I'm sure that the issue comes from Virtualmin powerdns plugin.
Submitted by JamieCameron on Mon, 12/26/2016 - 12:12 Comment #9
Any chance I could login to your system to see what's going wrong here? I'm unable to re-produce this, and it's really odd that an error in one plugin could effect a different feature..
Sure! Please confirm your public key
Submitted by JamieCameron on Tue, 12/27/2016 - 12:05 Comment #11
Here it is :
ssh-dss AAAAB3NzaC1kc3MAAACBALPtrQgus8wMeTrxiQREVKNGK1b8S9MLcsVngXsaNL2IpzHzajjDxEhkxARlpREFdvhPB9XEMa8IYVRmScyYaAMoespibzq1A24kcBQ3iLDrgoTb/UiRxv7c84WhQud1YpbteKpcpfG582wste+3FqkzvQ6pbNcI0Kkuruhb0s+HAAAAFQDDRVRFXdmNFNR+N3D/XwkIAb7hhQAAAIB0GN+AIuA9OonKbJpgoKz3TKhWNf6DAm39y8Zb//zMaK8/Lc1FMpOsNI/R4Y6LPvCJeAyDXuf/5OT3+613xu70bSSUi2g4UXA6RM/PlSUhdEH4XmG8SoB9abaIObU2AkH84Dkf25qVlSRAL/5aU/R7InXk7jJYFD+cz7vau/4jKAAAAIA1keU19UdRAzUKpbHFotBso8UnQzurcoFWNq8YtjkV9x32sjHuatab+mSXvjjSV9VDZ1Ru+6h5q/Vf6tr4yUuAYIo9s9LGA/MQgOVl7k+Dsn6N9UCta8/yoDXPMBbYQoiUJ2sOQ0pCaPeYXH6WTbB9edgxRow8WFQjGW26t6cF5Q== dsa-key-20031024
This has now been added, you can now login as root to gigfa.webs.nf !
Submitted by JamieCameron on Fri, 12/30/2016 - 01:44 Comment #13
Ok, give it a try now - it looks like something odd is happening on your system when two different parts of the Virtualmin code are connecting to MySQL as two different users. I enabled a work-around that should solve it though.