Ok... It appears i have some consistency issues in my DB that are causing SOME of the route_data queries to fail..

What boggles the mind tho is if the query failed, how does the error contain the value that the query SHOULD have returned...

-jwb

On Oct 19, 2005, at 10:33 AM, 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

Tony.
--
<[EMAIL PROTECTED]>   <[EMAIL PROTECTED]>   http://dotat.at/   ${sg{\N${sg{\
N\}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}\
\N}{([^N]*)(.)(.)(.*)}{\$1\$3\$2\$1\$3\n\$2\$3\$4\$3\n\$3\$2\$4}}

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