17 lines
646 B
Plaintext
17 lines
646 B
Plaintext
|
driver = mysql
|
||
|
|
|
||
|
|
connect = host=localhost user={{.User}} password={{.Password}} dbname={{.DBName}}
|
||
|
|
|
||
|
|
default_pass_scheme = CRYPT
|
||
|
|
|
||
|
|
password_query = SELECT username as user, password as password, \
|
||
|
|
homedir AS userdb_home, maildir AS userdb_mail, \
|
||
|
|
concat('*:bytes=', quota) as userdb_quota_rule, uid AS userdb_uid, gid AS userdb_gid \
|
||
|
|
FROM mailbox \
|
||
|
|
WHERE username = '%Lu' AND active = '1' \
|
||
|
|
AND ( access_restriction = 'ALL' OR LOCATE( '%Us', access_restriction ) > 0 )
|
||
|
|
|
||
|
|
user_query = SELECT homedir AS home, maildir AS mail, \
|
||
|
|
concat('*:bytes=', quota) as quota_rule, uid, gid \
|
||
|
|
FROM mailbox WHERE username = '%u'
|