Mike Cardwell wrote:
> * on the Mon, Feb 26, 2007 at 03:50:03PM +0000, #Ronan McGlue wrote:
>
>> bash3.1 #exim -bt [EMAIL PROTECTED]
>> [EMAIL PROTECTED] 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
>> [EMAIL PROTECTED] ~]#
>>
>> whereas
>>
>>
>> mysql> select concat(mailbox,'@',host) from routing where alias =
>> 'r.mcglue';
>> +-----------------------------+
>> | concat(mailbox,'@',host) |
>> +-----------------------------+
>> | [EMAIL PROTECTED] |
>> +-----------------------------+
>> 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:
>
> [EMAIL PROTECTED]:~$ /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
--
## List details at http://www.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://www.exim.org/eximwiki/
