Mailing List Managers?
greyrax asks: "So I'm trying to convince someone to go open source for their list manager. They're about to upgrade to an expensive proprietary solution.
With about 400,000 subscribers to this newsletter, a database back-end would certainly be helpful. Bounced address management and easy unsubscribes is important (I've read Smartmail vs. MailMan comparison here). Virtual host support and a web interface are desirable. Any thoughts from the /.ers since this thread last year would be appreciated."
one thing i hate is having to "e-mail with subject \"help\" to receive a list of possible commands", each of which, I gather, includes sending an e-mail with a certain subject, then receiving an e-mail in confirmation of it. Blech!
Whatever you use, make sure it has a clean web interface, and configure it to include a link at the end of each e-mail sent to the group to the effect of "Click here to change or configure your mailing list membership."
Although the largest list I've ever served with Mailman was 116 members, I really think Mailman has potential to do what you want. It has all the features you mentioned, though the database backend isn't SQL and I'm assuming that is what you meant.
Beware, Nugget is watching... See?
I think you'd want something like EZMLM and the manager software for it, it's not the prettiest thing but you can make an interface for it pretty easy. as long as the program can create directories and add to files you're interface is done. gotta love Qmail's config system.
One thing I hate is having to "log in with the plaintext password I store and mail you every month without fail to some random mailing list name to do anything because this MLM is too braindead to understand listname-requests, or even listname-(command)".
Whatever you use, make sure it has a clean email interface, and configure it to include rfc2369/rfc2919 List-(Subscribe|Unsubscribe|Post|Help|Owner|Id) headers so I can filter and automate control of it.
Ecartis is a great example of a MLM with support for both email and web-based manglement. Email is the standard double-opt-(in|out) stuff, with various other methods of authentication to make sending batched/automated commands easy for admins. Web emails you a "cookie" (effectively a temporary password), and lets you set up a (secure) password once logged in; if you forget your password, you just don't include it on login and get another cookie.
No monthly spam with one of your passwords going out for all to see to some random location in your filters (mine end up in lists/(test|news|announcements)), and an extensive but by no means required web interface, without the need for a monthly insecure irritating to filter spam.
Check out this link at the Mailman website. It details who's using it. Names like Apple Computer. My recollection from about a year a go was that the had a 1 million user list. I use Mailman as well for all client list serves. Works great.
It has a nice web interface for my non-techie friends but behaves as a proper MLM for everyone else. It can use a mysql backend too
-Yarn - Rio Karma: Excellent
The company I am working for is currently in the process of selecting a mailing list manager as well. And after a bit of wandering about we are about to settle on Sympa. It seem to have it all. Web-interfaces, sql-backends and fairly good documentation.
We also took a peek on Mailman, but came to the conclusion that it would take too much work on having to integrate it into our design. No stylesheets to edit, and if you want it to integrate into a search engine other than pipermail (which can't search at all, only list threads) you have to get down dirty with the source. And having an extra thread of yet another project isn't a viable solution atm.
=-kiOwA-> EOF
The Listproc MLM was closed source for a long time, but has recently gone open source. The source can be found on SourceForge, and appears to be using the Netscape Public License.
It doesn't use a relational database. It uses text files for configuration and subscriber lists, and then builds dbm files for quicker lookups. It does have a web front end. It has a crude bounce management--you can set a per list option to auto-delete any address that bounces multiple times. But it's not foolproof, and it doesn't have something more reliable like address probing.
Click on the "About" link for more details. I've not taken a look at what's under the hood, but if you want something that's largely text based, this could work.
This sig no verb.
I wondered how long it would be until people were on to my little plan! :) :)
NOT
I did wonder, as I posted this, if people would think that it was for spamming. This is an opt-in newsletter for a talk radio show. Believe it or not, there can actually be legitimate ways of building a large subscriber base.
See this reply. :)
I'm sure that spammers have much, much larger lists. Heck, if you can spend $99 for a CD with 500 million (or whatever) e-mail addresses, why stop at 400,000?
Probably more of a solution than you need, but it's a very good way to take a generic boxen and quickly turn it into a slam-dunk mail server and listserver.
The guy who developed it (Matt Simerson) is uber-conscious of security issues and a helluva nice guy to boot; he's put together an exceptionally tight package from a security standpoint. If nothing else, you may want to look at what he's got and do a modified or stripped-down install.
"It was a summer's tale: Just a boy, his Linux, and a head full of dreams..."
BugTraq uses ezmlm, and it's certainly a large mailing list.
I use Mailman and its great!
"With Microsoft, you get Windows. With Linux, you get the full house" - unknown
I have a bunch of mailman lists, and my users like the web based interface. Some of them like the monthly password mailing, some hate it. I'm not to thrilled about how badly it handles bounces, though, and I wish it could be configured to just reject email from non-subscribers (which is usually spam) rather than presenting it to me to have to make a decision on.
My web hosting company (Gradwell.net) has ezmlm, and from what I've been reading, it seems to be much better on the back end, giving me the option to reject all email from non-subscribers and better bounce handling. The only problem is that a lot of my users are not very email savvy, and they need the crutch of a web interface. Before I write my own, it would be nice to find out if there is one available. Does anybody know of one?
The next Cmdr Taco duplicate will be ready soon, but subscribers can beat the rush and see it early!