Quota issue with mailbox.

[Grant Pasley]

good morning,

i am experiencing an issue with a quot limits with a new install of 
dovecot with mysql integration. quotas are set to 0 (unlimited) and show 
as such in the mysql database as well as via the postfixadmin frontend.
i use imapsync to transfer mail from another imap server to this one, 
the total user mailbox size is 18gb. dovecot lda tells me mailbox is 
full even though i have set mailbox to unlimited.

*the the error is:*  Dec  9 19:17:01 sentinel dovecot: 
lda(grant at xxxxxxx.com): 
msgid=<e8b2c897c11cafda2c2ab93a92beb681 at localhost.localdomain>: 
rejected: Quota exceeded (mailbox for user is full)

*[root at sentinel dovecot]# grep -v '^ *\(#.*\)\?$' dovecot-mysql.conf*
driver = mysql
connect = host=localhost dbname=postfix user=postfix password=xxxxxxxx
default_pass_scheme = MD5-CRYPT
password_query = SELECT username as user, password, 
concat('/home/vmail/', maildir) as userdb_home, 
concat('maildir:/home/vmail/', maildir) as userdb_mail, 101 as 
userdb_uid, 12 as userdb_gid FROM mailbox WHERE username = '%u' AND 
active = '1'
user_query = SELECT concat('/home/vmail/', maildir) as home, 
concat('maildir:/home/vmail/', maildir) as mail, 101 AS uid, 12 AS gid, 
CONCAT('*:messages=10000:bytes=', quota) as quota_rule FROM mailbox 
WHERE username = '%u' AND active = '1'


*[root at sentinel dovecot]# dovecot -n*
*# 2.0.9: /etc/dovecot/dovecot.conf*
*# OS: Linux 2.6.32-504.1.3.el6.x86_64 x86_64 CentOS release 6.6 (Final) 
ext4*
auth_mechanisms = plain login
dict {
   quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf
}
first_valid_gid = 12
first_valid_uid = 101
lda_mailbox_autocreate = yes
lda_mailbox_autosubscribe = yes
lmtp_save_to_detail_mailbox = yes
mail_location = maildir:/home/vmail/%d/%n
managesieve_notify_capability = mailto
managesieve_sieve_capability = fileinto reject envelope 
encoded-character vacation subaddress comparator-i;ascii-numeric 
relational regex imap4flags copy include variables body enotify 
environment mailbox date
passdb {
   args = /etc/dovecot/dovecot-mysql.conf
   driver = sql
}
plugin {
   acl = vfile:/etc/dovecot/acls
   quota = dict:user::proxy::quotadict
   sieve = ~/dovecot.sieve
   sieve_before = /home/sieve/globalfilter.sieve
   sieve_dir = ~/sieve
   sieve_max_script_size = 1M
   trash = /etc/dovecot/trash.conf
}
protocols = imap pop3 lmtp sieve
service auth {
   unix_listener /var/spool/postfix/private/auth {
     group = postfix
     mode = 0666
     user = postfix
   }
   unix_listener auth-userdb {
     group = mail
     mode = 0666
     user = vmail
   }
}
service dict {
   unix_listener dict {
     group = mail
     mode = 0666
     user = vmail
   }
}
service imap-login {
   inet_listener imap {
     port = 143
   }
   inet_listener imaps {
     port = 993
     ssl = yes
   }
}
service imap {
   vsz_limit = 256 M
}
service managesieve-login {
   inet_listener sieve {
     port = 4190
   }
   process_min_avail = 0
   service_count = 1
   vsz_limit = 64 M
}
service pop3-login {
   inet_listener pop3 {
     port = 110
   }
   inet_listener pop3s {
     port = 995
     ssl = yes
   }
}
ssl_cert = </etc/pki/tls/certs/xxxxxxxxxxxxxxxx.crt
ssl_key = </etc/pki/tls/private/xxxxxxxxxxxxxxxxx.key
userdb {
   driver = prefetch
}
userdb {
   args = /etc/dovecot/dovecot-mysql.conf
   driver = sql
}
protocol lda {
   mail_plugins = quota sieve
   postmaster_address = postmaster at xxxxxxxxxxxxxx
}
protocol imap {
   imap_client_workarounds = delay-newmail
   mail_plugins = quota imap_quota trash
}
protocol lmtp {
   mail_plugins = sieve
}
protocol pop3 {
   mail_plugins = quota
   pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}
protocol sieve {
   managesieve_implementation_string = Dovecot Pigeonhole
   managesieve_max_compile_errors = 5
   managesieve_max_line_length = 65536
}





---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com