[sympa-fr] [Debian] Mise à jour 5.3.4 -> 6.0.1

[Johan A <adresse@cachée>]

Bonjour,

Je suis en train de tester la mise à niveau d'un serveur de messagerie Debian (Cyrus/Postfix/Sympa/Roundcube) de Lenny vers Squeeze.

Voici mes étapes de réalisation :

- Mise à jour du sources.list pour les dépôts Squeeze

- Mise à niveau minimale : apt-get update && apt-get upgrade

- Mise à niveau du noyau : apt-get install linux-image-2.6-686

- Mise à niveau d'udev : apt-get install udev

- Mise à niveau complète : apt-get update && apt-get dist-upgrade

C'est au niveau de cette mise à niveau complète que le paquet sympa se voit être mis à jour de la version 5.3.4 à la version 6.0.1.  A la fin de l'opération s'affiche le message d'erreur :

Des erreurs ont été rencontrées pendant l'exécution :

 sympa

E: Sub-process /usr/bin/dpkg returned an error code (1)

Et lorsque j'essaie de lancer sympa :

/etc/init.d/sympa start

Starting Sympa mailing list manager: sympaerror : data structure was not updated ; you should run sympa.pl --upgrade to run the upgrade process.

Starting Sympa bulk daemon: bulk.

Starting Sympa mailing list archive manager: archived.

Starting Sympa task manager: task_managererror : data structure was not updated ; you should run sympa.pl to run the upgrade process.

Starting Sympa bounce manager: bounced.

Je lance donc l'upgrade :

/usr/lib/sympa/bin/sympa.pl --upgrade
Configuration file read, default log level 0
wwslib::load_config() Parameter icons_url in /etc/sympa/wwsympa.conf no more supported : No more used. Using static_content/icons instead.
Sympa 6.0.1 started
Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/style.css ; previous file renamed
Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/print.css ; previous file renamed

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/fullPage.css ; previous file renamed

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/print-preview.css ; previous file renamed

Upgrade process...

Upgrading from 5.3.4 to 6.0.1...

Upgrade::upgrade() Upgrade::upgrade(5.3.4, 6.0.1)

Upgrade::upgrade() Rebuilding config.bin files for ALL lists...it may take a while...

Upgrade::upgrade() Rebuilding the admin_table...

Upgrade::upgrade() Looking for lists with user_data_source parameter set to file or database...

Upgrade::upgrade() Removing obsolete OTHER/ bounce directories

Upgrade process finished.

A noter que si je lance l'upgrade sans essayer de démarrer sympa au préalable (via le /etc/init.d/sympa start), la sortie écran est beaucoup plus complète :

/usr/lib/sympa/bin/sympa.pl --upgrade

Configuration file read, default log level 0

Upgrade::probe_db() Table conf_table created in database sympa

Upgrade::probe_db() Table session_table created in database sympa

Upgrade::probe_db() Table bulkspool_table created in database sympa

Upgrade::probe_db() Table one_time_ticket_table created in database sympa

Upgrade::probe_db() Table bulkmailer_table created in database sympa

Upgrade::probe_db() Field 'label_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field label_conf added to table conf_table

Upgrade::probe_db() Field 'robot_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field robot_conf added to table conf_table

Upgrade::probe_db() Field 'value_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field value_conf added to table conf_table

Upgrade::probe_db() Missing expected primary key : robot_conf

Upgrade::probe_db() Missing expected primary key : label_conf

Upgrade::probe_db() Table conf_table, PRIMARY KEY set on robot_conf,label_conf

Upgrade::probe_db() Field 'data_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field data_user added to table user_table

Upgrade::probe_db() Field 'last_login_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field last_login_date_user added to table user_table

Upgrade::probe_db() Field 'last_login_host_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field last_login_host_user added to table user_table

Upgrade::probe_db() Field 'data_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field data_session added to table session_table

Upgrade::probe_db() Field 'date_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field date_session added to table session_table

Upgrade::probe_db() Field 'email_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field email_session added to table session_table

Upgrade::probe_db() Field 'hit_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field hit_session added to table session_table

Upgrade::probe_db() Field 'id_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field id_session added to table session_table

Upgrade::probe_db() Field 'remote_addr_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field remote_addr_session added to table session_table

Upgrade::probe_db() Field 'robot_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field robot_session added to table session_table

Upgrade::probe_db() Field 'start_date_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field start_date_session added to table session_table

Upgrade::probe_db() Missing expected primary key : id_session

Upgrade::probe_db() Table session_table, PRIMARY KEY set on id_session

Upgrade::probe_db() Field 'lock_bulkspool' (table 'bulkspool_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field lock_bulkspool added to table bulkspool_table

Upgrade::probe_db() Field 'message_bulkspool' (table 'bulkspool_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field message_bulkspool added to table bulkspool_table

Upgrade::probe_db() Field 'messagekey_bulkspool' (table 'bulkspool_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field messagekey_bulkspool added to table bulkspool_table

Upgrade::probe_db() Missing expected primary key : messagekey_bulkspool

Upgrade::probe_db() Table bulkspool_table, PRIMARY KEY set on messagekey_bulkspool

Upgrade::probe_db() Field 'visibility_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field visibility_admin added to table admin_table

Upgrade::probe_db() Added INDEX 'user_index' in table 'admin_table'

Upgrade::probe_db() Field 'data_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field data_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'date_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field date_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'email_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field email_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'remote_addr_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field remote_addr_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'robot_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field robot_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'status_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field status_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Field 'ticket_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field ticket_one_time_ticket added to table one_time_ticket_table

Upgrade::probe_db() Missing expected primary key : ticket_one_time_ticket

Upgrade::probe_db() Table one_time_ticket_table, PRIMARY KEY set on ticket_one_time_ticket

Upgrade::probe_db() Field 'custom_attribute_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field custom_attribute_subscriber added to table subscriber_table

Upgrade::probe_db() Added INDEX 'user_index' in table 'subscriber_table'

Upgrade::probe_db() Field 'delivery_date_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field delivery_date_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'listname_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field listname_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'lock_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field lock_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'messagekey_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field messagekey_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'packetid_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field packetid_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'priority_message_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field priority_message_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'priority_packet_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field priority_packet_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'receipients_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field receipients_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'reception_date_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field reception_date_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'returnpath_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field returnpath_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'robot_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field robot_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Field 'verp_bulkmailer' (table 'bulkmailer_table' ; database 'sympa') was NOT found. Attempting to add it...

Upgrade::probe_db() Field verp_bulkmailer added to table bulkmailer_table

Upgrade::probe_db() Missing expected primary key : packetid_bulkmailer

Upgrade::probe_db() Missing expected primary key : messagekey_bulkmailer

Upgrade::probe_db() Table bulkmailer_table, PRIMARY KEY set on messagekey_bulkmailer,packetid_bulkmailer

wwslib::load_config() Parameter icons_url in /etc/sympa/wwsympa.conf no more supported : No more used. Using static_content/icons instead.

Sympa 6.0.1 started

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/style.css ; previous file renamed

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/print.css ; previous file renamed

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/fullPage.css ; previous file renamed

Conf::checkfiles() Updating static CSS file /var/lib/sympa/static_content/css/print-preview.css ; previous file renamed

Upgrade process...

Upgrading from 5.3.4 to 6.0.1...

Upgrade::upgrade() Upgrade::upgrade(5.3.4, 6.0.1)

Upgrade::upgrade() Rebuilding config.bin files for ALL lists...it may take a while...

Upgrade::upgrade() Rebuilding the admin_table...

Upgrade::upgrade() Looking for lists with user_data_source parameter set to file or database...

Upgrade::upgrade() Removing obsolete OTHER/ bounce directories

Upgrade process finished.

Dans un cas comme dans l'autre sympa peut ensuite démarrer mais l'interface web est inaccessible et le paquet sympa est considéré comme partiellement installé.

Lors du démarrage de sympa je trouve dans les logs : 

Jun 26 17:23:09 giedi2 wwsympa.fcgi: List::send_notify_to_listmaster() List::send_notify_to_listmaster(%s) : missing incoming parameter "$robot"

Jun 26 17:23:09 giedi2 wwsympa.fcgi: Log::fatal_err() Unable to send notify 'sympa died' to listmaster

Jun 26 17:23:14 giedi2 wwsympa.fcgi: wwslib::load_config() load_config: unable to open /etc/sympa/wwsympa.conf

Jun 26 17:23:14 giedi2 wwsympa.fcgi: Unable to load config file /etc/sympa/wwsympa.conf

Jun 26 17:23:14 giedi2 wwsympa.fcgi: Exiting.

A noter également que je remarque des changements de configuration au niveau du sympa.conf (par exemple l'adresse du listmaster qui a changé)

Le problème vient-il de sympa ou de la Debian ? J'ai vu que des gens étaient passés de la 5.3.4 à la 6.0.1 sans problème, est-ce moi qui ne prend pas la mise à jour par le bon bout ?

Cordialement,

Johan