* 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
--
## 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/