[ mailman-Patches-839386 ] MySQL MemberAdaptor for Mailman 2.1

SourceForge.net noreply at sourceforge.net
Sat Mar 12 00:22:04 CET 2005


Patches item #839386, was opened at 2003-11-10 18:04
Message generated for change (Comment added) made by simboforge
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=300103&aid=839386&group_id=103

Category: configure/install
Group: Mailman 2.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Kev Green (kyrian)
Assigned to: Nobody/Anonymous (nobody)
Summary: MySQL MemberAdaptor for Mailman 2.1

Initial Comment:
A MemberAdaptor "plugin" which should allow Mailman list members 
to be loaded from a MySQL database, rather than just a Mailman 
"pickle" file.

Provided as-is, and without warranty, this "plugin" may destroy your 
server, soul, scalp, house, and life. Please use it with caution.

Kev Green, oRe Net.
http://www.orenet.co.uk/

----------------------------------------------------------------------

Comment By: simboforge (simboforge)
Date: 2005-03-11 23:22

Message:
Logged In: YES 
user_id=1226150

excellent. can you please give me a list of the files
modified from the original distro? grep sees six that grep
have msyql in them. thx

----------------------------------------------------------------------

Comment By: Kev Green (kyrian)
Date: 2005-03-11 22:56

Message:
Logged In: YES 
user_id=99923

The flat file databases are unused when you put the MySQL adaptor in 
place, and they are untouched (and indeed not deleted) by it, the MySQL 
adaptor only queries the MySQL tables for membership information, without 
trying to force you into using it fulltime by deleting anything, etc.

Once you unconfigure the MySQL adaptor, Mailman should revert back to 
your existing flat file databases.

Of course, I could have missed something, etc. so do back up your flat file 
databases before installing the MySQL adaptor, and then you can just 
migrate back to them by restoring the backups.

Either way, you have come up with a good question for an FAQ on the SQL 
adaptor :-)

K.


----------------------------------------------------------------------

Comment By: simboforge (simboforge)
Date: 2005-03-11 22:42

Message:
Logged In: YES 
user_id=1226150

neat. just what i was looking for. i have a couple of live
lists running on version version 2.1.5. i am a bit leary
about unzipping this distrobution over the top of my working
mailman as i am not sure how to backup the existing flat
file databases. i would prefer to experiment with dropping
the adapter into my existing installation. any pointers as
to where to start? thx

----------------------------------------------------------------------

Comment By: Kev Green (kyrian)
Date: 2004-12-13 18:34

Message:
Logged In: YES 
user_id=99923

Oh, btw. v1.57 hasn't been tested yet, so it might kill your
server, eat your dog, and stick your wife in the oven. Be
careful using it!

----------------------------------------------------------------------

Comment By: Kev Green (kyrian)
Date: 2004-12-13 18:33

Message:
Logged In: YES 
user_id=99923

Version 1.57: 2004/12/13

* Merge in Daniel Shriver patch/code for a flat table
architecture.
  [ Suggested by Kevin McCann <kmccann(at)bellanet.org>, but
I hadn't found time to do it myself... ]
* Add bugfix information from Jinhyok Heo
<novembre at NOSPAM.ournature.org>
* Add in mksqlmailman script from TheSin
<thesin at SPAMNOTHANKS.southofheaven.org>
* Follow Barry Warsaw's suggestion on delivery status timestamp.


----------------------------------------------------------------------

Comment By: Kev Green (kyrian)
Date: 2004-01-08 11:38

Message:
Logged In: YES 
user_id=99923

Latest version incorporates automated generation of the necessary tables, 
cleaner error reporting, and updated documentation.

----------------------------------------------------------------------

Comment By: Kev Green (kyrian)
Date: 2003-11-11 11:14

Message:
Logged In: YES 
user_id=99923

Bit of an oops in version 1.49, 1.50 now uploaded, which should fix it.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=300103&aid=839386&group_id=103


More information about the Mailman-coders mailing list