Timo Sirainen schrieb:
On Sat, 2008-07-12 at 17:07 +0200, Robert Schetterer wrote:
sorry i read dict stuff and i dont understand it i have no idea to make this work out of the wiki .. ok i allready have my quota tables from postfix admin and i am unclear about the query i need as well how to set this in plugin quota section in dovecot.conf
i have this quota userdb sql working with maildir ..
So looks like you don't have to worry about setting quota limits, since you can use the exact same configuration. The only thing you need to change is where you currently have:
plugin { .. quota = maildir }
You'll have to change it to :
plugin { .. quota = dict:::proxy::quotadict }
And then add:
dict { quotadict = mysql:/etc/dovecot-dict-quota.conf }
And create the quota dovecot-dict-quota.conf file as specified in the wiki page and create the quota SQL table as specified by the wiki. The quota SQL table contains the users' current quota values, not the limits.
worked as you stated ( no problem in the logs, stuff in new quota tables semms right ) but quota isnt announced to clients ( horde, thunderbird )
concat('*:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota, \
in the sql statement at dovecot-sql.conf didnt help
quota reported to clients store and change them in postfixadmin sql is desired
-- Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria