[AMaViS-user] sql whitelisting problem

2005-09-02 Thread Paul Wolstenholme
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&#

Re: [AMaViS-user] can't get amavisd-new runnning

2005-08-30 Thread Paul Wolstenholme
I believe there is also an amavisd-new rpm that installs all the dependencies either at Dag or RPMfind. /Paul On Aug 30, 2005, at 10:37 AM, Martin Svensson wrote: Anne, Try to install all the needed modules using CPAN. The CPAN module will automatically install dependencies as well. sh %>p

Re: [AMaViS-user] sql based whitelisting

2005-08-26 Thread Paul Wolstenholme
x27;, _latin1 '.yachtworld.com', _latin1 '.com', _latin1 '.' ) ) ORDER BY mailaddr.priority DESC LIMIT 0 , 30 /Paul On Aug 26, 2005, at 6:57 PM, Paul Wolstenholme wrote: This is becoming a little off topic. It appears I may have come across a problem with MySQL. When

Re: [AMaViS-user] sql based whitelisting

2005-08-26 Thread Paul Wolstenholme
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 mailaddr.prior

Re: [AMaViS-user] sql based whitelisting

2005-08-26 Thread Paul Wolstenholme
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]" whit

[AMaViS-user] sql based whitelisting

2005-08-26 Thread Paul Wolstenholme
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&#