View Single Post
  #3  
Old 30th April 2012, 15:45
ftkyiu ftkyiu is offline
Junior Member
 
Join Date: Apr 2012
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default

till, Thanks, but the quota is not recalculated by sending mail or logging in as i have tried this again to no avail, even though as my example demonstrates i already tried it.

I have found the following: http://dovecot.org/list/dovecot/2012...ry/063777.html
which states:
With v2.x you can simply do: doveadm quota recalc -u username
With v1.x you can delete the user's quota row from sql.

I have v1.x (dovecot --version). Now i have checked phpmyadmin and i have no db for dovecot. Only for ispconfig and some other stuff.
The config file /etc/dovecot.conf (generated by ispconfig) says:
Code:
plugin {
quota = dict:user::file:/var/vmail/%d/%n/.quotausage
sieve=/var/vmail/%d/%n/.sieve
}
auth default {
...
  passdb sql {
    # Path for SQL configuration file
    args = /etc/dovecot/dovecot-sql.conf
  }
}
Yet sql.conf leads me to the ispconfig database:
Code:
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
How would i go about deleting said row from sql because i cant find anything in ispconfigs database having anything remotely to do with used quota space?

P.S. it seems that dovect only updates used quota space when
1) a user that is NOT logged in recieves an email.
and only increases it, deleting email doesn't decrease the used quota space. (Yes, it's not in the .Trash, fully expunged).

P.P.S. FIxed!
1) delete /var/vmail/domain.tld/user/Maildir/.quotausage
2) login via imap
3) logout
4) update ispconfig
5) in about 30 minutes or less the quota usage will update.

Last edited by ftkyiu; 30th April 2012 at 20:15.
Reply With Quote