Re: [Mailman-Users] Does mailman support a MySQL backend?
On Fri, 20 Sep 2002 17:47:15 -0400 Barry A Warsaw <[EMAIL PROTECTED]> wrote: > ...he maintains on the elspy project on SF. You know, eslpy would make a wicked TMDA integration base... -- J C Lawrence -(*)Satan, oscillate my metallic sonatas. [EMAIL PROTECTED] He lived as a devil, eh? http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live. -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
> "GAVH" == G Armour Van Horn <[EMAIL PROTECTED]> writes: GAVH> It sounded like Barry was running it, which meant that GAVH> Mailman would always work with Postfix! While I'd like to ensure that Mailman continues to run well with all the major mail servers, I do indeed run Postfix on my personal domains, and most of the test h/w I use. However we use Exim4 on python.org/zope.org so making sure it plays nice with both is a top priority for us. I'll also note that Greg Ward does most of the down-and-dirty postmastering on py.org and has some really excellent scripts and extensions which he maintains on the elspy project on SF. He keeps tempting me with his cool stuff enough and I might have to switch one day (having a Python interpreter running in your MTA is my definition of cool :). That's not to denegrate or neglect sendmail or qmail, since I'm officially agnostic on the subject. The Python Starship ran qmail until Greg recently took over postmastering that machine, and sendmail is still very widely used of course. My hacking time is fairly limited though and I'd rather spend time getting MM2.1 to completion than futzing with MTAs all the time, so I occasionally need the community's help to keep us honest. -Barry -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
When I first was investigating Mailman I read enough of the site to see that Postfix was probably the best bet. It sounded like Barry was running it, which meant that Mailman would always work with Postfix! So I installed RedHat and Postfix, and then setup Mailman. I still run Sendmail for my main mailserver, although I sometimes wish I didn't, but as complex as Sendmail is I'm very glad I could make the Mailman setup so simple by putting it in a box with Postfix. Van J C Lawrence wrote: > On Fri, 20 Sep 2002 17:18:25 +0100 > Angel Gabriel <[EMAIL PROTECTED]> wrote: > > > What would be a better MTA to use? Any recommendations? > > Please see the FAQ: > > http://www.python.org/cgi-bin/faqw-mm.py > > As stated there I generically recommend both Exim and Postfix, for the > reasons stated there. > > -- > J C Lawrence > -(*)Satan, oscillate my metallic sonatas. > [EMAIL PROTECTED] He lived as a devil, eh? > http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live. > > -- > Mailman-Users mailing list > [EMAIL PROTECTED] > http://mail.python.org/mailman/listinfo/mailman-users > Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py > Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ -- -- Sign up now for Quotes of the Day, a handful of quotations on a theme delivered every morning. Enlightenment! Daily, for free! mailto:[EMAIL PROTECTED]?subject=Subscribe_QOTD For web hosting and maintenance, visit Van's home page: http://www.domainvanhorn.com/van/ -- -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
On Fri, 20 Sep 2002 17:18:25 +0100 Angel Gabriel <[EMAIL PROTECTED]> wrote: > What would be a better MTA to use? Any recommendations? Please see the FAQ: http://www.python.org/cgi-bin/faqw-mm.py As stated there I generically recommend both Exim and Postfix, for the reasons stated there. -- J C Lawrence -(*)Satan, oscillate my metallic sonatas. [EMAIL PROTECTED] He lived as a devil, eh? http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live. -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
RE: [Mailman-Users] Does mailman support a MySQL backend?
Version 2.1? Okay, what I'm going to do is have a look around the net for more info on this. Having a MySQL backend should ease a few performance issues. Also I got a mail from someone saying that sending out about 100k mails with a few bad ones would bring my server to it's knees... hmm... that is SO not good! But it has one function, yep you guessed it, it's my mail server, and that's all it does. It runs a samba client, but that's just so that my windows boxes can see it. What would be a better MTA to use? Any recommendations? -Original Message- From: Harold Paulson [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 12:20 AM To: [EMAIL PROTECTED] Cc: Angel Gabriel Subject: RE: [Mailman-Users] Does mailman support a MySQL backend? Angel, For what it's worth... Mailman 2.1 is supposed to be able to use alternative backends (such as MySQL) to store user information. However, I haven't actually seen this working yet. Personally, I have given up on using Mailman for large broadcast-only lists. Mailman seems to do a lot of things based on the assumption that it's being used for an interactive list. Configuring it for broadcasting tends to be a lot of work. I use a custom-built Perl+PHP+MySQL thingy I wrote, for large broadcast lists these days. On a side note, if you are planning to send to a list of 100k+ addresses with a large number of bad ones, you had better be using something other than Sendmail. It *will* bring your machine to it's knees spawning a limitless number of queue running processes[1]. Good luck! :) - H Note: [1] If someone would like to contradict me on this point, I'd love to hear your argument, and see what config you suggest. Seriously, I really would like to see a solution. Please include more than MAX_DAEMON_CHILDREN, QUEUE_LA, or REFUSE_LA in your answer, since they do not seem affect queue runs. >I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even >attempted to send messages to list anymore, because I can't even get the web >interface to come up, it times out. I adjusted the cf files manually to show >3000 addresses per page, and STILL the pages time out. I'm thinking of using >a diffrent application to send out my email. I know a lot of the addresses >are going to bounce, and that is REALLY going to mess up performance, it's >such a shame, we've spent FOUR years collecting these addreses, from 16 >diffrenct universities up and down England. The thing that worries me, is >the bouncing mail, I don't mind if my server takes three days to send all >the mail, it's a one way list, I just want to increase performance when it >comes to admin tasks. > >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED]]On Behalf Of Dan Wilder >Sent: Thursday, September 19, 2002 6:17 PM >To: Mailman (E-mail) >Subject: Re: [Mailman-Users] Does mailman support a MySQL backend? > > >On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote: >> I was wondering if mailman supports a MySQL backend, because one of my >lists >> has hit over 100k addresses, and performance is REALLY bad. If mailman >> doesn't support a MySQL backend, does anyone know of any mailing list >> managers that do?? Any help would be appreciated. Thanks in adance. > >Do you know whether it's mailman, or your MUA that's the sticky >wicket? > >We have one list with 20,000 subscribers. It used to take several >days to get everybody out. Inspection revealed it was the MTA, >Postfix, which needed load tuning, and also the Linux kernel, >which needed some kernel parameters bumped up to allow Postfix >the elbow room to run 150 concurrent delivery processes. > >Now it takes about three hours for most of the good addresses >on the list to get delivered. The sticky wicket is the internet >connection, which also supports telecommuters, so we've had >to tune the mailserver to stop short of saturating the connection. > >-- >- > Dan Wilder <[EMAIL PROTECTED]> Technical Manager > SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 > Seattle, WA 98155-0549URL http://www.linuxjournal.com/ >- > >-- >Mailman-Users mailing list >[EMAIL PROTECTED] >http://mail.python.org/mailman/listinfo/mailman-users >Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py >Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ -- Harold Paulson Sierra Web Design [EMAIL PROTECTED] http://www.sierraweb.com VOICE: 775.833.9500 FAX:ÊÊ 775-201-4458 -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
On Thu, 19 Sep 2002 18:37:38 +0100 Angel Gabriel <[EMAIL PROTECTED]> wrote: > I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even > attempted to send messages to list anymore, because I can't even get > the web interface to come up, it times out. I adjusted the cf files > manually to show 3000 addresses per page, and STILL the pages time > out. I'm thinking of using a diffrent application to send out my > email. I know a lot of the addresses are going to bounce, and that is > REALLY going to mess up performance, it's such a shame, we've spent > FOUR years collecting these addreses, from 16 diffrenct universities > up and down England. The thing that worries me, is the bouncing mail, > I don't mind if my server takes three days to send all the mail, it's > a one way list, I just want to increase performance when it comes to > admin tasks. Use v2.1 with a database adaptor for the membership roster. -- J C Lawrence -(*)Satan, oscillate my metallic sonatas. [EMAIL PROTECTED] He lived as a devil, eh? http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live. -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
If you only need to send out a message and not an interactive list with users replying to the list, you could use a program called Mailloop. I work for Adoption.com and I send out their newsletter every Tuesday with over 200,000 users and it takes less than a day to send out. Again this is only for newsletters, not for interactive lists. I store all their email addresses in a MySQL database and just gather it from that before I send each one. It has a built in email filter to strip out bad and duplicates before I send it. If you want to check it out their website is: http://www.mailloop.com Even at $400 for what we need that's a steal! Good luck, Dean - Original Message - From: "Angel Gabriel" <[EMAIL PROTECTED]> To: "'Dan Wilder'" <[EMAIL PROTECTED]> Cc: "Mailman (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 10:37 AM Subject: RE: [Mailman-Users] Does mailman support a MySQL backend? > > I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even > attempted to send messages to list anymore, because I can't even get the web > interface to come up, it times out. I adjusted the cf files manually to show > 3000 addresses per page, and STILL the pages time out. I'm thinking of using > a diffrent application to send out my email. I know a lot of the addresses > are going to bounce, and that is REALLY going to mess up performance, it's > such a shame, we've spent FOUR years collecting these addreses, from 16 > diffrenct universities up and down England. The thing that worries me, is > the bouncing mail, I don't mind if my server takes three days to send all > the mail, it's a one way list, I just want to increase performance when it > comes to admin tasks. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Wilder > Sent: Thursday, September 19, 2002 6:17 PM > To: Mailman (E-mail) > Subject: Re: [Mailman-Users] Does mailman support a MySQL backend? > > > On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote: > > I was wondering if mailman supports a MySQL backend, because one of my > lists > > has hit over 100k addresses, and performance is REALLY bad. If mailman > > doesn't support a MySQL backend, does anyone know of any mailing list > > managers that do?? Any help would be appreciated. Thanks in adance. > > Do you know whether it's mailman, or your MUA that's the sticky > wicket? > > We have one list with 20,000 subscribers. It used to take several > days to get everybody out. Inspection revealed it was the MTA, > Postfix, which needed load tuning, and also the Linux kernel, > which needed some kernel parameters bumped up to allow Postfix > the elbow room to run 150 concurrent delivery processes. > > Now it takes about three hours for most of the good addresses > on the list to get delivered. The sticky wicket is the internet > connection, which also supports telecommuters, so we've had > to tune the mailserver to stop short of saturating the connection. > > -- > - > Dan Wilder <[EMAIL PROTECTED]> Technical Manager > SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 > Seattle, WA 98155-0549URL http://www.linuxjournal.com/ > - > > -- > Mailman-Users mailing list > [EMAIL PROTECTED] > http://mail.python.org/mailman/listinfo/mailman-users > Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py > Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ > > > > > -- > Mailman-Users mailing list > [EMAIL PROTECTED] > http://mail.python.org/mailman/listinfo/mailman-users > Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py > Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
RE: [Mailman-Users] Does mailman support a MySQL backend?
% -Original Message- % From: [EMAIL PROTECTED] % [mailto:[EMAIL PROTECTED]]On Behalf Of Angel Gabriel % Sent: 19 September 2002 18:38 % To: 'Dan Wilder' % Cc: Mailman (E-mail) % Subject: RE: [Mailman-Users] Does mailman support a MySQL backend? % % I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even % attempted to send messages to list anymore, because I can't even % get the web % interface to come up, it times out. ADSL lines' inbound connections drop to shit when there's a mailshot going out - you're using up so much outbound capacity that the web server has trouble sending ACKs out. If you're in London, give me a shout directly and I'll see what I can do for you -- John Handelaar T +44 20 8933 1494 M +44 7930 681789 F +44 870 169 7657 E [EMAIL PROTECTED] -- -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
Quoth Dan Wilder: > Do you know whether it's mailman, or your MUA that's the sticky > wicket? Oops. MTA. -- - Dan Wilder <[EMAIL PROTECTED]> Technical Manager SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 Seattle, WA 98155-0549URL http://www.linuxjournal.com/ - -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
RE: [Mailman-Users] Does mailman support a MySQL backend?
I'm using RH 7.3 and I have a DSL line @ 256k upload - I havn't even attempted to send messages to list anymore, because I can't even get the web interface to come up, it times out. I adjusted the cf files manually to show 3000 addresses per page, and STILL the pages time out. I'm thinking of using a diffrent application to send out my email. I know a lot of the addresses are going to bounce, and that is REALLY going to mess up performance, it's such a shame, we've spent FOUR years collecting these addreses, from 16 diffrenct universities up and down England. The thing that worries me, is the bouncing mail, I don't mind if my server takes three days to send all the mail, it's a one way list, I just want to increase performance when it comes to admin tasks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dan Wilder Sent: Thursday, September 19, 2002 6:17 PM To: Mailman (E-mail) Subject: Re: [Mailman-Users] Does mailman support a MySQL backend? On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote: > I was wondering if mailman supports a MySQL backend, because one of my lists > has hit over 100k addresses, and performance is REALLY bad. If mailman > doesn't support a MySQL backend, does anyone know of any mailing list > managers that do?? Any help would be appreciated. Thanks in adance. Do you know whether it's mailman, or your MUA that's the sticky wicket? We have one list with 20,000 subscribers. It used to take several days to get everybody out. Inspection revealed it was the MTA, Postfix, which needed load tuning, and also the Linux kernel, which needed some kernel parameters bumped up to allow Postfix the elbow room to run 150 concurrent delivery processes. Now it takes about three hours for most of the good addresses on the list to get delivered. The sticky wicket is the internet connection, which also supports telecommuters, so we've had to tune the mailserver to stop short of saturating the connection. -- - Dan Wilder <[EMAIL PROTECTED]> Technical Manager SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 Seattle, WA 98155-0549URL http://www.linuxjournal.com/ - -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
Re: [Mailman-Users] Does mailman support a MySQL backend?
On Thu, Sep 19, 2002 at 05:35:19PM +0100, Angel Gabriel wrote: > I was wondering if mailman supports a MySQL backend, because one of my lists > has hit over 100k addresses, and performance is REALLY bad. If mailman > doesn't support a MySQL backend, does anyone know of any mailing list > managers that do?? Any help would be appreciated. Thanks in adance. Do you know whether it's mailman, or your MUA that's the sticky wicket? We have one list with 20,000 subscribers. It used to take several days to get everybody out. Inspection revealed it was the MTA, Postfix, which needed load tuning, and also the Linux kernel, which needed some kernel parameters bumped up to allow Postfix the elbow room to run 150 concurrent delivery processes. Now it takes about three hours for most of the good addresses on the list to get delivered. The sticky wicket is the internet connection, which also supports telecommuters, so we've had to tune the mailserver to stop short of saturating the connection. -- - Dan Wilder <[EMAIL PROTECTED]> Technical Manager SSC, Inc. P.O. Box 55549 Phone: 206-782-8808 Seattle, WA 98155-0549URL http://www.linuxjournal.com/ - -- Mailman-Users mailing list [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/