The mailing list for listmasters using Sympa

[Riccardo Veraldi <address@concealed>]

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
>
>  
>
>