Quota issue with mailbox.

[Grant Pasley]

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