[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


More information about the dovecot mailing list