SQLWhitelist for content.scanning.rules

Kit Wong Kit at simplysites.co.uk
Fri Nov 14 14:13:26 GMT 2008

Hi Steve

Thank you, it works. I had to disable &SQLBlacklist otherwise everything
was marked as blacklisted.

Thanks again

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info
[mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Steve
Sent: 14 November 2008 11:20
To: MailScanner discussion
Subject: Re: SQLWhitelist for content.scanning.rules

Kit Wong wrote:
> Sorry about this, I do have it configured as you described. What I am
> trying to do is use the whitelist created within MailWatch. This is
> accessed via &SQLWhitelist in the MailScanner.conf.
> The whitelist works fine when its used where its supposed to be, ie 
> Is Definitely not spam = &SQLWhitelist
> But when I use to at 
> Scan Messages = &SQLWhitelist 
> It doesn't scan any messages.

Well thinking about it the reason is obvious:

Value		Is Definitely Not Spam		Scan Messages
yes		Whitelisted			Message is scanned
no		Not whitelisted			Message is not scanned

The logic for the options is inverted - so if you want to use 
SQLWhiteList for Scan Messages instead you will have to invert the 
return codes.

In SQLWhitelist - change all occurrences of 'return 1' to 'return 0' and

all occurrences of 'return 0' to 'return 1' and it will work correctly.

> Just wondering if it is possible to not scan messages in the whitelist
> rather than scanning them but never marking them as spam. (since
> whitelist still gets scanned for viruses and filenames etc).

Personally - I think that's a really bad idea; it lets your users 
side-step any rules that you have in-place for their/your own safety.

MailScanner mailing list
mailscanner at lists.mailscanner.info

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website! 

Scanned by MailScanner.

No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.175 / Virus Database: 270.9.2/1783 - Release Date:
13/11/2008 18:01

More information about the MailScanner mailing list