* 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
