[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