[Dovecot] Quota BUG - fixed

[Adrian Minta]

After some deep investigations I manage to solve the problem. I was only 
reading quota in user_querry. Now I read it in user_querry and in 
password_query and all seems fine:

--dovecot-sql.conf---

user_query = SELECT '/home/%d/%n' as home, 'maildir:/home/%d/%n' as mail, 150 AS uid, 8 AS gid, CONCAT('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1'
password_query = SELECT username as user, password, '/home/%d/%n' as userdb_home, 'maildir:/home/%d/%n' as userdb_mail, 150 as userdb_uid, 8 as userdb_gid, CONCAT('*:bytes=', quota) as userdb_quota_rule FROM mailbox WHERE username = '%u' AND active = '1'


--dovecot.conf---

plugin {
     quota = dict:user::proxy::quotadict
     quota_rule2 = Trash:storage=10%%
     quota_rule3 = SPAM:storage=10%%
}


the result is fine now:

2 getquotaroot inbox
* QUOTAROOT "INBOX" "user"
* QUOTA "user" (STORAGE 1997999 2000000)
2 OK Getquotaroot completed.


Only one "cosmetic" bug remains when an empty mailbox appear as a small 
negative number in quota2 table, but this is fixable in postfixadmin.


-- 

Best regards,
Adrian Minta    MA3173-RIPE,www.minta.ro