[Exim] Question about routing

Top Page
Delete this message
Reply to this message
Author: Eric Balsa
Date:  
To: exim-users
Subject: [Exim] Question about routing
Hi All,

I am trying to create a router which will only accept mail for current
'virtual domains / users'. However, the format of my MySQL DB has fully
qualified usernames (i.e. eric@???), instead of local_part and domain
columns. Here is my current router configuration:

catchall:
driver = accept
domains = +local_domains
local_parts = mysql;MYSQL_LOCALUSERS
transport = test
cannot_route_message = Unknown local user

I know local_domains is working properly.

But when I run
/usr/exim/bin/exim -bh 10.9.8.7 I see the following response when checking
MYSQL_LOCALUSERS

>>> eric in "mysql;SELECT userName FROM user WHERE
>>> user.userName='eric@???'"? no (end of list) no more routers
>>> ----------- end verify ------------
>>> accept: condition test failed


That is probably because userName returned from the SQL query is
eric@???, not simply eric. Anyone have some ideas how I can get
around this? I don't see an expansion variable that is the full email
address being delivered to (but I may have missed it!)

Regards,
--Eric