Objet : Pour les administrateurs de serveurs de listes utilisant le logiciel Sympa
Archives de la liste
[sympa-fr] Installation base mysql pour sympa 5.2.4
- From: "adresse@cachée" <adresse@cachée>
- To: adresse@cachée
- Subject: [sympa-fr] Installation base mysql pour sympa 5.2.4
- Date: Fri, 04 May 2007 15:47:57 +0200
|
Bonjour, Je suis en train d'installer la version 5.2.4 de sympa sur une redhat AS4 et je rencontre divers problèmes notamment pour la création de ma base mysql. 1) J'ai crée la base sympa vide et je lance sympa Voici ce que j'obtiens: Starting Sympa subsystem: Starting module sympa.pl: DBD::mysql::db do failed: Can't DROP 'list_admin'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'robot_admin'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'user_admin'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'role_admin'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'email_user'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'list_subscriber'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'robot_subscriber'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'user_subscriber'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'netid_netidmap'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'serviceid_netidmap'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. DBD::mysql::db do failed: Can't DROP 'robot_netidmap'. Check that column/key exists at /home/sympa/bin/List.pm line 11003. je reçois un mail avec comme objet "La structure de la base de données a été mise à jour" et dans le corps La structure de la base de données a été mise à jour ; consultez les journaux pour plus de détails : Table admin_table created in database sympa Table user_table created in database sympa Table subscriber_table created in database sympa Table netidmap_table created in database sympa Field 'comment_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field comment_admin added to table admin_table Field 'date_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field date_admin added to table admin_table Field 'include_sources_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field include_sources_admin added to table admin_table Field 'included_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field included_admin added to table admin_table Field 'info_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field info_admin added to table admin_table Field 'list_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field list_admin added to table admin_table Field 'profile_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field profile_admin added to table admin_table Field 'reception_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field reception_admin added to table admin_table Field 'robot_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field robot_admin added to table admin_table Field 'role_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field role_admin added to table admin_table Field 'subscribed_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field subscribed_admin added to table admin_table Field 'update_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field update_admin added to table admin_table Field 'user_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it... Field user_admin added to table admin_table Table admin_table, PRIMARY KEY dropped Table admin_table, PRIMARY KEY set on list_admin,robot_admin,user_admin,role_admin Table admin_table, INDEX set on list_admin,robot_admin,user_admin,role_admin Field 'attributes_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field attributes_user added to table user_table Field 'cookie_delay_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field cookie_delay_user added to table user_table Field 'email_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field email_user added to table user_table Field 'gecos_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field gecos_user added to table user_table Field 'lang_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field lang_user added to table user_table Field 'password_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it... Field password_user added to table user_table Table user_table, PRIMARY KEY dropped Table user_table, PRIMARY KEY set on email_user Table user_table, INDEX set on email_user Field 'bounce_address_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field bounce_address_subscriber added to table subscriber_table Field 'bounce_score_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field bounce_score_subscriber added to table subscriber_table Field 'bounce_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field bounce_subscriber added to table subscriber_table Field 'comment_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field comment_subscriber added to table subscriber_table Field 'date_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field date_subscriber added to table subscriber_table Field 'include_sources_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field include_sources_subscriber added to table subscriber_table Field 'included_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field included_subscriber added to table subscriber_table Field 'list_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field list_subscriber added to table subscriber_table Field 'reception_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field reception_subscriber added to table subscriber_table Field 'robot_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field robot_subscriber added to table subscriber_table Field 'subscribed_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field subscribed_subscriber added to table subscriber_table Field 'topics_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field topics_subscriber added to table subscriber_table Field 'update_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field update_subscriber added to table subscriber_table Field 'user_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field user_subscriber added to table subscriber_table Field 'visibility_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it... Field visibility_subscriber added to table subscriber_table Table subscriber_table, PRIMARY KEY dropped Table subscriber_table, PRIMARY KEY set on list_subscriber,robot_subscriber,user_subscriber Table subscriber_table, INDEX set on list_subscriber,robot_subscriber,user_subscriber Field 'email_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it... Field email_netidmap added to table netidmap_table Field 'netid_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it... Field netid_netidmap added to table netidmap_table Field 'robot_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it... Field robot_netidmap added to table netidmap_table Field 'serviceid_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it... Field serviceid_netidmap added to table netidmap_table Table netidmap_table, PRIMARY KEY dropped Table netidmap_table, PRIMARY KEY set on netid_netidmap,serviceid_netidmap,robot_netidmap Table netidmap_table, INDEX set on netid_netidmap,serviceid_netidmap,robot_netidmap 2) Lors du démarrage suivant sympa.pl ne se lance plus et j'ai le message Starting Sympa subsystem: Starting module sympa.pl: DBD::mysql::db do failed: Table 'admin_table' already exists at /home/sympa/bin/List.pm line 10767. DBD::mysql::db do failed: Table 'user_table' already exists at /home/sympa/bin/List.pm line 10767. DBD::mysql::db do failed: Table 'subscriber_table' already exists at /home/sympa/bin/List.pm line 10767. DBD::mysql::db do failed: Table 'netidmap_table' already exists at /home/sympa/bin/List.pm line 10767. DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '.`admin_table' at line 1 at /home/sympa/bin/List.pm line 10789. Database sympa defined in sympa.conf has not the right structure or is unreachable. If you don't use any database, comment db_xxx parameters in sympa.conf Merci de votre assistance Cordialement |
-
[sympa-fr] Installation base mysql pour sympa 5.2.4,
adresse@cachée, 04/05/2007
- [sympa-fr] Re: Installation base mysql pour sympa 5.2.4, David Verdin, 09/05/2007
Archives gérées par MHonArc 2.6.19+.