ispconfig 3.0.2 oriblem with mysql - access denied

[zabry23]

Hi,

please I need help with ISPconfig 3.0.2.
After automatic update from version 3.0.1.6. email and web server is not runing
because have problem with connection to database.

Apache 2 log >>
DBI connect('database=dbispconfig;host=localhost:3306' ,'ispconfig',...) failed: Access denied for user 'ispconfig'@'localhost' (using password: YES) at /usr/local/ispconfig/server/scripts/vlogger line 255

Postfix log >>

postfix/smtp[3645]: warning: connect to mysql server 127.0.0.1: Access denied for user 'ispconfig'@'localhost' (using password: YES)


I try change password with phpmyadmin for user ispconfig and then paste MD5 hash to config.inc.php file to field db_password, but problem is still there.

Could you help me with this.

Thank you

[till]

I try change password with phpmyadmin for user ispconfig and then paste MD5 hash to config.inc.php file to field db_password, but problem is still there.

This can not work. Never try to change the password manually.

Please redo the update by using the manual update instructions that are diescribed in the release notes and select to reconfigure services when the updater asks you.

[zabry23]

I try run update manualy again but this problem is still there.
Is possible install ispconfig again with no lose data? Because I have a lot of email account in ispconfig.

Or is possible correct password for user ispconfig ?

Thank you

[till]

Is possible install ispconfig again with no lose data?

No. And this wont help you as the ispconfig install is not the problem, the problem is the mysql login.

Take a look at the config.inc.php file from ispconfig, there you find the cleartext password of the ispconfig user (looks like an md5, but thats the claertext password). Now login to your mysql database as root user with e.g. phpmyadmin and make sure that the user ispconfig is able to login to mysql with this password from localhost. Change this only in mysql and do not change the password in any ispconfig file, you have to make the mysal login work with this password and not try to set any other password.

[zabry23]

Originally Posted by till

No. And this wont help you as the ispconfig install is not the problem, the problem is the mysql login.

Take a look at the config.inc.php file from ispconfig, there you find the cleartext password of the ispconfig user (looks like an md5, but thats the claertext password). Now login to your mysql database as root user with e.g. phpmyadmin and make sure that the user ispconfig is able to login to mysql with this password from localhost. Change this only in mysql and do not change the password in any ispconfig file, you have to make the mysal login work with this password and not try to set any other password.

wery well ,,, I use password from config file to mysql for user ispconfig and everything is working.

Thank you