Hi.

I have an strange problem with dovecot's maildir quota and postfix.

I've tested quota and it works fine but sometimes there are users that having their Maildir/ empty, they trigger the "quota exceeded" message when someone sends email to them.

Some config / version info:

### Versions:
ii  dovecot-common      1:1.0.10-1ubuntu5.1
ii  dovecot-imapd         1:1.0.10-1ubuntu5.1
ii  dovecot-pop3d         1:1.0.10-1ubuntu5.1

### From dovecot.conf:

(...)
 # SQL database <doc/wiki/AuthDatabase.SQL.txt>
 userdb sql {
   # Path for SQL configuration file
   args = /etc/dovecot/dovecot-mysql.conf
 }

(...)

dict {
 #quota = mysql:/etc/dovecot-dict-quota.conf
}

(...)

plugin {
 quota = maildir:storage=51200
}


### dovecot-mysql.conf (splitted to be readable):
user_query = SELECT maildir, 5000 AS uid, 5000 AS gid,
   concat('maildir:storage=', floor(quota/1024)) AS quota FROM
   mailbox WHERE username = '%u' AND active = '1'


### Database "mailbox" record example:
| pru...@domain.com | Password | prueba | domain.com/prueba/ | 51200000 | domain.com | 2009-02-02 10:01:24 | 2009-02-02 10:07:46 | 1 |


The symptons: users are working nicely, and quota works (If I create a new user and set it a quota of, say, 1MB, I can send him msgs until Maildir reachs 1MB, after that I get "quota exceeded" messages). But sometimes there are users with the Maildir empty that can't receive messages and trigger the "quota exceeded" warning. Users always download messages by POP.

Removing "maildirsize" file in their folder fixes the problem. Also fixes it changing the quota to any value (maildirsize is then removed and recreated after a new message arrives for the user).

Sometime that I don't know if it's strange is that I don't see "removing" messages in the maildirsize file after user downloads messages. I mean that I can't see "-1" lines in maildirsizes:

# cat prueba/maildirsize
51200000S
0 0
615 1
1540 1
11446 1
46085 1
2623 1
21218 1
2815301 1
15110 1
21289 1
18330 1
(and so).

Any idea of what's going on? Shouldn't appear "MSGSIZE -1" lines in maildirsize file to "restore" space in Maildir after POP RETRs?

Currently I'm fixing the problem with a regular:

# find /home/vmail/vhosts -name "maildirsize"  -exec rm {} \;

But there must exist a better solution (or maybe my config is wrong).

Thanks a lot for any help.

--
Santiago Romero


Reply via email to