Hello all! I got a strange problem since today. Since today, I have an PHP process on my ISPConfig3 system, which starts automatically, and starts eating ALL available memory. The problem seams to be the server.php / server.sh. Also, the jobqueue inside the ispconfig3 frontend is no more processed. So I configured Debugging, and disabled the Cronjob for server.sh. But I can't locate the Problem. Till now ISPConfig3 seemd fully functional, but in the output of server.sh (started from command line), i get thousands of lines like this 23.02.2014-15:25 - WARNING - DB::query(SELECT count(syslog_id) as number FROM sys_log WHERE datalog_id = 910 AND loglevel = 2) -> mysqli_query Access denied for user 'root'@'localhost' (using password: YES) What is going wrong, in which direction do i have to search? Thanks in advance, Ralf
You must have altered the mysql details in the ispconfig server config.inc.php files on your system. The ispconfig server process never uses the mysql root user for the query that you posted above. On a a single server setup, the mysql user "ispconfig" is used, on multiserver setups, the username is ispcsrv followed by a number which represents the server if of the server.
I did not change the settings in server/lib/config.inc.php. Here are my DB settings: //** Database $conf['db_type'] = 'mysql'; $conf['db_host'] = 'localhost'; $conf['db_database'] = 'dbispconfig'; $conf['db_user'] = 'ispconfig'; $conf['db_password'] = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'; $conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1") $conf['db_new_link'] = false; $conf['db_client_flags'] = 0; define('DB_TYPE',$conf['db_type']); define('DB_HOST',$conf['db_host']); define('DB_DATABASE',$conf['db_database']); define('DB_USER',$conf['db_user']); define('DB_PASSWORD',$conf['db_password']); define('DB_CHARSET',$conf['db_charset']); The /var/log/ispconfig/ispconfig.log contains: 23.02.2014-15:55 - DEBUG - There is already a lockfile set. Waiting another 10 seconds... 23.02.2014-15:55 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 23.02.2014-15:55 - DEBUG - Found 36 changes, starting update process. 23.02.2014-15:55 - DEBUG - Calling function 'db_user_delete' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_delete'. 23.02.2014-15:55 - ERROR - Unable to connect to mysqlAccess denied for user 'root'@'localhost' (using password: YES) 23.02.2014-15:55 - WARNING - DB::query(SELECT count(syslog_id) as number FROM sys_log WHERE datalog_id = 910 AND loglevel = 2) -> mysqli_query Access denied for user 'root'@'localhost' (using password: YES) The last line is repeated endless. (The size of the logfile was already 2GB) Is it possible, that in any kind server.php makes a call to mysql, without setting the USER, so the executing user (root) is used???
Please check that the root user password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct. This user and password is used to add / remove databases like in this line "23.02.2014-15:55 - DEBUG - Calling function 'db_user_delete' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_delete'." mentioned.
