[Exim] mysql localdomains?

Góra strony
Delete this message
Reply to this message
Autor: Chris Knipe
Data:  
Dla: exim-users
Temat: [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)

mysql>

Any help appreciated :)

--

Regards
Chris Knipe