dovecot - Mar 2007 - Driving quota out of a database.

Hi there,
    I'm using postgres as a userdb for dovecot. I'm am trying to get the
quota plugin to work.
 
I have a column in my table that returns the quota in KB. I am using the
postgres expression "('maildir:storage=' ||
mailstore_control.mailbox.quota) AS quota" as recommended in the
manuals. This expression is  NULL to start with, which I take to mean
unlimited quota.

Trouble is, if I change it to a value, and then change it back to null,
I don't seem to go back to unlimited quota.

I'm using maildir++ quotas.

What gives? :-)

David
 
Griffin Information Systems Ltd
20 St Christopher's Way,
Pride Park,
Derby
DE24 8JY 
www.griffin.com <http://www.griffin.com/>  

Registered in England and Wales. Company Registration Number: 3676297.

On Mon, 2007-03-05 at 11:52 +0000, David Craigon wrote:
> 
> Trouble is, if I change it to a value, and then change it back to
> null,
> I don't seem to go back to unlimited quota.
> 
> I'm using maildir++ quotas. 
Dovecot's maildir++ quota works by first using the quota=nn setting in
Dovecot, but if it's not given the quota limits in maildirsize file are
used.

Either delete maildirsize file, or use storage=0 instead of NULL quota
value.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20070306/6cb7efe3/attachment.bin>

Hi David,

i also could not get quota to work, i have maildirsize files in the
mboxes and set quota=maildir.

Whatever i try dovecot is not taking care of the maildirsize file, not
updating or using it.

if i understood you right, i shall try to use storage=0 and then it may
work ?

Thanks

Timo Sirainen wrote:
> On Mon, 2007-03-05 at 11:52 +0000, David Craigon wrote:
>> Trouble is, if I change it to a value, and then change it back to
>> null,
>> I don't seem to go back to unlimited quota.
>>
>> I'm using maildir++ quotas. 
> 
> Dovecot's maildir++ quota works by first using the quota=nn setting in
> Dovecot, but if it's not given the quota limits in maildirsize file are
> used.
> 
> Either delete maildirsize file, or use storage=0 instead of NULL quota
> value.
>