The mailing list for listmasters using Sympa

["Chris Andrews" <address@concealed>]

So you had lists created with the same names as existing lists after you
changed the Sympa and Robot names? You have to manually clean those up.  Did
you make this change to a production server?

---
 Chris Andrews
 Boston College
 Collaboration Team


-----Original Message-----
From: Riccardo Veraldi [mailto:address@concealed] 
Sent: Thursday, April 05, 2007 10:58 AM
To: Chris Andrews
Cc: sympa-users
Subject: [sympa-users] Re: how to change sympa host name ?

yes... but the problem is that I get duplicate entries because
I had changed the host name and the robot name in sympa.conf  before...
without
updating the database tables so that a few mailing lists where created
with new robot name as property  in the primary key, so that when I try
to update it I get duplicate entry...
is there a way to remove duplicate entries in the database ?

thanks

Riccardo


Chris Andrews wrote:
>
> You have to update all the robot names in the database and the Sympa
> alias file.  Just stop Sympa and sendmail (so you do not lose emails
> sent to lists before you make the change) and then run these database
> updates:
>
>
>
> UPDATE subscriber_table SET robot_subscriber="newname" WHERE
> robot_subscriber ="oldname";
>
> UPDATE admin_table SET robot_admin=" newname " WHERE robot_admin ="
> oldname ";
>
>
>
> Also update the Sympa config to reflect the new name.  Make sure to
> tell sendmail to recompile your aliases files and restart Sympa and
> sendmail.  You should definitely run through this procedure on your
> test or qa setup first, as you can screw things up if you fat finger
> things (plus my setup may be different then yours.)
>
>
>
>
>
> ---
>
>  Chris Andrews
>
>  Boston College
>
>  Collaboration Team
>
>
>
> -----Original Message-----
> From: Riccardo Veraldi [mailto:address@concealed]
> Sent: Thursday, April 05, 2007 6:26 AM
> To: sympa-users
> Subject: [sympa-users] how to change sympa host name ?
>
>
>
>
>
> Hello, I would like to change sympa host
>
> name that is also the robot main hostname.
>
> I tried to do it but then the lists created with the old robot hostname
>
> does not work anymore... subscribers are losts  etc... this because
>
> sympa stores robot hostname in the subscriber table, admin table etc...
>
>
>
> is there a way to do it ?
>
>
>
> thanks
>
>
>
> Riccardo
>
>
>
>
>

Attachment: smime.p7s
Description: S/MIME cryptographic signature