3 messages in net.sourceforge.lists.courier-maildrop[maildropl] Quota problem with maildr...
FromSent OnAttachments
Rolan YangSep 8, 2002 10:01 am 
Deim AgostonSep 9, 2002 3:41 pm 
Rolan YangSep 10, 2002 6:24 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:[maildropl] Quota problem with maildrop/mysql/maildir/virtual usersActions...
From:Rolan Yang (rol@omnistep.com)
Date:Sep 8, 2002 10:01:40 am
List:net.sourceforge.lists.courier-maildrop

I'm currently using Postfix/Maildrop/MySQL for delivery to maildirs. The users are all virtual (no one has a real account on the system).

I've noticed that quotas will only work properly when the "maildirsize" file is present within the maildir directory (created during "maildirmake -q"), and only operating with the quota specified in that file. The quota field in my mysql database seems to be completely ignored. Is it used at all?

I see in "/etc/maildrop/maildropmysql.cf" there is an option:

# QUOTA_FIELD - MySQL attribute which contains the users quota quota_field quota

and I've checked my mysql logs - maildrop does query and request for the quota field.

Playing around, I set a 1MB quota in the "maildirsize" file, while setting 2MB in the mysql table. Then I sent a 1.2MB file to the email box - resulting in a "over quota error"

Then I removed the maildirsize file, and was able to send an unlimited amount of data (way over the 2MB limit set in the mysql database) to the inbox without going over quota.

I think it would be ideal if maildrop was able to automatically create/update the "maildirsize" file if it did not exist already. That would come in quite handy. However, maildrop (and any other app that was associated with maildir quotas) would have to update the quota field in the first line of "maildirsize" accordingly, keeping in synch with the "quota" field of the database - should that ever change.

~Rolan rol@techfreakz.org