Files
crm_ecosplay/docker/dovecot/dovecot-sql.conf

14 lines
560 B
Plaintext
Raw Permalink Normal View History

driver = pgsql
connect = host=database dbname=esymail user=app password=secret
default_pass_scheme = BLF-CRYPT
# Auth: cherche email + password dans la table mailbox
password_query = SELECT email AS user, password FROM mailbox WHERE email = '%u' AND is_active = true
# Userdb: retourne les infos de stockage mail
user_query = SELECT '/var/mail/vhosts/%d/%n' AS home, 1000 AS uid, 1000 AS gid FROM mailbox WHERE email = '%u' AND is_active = true
# Iteration pour les operations batch
iterate_query = SELECT email AS user FROM mailbox WHERE is_active = true