Hi, i've installed 2 server in cluster mode. Centos version: CentOS Linux release 7.3.1611 (Core) ISPConfig version: 3.1 dev Master ip (balthasar): XXX.YYY.ZZZ.182 Slave ip (casper): XXX.YYY.ZZZ.183 I have deployed some sites on master and everything it's ok. Today i've created a new site on slave machine and the job queue doesn't progress. Only slave's job stuck in queue. If i run /usr/local/ispconfig/server/server.sh in slave server i obtain the following error: Code: [[email protected] tmp]# /usr/local/ispconfig/server/server.sh 16.03.2017-16:08 - WARNING - There is already a lockfile set, but no process running with this pid (2110). Continuing. Datenbank nicht gefunden / Database not foundPHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 PHP Warning: mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198 PHP Warning: mysqli_connect(): (42000/1044): Access denied for user 'ispcsrv2'@'XXX.YYY.ZZZ.183' to database 'dbispconfig' in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 200 DB::query -> reconnectUnable to load the server configuration from database.Datenbank nicht gefunden / Database not found Someone know how to debug (more deeply) the problem?
Presumably, 'dbispconfig' is the master server database. The user, 'ispcsrv2' would have been created during the install process on the slave with permissions to read 'dbispconfig', and write to specific tables in 'dbispconfig'. If the install was done using the host name (casper.domain.tld) and not the IP address (XXX.YYY.ZZZ.183), then it is possible that the user in the database schema (mysql) that has the correct permissions is actually 'ispcsrv2'@'casper.domain.tld'. You may need to create a user 'ispcsrv2'@'XXX.YYY.ZZZ.183' and give it the same permissions to the 'dbispconfig' database as the other user. When adding servers to a multi-server setup, it is usually better to use the IP address as the hostname during the install. You can always change the 'name' of the server in the Web UI afterwards without affecting the config files.
