Auteur: Eric Balsa Date: À: exim-users Sujet: [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!)