<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16414" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>Im just trying to
spec out a web interface im going to put together to allow editing/amending of
various MailScanner preferences.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>At the moment ive
got a basic PHP setup that writes info to a Mysql DB. At 5 minute intervals a
perl script connects to the DB checks for any changes and rewrites the ruleset
files.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>So for example in
MailScanner.conf I have</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>Virus Scanning =
%rules-dir%/virus.scanning.rules</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>I have a Mysql table
with columns</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2>Direction</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2>Domain</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2>Value</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>With values like -
FromOrTo --- example.com --- yes</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>My perl script just
loops round all the values and writes the flat file "virus.scanning.rules" -
changes take affect based on the MailScanner.conf "Restart Every"
directive.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>This kind of worked
ok with 1 MailScanner server but ive now introduced another for load
balancing/resilience and wanted to put together a more sophisticated
system.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>I was
intending writing custom functions for all my rulesets by following
the examples in /usr/lib/MailScanner/MailScanner/CustomFunctions/ and also the
SQLSpamSettings.pm and SQLBlackWhiteList.pm done for the mailwatch
project.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>I would consider
myself very much an amatuer programmer and was looking for opinions and advice
on the following:-</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>- Would there be
much performance impact on using Custom Functions that read from a
(potentially remote) database, rather than a flat file on the system? I can
see myself writing custom functions for quite a number of the MailScanner.conf
directives</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>- Any problems using
LDAP instead of Mysql?</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>The reason im
thinking of LDAP was im looking to move all my sendmail routing info to LDAP and
would be nice to just maintain 1 system?</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>Any advice
appreciated.</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial size=2>Kind
Regards</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2>Paul</FONT></SPAN></DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=953230711-26042007></SPAN> </DIV></BODY></HTML>