Mailing List Archive

http://www.exim.org/bugzilla/show_bug.cgi?id=394

Summary: expansion of route_list
Product: Exim
Version: 4.52
Platform: x86
OS/Version: Linux
Status: NEW
Severity: bug
Priority: high
Component: Routing
AssignedTo: ph10@hermes.cam.ac.uk
ReportedBy: ml@lofl.de
QAContact: exim-dev@exim.org


I have to match in a mysql-Statement against ';', but exim gives me a error:

2006-09-21 13:14:15 1GQMVT-0007NW-NG == user@domain.com R=forward_aliases defer
(-1): forward_aliases router: failed to expand "${lookup mysql {SELECT
U_RemoteAddress FROM Users WHERE U_Type = '4' AND U_Domain =
'${quote_mysql:$domain}' AND U_Alias LIKE '%": missing } at end of string

my route_list is:

route_list = * "${lookup mysql {SELECT U_RemoteAddress FROM Users WHERE U_Type =
'4' AND U_Domain = '${quote_mysql:$domain}' AND U_Alias LIKE
'%;${quote_mysql:$local_part};%'}}"

so I have to use this statement which is very ugly:

route_list = * "${lookup mysql {SELECT U_RemoteAddress FROM Users WHERE U_Type =
'4' AND U_Domain = '${quote_mysql:$domain}' AND U_Alias LIKE CONCAT('%',
CHAR(59), '${quote_mysql:$local_part}', CHAR(59), '%')}}"



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.

--
## List details at http://www.exim.org/mailman/listinfo/exim-dev Exim details at http://www.exim.org/ ##