Re: [exim] Using MySQL "INSTR" function fails exim-4.62

Top Page
Delete this message
Reply to this message
Author: Matt Judge
Date:  
To: exim-users
Subject: Re: [exim] Using MySQL "INSTR" function fails exim-4.62
Tony Finch wrote:
> See my earlier advice.
>
> Tony.
>


17:58:23 48503 processing "accept"
17:58:23 48503 expanding: $h_from:
17:58:23 48503    result:
17:58:23 48503 expanding: SELECT '1' FROM domain_whitelist AS b, 
vdomains AS v WHERE INSTR('${quote_mysql:$h_from:}', b.address)
17:58:23 48503    result: SELECT '1' FROM domain_whitelist AS b, 
vdomains AS v WHERE INSTR('', b.address)
17:58:23 48503 search_open: mysql "NULL"
17:58:23 48503   cached open
17:58:23 48503 search_find: file="NULL"
17:58:23 48503   key="SELECT '1' FROM domain_whitelist AS b, vdomains AS 
v WHERE INSTR('', b.address)" partial=-1 affix=NULL starflags=0
17:58:23 48503 LRU list:
17:58:23 48503 internal_search_find: file="NULL"
17:58:23 48503   type=mysql key="SELECT '1' FROM domain_whitelist AS b, 
vdomains AS v WHERE INSTR('', b.address)"
17:58:23 48503 database lookup required for SELECT '1' FROM 
domain_whitelist AS b, vdomains AS v WHERE INSTR('', b.address)
17:58:23 48503 MYSQL query: SELECT '1' FROM domain_whitelist AS b, 
vdomains AS v WHERE INSTR('', b.address)


There ye go :)