The mailing list for listmasters using Sympa

[Adam Stephens <address@concealed>]

Adam Stephens wrote:
> Serge Aumont wrote:
> > On 03/05/2010 04:23 PM, Chris Peck wrote:
> >  
> > > However, sending email to lists as well as admin'ing sympa list via 
> > > email commands will most likely be problematical.  Has anyone run 
> > > into this in the past? Does anyone have an ideas on how I can  
> > > circumvent any authorization issues without having to modify every 
> > > list config that may be effected?
> > > To be honest, I haven't started digging into this yet, I'm thinking 
> > > that as a lasts resort I can use postfix to change incoming email 
> > > from @email.wm.edu to be from @wm.edu, but, that's a short term 
> > > solution and a hack at best.
> > >
> > > We are currently running v 5.3.3 and assuming all goes well I hope 
> > > to upgrade to the most current this summer.
> > >       
> > Why not rewrite all related subscription from old email form to the new
> > one ? This coud be done via sql in subscriber_table . Of course, this
> > suppose to be able to have a list all student email to avoid change in
> > staff and teachers emails.
> >
> > Serge   
>
> You might need to change admin_table too, if you allow students to be 
> list owners.
>
> update admin_table set user_admin = replace(user_admin, 
> 'address@concealed <mailto:%address@concealed>','address@concealed 
> <mailto:%address@concealed>')

...except without the mailto: rubbish, obviously - that's my mail client 
trying to be clever.

Incidentally, I'm writing a script to do something like this and I found 
this command to be cripplingly slow,  because the update is applied to 
all rows in the table regardless of whether they match. This is orders 
of magnitude faster:

UPDATE subscriber_table SET email=REPLACE(user_subscriber, 
'address@concealed', 'address@concealed') where user_subscriber = 
"address@concealed";

Regards,
Adam Stephens.

--
--------------------------------
Adam Stephens
Network Specialist - Email & DNS
address@concealed