22 lines
626 B
Plaintext
22 lines
626 B
Plaintext
driver = pgsql
|
|
connect = host=dbserver dbname=postfix user=postgres password=psqlpass
|
|
default_pass_scheme = MD5-CRYPT
|
|
|
|
user_query = \
|
|
SELECT \
|
|
'/var/mail/domains/%u/' as home, \
|
|
'maildir:/var/mail/domains/%u/' as mail, \
|
|
8 as uid, \
|
|
12 as gid\
|
|
FROM mailbox \
|
|
WHERE username = '%u' AND active = true
|
|
|
|
password_query = SELECT \
|
|
username AS user, \
|
|
password, \
|
|
8 as userdb_uid, \
|
|
12 as userdb_gid, \
|
|
'/var/mail/domains/' || maildir AS userdb_home, \
|
|
'/var/mail/domains/' || maildir AS userdb_mail \
|
|
FROM mailbox \
|
|
WHERE username = '%u' AND active = true |