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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 10 Dec 2014, Grant Pasley wrote:> 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 WHEREa) you have not set the quota to unlimited, you still limit to 10'000 messages. b) what does doveadm quota get -u grant at xxxxxxx.com say? Maybe your quota database is out of sync, try: doveadm quota recalc -u .... - -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQEVAwUBVIfvKnz1H7kL/d9rAQLAiAgAyl6A4HAXNWZt9D26ZJ24O58/0t1vTt85 WO8YHwZbg32NqMTVY5nU/rIo1P+5ETq/NaEYfVQ+ip+W+M7OE5SXymNGMmM82OIz ly6L71T4CZi6iPn0nWdIuO6hUgg8kIUPD4eU8CHIwjB4E1gAoKn3+BXXAa7TFhHY YJKNV7pF7Ema1iGkm7stplpM4/E8ppPeuWnof8BgYAg9vky3yxBAxi3qha40BGP4 hNePgmVUBKl/9bxRmytiUrZVIUQW3NCqwj0L5rQJ3I0BfbW0TjhwnJxUg7HaOSS/ ckO9wkVeolccq6T6b5lPGkWfOvCej8mYdPm8wu/a+/2j+kB/7Nomag==kn0X -----END PGP SIGNATURE-----
thank you steffen - did not pick that up, it was the
CONCAT('*:messages=10000:bytes=', quota)
i set it to CONCAT('*:messages=:bytes=', quota) and it now works
perfectly!
On 12/10/2014 8:58 AM, Steffen Kaiser wrote:> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Wed, 10 Dec 2014, Grant Pasley wrote:
>
>> 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
>
> a) you have not set the quota to unlimited, you still limit to 10'000
> messages.
>
> b) what does
> doveadm quota get -u grant at xxxxxxx.com
> say? Maybe your quota database is out of sync, try:
> doveadm quota recalc -u ....
>
> - -- Steffen Kaiser
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iQEVAwUBVIfvKnz1H7kL/d9rAQLAiAgAyl6A4HAXNWZt9D26ZJ24O58/0t1vTt85
> WO8YHwZbg32NqMTVY5nU/rIo1P+5ETq/NaEYfVQ+ip+W+M7OE5SXymNGMmM82OIz
> ly6L71T4CZi6iPn0nWdIuO6hUgg8kIUPD4eU8CHIwjB4E1gAoKn3+BXXAa7TFhHY
> YJKNV7pF7Ema1iGkm7stplpM4/E8ppPeuWnof8BgYAg9vky3yxBAxi3qha40BGP4
> hNePgmVUBKl/9bxRmytiUrZVIUQW3NCqwj0L5rQJ3I0BfbW0TjhwnJxUg7HaOSS/
> ckO9wkVeolccq6T6b5lPGkWfOvCej8mYdPm8wu/a+/2j+kB/7Nomag=> =kn0X
> -----END PGP SIGNATURE-----
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com