The mailing list for listmasters using Sympa

[Chris Peck <address@concealed>]

Adam,
Nice catch - I wasn't sure how we were going to handle the owner/editor 
roles.  I thought we would have to rip through all the config files to update 
them.  How do the config files get updated with the new information if I 
change it in the MySQL DB?
Thanks,
Chris

PS - we started the changeover a couple of weeks ago, during this interim 
period I am simply re-writing the incoming From addresses in Postfix to match 
their old @wm.edu email address. Since we forward email during the interim 
(and for some time after, yet to be decided), this hasn't been an issue.  
After the dust has settled, we'll start mucking about with the email 
addresses in Sympa's DB (probably in May sometime).


On Mar 17, 2010, at 12:21 PM, Adam Stephens wrote:

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