<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 12 February 2019 at 20:52 Robert Moskowitz via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
On 2/12/19 1:03 PM, Aki Tuomi via dovecot wrote:
</div>
<div>
>> On 12 February 2019 at 19:55 Robert Moskowitz via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
<div>
>>
</div>
<div>
>>
</div>
<div>
>>
</div>
<div>
>>
</div>
<div>
>> On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote:
</div>
<div>
>>>> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <
<a href="mailto:dovecot@dovecot.org">dovecot@dovecot.org</a>> wrote:
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>>> Does dovecot compute that values for quota2 with each email it updates
</div>
<div>
>>>> for the user? Or only an incremental change?
</div>
<div>
>>>>
</div>
<div>
>>>> I ask because I am looking at migrating all the user mail from the old
</div>
<div>
>>>> server to the new and building a new sql database. All I see is:
</div>
<div>
>>>>
</div>
<div>
>>>> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock
</div>
<div>
>>>> dbname=postfix user=postfix password=$Postfix_Database_Password map {
</div>
<div>
>>>> pattern = priv/quota/storage table = quota2 username_field = username
</div>
<div>
>>>> value_field = bytes } map { pattern = priv/quota/messages table = quota2
</div>
<div>
>>>> username_field = username value_field = messages }
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>>> what is actually done with this table?
</div>
<div>
>>>>
</div>
<div>
>>>> thanks
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>>>
</div>
<div>
>>> dict-sql converts the mappings into SQL statements.
</div>
<div>
>> But does dovecot check out the current bytes used and # of messages and
</div>
<div>
>> resets quota2, or only uses this latest operation (add message, delete
</div>
<div>
>> message...) to adjust quota2?
</div>
<div>
>>
</div>
<div>
>> If the later how to reset quota2 to the current reality?
</div>
<div>
>>
</div>
<div>
>> thanks
</div>
<div>
>>
</div>
<blockquote type="cite">
<div>
Dovecot keeps the quota current, although dict quota has been known to be bit bad at this.
</div>
</blockquote>
<blockquote type="cite">
<div>
We nowadays recommend using count quota instead and use quota_clone to copy the quota state to database. It is more accurate.
</div>
</blockquote>
<div>
And how is this recommendation implemented?
</div>
<div>
<br>
</div>
<div>
All I have are my old notes and what google is finding for me...
</div>
<div>
<br>
</div>
<div>
Please give me some pointers.
</div>
<div>
<br>
</div>
<div>
thanks
</div>
</blockquote>
<div>
<br>
</div>
<div>
<a href="https://wiki.dovecot.org/Quota/Count">https://wiki.dovecot.org/Quota/Count</a>
<br>
</div>
<div>
<a href="https://wiki.dovecot.org/Plugins/QuotaClone">https://wiki.dovecot.org/Plugins/QuotaClone</a>
<br>
</div>
<div>
<br>
</div>
<div>
and the recommendation is under
</div>
<div>
<br>
</div>
<div>
https://wiki.dovecot.org/Quota
<br>
</div>
<div class="io-ox-signature">
---
<br>Aki Tuomi
</div>
</body>
</html>