[Exim] Basic Exim+SQL

Top Page
Delete this message
Reply to this message
Author: Steve Sherwood
Date:  
To: exim-users
Subject: [Exim] Basic Exim+SQL
Just getting into Exim+SQL. I've scanned the web + mailing lists and
what I seem to be doing is correct.

hide mysql_servers = localhost/db/user/pass
domainlist local_domains = @:localhost:mydomain.com:mydomain2.com

The config file works perfectly with this... (xyz@???) is
delivered locally.

If I swap it to say

domainlist local_domains = @:localhost:${lookup mysql{SELECT domain FROM
local_domains}}

mysql> select * from local_domains;
+-----------------------------+
| domain                      |

+-----------------------------+
| mydomain.com                |
| mydomain2.com               |

+-----------------------------+

It stops working. By running a status on the MySQL database, I can see
that a query has happened but it doesn't recognize mydomain.com as being
local any more.

Anyone has any ideas why this doesn't work?

TIA
Steve
--
Sherwood Technologies Ltd
URL : www.sherwood-tech.co.uk
Email: steve@???
Phone: (01635) 49088