The mailing list for listmasters using Sympa

["Jean-Baptiste Denis" <address@concealed>]

On Monday 14 June 2010 14:03:15 Jean-Baptiste Denis wrote:
> On Monday 14 June 2010 12:26:02 Jean-Baptiste Denis wrote:
> > Before looking precisely at Dan Pritts script, i come here to ask for any
> > advices, again.
> 
> Oups. Forgot to copy some etc/ config file from the old sympa installation.
> Sorry for flooding.

So. Here is my current setup :

1) sympa 6.0.3 installation in /home/sympa

2) database creation using 6.0.3 create_db.Pg script for postgresql :
   $ psql -U sympa -d sympa < /home/sympa/bin/create_db.Pg

3) retrieve text dump from old sympa (3.4.3) postgresql database

4) running some cleaning script on them. I've manually added the   
  'robot_subscriber' column in the subscriber table and added the '*' default
   value to it. it looks like that :

   sympa=> select list_subscriber, user_subscriber, robot_subscriber from 
   subscriber_table limit 1;
    list_subscriber |     user_subscriber      | robot_subscriber 
   -----------------+--------------------------+------------------
    mylist          | myname@mydomain          | *

5) i have imported cleaned version of user_table and subscriber_table in the
   new database without any warnings

6) copied old expl directory to new list_data directory with some cleaning in 
   the loop to change all "subscribers" and "config*" files to UTF-8 using 
   iconv

7) copied old arc archive folder content in the new one

8) copied old /home/sympa/etc configs in the new folder


I thought i was in a good shape to start the sympa.pl --upgrade process.
I didn't have spotted anything in the NEWS file to reach the 4.2b.1, maybe 
it wasn't obvious to me.

I've changed data_structure.version to 4.2b.1 and ran sympa.pl --upgrade. 
I've got some minor (i think) warnings regarding missing owner parameter
for some of the old lists?

I've seen a lot of constraint violation concerning uniq constraint 
"ind_subscriber". I think its due to the fact i've already restored the
subscriber_table from the old database ? 

I've seen some :
"Upgrade::upgrade() List webwriters ; changing user_data_source from
database to include2..."

I've started sympa (/etc/init.d/sympa start) and watched /var/log/sympa. 
Nothing seemed wrong to me. It takes some time (20 minutes) to rebuid the 
entire archive.

I've connected to the sympa web interface (http://localhost/sympa), logged as 
listmaster, but i can't see any lists here. The sympa log just shows :
Jun 16 17:05:51 mymachine wwsympa[16173]: [robot mymachine] [session 
9703905223218] [client 127.0.0.1] main::do_lists() do_lists(,)

I think i need some help to reach the user state of the old version. I've 
looked carefully (not enough ? :)) at the documentation, but i didn't see 
anything to help me at this time.

Regards,

Jean-Baptiste