[Exim] Problem expansion of lookup mysql

Top Page
Delete this message
Reply to this message
Author: Steffen Herold
Date:  
To: exim-users
Subject: [Exim] Problem expansion of lookup mysql
Hello,


I want to use the following mysql string in a domainlist router.

dom_router:
driver = domainlist
condition =${lookup mysql {MYSQL_ROUTING_DOMAIN}{$value}fail}
transport = remote_smtp
route_list ="* ${lookup mysql {MYSQL_ROUTING_MX}{$value}fail} byname"

MYSQL_ROUTING_MX= SELECT MYSQL_RMXHOSTFIELD FROM MYSQL_ROUTINGTABLE
WHERE MYSQL_DOMAINFIELD LIKE '${quote_mysql:$route_domain}'

I got thise error while testing:

dom_router router called for test@???
route_domain = gmx.de
routelist_item = * ${lookup mysql {SELECT mx FROM routing WHERE domain
LIKE '${quote_mysql:$route_domain}'}{$value}fail} byname
after handling route_lists items, matched = 1
original hostlist=${lookup options=mysql {SELECT mx FROM routing WHERE
domain LIKE '${quote_mysql:$route_domain}'}{$value}fail} byname
dom_router router: error for gmx.de
message: dom_router router: failed to expand "${lookup": missing
lookup type
test@??? cannot be resolved at this time:
dom_router router: failed to expand "${lookup": missing lookup type
search_tidyup called

Why exim is missing lookup type ??

Thanks Steffen
-- 
-------------------------------------------------
Steffen Herold            IN-Systeme
steffen.herold@??? 
Curiestr. 2
                70563 Stuttgart