Re: [Dovecot] quota in SQL and static userdb

2009-11-23 Thread Timo Sirainen
On Fri, 2009-11-20 at 21:57 +0100, Lampa wrote: 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 This

Re: [Dovecot] quota in SQL and static userdb

2009-11-23 Thread Anton Dollmaier
Probably with sql dict too, but I can't remember right now how exactly. This works for us: dict { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } plugin { quota = dict:INBOX::proxy::quotadict quota2 = dict:shared:%d:ns=shared.:proxy::quotadict } in the mysql-table, username and

[Dovecot] quota in SQL and static userdb

2009-11-20 Thread Lampa
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=1 and i need override this default quota for some users) A) passdb sql(SELECT userid AS user, pw AS password, quota AS