Rules via SQL queries?

[Julian Field]

If you want to give it a try, you'll find a new set of "mailscanner",
"Config.pm" and "CustomConfig.pm" files attached. Have a read of
CustomConfig.pm and see if it explains enough so you can see what you need
to do.

I will happily publish any useful plugins on the website.

At 14:25 26/10/2002, you wrote:
>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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: custom.zip
Type: application/zip
Size: 17310 bytes
Desc: not available
Url : http://lists.mailscanner.info/pipermail/mailscanner/attachments/20021026/18a2cb9e/custom.zip
-------------- next part --------------
--
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