On Thu, 3 May 2007, Andreas Haschka wrote:
> 1977 check senders = mysql;SELECT '[EMAIL PROTECTED]' :
> 1977 address match: [EMAIL PROTECTED] pattern=mysql;SELECT
> '[EMAIL PROTECTED]'
> 1977 search_open: mysql "NULL"
> 1977 search_find: file="NULL"
> 1977 key="SELECT '[EMAIL PROTECTED]'" partial=-1 affix=NULL starflags=0
> 1977 LRU list:
> 1977 internal_search_find: file="NULL"
> 1977 type=mysql key="SELECT '[EMAIL PROTECTED]'"
> 1977 database lookup required for SELECT '[EMAIL PROTECTED]'
> 1977 MYSQL query: SELECT '[EMAIL PROTECTED]'
> 1977 MYSQL new connection: host=localhost port=0 socket=NULL
> database=NULL user=root
> 1977 lookup yielded: [EMAIL PROTECTED]
> 1977 [EMAIL PROTECTED] in "mysql;SELECT '[EMAIL PROTECTED]' :"? yes
> (matched "mysql;SELECT '[EMAIL PROTECTED]'")
> 1977 accept: condition test succeeded
>
> So what's the deal here?
You've confused the two different lookup syntaxes. Since your query
delivers a list of addresses to check, you need to use the
${lookup mysql{SELECT....
syntax. The mysql;SELECT... syntax in a lookup means "if this lookup
succeeds, the thing we are looking for matches". It has, so it does.
--
Philip Hazel University of Cambridge Computing Service
Get the Exim 4 book: http://www.uit.co.uk/exim-book
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
