[Résolu] Probléme de mise a jour 1.0.6 => 1.0.7

[Sissou]

Bonsoir,

Je me permet de demander votre aide car je rencontre un problème lors de la mise a jour d'ispcp 1.0.6 vers 1.0.7

Pour effectuer la mis a jour j'ai suivi cette doc : http://isp-control.net/documentation/sta...ade/debian

Je démarre donc la mise a jour avec la commande: perl ispcp-update

Mais la connexion a la basse de donné et impossible :


Fichier log /var/log/ispcp/setup :

Code:

get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
makepath()                     | Starting...
makepath()                     | [NOTICE] '/var/log/ispcp/setup' exists ! Setting its permissions...
setfmode()                     | Starting...
setfmode()                     | Ending...
makepath()                     | Ending...
update_startup()               | Starting...
del_file()                     | Starting...
del_file()                     | [ERROR] File '/tmp/ispcp-setup.log' does not exist !
lock_system()                  | Starting...
lock_system()                  | Ending...
update_startup()               | Ending...
update_engine()                | Starting...
user_dialog()                  | Starting...
welcome_note()                 | Starting...
welcome_note()                 | Ending...
warn_msg()                     | Starting...
warn_msg()                     | Ending...
user_dialog()                  | Ending...
stop_services()                | Starting...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP Network Traffic Logger: ispcp_network failed!
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_network stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/ispcp_daemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping domain name service...: bind9.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/bind9 stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping web server: apache2 ... waiting ...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/apache2 stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping ftp server: proftpd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/proftpd stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping policyd-weight (incl. cache): policyd-weight.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/policyd-weight stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Postfix Mail Transport Agent: postfix.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/postfix stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier authentication services: authdaemond.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-authdaemon stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier POP3 server: pop3d.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-pop stop') | Ending...
sys_command()                  | Starting...
system()                       | [DEBUG] Stopping Courier IMAP server: imapd.
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/etc/init.d/courier-imap stop') | Ending...
stop_services()                | Ending...
load_old_ispcp_config()        | Starting...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
load_old_ispcp_config()        | Ending...
update_ispcp_cfg()             | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
set_conf_val()                 | Starting...
set_conf_val()                 | Ending...
store_conf()                   | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
store_file()                   | Starting...
setfmode()                     | Starting...
setfmode()                     | Ending...
store_file()                   | Ending...
get_conf()                     | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
setup_main_vars()              | Starting...
decrypt_db_password()          | Starting...
decrypt_db_password()          | Ending...
setup_main_vars()              | Ending...
get_conf()                     | Ending...
store_conf()                   | Ending...
update_ispcp_cfg()             | Ending...
check_ispcp_cfg_file()         | Starting...
check_ispcp_cfg_file()         | Ending...
preinst()                      | Starting...
sys_command()                  | Starting...
getCmdExitValue()              | Starting...
getCmdExitValue()              | [DEBUG] External command exited with value 0
getCmdExitValue()              | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst()                      | Ending...
update_database_schema()       | Starting...
get_file()                     | Starting...
get_file()                     | Ending...
save_file()                    | Starting...
save_file()                    | Ending...
sys_command_rs()               | Starting...
system()                       | [DEBUG]
[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(235): ispCP_Initializer::run(Object(ispCP_Config_Handler_File))
#3 /var/www/ispcp/gui/include/ispcp-lib.php(115): 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...

Code:

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

Donc le prossesus de mise a jour ne parvient pas a se connecter a la base de donnée alors que mysql et démarrer, et le mot de passe du compte n'a pas changer.

Si quelqu'un a une solution ?

Je vous remercie par avance pour votre aide.

Salutation
Sissou

[momo]

Bonjour Sissou,

le message est clair : "Ne peut se connecter à mysql"
Donc mauvais mot-de-passe root

Dans ces cas là :
1-connectez-vous mysql en root

Code:

SET PASSWORD FOR 'root'@'localhost' = password('');
FLUSH PRIVILEGES;
quit
nano /etc/ispcp/ispcp.conf

2-Vérifiez la ligne

Code:

DATABASE_NAME = root

3-effacer le mot-d-pass (ça donne)

Code:

DATABASE_PASSWORD =

4-Relancer le update

5-!!! REMETTRE UN MOT-DE-PASSE root après l'install
6- Dites-le à ispcp

Code:

/var/www/ispcp/engine/ispcp-db-passwd
/etc/init.d/ispcp_daemon restart

Ça devrait être bon.

[Sissou]

Merci bien pour votre aide