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([email protected]):
msgid=<[email protected]>:
rejected: Quota exceeded (mailbox for user is full)
*[root@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@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@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
