Rules via SQL queries?

[Julian Field]

What I have been thinking about is a slightly more general system than
that. You set a parameter to be the name of a Perl function. You write the
function, which is passed a message and returns a result for that rule.
Then you can easily write plugins that do things like this. You also write
an initialisation function that is called at startup for you to setup any
global state such as database conections.

And you can develop them entirely independent of the MS distribution so
upgrading is simple.

At 14:16 26/10/2002, you wrote:
>Is it possible for MailScanner to pull rules from a SQL database?  What I'm
>looking for is similar to what exim does with its ability to pull certain
>values in this manner.  Example:
>
>domainlist relay_to_domains = mysql;SELECT DISTINCT domain from domains
>WHERE mx1='mx10.tulsaconnect.com' AND domain='${domain}';
>
>So, if I set the Required SpamAssassin Score per-domain, it would be much
>easier/scalable if I could tell MailScanner to pull that from a database, e.g.
>
>SELECT score FROM scoretable WHERE domain='${domain}';
>
>Same would apply for the whitelist/blacklist function.

--
Julian Field                Teaching Systems Manager
jkf at ecs.soton.ac.uk         Dept. of Electronics & Computer Science
Tel. 023 8059 2817          University of Southampton
                             Southampton SO17 1BJ