[AMaViS-user] sql whitelisting problem

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 "webmaster@yachtworld.com" 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), "webmaster@yachtworld.com" 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, 'paul@shoutout.ca', 'Paul
Wolstenholme', 'Y');

mailaddr:
INSERT INTO `mailaddr` VALUES (6, 7, '.aeroplan.com');
INSERT INTO `mailaddr` VALUES (7, 7, 'c-d-@telus.net');
INSERT INTO `mailaddr` VALUES (8, 7, 'ianywhere_info@ianywhere.com');
INSERT INTO `mailaddr` VALUES (9, 7, 'aeroplan.com');
INSERT INTO `mailaddr` VALUES (10, 7, 'webmaster@yachtworld.com');
INSERT INTO `mailaddr` VALUES (11, 7, 'mailinglist@ncix.com');


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
<webmaster@yachtworld.com>
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql_field(id)
"paul@shoutout.ca" result=1
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup, 1 matches for
"paul@shoutout.ca", results: "/cached/"=>"1"
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) wbl: (SQL) recip
<paul@shoutout.ca>, 1 matches
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) query_keys:
webmaster@yachtworld.com, webmaster@, yachtworld.com, .yach
tworld.com, .com, .
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04)
lookup_hash(webmaster@yachtworld.com), no matches
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup (local_domains) =>
undef, "webmaster@yachtworld.com" does not ma
tch
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) query_keys:
webmaster@yachtworld.com, @yachtworld.com, @.yachtworld.com
, @.com, @.
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql
"webmaster@yachtworld.com", query args: "1", "webmaster@yach
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,
"webmaster@yachtworld.com" no match
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup_sql_field(wb),
"webmaster@yachtworld.com" no matching records
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) lookup => undef,
"webmaster@yachtworld.com" does not match
Aug 24 23:11:21 ip3 amavis[31600]: (31600-04) wbl: (SQL) recip
<paul@shoutout.ca>, 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/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/