Re: [exim] Exim 3.36, mySQL and route_list

Top Page
Delete this message
Reply to this message
Author: Adrian Zaugg
Date:  
To: exim-users
Subject: Re: [exim] Exim 3.36, mySQL and route_list
Hi Rob

Rob Stead wrote:

>    route_list = * ${lookup mysql {MYSQL_SMARTHOST}{$value}fail} bydns_a

>
> MYSQL_SMARTHOST represents a SQL statement that returns the smarthost for
> the domain in question.

Does it work, when you do not use MYSQL_SMARTHOST and fill in your
actual SQL Query code?

...or you can try a structure like:

sql_routes:
driver = domainlist
transport = remote_smtp
search_type = mysql
query = select route from ...

The query should return a host list and routing options like the
arguments of route_list are. For details, please see the exim-doc:
http://ente.limmat.ch/doc/exim/manual.html/spec_28.html#IDX1591
...I personally do not use sql with exim and thus do not know how to do
it exactly.

Regards, Adrian.