+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: [solved] update 1.0.5 to 1.0.6: Unable to connect SQL server (/thread-12124.html)
[solved] update 1.0.5 to 1.0.6: Unable to connect SQL server - Endimmion - 11-13-2010 12:32 AM
Hi,
when upgrading from version 1.0.5 to 1.0.6 (on a Debian 5.0.6), I get the following error in the "Rebuilding all customers configuration files" section.:
Quote: Rebuilding all customers configuration files
Please wait, this may take some time:DEBUG: push_el() sub_name: update_old_disabled_dmn_layout(), msg: Starting...
DEBUG: push_el() sub_name: update_old_disabled_dmn_layout(), msg: Ending...
DEBUG: push_el() sub_name: rebuild_customers_cfg(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: Starting...
DEBUG: push_el() sub_name: doSQL(), msg: ERROR: Unable to connect SQL server !
Failed
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
I found the following thread http://isp-control.net/forum/thread-11623.html?highlight=connect but I can't understand the solution.
Can someone help me solve this problem? thank you
I have try something, but I think it's getting worse:
I've use the following command:
/var/www/ispcp/engine/ispcp-db-passwd
to reset the good password for my root user
But now the update script stop at the "ispCP database" section, and I have the following error in the log:
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
I have copy the value in :
$main::db_pass_key = '*****';
$main::db_pass_iv = '***';
in /var/www/ispcp/engine/ispcp-db-keys.pl
to /var/www/ispcp/gui/include/ispcp-db-keys.php
And finally the upgrade get successful