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: 
Closed (fixed)

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/

REMOVE STRICT_TRANS_TABLES

For me worked editing my.cnf from Webmin > Servers > Mysql... > edit config files

Before adding next line view what you have in sql_mode in Webmin > Servers > Mysql... > MySQL System Variables from

add next line in section client : [client] init-command="set sql_mode='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'"

then restart mysql server from dashboard and restart webmin service from ssh.

for me worked with debian 10 and mariadb 10.3 on latest version of webmin and virtualmin in sept 2019.

Sorry for my english. Not my native language.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.