Mysql nutzer anlegen nicht möglich

**lorddeath87** · Apr 29th 2017

Hallo

ich habe folgende Fehlermeldung beim anlegen eines Mysql Nutzers bekommen:

Code

An exception has been thrown in file
/var/www/imscp/gui/library/Functions/Shared.php at line 2345:
==========================================================================
SQLSTATE[HY000]: General error: 1396 Operation ALTER USER failed for '2_shop'@'localhost'
Query was:
ALTER USER ?@? IDENTIFIED BY ? PASSWORD EXPIRE NEVER ==========================================================================
Backtrace:
__________
File: /var/www/imscp/gui/public/client/sql_change_password.php at line
109
Function: exec_query()
File: /var/www/imscp/gui/public/client/sql_change_password.php at line
157
Function: client_updateSqlUserPassword()
Contextual information:
_______________________
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0)
Gecko/20100101 Firefox/53.0
Request Uri: /client/sql_change_password.php?id=10
Http Referer:
https://panel.xx.de:8443/client/sql_change_password.php?id=10
Remote Addr: 84.115.253.xx
Server Addr: 82.220.38.xx

Display More

Debian Jessie

i-MSCP 1.4.3
Build: 20170417
Codename: Zimmer
MySQL: 5.7.18
Apache/2.4.10 (Debian)
Dovecot: 2.2.13

**Nuxwin** · Apr 29th 2017

This was a one time-failure or does this occurs each time you try to update a SQL user password?

**lorddeath87** · Apr 30th 2017

This failure occours each time when I update the Password.

When I create a new user I get the following error message:

Code

An exception has been thrown in file
/var/www/imscp/gui/library/Functions/Shared.php at line 2345:
==========================================================================
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imscp.sql_user.sqlu_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query was:
SELECT sqlu_id, sqlu_name, sqlu_host FROM sql_user INNER JOIN
sql_database USING(sqld_id) WHERE domain_id = :domain_id AND
sqld_id != :sqld_id AND CONCAT(sqlu_name, sqlu_host) NOT IN(
SELECT CONCAT(sqlu_name, sqlu_host) FROM sql_user WHERE sqld_id = :sqld_id
) GROUP BY sqlu_name, sqlu_host
==========================================================================
Backtrace:
__________
File: /var/www/imscp/gui/public/client/sql_user_add.php at line 82
Function: exec_query()
File: /var/www/imscp/gui/public/client/sql_user_add.php at line 379
Function: client_generateSqlUserList()
Contextual information:
_______________________
Http User Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0)
Gecko/20100101 Firefox/53.0
Request Uri: /client/sql_user_add.php?id=21 Http Referer: https://panel.xxx.de:8443/client/sql_manage.php
Remote Addr: 84.115.253.xx
Server Addr: 82.220.38.xx

Display More

**lorddeath87** · Apr 30th 2017

Nach einer neuinstallierung von imscp war der fehler behoben

**Nuxwin** · Apr 30th 2017

Solved with same MySQL version?

**lorddeath87** · Apr 30th 2017

Quote from Nuxwin

@lorddeath87

Solved with same MySQL version?

# mysql --version
mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper

Yes, it is the same Version

Share