Actually, the query is returning 0 rows, empty string.. (I tried it
manually in a SQL interpreter)
Thats why I'm confused... Its not returning host.from.db anywhere
(which is what it should be doing if the row existed)
Oh well, in a bit I'll run a script to add the missing rows to my DB
and then see if my problem goes away, still confusing tho.
-jwb
On Oct 19, 2005, at 11:29 AM, Philip Hazel wrote:
> On Wed, 19 Oct 2005, Tony Finch wrote:
>
>
>> On Wed, 19 Oct 2005, James W. Brinkerhoff wrote:
>>
>>
>>> I have an issue with a manualroute router. This router (below)
>>> uses a mysql
>>> lookup to return the host to route to. It works 99% of the
>>> time, however
>>> sometimes and seemingly with messages containing multiple
>>> recipients, I get
>>> the following error for 1 of the recipients:
>>>
>>> 2005-10-19 13:14:37 1ESDm9-0006Nr-KQ Error in to_mailbox router:
>>> unknown
>>> routing option or transport name "host.from.db"
>>>
>>> host.from.db is exactly what SHOULD be returned from the lookup,
>>> and is the
>>> same value returned for the other recipients that were delivered
>>> properly.
>>>
>>
>> run it in debugging mode and check the result of the mysql query
>>
>
> The query is returning something followed by white space, before
> "host.from.db", which is therefore being interpreted as an option or
> transport name.
>
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
> Get the Exim 4 book: http://www.uit.co.uk/exim-book
>
> --
> ## 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/
>
