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