Hallo,
I wanted to create a new MariaDb user and all I got was:
2016-03-09_20h11_26.png
Message I got via E-Mail:
Dear admin,
An exception has been thrown in file
/var/www/imscp/gui/library/Functions/Shared.php at line 2719:
=================================================================
SQLSTATE[42000]: Syntax error or access violation: 1064 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 'PASSWORD
EXPIRE NEVER' at line 1
Query was:
CREATE USER ?@? IDENTIFIED BY ? PASSWORD EXPIRE NEVER
=================================================================
Debug backtrace:
---------------
File: /var/www/imscp/gui/public/client/sql_user_add.php at line 252
Function: exec_query()
File: /var/www/imscp/gui/public/client/sql_user_add.php at line 342
Function: client_addSqlUser()
Additional information:
----------------------
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116
Safari/537.36
Request Uri: /client/sql_user_add.php
Http Referer:
https://SRV.DOMAIN.TLD:4443/client/sql_user_add.php?id=26
Remote Addr: XXX.XXX.XXX.XXX
Server Addr: YYY.YYY.YYY.YYY
____________________________________________________________
i-MSCP Exception Mail Writer
Note: You will not receive further emails for this exception in the
next 24 hours.
Is there anyone who knows this error / who can help me?
This is a known bug which has been fixed in the 1.2.x branch. The fix will be available in version 1.2.16.
Awaiting the new version, you can fix the problem as follow:
Edit the /var/www/imscp/gui/public/client/sql_user_add.php and change line 247
to
Edit /var/www/imscp/gui/public/client/client/sql_change_password.php line and change line 106
to:
Once done, restart imscp_panel service.