Marshal Newrock schrieb:

On Tue, 13 Feb 2007 23:54:56 +0100 Robert Schetterer robert@schetterer.org wrote:

...

Hi @ll, with dovecot latest

following http://wiki.dovecot.org/DovecotLDAPostfixAdminMySQL

i have defined

plugin { quota = maildir acl = vfile:/etc/dovecot/acls trash = /etc/dovecot/dovecot-trash.conf }

Example dovecot-trash.conf file

1 Spam 2 Trash 3 Sent

from wiki

The Trash plugin. When saving a message would make user go over quota, this plugin automatically deletes the oldest mails from configured mailboxes until the message can be saved within quota limits.

this dont work at my setup

where quota is coming out of sql

is there any trick to solve this? or did i missunderstand something

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

-- Mit freundlichen Gruessen Best Regards

Robert Schetterer

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

Marshal Newrock schrieb:

On Wed, 14 Feb 2007 00:21:43 +0100 Robert Schetterer robert@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

Timo Sirainen schrieb:

On Tue, 2007-02-13 at 23:54 +0100, Robert Schetterer wrote:

...

The Trash plugin. When saving a message would make user go over quota, this plugin automatically deletes the oldest mails from configured mailboxes until the message can be saved within quota limits.

this dont work at my setup

Well, looks like it didn't work for the same message saving, but only for the next one. Fixed: http://dovecot.org/list/dovecot-cvs/2007-February/007736.html

Hi Timo, thx for fixing this , i will give it a try on my test server when you get the next version release i which, i hope, you will include the fix

-- Mit freundlichen Gruessen Best Regards

Robert Schetterer

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