Skip to Content.
Sympa Menu

en - Re: [sympa-users] Upgrade strategy from Sympa 3.4.3 to Sympa 6.x

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: "Jean-Baptiste Denis" <address@concealed>
  • To: address@concealed
  • Subject: Re: [sympa-users] Upgrade strategy from Sympa 3.4.3 to Sympa 6.x
  • Date: Wed, 16 Jun 2010 17:31:22 +0200

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










Archive powered by MHonArc 2.6.19+.

Top of Page