ispconfig and mysql

[sefokuma]

Hi, i´ve a ispconfig server running ok but i want use other sever for mysql server. When i try change the config (db_host) from localhost to new_mysql_server I recive an error and cant login, in the new server i have the same database copied and runs with the same permissions.

I have could see that when i try restart ispconfig service this launch the next error, but the system starts.

error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
No results found!ISPConfig system is now up and running!


I have only edit the file /home/admispconfig/ispconfig/lib/config.inc.php, switching in the line 87 localhost to new_mysql_server.

Thx, bye.

[till]

are you able to login in the ISPConfig interface?

[sefokuma]

Yes i have running ispconfig on port 81 with https ok, and load login.php but when i try to login with the user and password corrects i recive ERROR 101.

Some idea?

[till]

Ok, in this case the login data to the mysql database is not correct or the database is empty or ISPConfig has no permissions to read the data.

[sefokuma]

OMG, mate i forgot a simple GRANT ALL. Sorry but this noob post lol.

Thx