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,
[EMAIL PROTECTED]      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/



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

Reply via email to