ispCP - Board - Support
Help RC4 =>> RC5 Mysql error! - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: Help RC4 =>> RC5 Mysql error! (/thread-4705.html)



Help RC4 =>> RC5 Mysql error! - olegka - 10-15-2008 06:48 AM

Hi all.
Please forgive me my bad english!
After i update ispcp from rc5 to RC6, update script tell me all ok.
But, when i try go to the admin-interface i got error:

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'ispcp_user_name'@'localhost' (using password: YES)

I trying change password (http://www.isp-control.net/ispcp/wiki/howto_dbchangepw), change username...

Any ideas on how to fix this?
Thanks VERY BIG MUCH!


RE: Help RC4 =>> RC5 Mysql error! - olegka - 10-15-2008 09:14 AM

All other sites, mqsql, passwords and bases work fine!
& When i replace in /var/www/ispcp/gui/include/sql.php on line 30 "Config::get('DB_PASS')," on my password - all work fine.
I think error in function "function decrypt_db_password ($db_pass)" in file /var/www/ispcp/gui/include/ispcp-config.php
Thanks!


RE: Help RC4 =>> RC5 Mysql error! - joximu - 10-15-2008 03:33 PM

Maybe the password is not encrypted correctly - or had some signs/characters which could cause a problem.

You can do a change of the password - have a look here:
http://www.isp-control.net/ispcp/wiki/howto_dbchangepw

/Joxi


RE: Help RC4 =>> RC5 Mysql error! - olegka - 10-15-2008 08:43 PM

I do this. & i got the same error!


RE: Help RC4 =>> RC5 Mysql error! - joximu - 10-15-2008 08:59 PM

can you log in the database with the username and password?
eg. in pma or directly in mysql...


RE: Help RC4 =>> RC5 Mysql error! - olegka - 10-16-2008 07:35 PM

In pma, and directly in mysql i login correctly. Width same login\password


RE: Help RC4 =>> RC5 Mysql error! - sci2tech - 10-16-2008 08:40 PM

Mysql password is not stored in clear in ispcp.conf. If your mysql password is in clear in ispcp.conf something is really wrong. In ispcp.conf is saved an hash that can be decrypted using values from ispcp-db-keys.pl in case of perl or gui/include/ispcp-db-keys.php in case of php.