[Dovecot] quota usage

[Papp Tamás]

hi All!

Dovecot's version is 1.2.11-0~auto+0 from http://xi.rename-it.nl/debian/ .

dovecot.conf:

dict {
  quota = mysql:/data/apps/dovecot/dict-sql.conf
  #expire = db:/var/lib/dovecot/expire.db
}


/data/apps/dovecot/dict-sql.conf:

connect = host=127.0.0.1 dbname=db user=user password=pw

map {
  pattern = priv/quota/storage
  table = quota
  username_field = username
  value_field = bytes
}
map {
  pattern = priv/quota/messages
  table = quota
  username_field = username
  value_field = messages
}

The problem is that the mailbox is almost empty:
$ du -sh .
228K    .

But the quota usage show something else:

mysql> select bytes,messages from quota where username='<user>';
+-----------+----------+
| bytes     | messages |
+-----------+----------+
| 217699358 |      987 |
+-----------+----------+

What could be a problem, how can I fix this?

Thank you very much,

tamas