[Dovecot] Quotas not recalculating

[Kyle Brantley]

On 9/6/2011 2:17 PM, Tobias Hachmer wrote:
> On Tue, 6 Sep 2011 23:08:37 +0300, Timo Sirainen wrote:
>> On 6.9.2011, at 23.01, Tobias Hachmer wrote:
>>
>>> On Mon, 5 Sep 2011 08:39:39 +0300, Timo Sirainen wrote:
>>>> On 5.9.2011, at 4.28, Kyle Brantley wrote:
>>>>
>>>>> Okay, something else isn't cooperating with this at all. I 
>>>>> reconfigured it to use dirsize just to test (quota = dirsize:User 
>>>>> quota in 90-quota.conf instead of quota = maildir:User quota), and 
>>>>> it is still trying to use maildir quotas:
>>>>
>>>> Your user_query in dovecot-sql.conf overrides the quota setting.
>>>
>>> Same problem here.
>>> But how can I use maildirsize quota && user_query in dovecot-slq.conf ?
>>>
>>> I want to manage my users in a sql table and use maildirsize quota.
>>
>> There's nothing special in that. Just about all the examples in wiki
>> assume you want to do that.
>> http://wiki2.dovecot.org/Quota/Configuration#Per-user_quota
>
> OK, thanks. Removing "CONCAT('*:bytes=', CAST(quota AS CHAR)) AS  
> userdb_quota_rule" from user_query as well as from password_query in 
> dovecot-sql.conf worked for me.
>
> Greetz, Tobias

I was migrating from 1.x to 2.x and manually rebuilt everything with 
respect to the configs... except for my queries. In my case, luckily, it 
was as easy as changing the column returned from "quota" to "quota_rule" 
and replacing the "maildir:storage=" with "*:storage=."

Thanks for the help, all.

--Kyle