Re: [exim] quote_mysql refuses to work in plain authenticato…

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Tomer Horn
CC: exim-users
Subject: Re: [exim] quote_mysql refuses to work in plain authenticator
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