The mailing list for listmasters using Sympa

[Chris Peck <address@concealed>]

Serge,

This may be the way - we can generate a list of students (approx 10000) and create a sql change statement for each one -  I just ran across and old entry from 2004 in the archive https://listes.cru.fr/sympa/arc/sympa-users/2004-12/msg00003.html

So it would be? (bear with me - i'm not a sql coder)

use sympadb;
UPDATE subscriber_table SET email=REPLACE(email, 'address@concealed','address@concealed');
UPDATE subscriber_table SET email=REPLACE(email, 'address@concealed','address@concealed');
ad nauseum...

-chris

On Mar 5, 2010, at 10:51 AM, 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