Message
From: Sven Riedel [mailto:sr (AT) baghus (DOT) net]
Sent: Wednesday, January 18, 2006 12:49 AM
To: dev (AT) spamassassin (DOT) apache.org
Subject: Rules from Database
Hi,
I'm currently working on a (among other frontends) SA
frontend for work, which stores a lot of the configuration
information in a database, including the rule set.
My current approach is going to be to generate a rules.cf
file from the rules table, and load that into SA. I might
work on a patch for SA to read the ruleset directly from the
database table instead (I think this would complement the
Bayes/AWL in an SQL database nicely).
When you say 'read the ruleset directly', I hope you mean loading rules
from SQL on spamd startup (which would require a patch), because loading
800 ish rules from SQL via ConfSQL.pm per msg would incur quite a lot of
unneeded overhead when the rules do not change often enough to warrant
it (bayes and awl do).
I think you would be better off developing your SQL schema and then
cron'ing a perl script to read the DB and write a rules.cf (hourly/daily
whatever), and then HUP the spamd when you do. That way your schema
that you need for your web frontend doesn't have to marry to SA
necessarily, since you have an intermediary script making it work the
way SA wants.
Just my $0.02, since I've done a lot of what you are talking about here.
Dallas