Re: [Exim] virtual domains, postgres user auth, and courier …

Page principale
Supprimer ce message
Répondre à ce message
Auteur: Jason J. Horton
Date:  
À: Mark D McCoy
CC: exim-users
Sujet: Re: [Exim] virtual domains, postgres user auth, and courier imap
> 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