2024-05-18 13:18:39 +02:00

8 lines
396 B
Plaintext

driver = pgsql
connect = host=db.lxc.br0tkasten.de dbname=users user=mail
default_pass_scheme = PLAIN-MD5
#user_query = SELECT home, uid, gid FROM users WHERE userid = '%n'
user_query = SELECT r.home, r.uid, r.gid FROM users r, users v WHERE v.userid = '%n' AND v.realuser = r.userid
password_query = SELECT realuser as user, '{PLAIN-MD5}' || password as password FROM users WHERE userid = '%n'