[Dovecot] trash plugin sql

Robert Schetterer robert at schetterer.org
Wed Feb 14 00:28:26 UTC 2007


Marshal Newrock schrieb:
> On Wed, 14 Feb 2007 00:21:43 +0100
> Robert Schetterer <robert at schetterer.org> wrote:
> 
>>> Your quota definition looks incomplete.  I assume the quota is
>>> defined in your user query.  What's the output if you run that
>>> query in mysql? Also, what is the current quota usage, and how big
>>> are each of the mailboxes?
>>>
>> Hi Marshal, i didnt found any other info
>> about quota/lda/sql
>>
>> there is a thread
>> http://www.dovecot.org/list/dovecot/2006-December/018141.html
>> i tried
>>  to add ':ignore=Trash'
>> to user sql query
>> this results in
>>
>> quota=dirsize:storage=50000:ignore=Trash
>>
>> but tis dont work too
>> ( as i understand the thread it cannot work this way )
>>
>>
>> from wiki it should work only
>> with
>>
>> plugin {
>> quota = maildir
>> acl = vfile:/etc/dovecot/acls
>> trash = /etc/dovecot/dovecot-trash.conf
>>
>> after all i tried many combinations , none had worked
> 
> From http://wiki.dovecot.org/Quota: "The above example shows how to set
> the same quota globally for everyone. You can override this for one or
> all users by returning a quota field from the user database."
> 
> http://wiki.dovecot.org/DovecotLDAPostfixAdminMySQL has the following
> config sample:
> plugin {
>   quota = maildir:storage=10240:messages=1000
>   acl = vfile:/etc/dovecot/acls
>   trash = /etc/dovecot/trash.conf
> }
> 
> I doubt "quota = maildir" will work, since it doesn't define any
> defaults.  You also said that your quotas are defined in the database,
> so I'm assuming that it's part of your user query.
> 
> The query result you have above indicates that the quota is about 50MB,
> and that it should ignore the Trash folder.  What is the current disk
> usage of everything except the Trash folder?
> 
Hi Marshall , that was just a example grep from log
i filled up a smaller mailbox , and checked if trash worked
playing with user query leads not to better results
variations of quota like
quota = maildir:storage=10240:messages=1000
didnt work too, cause this value is simply overide by sql
as this is written so in the faqs and tested to work so
-- 
Mit freundlichen Gruessen
Best Regards

Robert Schetterer

https://www.schetterer.org
Munich/Bavaria/Germany



More information about the dovecot mailing list