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
