Re: [exim] More routing

Pàgina inicial
Delete this message
Reply to this message
Autor: Tony Finch
Data:  
A: John Oxley
CC: exim-users
Assumpte: Re: [exim] More routing
On Tue, 12 Apr 2005, John Oxley wrote:

> On Tue, Apr 12, 2005 at 11:21:02AM +0100, Tony Finch wrote:
> > On Tue, 12 Apr 2005, John Oxley wrote:
> > >
> > > I have a routers.conf with about 150 entries similar to:
> > > hub_route_foo:
> > >     driver = manualroute
> > >     transport = remote_smtp
> > >     route_list = foo.com 1.2.3.4

> > >
> > > I have a mysql table with foo.com and 1.2.3.4 in it.
> >
> > Use one router like the above, but replace the route_list setting with a
> > route_data setting which performs a MySQL query using $domain as a key.
>
> You mean
>    route_list = {$lookup mysql{select domain,ip from domains}}


No. There are several mistakes there.

route_data = ${lookup mysql {select ip from domains where domain = $domain} }

(though I might have screwed up the SQL)

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