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 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
I would like to test the sql manually but I'm not sure what values are
being used in the IN statement:
SELECT wb FROM wblist LEFT JOIN mailaddr
ON wblist.sid=mailaddr.id WHERE (wblist.rid=?) AND (mailaddr.email IN
(?,?,?,?,?)) ORDER BY mailaddr.priority DESC
SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id WHERE
(wblist.rid=1) AND (mailaddr.email IN
("[EMAIL PROTECTED]","@yachtworld.com", "@.yachtworld.com",
"@.com", "@.")) ORDER BY mailaddr.priority DESC
(Assuming the break in the email address was introduced by your email
program)
Try whitelisting "@yachtworld.com". Is the data you posted actually
from a dump of your table? Or is a typo possible?
-------------------------------------------------------
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/