Re: [Exim] Creating domainlist with SQL select

Top Page
Delete this message
Reply to this message
Author: Rossz Vamos-Wentworth
Date:  
To: exim-users
Subject: Re: [Exim] Creating domainlist with SQL select
> I recently found out that:
>
> domainlist virtual_domains      = ${lookup mysql{SELECT DISTINCT host FROM
> users}}


You should read the emails from the last two days as this was covered. However,
I'll give you the highlights:

VIRTUAL_DOMAINS = SELECT DISTINCT concat(domain, ' : ') from users;
domainlist local_domains = localhost : ${lookup mysql{VIRTUAL_DOMAINS}}

Adjust to match your particular needs. I'm using lines even though all my domains
are virtual.

Rossz