Quota & prefetch uiserDB questions
Cédric ML
cedric.bassaget.ml at gmail.com
Wed Oct 12 06:53:42 UTC 2016
Hello,
I'm trying to make quota work on my dovecot server.
I'm using prefetch userdb (source :
http://wiki2.dovecot.org/UserDatabase/Prefetch) with a database located
on a remote host :
passdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf.ext
}
userdb {
driver = prefetch
}
userdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf.ext
}
With password_query containing (source :
http://wiki2.dovecot.org/Quota/Configuration) :
password_query = SELECT \
username AS user, \
password, \
homedir AS userdb_home, \
maildir AS userdb_mail, \
uid AS userdb_uid, \
gid AS userdb_gid, \
CONCAT('*:bytes=', quota) AS userdb_quota_rule \
FROM mailbox \
WHERE username = '%u'
When I change the quota value in DB, it's not reflected to maildirsize
file of the user.
If I delete maildirsize file, it's re-created but not with the quota
value which is set in the DB.
Questions : how is this maildirsize file created ? how is it updated ?
is there a way to make maildir++ quota work with dovecot using prefetch
userDB ? Or do I have to use dict quotas ?
Many thanks for your help.
Regards,
Cédric
More information about the dovecot
mailing list