[Dovecot] dbox and quota question

[Robert Schetterer]

Robert Schetterer schrieb:
> 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
> 
> 
> 
  sorry my fault
concat('*:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota, \
cant work with dict, working on it
-- 
Best Regards

MfG Robert Schetterer

Germany/Munich/Bavaria