On Tue, 8 Aug 2006, Tomer Horn wrote:
> client_send = ${lookup mysql{select
> concat('^',users_manualroute.user,'^',users_manualroute.passwd) \
> from users_manualroute,users,domains \
> where
> concat(users.user,'@',domains.domain)='${quote_mysql:$authenticated_id}' \
> and users.domain_id=domains.id \
> and users.active='on' and domains.active='on' \
> and users_manualroute.host LIKE '%.%'}}
You need to double the colon after quote_mysql because client_send is a
*list* of strings to send.
> (0): expansion of "${lookup mysql{select
> concat('^',users_manualroute.user,'^',users_manualroute.passwd) from
> users_manualroute,users,domains where
> concat(users.user,'@',domains.domain)='${quote_mysql" failed in plain
There is the clue ... note that it has chopped the string that it is
trying to expand at the colon.
--
Philip Hazel University of Cambridge Computing Service
Get the Exim 4 book: http://www.uit.co.uk/exim-book
