unable to create Virtual Server

Submitted by niaosuan on Thu, 01/16/2020 - 20:32

When creating Virtual Server through Virtualmin get this

Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL create user 'xxxxxxxxx'@'localhost' identified by password('') 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 '('')' at line 1 at /usr/share/webmin/web-lib-funcs.pl line 1374.

Saving server details .. .. done

Virtualmin version: 6.08
Mariadb/MySQL version: 10.3.17

Status: 
Active

Comments

Submitted by andreychek on Thu, 01/16/2020 - 20:34

Howdy -- thanks for contacting us!

What is the username and password in question in this case?

I'm curious if there's a character in one of them that's causing the issue you're seeing.

Submitted by niaosuan on Thu, 01/16/2020 - 21:09

ok sure. since it will be recreate username: speedtest password: bBQ3V[tBCutL

Submitted by andreychek on Thu, 01/16/2020 - 22:43

Hmm, just as a test, could you try changing the users password so that there is no "[" character in it, and then try it again?

If that works, that means there's some kind of escaping issue going on there.

Submitted by niaosuan on Fri, 01/17/2020 - 00:02

same...I think it is related to incompatible mariadb problem.

Ilia's picture
Submitted by Ilia on Fri, 01/17/2020 - 05:23

What Webmin version are you running on your system? Make sure to install latest version, which is 1.941.

Besides, what is the output of:

cat /usr/libexec/webmin/virtual-server/feature-mysql.pl |grep '$variant eq "mariadb" && &compare_versions($ver, "10.4")'

Note: Replace `libexec` with `share` on Debian/Ubuntu.