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.
> --
> <fanf@???> <dot@???> 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/
>