Can't enable MYSQL feature on Virtual Server - web-lib-funcs.pl line 1476.

After last update I can't make new virtual server Server : VPS Fresh Install Deb9 / Fresh Virtualmin LEMP bundle. (Version 1.90202181208) I have made fresh install of system and virtualmin.. (debian 9, 2gb rab) and ... I got error message

Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL alter user 'gfdn'@'localhost' identified by 'test123' failed : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user 'gfdn'@'localhost' identified by 'test123'' at line 1 at /usr/share/webmin/web-lib-funcs.pl line 1476.

I made full dev update too and no changes..

Status: 
Active

Comments

Same here with:

Server version: 10.1.37-MariaDB-0+deb9u1 Debian 9.6

Hello

same error for me when i would clone a server!

Creating MySQL login .. .. Base de données MySQL a échoué! : mysql::execute_sql_logged failed : SQL alter user 'wnb.xxxxxx.net'@'localhost' identified by '2684bf895f72' manqué : Erreur de syntaxe pr�s de 'user 'wnb.xxxxxx.net'@'localhost' identified by '2684bf895f72'' � la ligne 1 at /usr/share/webmin/web-lib-funcs.pl line 1478.

for completed, the mysql user is created but with no password and the database is not created, after delete the server, the mysql user is not deleted !

Hi Jamie

same error with this patch ! Debian 8 and MariaDB 10.0.38

Thank you for your help Régis

Sorry !!!! I forgot to restart virtualmin ! it's ok for me with this patch !!

Thank you Jamie

Hello Same error also for me. Centos 7.6.1810 MariaDB 10.1.38. How have you restarted Virtualmin? I actually have restarted all my servers:

Apache Webserver
BIND DNS Server
Postfix Mail Server
Dovecot IMAP / POP3 Server
ProFTPD FTP Server
SSH Server
ClamAV Virus Scanning Server
SpamAssassin Filter Server
MySQL Database Server

but still the same problem using the patch. Any advice?

All right I found out by myself the way to restart virtualmin.

Since Virtualmin is a subcomponent of Webmin, you must restart Webmin in order to restart Virtualmin. 1> Connect to your VPS service via SSH. You will need to log in as the root user in order to run the restart command. 2> On the command line, type the "command /etc/init.d/webmin stop" and press Enter. Note that you may get an error message that says the Webmin service is already stopped. This is okay. 3> On the command line, type the "command /etc/init.d/webmin start" and press Enter.

NOW PATCH WORKS :)

@Maverjk go to "Webmin tab" and click "Webmin configuration" or with command line (Centos ?) with debian : systemctl restart webmin.service

Hello, I had the same issue on Devuan ascii (systemd-free fork of Debian 9) and the fix worked well.

Thanks James ! :)

Just jumping in (same problem here, it's a big issue) to get the updates.

--n

Hello, having same problem and i am unable to locate feature-mysql.pl file to apply that patch from github. any reference where and how to apply that patch?

thanks and regards.

@wajdan Depending on your OS it might be different, but for me on Debian9 the path is /usr/share/webmin/virtual-server/