The mailing list for listmasters using Sympa

[address@concealed]

Johann Spies wrote:

> I would appreciate some advice on the way forward.
>
> My present setup: Sympa 3.3.3 (Debian Woody) running on one (mail3) of
> three mailservers (Exim4).  I am in the process of upgrading to Debian
> Sarge which has Sympa 4.1.5-2.  I want to create a Sympa server on mail2
> that will be able to take over the function of the one on mail3 while
> mail3 gets updated to Sarge.  It must in the future also be available
> as a backup Sympa server.
Version 4.1 is really very old. Check 
http://macallan.u-picardie.fr/~delepine/APT/sympa/ for debian package.

> Now my questions:
>
> 1. Can I setup Sympa on mail2 to serve sympa under the hostname "mail3"?
> 2. Is there somewhere a script which will help me to transfer a dump of
>   the postgresql-data of version 3.3.3 to version 4.1.5?  Where is the
>   differences between the data structure of the two versions
>   documented?
> 3. Will creating a "virtual domain" and/or "virtual robot" help to
>   smoothen the transition from one server to another and if so how do I
>   set it up in a way that will be hidden from users?
>
> Comments, answers and advice are welcome.
>  

First : remember that the parameter cookie must be the same for your 2 
installations (sympa.conf).

-1- install sympa on your spare machine, edit sympa.conf and set 
parameter cookie to the same as it is on your production server.
-2- drop the database
-3- import a copy of the existing database on your production server
-4- edit file ~sympa/expl/data_structure.version on the spare server, 
set the version number to the version which is riunning on the 
production server
-5- killall sympa running process, including wwsympa.fcgi (this suppose 
to stop apache)
-6- run sympa.pl  : it will tell you what to do.

NEVER share a database with to different version of Sympa.
Serge