Accéder au contenu.
Menu Sympa

fr - [sympa-fr] problème upgrade base mysql sympa

Objet : Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa

Archives de la liste

Chronologique Discussions  
  • From: Anne-Marie Philippon <adresse@cachée>
  • To: adresse@cachée
  • Subject: [sympa-fr] problème upgrade base mysql sympa
  • Date: Fri, 28 Oct 2011 15:44:43 +0200

Bonjour
Je viens d'installer un nouveau serveur sympa en version 6.1.5
Après avoir récupéré la base sympa installée sur une version 5.2.4, je n'arrive pas à upgrader ma base:

Voici ce que j'obtiens:
/usr/sbin/sympa.pl --upgrade --from=5.2.4 --to=6.1.5
info Configuration file read, default log level 0
notice Upgrade::probe_db() Table conf_table created in database sympa
notice Upgrade::probe_db() Table logs_table created in database sympa
notice Upgrade::probe_db() Table exclusion_table created in database sympa
notice Upgrade::probe_db() Table session_table created in database sympa
notice Upgrade::probe_db() Table bulkspool_table created in database sympa
notice Upgrade::probe_db() Table one_time_ticket_table created in database sympa
notice Upgrade::probe_db() Table bulkmailer_table created in database sympa
info Upgrade::probe_db() Field 'label_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field label_conf added to table conf_table
info Upgrade::probe_db() Field 'robot_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field robot_conf added to table conf_table
info Upgrade::probe_db() Field 'value_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field value_conf added to table conf_table
info Upgrade::probe_db() Missing expected primary key : robot_conf
info Upgrade::probe_db() Missing expected primary key : label_conf
info Upgrade::probe_db() Table conf_table, PRIMARY KEY set on robot_conf,label_conf
info Upgrade::probe_db() Field 'action_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field action_logs added to table logs_table
info Upgrade::probe_db() Field 'client_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field client_logs added to table logs_table
info Upgrade::probe_db() Field 'daemon_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field daemon_logs added to table logs_table
info Upgrade::probe_db() Field 'date_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field date_logs added to table logs_table
info Upgrade::probe_db() Field 'error_type_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field error_type_logs added to table logs_table
info Upgrade::probe_db() Field 'id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field id_logs added to table logs_table
info Upgrade::probe_db() Field 'list_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field list_logs added to table logs_table
info Upgrade::probe_db() Field 'msg_id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field msg_id_logs added to table logs_table
info Upgrade::probe_db() Field 'parameters_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field parameters_logs added to table logs_table
info Upgrade::probe_db() Field 'robot_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field robot_logs added to table logs_table
info Upgrade::probe_db() Field 'status_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field status_logs added to table logs_table
info Upgrade::probe_db() Field 'target_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field target_email_logs added to table logs_table
info Upgrade::probe_db() Field 'user_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field user_email_logs added to table logs_table
info Upgrade::probe_db() Missing expected primary key : id_logs
info Upgrade::probe_db() Table logs_table, PRIMARY KEY set on id_logs
info Upgrade::probe_db() Field 'data_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field data_user added to table user_table
info Upgrade::probe_db() Field 'last_login_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field last_login_date_user added to table user_table
info Upgrade::probe_db() Field 'last_login_host_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field last_login_host_user added to table user_table
info Upgrade::probe_db() Field 'wrong_login_count_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
info Upgrade::probe_db() Field wrong_login_count_user added to table user_table
info Upgrade::probe_db() Missing expected primary key : email_user
DBD::mysql::db do failed: Duplicate entry 'adresse@cachée' for key 1 at /usr/share/sympa/lib/Upgrade.pm line 1309.

err Upgrade::probe_db() Could not set field 'email_user' as PRIMARY KEY, table'user_table'.
Database sympa defined in sympa.conf has not the right structure or is unreachable. verify db_xxx parameters in sympa.conf


Comment s'en sortir?
Les paramètres db_... de sympa.conf sont identiques à ceux de la version 5.2.4
Si je supprime une des 2 entrées  adresse@cachée, je tombe sur la suivante, etc

Merci de m'aider
Anne-Marie Philippon





Archives gérées par MHonArc 2.6.19+.

Haut de le page