Author: Chris Knipe Date: To: exim-users Subject: [Exim] mysql localdomains?
Hi,
Any reason why
local_domains=localhost:mysql;SELECT domain FROM domains WHERE active='1';
or
local_domains="localhost:mysql;SELECT domain FROM domains WHERE
active='1';"
Wont work?
The exact same statement seems to work 100% as a virtual domain transport
thingy, but I can't seem to get it to accept the returns from mysql as a
list of local_domains?
Here's the virual domain director:
----------------------------------
virtual:
driver = aliasfile
domains = "mysql;SELECT domain FROM domains WHERE active='1'"
no_more
file = /etc/exim/domains/$domain
search_type = lsearch*@
The debug info:
---------------
internal_search_find: file="NULL"
type=mysql key="SELECT domain FROM domains WHERE active='1'"
database lookup required for SELECT domain FROM domains WHERE active='1'
MYSQL query: SELECT domain FROM domains WHERE active='1'
MYSQL new connection: host=localhost port=0 database=vardus user=xxxx
password=xxxx
lookup yielded: 14ct.com
18ct-gold.co.uk
18ct-gold.com
24ct-gold.co.uk
.... <- About 50 domains cut out (900+ in the DB)
authority.net
avendalegr
**** debug string overflowed buffer ****
test.com in local_domains? yes (matched mysql;SELECT domain FROM domains
WHERE active='1')
test.com in percent_hack_domains? no (end of list)
address test@???
local_part=test domain=test.com
domain is local >>>>>>>>>>>>>>>>>>>>>>>> directing test@???
My results:
-----------
mysql> SELECT * FROM domains WHERE domain='test.com';
Empty set (0.02 sec)