Problem after upgrade to 3.

[diablo666]

Hi there, i've upgrade ispconfig from version 3.0.4.3 to 3.0.4.4

My configuration is based in on debian etch 6.0, and it's configured with two nodes in cluster. Before the upgrade all works fine, but now i can't login to panel.

In the syslog i saw the following error

mysqld: 120427 13:28:17 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `attempts_login` SET `times`=`times`+1, `login_time`=NOW() WHERE `login_time` >= '1335526097' LIMIT 1

Any idea?

[till]

I've no idea, the scripts involved in the login process have not been altered between these two versions.

Are you sure that you installed the 3.0.4.4 stable version and not e.g. ispconfig svn version? And are the mysql login details in the file /usr/local/ispconfig/interface/lib/config.inc.php correct?

[diablo666]

Yes, i've upgraded to stable version.

i'm now looking on confing backup files to control the parameter you suggested.

[till]

You can test the mysql login details with the mysql command. Example:

mysql -h localhost -u ispconfig -p dbispconfig

the command should ask for the password then which can be found in the config.inc.php file.

[diablo666]

Oh maybe i've found the mistake

... and execute this command:

scp -p /usr/local/ispconfig/interface/lib/config.inc.php root@192.168.0.106:/usr/local/ispconfig/interface/lib/config.inc.php

This command has to be excuted after each ISPConfig update again after you updated ISPConfig on the master and on the slave with the normal ISPConfig update command (ispconfig_update.sh).

[diablo666]

Originally Posted by till

You can test the mysql login details with the mysql command. Example:

mysql -h localhost -u ispconfig -p dbispconfig

the command should ask for the password then which can be found in the config.inc.php file.

Credentials are fine, they work perfectly.

[diablo666]

Ok solved.

The problema was as i said before that you got to copy config.inc.php from master to slave.

scp -p /usr/local/ispconfig/interface/lib/config.inc.php root@192.168.0.106:/usr/local/ispcon...config.inc.php

After that all worked fine.

Tnx Till for support!