Re: [exim] mysql expansion

Top Page
Delete this message
Reply to this message
Author: #Ronan McGlue
Date:  
CC: exim-users
Subject: Re: [exim] mysql expansion
Mike Cardwell wrote:
> * on the Mon, Feb 26, 2007 at 03:50:03PM +0000, #Ronan McGlue wrote:
>
>> bash3.1 #exim -bt r.mcglue@???
>> r.mcglue@??? cannot be resolved at this time: failed to expand
>> "${lookup mysql{select concat(mailbox,'@',host) from routing where alias
>> = '${quote_mysql:$local_part}'}}": lookup of "select
>> concat(mailbox,'@',host) from routing where alias = 'r.mcglue'" gave
>> DEFER: incomplete MySQL server data: sXT
>> [root@rhexim ~]#
>>
>> whereas
>>
>>
>> mysql> select concat(mailbox,'@',host) from routing where alias = 
>> 'r.mcglue';
>> +-----------------------------+
>> | concat(mailbox,'@',host)    |
>> +-----------------------------+
>> | rmcglue@???       |
>> +-----------------------------+
>> 1 row in set (0.00 sec)

>
> I'm not familiar with this error message. I could be barking up the
> wrong tree here, but is exim successfully performing any other mysql
> queries at the moment? What happens if you do this:
>
> mike@rabies:~$ /usr/sbin/exim -be
>> ${lookup mysql{SELECT "foo"}}
> foo
>
> Mike
>

The username and password combination was the issue. I used myphpadmin
to generate a pass which ended :sXT :D

I've tried escaping the colon, wrapping the pass in single and double
quotes, but still i get the same error.

how do i encapsulate the : in the password?

Ronan



--
Regards

Ronan McGlue

===================
Analyst / Programmer
Queens University Belfast