The mailing list for listmasters using Sympa

[address@concealed]

[apologies if this is a duplicate - my mail system is in flux as I d a
migration - I'm posting this copy through the web interface at listes.cru.fr]

Hi Folks,

Now that I have Sympa 5.2.1 installed on a new machine, I'm trying to migrate
from a 3.4.4.3 installation, and I've run into a few snags.  I hope some of 
you
can point me at a way out!

Basic approach: Upgrade to 5.2.1 on the old machine, convert files, databases
and such, and then copy the up-to-date materials to the new machine.

So far, it's not working so well:

1. Backed everything up (but of course!)

2. ./configure; make; make install

- first time around it says it installed all the perl modules, but didn't - 
had
to force install Template and XML::LibXML via cpan (each failed one test out 
of
about 100 - hopefully not a critical one)

3. running mysql, so the upgrade notes say that the database would be updated
automagically, so I tried to start things:

- got a bunch of errors:
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 10997.
DBD::mysql::db do failed: Can't DROP 'robot_admin'. Check that column/key
exists at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'user_admin'. Check that column/key 
exists
at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'role_admin'. Check that column/key 
exists
at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'list_subscriber'. Check that column/key
exists at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'robot_subscriber'. Check that column/key
exists at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'netid_netidmap'. Check that column/key
exists at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'serviceid_netidmap'. Check that
column/key exists at /home/sympa/bin/List.pm line 10997.
DBD::mysql::db do failed: Can't DROP 'robot_netidmap'. Check that column/key
exists at /home/sympa/bin/List.pm line 10997.

- then got two emails: one titled "database updated" saying that everything 
was
updated:

The database structure has been updated ; check log file for further details 
: 
Table admin_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 '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 'included_subscriber'  (table 'subscriber_table' ; database 'sympa')
does NOT have awaited type (int(1)). Attempting to change it...
 ALTER TABLE subscriber_table CHANGE included_subscriber included_subscriber
int(1)  Field included_subscriber in table subscriber_table, structur updated
 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')
does NOT have awaited type (int(1)). Attempting to change it...
 ALTER TABLE subscriber_table CHANGE subscribed_subscriber
subscribed_subscriber int(1)  Field subscribed_subscriber in table
subscriber_table, structur updated
 Field 'topics_subscriber' (table 'subscriber_table' ; database 'sympa') was
NOT found. Attempting to add it...
 Field topics_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 dropped
 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

- immediately followed by one titled Listmaster/ sympa died, containing:
error : data structure was not updated ; you should run sympa.pl to run the
upgrade process.

4. tried a /home/sympa/bin/sympa.pl - and it seemed to start, so then stopped
it and did a /home/rc3.d/sympa start and everything seemed to start, but
archived stops immediately (which it's been doing lately - I expect something
is locked or corrupted - ANY SUGGESTIONS?)

[now it gets "interesting"]

5. the install message indicated that: "Sympa.pl should detect that you are
upgrading
from an old version and will run the tpl2tt2.pl script to migrate your
existing .tpl files to .tt2 format." but... this doesn't seem to have 
happened.
 I can get to everything through the standard web interface, but all the 
custom
messages don't come up.  Various files (e.g., welcome.tpl) remain unchanged in
/home/sympa/expl/<listname> and don't seem to be either converted or used.

6. I tried to convert archive files using the button on the sympa admin 
screen,
but...

- nothing seems to happen if I hit "rebuild all"

- if I specify one list, and hit "rebuild" - it seems to only rebuild the
current months messages, and the resulting web page does not show any of the
buttons for looking at earlier months

So....  HELP!!!!

Thanks very much,

Miles Fidelman