[sympa-fr] Re: Error upgrade 5.1.2 en 5.2.3

[Samuel Torton <adresse@cachée>]

Bonjour et bonne annee a toute la liste,

Je me permets de re-poster un message (ci-dessous), que j'avais posté juste
avant Noel. Il avait ete sans reponse, car sans doute tombé dans les 
oubliettes
des festivités ;-)

Pour se remettre dans le sujet: j'ai fait un upgrade d'une version 5.1.2 vers
5.2.3, qui a echoué avec PostgreSQL. Apparemment, PostgreSQL n'est pas
supporté. Dans ce cas-là, quelqu'un pourrait-il me fournir le schema exact des
tables SQL de la version 5.2.3, ainsi que les valeurs a mettre dans les
nouveaux champs vides de mes tables existantes, post-migration ?

Merci d'avance.

Cdlt,
Samuel Torton



-----Original Message-----
From: Samuel Torton [mailto:adresse@cachée]
Sent: jeudi 21 décembre 2006 16:31
To: adresse@cachée; adresse@cachée
Cc: adresse@cachée
Subject: [sympa-fr] RE: Re: Error upgrade 5.1.2 en 5.2.3


Re-bonjour,


Voir ci-dessous le log du resultat de deux commandes differentes (assez long):
  - /usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1 --to=5.2
  - /usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1.2 --to=5.2.3

Et aussi, pour repondre au message de Rafael, si l'upgrade ne fonctionne pas
avec PostgreSQL, dans ce cas-là, est-ce possible de me fournir le schema exact
des tables SQL pour la version 5.2.3, et dans ce cas là je ferai l'upgrade SQL
manuellement.

Merci,
Samuel


/usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1.2 --to=5.2.3
-------------------------------------------------------------
Conf::_load_auth(/etc/sympa/auth.conf)
Configuration file read, default log level  0
Sympa 5.2.3 started
List::upgrade(5.1.2, 5.2.3)
Updating the new robot_subscriber and robot_admin  Db fields...
DBD::Pg::db do failed: ERROR:  column "robot_subscriber" of relation
"subscriber_table" does not exist
Unable to execute SQL statement "UPDATE subscriber_table SET
robot_subscriber='alzheimer-fr.org' WHERE (list_subscriber='observatoire')" :
ERROR:  column "robot_subscriber" of relation "subscriber_table" does not 
exist

Language::SetLang(), missing locale parameter
Migration from 5.1.2 to 5.2.3 failed
-------------------------------------------------------------



/usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1 --to=5.2
---------------------------------------------------------
Conf::_load_auth(/etc/sympa/auth.conf)
Configuration file read, default log level  0
Sympa 5.2.3 started
List::upgrade(5.1, 5.2)
Rename archives/log. files...
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin =
'observatoire' AND robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner')
ORDER BY dom" : ERROR:  column "robot_admin" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Samuel
Torton', 'observatoire', 'alzheimer-fr.org', 'epoch'::timestamp with time zone
+ '1166710321 sec', 'epoch'::timestamp with time zone + '1166710321 sec',
'mail', 1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" 
of
relation "admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Said
E-rghioui', 'observatoire', 'alzheimer-fr.org', 'epoch'::timestamp with time
zone + '1166710321 sec', 'epoch'::timestamp with time zone + '1166710321 sec',
'mail', 1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" 
of
relation "admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée',
'Jennifer Daubanes', 'observatoire', 'alzheimer-fr.org', 'epoch'::timestamp
with time zone + '1166710321 sec', 'epoch'::timestamp with time zone +
'1166710321 sec', 'mail', 1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:
column "robot_admin" of relation "admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Martial
Fol', 'observatoire', 'alzheimer-fr.org', 'epoch'::timestamp with time zone +
'1166710321 sec', 'epoch'::timestamp with time zone + '1166710321 sec', 
'mail',
1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" of 
relation
"admin_table" does not exist

List:sync_include_admin(owner): Failed to add new observatoires
List::new() : sync_include_admin_failed
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin =
'observatoire' AND robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner')
ORDER BY dom" : ERROR:  column "robot_admin" does not exist

The list "observatoire" has got no owner defined
The list "observatoire" is set in status error_config
Language::SetLang(), missing locale parameter
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin = 'presse'
AND robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner') ORDER BY dom" :
ERROR:  column "robot_admin" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Samuel
Torton', 'presse', 'alzheimer-fr.org', 'epoch'::timestamp with time zone +
'1166710322 sec', 'epoch'::timestamp with time zone + '1166710322 sec', 
'mail',
1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" of 
relation
"admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Said
E-rghioui', 'presse', 'alzheimer-fr.org', 'epoch'::timestamp with time zone +
'1166710322 sec', 'epoch'::timestamp with time zone + '1166710322 sec', 
'mail',
1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" of 
relation
"admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée',
'Jennifer Daubanes', 'presse', 'alzheimer-fr.org', 'epoch'::timestamp with 
time
zone + '1166710322 sec', 'epoch'::timestamp with time zone + '1166710322 sec',
'mail', 1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" 
of
relation "admin_table" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Martial
Fol', 'presse', 'alzheimer-fr.org', 'epoch'::timestamp with time zone +
'1166710322 sec', 'epoch'::timestamp with time zone + '1166710322 sec', 
'mail',
1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" of 
relation
"admin_table" does not exist

List:sync_include_admin(owner): Failed to add new presses
List::new() : sync_include_admin_failed
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin = 'presse'
AND robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner') ORDER BY dom" :
ERROR:  column "robot_admin" does not exist

The list "presse" has got no owner defined
The list "presse" is set in status error_config
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin = 'test' AND
robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner') ORDER BY dom" :
ERROR:  column "robot_admin" does not exist

DBD::Pg::db do failed: ERROR:  column "robot_admin" of relation "admin_table"
does not exist
Unable to execute SQL statement "INSERT INTO admin_table (user_admin,
comment_admin, list_admin, robot_admin, date_admin, update_admin,
reception_admin,subscribed_admin,included_admin,include_sources_admin,
role_admin, info_admin, profile_admin) VALUES ('adresse@cachée', 'Samuel
Torton', 'test', 'alzheimer-fr.org', 'epoch'::timestamp with time zone +
'1166710323 sec', 'epoch'::timestamp with time zone + '1166710323 sec', 
'mail',
1, 0, NULL, 'owner', NULL, 'normal')" : ERROR:  column "robot_admin" of 
relation
"admin_table" does not exist

List:sync_include_admin(owner): Failed to add new tests
List::new() : sync_include_admin_failed
DBD::Pg::st execute failed: ERROR:  column "robot_admin" does not exist
Unable to execute SQL statement "SELECT user_admin AS email, comment_admin AS
gecos, reception_admin AS reception, date_part('epoch',date_admin) AS date,
date_part('epoch',update_admin) AS update_date, info_admin AS info,
profile_admin AS profile, subscribed_admin AS subscribed, included_admin AS
included, include_sources_admin AS id, SUBSTRING(user_admin FROM position('@'
IN user_admin) FOR 50) AS dom  FROM admin_table WHERE (list_admin = 'test' AND
robot_admin = 'alzheimer-fr.org' AND role_admin = 'owner') ORDER BY dom" :
ERROR:  column "robot_admin" does not exist

The list "test" has got no owner defined
The list "test" is set in status error_config
Updating the new robot_subscriber and robot_admin  Db fields...
DBD::Pg::db do failed: ERROR:  column "robot_subscriber" of relation
"subscriber_table" does not exist
Unable to execute SQL statement "UPDATE subscriber_table SET
robot_subscriber='alzheimer-fr.org' WHERE (list_subscriber='observatoire')" :
ERROR:  column "robot_subscriber" of relation "subscriber_table" does not 
exist

Migration from 5.1 to 5.2 failed
-------------------------------------------------------------








-----Original Message-----
From: Olivier Salaün - CRU [mailto:adresse@cachée]
Sent: jeudi 21 décembre 2006 13:44
To: Samuel Torton
Cc: adresse@cachée
Subject: [sympa-fr] Re: Error upgrade 5.1.2 en 5.2.3


Samuel Torton wrote:
Je suis sur une Debian + PostgreSQL, et mes packages sympa proviennent de
http://macallan.u-picardie.fr/~delepine/APT/sympa/

J'etais avec une version 5.1.2 de sympa, et je viens de passer à 5.2.3 (je
suppose que JC Delepine vient d'upgrader le package recemment)

J'ai un probleme: le service Sympa ne veut pas redemarrer (sympaerror : data
structure was not updated ; you should run sympa.pl to run the upgrade
process.)

Alors, quand je lance "/usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1.2
--to=5.2.3" ou bien "/usr/lib/sympa/bin/sympa.pl --upgrade --from=5.1
--to=5.2", cela ne resoud pas mon probleme, la migration echoue, avec des
erreurs de requetes SQL, missing columns, etc...

Que puis-je faire (manuellement), pour que ma migration reussisse ?

Merci de fournir des messages d'erreur précis ; sans quoi il nous est 
impossible
de vous aider.