I'm trying to get sql based whitelisting to work. The policy stuff
seems to work fine but not whitelisting. For example, I have the mail
address [EMAIL PROTECTED] whitelisted but the mail is still
tagged as spam.
The report from the header indicates that the rule is not applied:
On Aug 26, 2005, at 2:08 PM, Alan Munday wrote:
Paul Wolstenholme wrote the following on 26/08/2005 21:25:
I'm trying to get sql based whitelisting to work. The policy stuff
seems to work fine but not whitelisting. For example, I have the mail
address [EMAIL PROTECTED] whitelisted but the
Paul
My reading of your logs is that the RID matches but you don't get a SID match
when tested against the query keys.
Hence no WBlist adjustment.
Can you add an explicit record in your wblist table for this explicit sender
and retest, or check for typo's in your existing data?
HTH
Alan
This is becoming a little off topic. It appears I may have come across
a problem with MySQL. When I run the query:
SELECT wb
FROM wblist
LEFT JOIN mailaddr ON wblist.sid = mailaddr.id
WHERE (
wblist.rid =1
)
AND (
mailaddr.email
IN (
'webmaster', 'yachtworld', 'com'
)
)
ORDER BY
I found a temporary fix by specifying the character set in the query:
ELECT wb
FROM wblist
LEFT JOIN mailaddr ON wblist.sid = mailaddr.id
WHERE (
wblist.rid =1
)
AND (
mailaddr.email
IN (
_latin1 '[EMAIL PROTECTED]', _latin1 'webmaster@', _latin1
'yachtworld.com', _latin1 '.yachtworld.com',
In a process of deep
contemplation, Paul Wolstenholme carefully constructed the following
missive on 8/26/2005 5:43 PM:
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql
[EMAIL PROTECTED], query args: 1, [EMAIL PROTECTED]
tworld.com, @yachtworld.com, @.yachtworld.com, @.com, @.
Aug 24