Re: seeking mailing list from SQL

2003-10-03 Thread martin f krafft
also sprach Sacha Chua <[EMAIL PROTECTED]> [2003.10.03.0745 +0200]: > Hmm. What's the bigger problem? Is it load-balancing the outgoing > mail? I remember coming across load-balancing suggestions in the > postfix documentation. That might be a way of dealing with the > situation: have the mailing l

Re: seeking mailing list from SQL

2003-10-02 Thread Sacha Chua
martin f krafft <[EMAIL PROTECTED]> writes: >> How about a trigger in the database that runs the script ? I never >> tried it, but it should work > Of all things, however, I would really appreciate if there existed > a mailing list manager that can do what I need. Hmm. What's the bigger problem?

Re: seeking mailing list from SQL

2003-10-02 Thread martin f krafft
also sprach Ray <[EMAIL PROTECTED]> [2003.10.02.2323 +0200]: > what if someone hits send to unsubscribe while their smtp server > is recieving an email from the list. i guess you are right. maybe i also just wanted a clean solution... i hate patchwork. > mysql doesn't support triggers last time

Re: seeking mailing list from SQL

2003-10-02 Thread Tom
On Thu, Oct 02, 2003 at 11:18:19PM +0200, martin f krafft wrote: > also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2238 +0200]: > > Well, are you _sure_ you can run a cron every minute? I mean, > > seriously, have you tried it? Depending on your situation, it > > might not be that bad.

Re: seeking mailing list from SQL

2003-10-02 Thread martin f krafft
also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2238 +0200]: > Well, are you _sure_ you can run a cron every minute? I mean, > seriously, have you tried it? Depending on your situation, it > might not be that bad. Or every 5 minutes, even? The system is heavily loaded, so 5 minutes wo

Re: seeking mailing list from SQL

2003-10-02 Thread martin f krafft
also sprach Frank Gevaerts <[EMAIL PROTECTED]> [2003.10.02.2245 +0200]: > How about a trigger in the database that runs the script ? I never > tried it, but it should work That's an interesting idea. Of all things, however, I would really appreciate if there existed a mailing list manager that ca

Re: seeking mailing list from SQL

2003-10-02 Thread Ray
On Thursday 02 October 2003 15:11, martin f krafft wrote: > also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2156 +0200]: > > remove_members --all mylist > > mysql -h localhost -e "SELECT email from people" mydb | \ > > add_members -n - -c n -w n mylist > > I know about the script pos

Re: seeking mailing list from SQL

2003-10-02 Thread Frank Gevaerts
On Thu, Oct 02, 2003 at 10:11:15PM +0200, martin f krafft wrote: > also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2156 +0200]: > > remove_members --all mylist > > mysql -h localhost -e "SELECT email from people" mydb | \ > > add_members -n - -c n -w n mylist > > I know about the scr

Re: seeking mailing list from SQL

2003-10-02 Thread Mark Ferlatte
martin f krafft said on Thu, Oct 02, 2003 at 10:11:15PM +0200: > also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2156 +0200]: > > remove_members --all mylist > > mysql -h localhost -e "SELECT email from people" mydb | \ > > add_members -n - -c n -w n mylist > > I know about the scrip

Re: seeking mailing list from SQL

2003-10-02 Thread martin f krafft
also sprach Mark Ferlatte <[EMAIL PROTECTED]> [2003.10.02.2156 +0200]: > remove_members --all mylist > mysql -h localhost -e "SELECT email from people" mydb | \ > add_members -n - -c n -w n mylist I know about the script possibility, but what then if someone unsubscribes from the mailinglist

Re: seeking mailing list from SQL

2003-10-02 Thread Mark Ferlatte
martin f krafft said on Thu, Oct 02, 2003 at 04:22:56PM +0200: > I am looking for a mailing list manager that can pull a single > list's membership list from a configurable SQL datasource. Nothing > like sympa, which can either completely live in a SQL database, or > not at all. No, I want to be ab

seeking mailing list from SQL

2003-10-02 Thread martin f krafft
I am looking for a mailing list manager that can pull a single list's membership list from a configurable SQL datasource. Nothing like sympa, which can either completely live in a SQL database, or not at all. No, I want to be able to say: the subscriberlist for mylist is obtained by "select emai