Bug 2197 - SQL failover patch
Summary: SQL failover patch
Status: NEW
Alias: None
Product: Spamassassin
Classification: Unclassified
Component: spamc/spamd (show other bugs)
Version: unspecified
Hardware: Other other
: P5 enhancement
Target Milestone: Future
Assignee: SpamAssassin Developer Mailing List
URL:
Whiteboard:
Keywords:
: 5245 (view as bug list)
Depends on:
Blocks:
 
Reported: 2003-07-08 01:51 UTC by Mark Lowes
Modified: 2009-09-21 13:03 UTC (History)
4 users (show)



Attachment Type Modified Status Actions Submitter/CLA Status
SQL failover patch patch None Mark Lowes [NoCLA]
Connection failover patch for Mail::SpamAssassin::BayesStore::MySQL patch None cory.meyer@gmail.com [NoCLA]
Connection failover patch for Mail::SpamAssassin::SQLBasedAddrList patch None cory.meyer@gmail.com [NoCLA]

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Lowes 2003-07-08 01:51:58 UTC
This patch provides the functionality needed to support multiple SQL servers for
central configuration.  It's not pretty but it works.
Comment 1 Mark Lowes 2003-07-08 01:52:36 UTC
Created attachment 1144 [details]
SQL failover patch
Comment 2 Daniel Quinlan 2005-03-30 01:08:22 UTC
move bug to Future milestone (previously set to Future -- I hope)
Comment 3 Michael Parker 2006-12-15 07:58:37 UTC
*** Bug 5245 has been marked as a duplicate of this bug. ***
Comment 4 cory.meyer 2009-09-17 08:28:16 UTC
Last update on this was 2005-03-30 01:08:22 PST.   Any chance of this patch or any type of DBI connection fail-over being moved into the main release?
Comment 5 Justin Mason 2009-09-17 09:33:54 UTC
If we could get someone with experience of the SQL code to review it, it would be a candidate... anyone?
Comment 6 cory.meyer 2009-09-21 12:57:04 UTC
Created attachment 4538 [details]
Connection failover patch for Mail::SpamAssassin::BayesStore::MySQL

Modifications were made against SA version 3.2.5  This is based on a patch submitted by Mark Lowes.
Comment 7 cory.meyer 2009-09-21 12:58:53 UTC
Created attachment 4539 [details]
Connection failover patch for Mail::SpamAssassin::SQLBasedAddrList

Modifications were made against SA version 3.2.5  This is based on a patch
submitted by Mark Lowes.
Comment 8 Michael Parker 2009-09-21 13:02:51 UTC
Personally I'd rather see patches or additional plugins based on one of the several high availability/failover modules in CPAN:

http://search.cpan.org/~dwright/DBD-Multi-0.14/

http://search.cpan.org/~markstos/DBIx-HA-1.1/lib/DBIx/HA.pm

http://search.cpan.org/~markstos/DBIx-HA-1.1/lib/DBIx/HA.pm
Comment 9 Michael Parker 2009-09-21 13:03:13 UTC
oops, that was link was:

http://search.cpan.org/~tkishel/DBD-Multiplex-2.09/lib/DBD/Multiplex.pm