Patrick Saweikis wrote:
Has anyone had any experience trying to make spamassassin use a mysql
database for it's ruleset instead of text files? We are planning on
making our anti-spam solution redundant, and it would be nice to have
this in a database instead of copying files around when we make changes.
we have multiple redundant cluster sets that need to do just that.
custom rules, *.pre files, local.cf files, etc.
put any custom rules in the database, and modify the spamd? start
scripts to write the custom rules to flat files. modify your update
program to signal a spamd reload every time you modify the rules, or,
use unison. we use unison (not for our VPS spam clusters) but for
syncing flat files used on our redundant web servers (any downloaded
pdf's can be up to 15 mins behind the 'master') which is why we don't do
that on our anti-spam clusters.
other option is to use a unixsocket to simulate files.. spamd would
never know the difference, but a failure on sql would hurt.
or, spamassassin is open source, go for it, but you would be reading
(multiple dozens of files? ) each time a spamd instance started or
reloaded or spawned.
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best Anti-Spam Product 2008, Network Products Guide
* King of Spam Filters, SC Magazine 2008
_________________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
_________________________________________________________________________
