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:
X-Spam-Status: Yes, hits=6.568 tagged_above=2 required=5
tests=[AWL=-0.016,
BAYES_99=4.3, FORGED_RCVD_HELO=1.651, HTML_80_90=0.146,
HTML_MESSAGE=0.001,
HTML_NONELEMENT_00_10=0.001, MIME_HEADER_CTYPE_ONLY=0.11,
MIME_HTML_ONLY=0.177, NO_REAL_NAME=0.007, REMOVE_PAGE=0.191]
The log seems to support the problem (more detail below):
lookup_sql_field(wb), "[EMAIL PROTECTED]" no matching records
Could someone point me in the correct direction to fix the problem.
Thanks,
Paul
Users:
INSERT INTO `users` VALUES (1, 10, 36, '[EMAIL PROTECTED]', 'Paul
Wolstenholme', 'Y');
mailaddr:
INSERT INTO `mailaddr` VALUES (6, 7, '.aeroplan.com');
INSERT INTO `mailaddr` VALUES (7, 7, '[EMAIL PROTECTED]');
INSERT INTO `mailaddr` VALUES (8, 7, '[EMAIL PROTECTED]');
INSERT INTO `mailaddr` VALUES (9, 7, 'aeroplan.com');
INSERT INTO `mailaddr` VALUES (10, 7, '[EMAIL PROTECTED]');
INSERT INTO `mailaddr` VALUES (11, 7, '[EMAIL PROTECTED]');
wblist:
INSERT INTO `wblist` VALUES (1, 2, 'W');
INSERT INTO `wblist` VALUES (1, 3, 'W');
INSERT INTO `wblist` VALUES (1, 4, 'W');
INSERT INTO `wblist` VALUES (1, 5, 'W');
INSERT INTO `wblist` VALUES (1, 7, 'W');
INSERT INTO `wblist` VALUES (1, 9, 'W');
INSERT INTO `wblist` VALUES (1, 10, 'W');
INSERT INTO `wblist` VALUES (1, 11, 'W');
The logs say:
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) wbl: checking sender
<[EMAIL PROTECTED]>
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql_field(id)
"[EMAIL PROTECTED]" result=1
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup, 1 matches for
"[EMAIL PROTECTED]", results: "/cached/"=>"1"
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) wbl: (SQL) recip
<[EMAIL PROTECTED]>, 1 matches
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) query_keys:
[EMAIL PROTECTED], webmaster@, yachtworld.com, .yach
tworld.com, .com, .
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04)
lookup_hash([EMAIL PROTECTED]), no matches
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup (local_domains) =>
undef, "[EMAIL PROTECTED]" does not ma
tch
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) query_keys:
[EMAIL PROTECTED], @yachtworld.com, @.yachtworld.com
, @.com, @.
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 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql select: SELECT
wb FROM wblist LEFT JOIN mailaddr ON wblist.s
id=mailaddr.id WHERE (wblist.rid=?) AND (mailaddr.email IN (?,?,?,?,?))
ORDER BY mailaddr.priority DESC
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) sql begin, nontransaction
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) sql: preparing and
executing: SELECT wb FROM wblist LEFT JOIN mailaddr
ON wblist.sid=mailaddr.id WHERE (wblist.rid=?) AND (mailaddr.email IN
(?,?,?,?,?)) ORDER BY mailaddr.priority DESC
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql,
"[EMAIL PROTECTED]" no match
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql_field(wb),
"[EMAIL PROTECTED]" no matching records
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup => undef,
"[EMAIL PROTECTED]" does not match
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) wbl: (SQL) recip
<[EMAIL PROTECTED]>, rid=1, got: ""
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
