[Mailman-Users] MySQL
Is it possible to have mailman store the email addresses in a database in MySQL? Aaron Dolgin (661) 400-6301 VP of Business Marketing Electrical Lead Webmaster Hart District Robotics Team 691 Team691.org http://team691.org/ Follow us on Twitter @Project691 -- Mailman-Users mailing list Mailman-Users@python.org https://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://wiki.list.org/x/AgA3 Security Policy: http://wiki.list.org/x/QIA9 Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: https://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL
On 09/25/2013 01:23 PM, Aaron Dolgin wrote: Is it possible to have mailman store the email addresses in a database in MySQL? See the FAQ at http://wiki.list.org/x/VIDt. -- Mark Sapiro m...@msapiro.netThe highway is for gamblers, San Francisco Bay Area, Californiabetter use your sense - B. Dylan -- Mailman-Users mailing list Mailman-Users@python.org https://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://wiki.list.org/x/AgA3 Security Policy: http://wiki.list.org/x/QIA9 Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: https://mail.python.org/mailman/options/mailman-users/archive%40jab.org
[Mailman-Users] MySQL or other backends
Does Mailman support using MySQL, LDAP or another SQL server for a backend? -- Mailman-Users mailing list Mailman-Users@python.org 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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
Re: [Mailman-Users] MySQL or other backends
On 9/25/06, Jeremy Leonard [EMAIL PROTECTED] wrote: Does Mailman support using MySQL, LDAP or another SQL server for a backend? I believe there's a third-party patch/addon to use MySQL for storing membership information, although I think list configurations (and almost certainly archives) are still stored on the filesystem. Try searching for 'mailman mysql member adapter'. It would probably be fairly easy to modify this to use a different SQL server. Theoretically, LDAP, as well, although that would likely be a more extensive rewrite. If you're interested in storing *all* data on a MySQL server, you're out of luck as far as I know. -- - Patrick Bogen -- Mailman-Users mailing list Mailman-Users@python.org 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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
Re: [Mailman-Users] MySQL or other backends
Patrick Bogen wrote: On 9/25/06, Jeremy Leonard [EMAIL PROTECTED] wrote: Does Mailman support using MySQL, LDAP or another SQL server for a backend? I believe there's a third-party patch/addon to use MySQL for storing membership information, although I think list configurations (and almost certainly archives) are still stored on the filesystem. Try searching for 'mailman mysql member adapter'. It would probably be fairly easy to modify this to use a different SQL server. Theoretically, LDAP, as well, although that would likely be a more extensive rewrite. If you're interested in storing *all* data on a MySQL server, you're out of luck as far as I know. Patrick is correct. There is also a read only LDAP MemberAdaptor. You can find both of these in the Mailman patch tracker on sf.net. There is active work on the MySQL MemberAdaptor. See http://trac.rezo.net/trac/rezo/browser/Mailman/. Also see the Mailman 2.2 wiki at http://wiki.list.org/display/DEV/Mailman+2.2 for info on plans to use some kind of SQL database for all list data, not just membership. -- Mark Sapiro [EMAIL PROTECTED] The highway is for gamblers, San Francisco Bay Area, Californiabetter use your sense - B. Dylan -- Mailman-Users mailing list Mailman-Users@python.org 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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
[Mailman-Users] mysql and mailman part 2
Hi All, here is some more information about my issue from yesturday. On my default 'mailman' list I can add users and delete users no problem via the web interface, however our 'emagazine' database which is set up the same way, does not work. the only real difference is the 'emagazine' database has over 123000 addresses in it. Did I hit some sort of limitation? Thanks, Sean -- Mailman-Users mailing list Mailman-Users@python.org 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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=showamp;file=faq01.027.htp
[Mailman-Users] MySQL MemberAdaptor.
All, http://kyrian.ore.org/MailmanMysql/ I accept absolutely no responsibility for the above ruining your marriage, hairdo, life, dogs, cats, children, computer systems, reputations, sanity, or indeed destroying the entire known universe. However, it should allow you to use MySQL with Mailman 2.1+ for your mailing list members. The bounce detection and delivery status stuff is less than perfect, and there could well be other problems. Enjoy. K. PS. Feel free to report bugs in the code/suggest enhancements/offer help to make it better via email (to me directly please), but I'm very busy, so please don't expect them to get solved/incorporated particularly quickly, and certainly don't even bother getting cranky with me if it doesn't work because I'll probably just ignore you. Unless you want to pay me for my time, of course ;-) -- Kev Green, aka Kyrian. Be excellent to each other -- Bill Ted. Email: kyrian#64;ore.org Web: http://kyrian.ore.org/ ISP/Perl/PHP/Linux/Security Contractor, via http://www.orenet.co.uk/ -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL?
Ideally, the MySQL bridge would be an option or add-on, much like say, the htdig search tool, the Mhonarc hook, etc. Organisations such as yours would not be obliged to use it. So long as it didn't ONLY support MySQL, and supported PostgreSQL, etc. (I think cursor's would be pretty much essential) then I wouldn't complain. Chris -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
[Mailman-Users] MySQL?
I remember reading somewhere that mailman can operate with a MySQL backend? If that is so, they it should be possible to develop a diffrent front end, to interface with users, add users to mailman etc etc. Is there any truth to this?? -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL?
On Fri, 2003-05-30 at 10:30, Angel Gabriel wrote: I remember reading somewhere that mailman can operate with a MySQL backend? If that is so, they it should be possible to develop a diffrent front end, to interface with users, add users to mailman etc etc. Is there any truth to this?? If this was true I'd be doing a breakdance right about now. ;-) Currently Mailman does not operate directly with a MySQL database. I know Barry has a few ideas up his sleeve with regard to opening things up a bit but I don't know how he sees MySQL fitting in, if at all. In my ideal world, fundamental data would be able to be in a SQL database: - user info - archived messages - list configurations - site configurations and possibly: - incoming queue - outgoing queue - logs I don't anticipate this in Mailman in the very near future so I am currently working on a MLMI (mailing list manager interface) API for PHP. The Mailman section of the API will be a collection of functions that execute Mailman commands and return results. Like so: mlmi_settype(Mailman); mlmi_getlists(); mlmi_getmembers($listname); mlmi_getconfig($listname); mlmi_newlist($listname,$adminemail,$adminpass,$security); The mlmi_getlists function, for example, would just execute bin/list_lists, parse the results, and return an array available to any PHP script that calls it. Conceivably, mlmi functions could be used to populate a MySQL database (I know, it would be much nicer if there was just one data source). This may all seem a bit insane but it seems to be the only way I can do what I need to do for the project I'm working on. - Kevin -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL?
Been there, done that! (thank you, though) Sympa showed promise on paper (specifically, the comparison paper available on the Sympa site) but it just didn't work out. I couldn't get the bloody thing installed on RedHat 8.0, despite working with one of the developers to try to get it happening. I sent out a message to the sympa-users list asking if *anyone* had successfully installed it on 8.0 and I all I heard was the crickets chirping. On the Sympa users list I constantly hear (read) of people running into significant problems. And the fact that there are *so* many Perl module dependencies just doesn't leave me with a comfortable feeling about Sympa. A colleague and I managed to get Sympa running on RedHat 7.3 after many hurdles, and we gave it a spin, but it just isn't what we're looking for. In addition, the SQL offering in Sympa only applies to the user table. OK for a start, but I need more than that. I have pretty much decided to go with Mailman because it is easy to install, has a very large install base, and has most of the delivery features I need. And the problems that are reported on this list don't seem to be major show stoppers with no solutions in sight. So now that I have identified the best open source MLM (at least for my purposes), I just have to convince/beg/influence the Mailman developmnent folks to get it to behave more like the best commercial MLM (Lyris).;-) - Kevin On Fri, 2003-05-30 at 11:54, Jeff D wrote: You guys might want to check out Sympa instead of Mailman - http://www.sympa.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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL?
On Fri, May 30, 2003 at 11:16:46AM -0400, Kevin McCann wrote: On Fri, 2003-05-30 at 10:30, Angel Gabriel wrote: I remember reading somewhere that mailman can operate with a MySQL backend? If that is so, they it should be possible to develop a diffrent front end, to interface with users, add users to mailman etc etc. Is there any truth to this?? If this was true I'd be doing a breakdance right about now. ;-) I chose mailman because it didn't have any complex database backends. The reason is because I run mailman as a mission critical service for Keele University and so I want the least amount of software and technology to do the job. Each new piece of software has to be evaluated and tested, then installed and checked and then a backup procedure worked out and also a fault recover procedure. Mailman as it stands is easy because there really isn't that much beyond the software scripts and the data directories to it. All I have is an rdist running to copy a working set of software to a backup machine every few hours. Should we get a failure the changeover is very simple. If you start adding MySQL into the equation then there's the mailman stuff AND the MySQL stuff to set up for duplicate fault tollerant operation. If mailman could be made to work concurrantly on several servers using a distributed MySQL database then that would certainly be worth doing because you get failover backups for free but I suspect that the architecture of mailman is too ingrained to the qrunner concept to make that possible. -- __[EMAIL PROTECTED]Jonathan Knight, / Department of Computer Science / _ __ Telephone: +44 1782 583437 University of Keele, Keele, (_/ (_) / / Fax : +44 1782 713082 Staffordshire. ST5 5BG. U.K. -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL?
On Fri, 2003-05-30 at 13:10, Jonathan Knight wrote: I chose mailman because it didn't have any complex database backends. The reason is because I run mailman as a mission critical service for Keele University and so I want the least amount of software and technology to do the job. snip If you start adding MySQL into the equation then there's the mailman stuff AND the MySQL stuff to set up for duplicate fault tollerant operation. I respect your position on this. However, many organisations do things differently. We tend to push the envelope a little bit more and do not shy away from trying new things, especially when there is a specific goal in mind. FWIW, we want to create a community-building tool, something simlar to yahoogroups, but simpler, and with the mailing list being the focus. We have already done this quite successfully, but using commercial software (Lyris + ColdFusion on NT). We want to do the same thing but in an open source envuronment (Mailman + PHP on Linux). Ideally, the MySQL bridge would be an option or add-on, much like say, the htdig search tool, the Mhonarc hook, etc. Organisations such as yours would not be obliged to use it. (sorry if I'm getting off-topic for this list - maybe the developers list would be a better place to bandy-about ideas?) - Kevin -- 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/ This message was sent to: [EMAIL PROTECTED] Unsubscribe or change your options at http://mail.python.org/mailman/options/mailman-users/archive%40jab.org
Re: [Mailman-Users] MySQL database?
On Thu, May 16, 2002 at 07:23:31PM -0700, J C Lawrence wrote: 2) using MySQL or data from MySQL to include in the mail list. Not really possible in 2.0, easier but not done yet in 2.1. You end up doing tricks with ~mailman/bin/add_members until then. Any reference to these tricks? I'm interested in what may be a slightly different question: Is there any official way of maintaining a master list, perhaps in XML, so the new user is asked to give some information, eg full name, which is then kept (somewhere) with the email address? -- Timothy Murphy e-mail: [EMAIL PROTECTED] tel: 086-233 6090 s-mail: School of Mathematics, Trinity College, Dublin 2, Ireland -- 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
[Mailman-Users] MySQL database?
I've just installed Mailman and am quite please at how easy it was to get it up and running. I now have two issues that I cannot seem to find documentation on: 1) running Mailman for Virtual Hosts and 2) using MySQL or data from MySQL to include in the mail list. With a bit of time I can probably figure out the former issue. The latter issue seems a bit more tricky for a variety of reasons. In short, I have other functionality (CGI/mod_perl scripts) running for virtual web hosts that allow users to input email address and thus be attached to a mailing list. I'd like to either a) use MySLQ as the database for Mailman or b) pull those addresses from MySQL and include them in the Mailman database for the mail list. Both ideas have obvious caveats and pitfalls (how to sync an un-subscribe request with MySQL if I use the original Mailman database...). Any ideas or leads are much appreciated. -- -Doug -- 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
Re: [Mailman-Users] MySQL database?
On Thu, 16 May 2002 15:10:54 -0700 Doug La Farge [EMAIL PROTECTED] wrote: 1) running Mailman for Virtual Hosts See hostname that this list prefers on the first admin page for each list. 2) using MySQL or data from MySQL to include in the mail list. Not really possible in 2.0, easier but not done yet in 2.1. You end up doing tricks with ~mailman/bin/add_members until then. -- 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
[Mailman-Users] MySQL back end to Mailman?
Boy is it hard doing a search for this stuff because of the infrastructural uses of both components causing their names to be archived in many totally unrelated places... A little birdy said that Mailman was going to support a MySQL back end in 2.1. Is this true? If so I can't find anything about that on the Mailman web site. Where can I learn more about this? And how close is it to being ready for general consumption? Reason I ask is I am currently building a PHP system for managing clubs and would like to use Mailman as the mailing list manager instead of having to waste lots of time reinventing the wheel and coming up short. The membership database will be kept in MySQL which I would like Mailman to use. Thanks, Chris -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
Re: [Mailman-Users] MySQL back end to Mailman?
Hay Chris! AFAIK, Mailman 2.1 is not going to be fixed to use any particular external database, but will have the hooks to use any external database. Someone, perhaps you, will have to write the interface from Mailman to the database format. Someone may have already written such an interface for MySQL. If they haven't yet, I'm sure it will come soon. You should ask on the Dev list though, as this list is only for current production releases. Good luck, and if you need any help in re-inventing this wheel, let me know, I've written a few... Jon === On Sunday 03 February 2002 18:27, Chris Hedemark wrote: Boy is it hard doing a search for this stuff because of the infrastructural uses of both components causing their names to be archived in many totally unrelated places... A little birdy said that Mailman was going to support a MySQL back end in 2.1. Is this true? If so I can't find anything about that on the Mailman web site. Where can I learn more about this? And how close is it to being ready for general consumption? Reason I ask is I am currently building a PHP system for managing clubs and would like to use Mailman as the mailing list manager instead of having to waste lots of time reinventing the wheel and coming up short. The membership database will be kept in MySQL which I would like Mailman to use. Thanks, Chris -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
Re: [Mailman-Users] mysql and mailman
There is no true integration with Mysql (though rumor has it that this may change in the near future...); however, you can use a couple of procedures to build a bridge between Mailman's database and your Mysql database. If you check the archives for the past month, you'll see some suggestions. You can use the following Mailman commands to keep the databases in sync: list_members - print out the email addresses in a list sync_members - compare current members to a text file of email addresses and add unique folks from the file to the Mailman list. Good Luck. You might want to write up what you do and release it as a HowTo, since this question seems to be popping up quite a bit. Jon Carnes - Original Message - From: Daniel Bondurant [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 11, 2001 2:12 PM Subject: [Mailman-Users] mysql and mailman Is there anyway to tie in the userlist for a mailing list with mysql? I need to keep track contact information, along with the email address/name. when a user deletes themself from a list, I need to also delete them from the database. I'm sure this issue has been dicussed before, so If someone would point me in the right direction, I'm sure I can figure it out. thanks -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
Re: [Mailman-Users] MySQL?
Frank Goossens wrote: e-mails out of the database (all of them), saves them in a temp-file and which uses the remove_member and add_member mailman (python) scripts to first remove (all) and then add (all) the users? ~mailman/bin/sync_members is enough. I use such a script and it's fine. -- Alessio F. Bragadini[EMAIL PROTECTED] APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-2-755750 It is more complicated than you think -- The Eighth Networking Truth from RFC 1925 -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
[Mailman-Users] MySQL?
I have a large mailing list of about 500. Concurrently there is a maintained MySQL database that includes a column with these email addresses. Would there be any possibility of getting mailman to draw the list from MySQL thus making updates automatic? Michael -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
Re: [Mailman-Users] MySQL?
On Wed, 19 Sep 2001 14:51:31 -0400 Michael Lampman [EMAIL PROTECTED] wrote: Would there be any possibility of getting mailman to draw the list from MySQL thus making updates automatic? The version of Mailman currently in Alpha supports such operations via a plugin layer. You'll have to write the adaptor for your DB to fit Mailman. -- 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 maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
RE: [Mailman-Users] MySQL?
Title: RE: [Mailman-Users] MySQL? you could consider writing a cronned script (perl/ python/ whatever can access mysql) that gets the e-mails out of the database (all of them), saves them in a temp-file and which uses the remove_member and add_member mailman (python) scripts to first remove (all) and then add (all) the users? you could make it (and your database design) even more complex by using flags in your table to mark entries as 'to be added' and 'to be removed', have the script interpret those flags and clear them (+ remove removed entries) from the table. but i'd stick to the simpler solution ;-) frank -Original Message- From: Michael Lampman To: [EMAIL PROTECTED] Sent: 9/19/01 8:51 PM Subject: [Mailman-Users] MySQL? I have a large mailing list of about 500. Concurrently there is a maintained MySQL database that includes a column with these email addresses. Would there be any possibility of getting mailman to draw the list from MySQL thus making updates automatic? Michael -- Mailman-Users maillist - [EMAIL PROTECTED] http://mail.python.org/mailman/listinfo/mailman-users
