On Wed, 20 Sep 2000, Andrew Chant wrote:
> Can anyone see any reason as to why the following router would not work.
>
> virtual_router:
> driver = domainlist
> route_list = mysql;SQL_LOCAL_DOMAIN
> transport = virtual_delivery
>
> SQL_LOCAL_DOMAIN = SELECT DISTINCT MYSQL_DOMAINFIELD FROM MYSQL_AUTHTABLE
> WHERE MYSQL_DOMAINFIELD LIKE '$key'
>
> I have probably missed something fundamental.
Yes. :-) Syntax problem. You have used "host list" syntax in a driver.
Try
virtual_router:
driver = domainlist
route_query = SQL_LOCAL_DOMAIN
search_type = mysql
transport = virtual_delivery
SQL_LOCAL_DOMAIN = SELECT DISTINCT MYSQL_DOMAINFIELD FROM MYSQL_AUTHTABLE \
WHERE MYSQL_DOMAINFIELD LIKE '$domain'
--
Philip Hazel University of Cambridge Computing Service,
ph10@??? Cambridge, England. Phone: +44 1223 334714.
