[Dovecot] quota in SQL and static userdb
Lampa
lampacz at gmail.com
Fri Nov 20 22:57:50 EET 2009
Hello,
which solution will be working or will be working better
(performance). Using dovecot 1.2.6 (plugin section contains quota_rule
= *:storage=500M:messages=10000 and i need override this default quota
for some users)
A) passdb sql(SELECT userid AS user, pw AS password, quota AS
userdb_quota_rule FROM users WHERE userid = '%u') + userdb static
(uid=500 gid=500 home=/home/mail/%d/%n allow_all_users=yes) - using
extra fields quota with no prefetch userdb
or
B) passdb sql(SELECT userid AS user, pw AS password, quota AS
userdb_quota_rule, CONCAT('/home/mail/', domain, '/', user) AS
userdb_home, 500 AS userdb_uid, 500 AS userdb_gid FROM users WHERE
userid = '%u') + prefetch (eg same sql file)
Solution for LDA only(postfix local delivery) and for another
IMAP/POP3 dovecot instance?
And how to implement domain quotas (something like user quotas using dict) ?
Thank you.
--
Lampa
More information about the dovecot
mailing list