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

[SourceForge.net]

Patches item #839386, was opened at 2003-11-10 18:04
Message generated for change (Comment added) made by kyrian
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: 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