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