ispCP - Board - Support
Update db error - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Preinstallation Questions (/forum-31.html)
+--- Thread: Update db error (/thread-12661.html)



Update db error - Alex1 - 01-13-2011 08:19 AM

When i want to update to 1.0.7 out this


Starting ispCP update
* Stopping services: .......... [ Done ]

ispCP main configuration file

Pre-installation tasks for Debian
* Postgrey configuration (Updating listening port): [ Done ]
* Loading old ispCP configuration file: [ Done ]
* Update ispCP configuration file: [ Done ]
* Check ispCP configuration file: [ Done ]
* Update ispCP key configuration file: [ Done ]

ispCP database
* Update ispCP database schema: [ Failed ]

[FATAL] An error occurred during update process!
Correct it and re-run this program.

Log files are stored in /var/log/ispcp/setup
You can also find help at http://isp-control.net/forum

ispcp-update.log

Quote:[ERROR]: Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

StackTrace:
#0 /var/www/ispcp/gui/include/ispCP/Initializer.php(201): ispCP_Initializer->_initializeDatabase()
#1 /var/www/ispcp/gui/include/ispCP/Initializer.php(102): ispCP_Initializer->_processCLI()
#2 /var/www/ispcp/gui/include/environment.php(236): ispCP_Initializer::run(Object(ispCP_Config_Handler_File))
#3 /var/www/ispcp/gui/include/ispcp-lib.php(114): require_once('/var/www/ispcp/...')
#4 /var/www/ispcp/engine/setup/updDB.php(44): require_once('/var/www/ispcp/...')
#5 {main}



sys_command_rs() | Ending...
getCmdExitValue() | Starting...
getCmdExitValue() | [DEBUG] External command exited with value 1
getCmdExitValue() | Ending...
exit_msg() | Starting...
exit_msg() | Ending...
del_file() | Starting...
del_file() | Ending...



RE: Update db error - Tjodalf - 03-07-2011 08:35 PM

(01-13-2011 08:19 AM)Alex1 Wrote:  When i want to update to 1.0.7 out this

[quote]
[ERROR]: Error: Unable to establish connection to the database! SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

Same problem here, I've checked ispcp.old.config many times but no success.
I can login to mysql console with the user/pw combination, but ispcp refuses to update....

OS is Lenny, ispCP Version: 1.0.7 RC

Thx in advance

Tjodalf


RE: Update db error - gOOvER - 03-08-2011 12:20 AM

Try to set a New MySQL Root Pw and restart upgrade. Then it should work Wink