> Any good pointers on where to start?
I can help with the postgresql part. Set up a director like so:
virtual_localuser:
driver = aliasfile
transport = virtual_localdelivery
# a list of domains you do email for, simular to sendmail.cw
domains = lsearch;/mail/conf/domains
search_type = pgsql
query = "select username from exim where username='$local_part' and domain='$domain'"
use a schema like this:
CREATE TABLE exim ( domain varchar(200) NOT NULL,
username varchar(50) NOT NULL,
pass_word varchar(50) NOT NULL,
encryptedpassword varchar(50) NOT NULL,
enabled char(2) NOT NULL,
accounttype char(2) NOT NULL,
destination varchar(256),
comment text);
make sure you have something like this in the main config section:
pgsql_servers = postgresql.server.here/dbusername/dbpassword
then construct a transport that does what you want.
-J
