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

Top Page
Delete this message
Reply to this message
Author: Tomer Horn
Date:  
To: exim-users
Subject: Re: [exim] quote_mysql refuses to work in plain authenticator
*Thank you* Philip.

Tomer.

Philip Hazel wrote:
> 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.
>
>