[ mailman-Patches-839386 ] MySQL MemberAdaptor for Mailman 2.1
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 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. 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-05-31 19:57
Message:
Logged In: YES
user_id=99923
Folks,
Well, I've finally gotten around to releasing an update to
this thing, after a phone conversation with the client who
are using it, and I've incorporated a couple of cosmetic
fixes, fairly substantial changes to make the bounce
processing work properly (the ability to set people to
NOMAIL now exists, and real world testing is commencing
soon), and incorporated the flat vs. wide table archivecture
types with various bugfixes.
Main notes:
* It would be a good idea to change all your delivery_status
fields from VARCHAR(255) to INT(10) or similar, so that they
will work properly, and not bomb out on this new version
(they should be okay I think, but I'd advise the change).
* The missing-'AND' typo has been rectified.
Any suggestions and bugs should be sent to my sourceforge
account address, which ends up in the right place.
K.
----------------------------------------------------------------------
Comment By: Gergely EGERVARY (egervary)
Date: 2005-04-09 11:14
Message:
Logged In: YES
user_id=1255996
Thank you for your good work.
FYI: there's a missing "AND" in MysqlMemberships.py in line 494.
----------------------------------------------------------------------
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
participants (1)
-
SourceForge.net