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.
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
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.
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..."
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!