Does dovecot compute that values for quota2 with each email it updates
for the user?? Or only an incremental change?
I ask because I am looking at migrating all the user mail from the old
server to the new and building a new sql database.? All I see is:
dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock
dbname=postfix user=postfix password=$Postfix_Database_Password map {
pattern = priv/quota/storage table = quota2 username_field = username
value_field = bytes } map { pattern = priv/quota/messages table = quota2
username_field = username value_field = messages }
what is actually done with this table?
thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20190212/7689b09c/attachment.html>
> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: > > > Does dovecot compute that values for quota2 with each email it updates > for the user?? Or only an incremental change? > > I ask because I am looking at migrating all the user mail from the old > server to the new and building a new sql database.? All I see is: > > dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock > dbname=postfix user=postfix password=$Postfix_Database_Password map { > pattern = priv/quota/storage table = quota2 username_field = username > value_field = bytes } map { pattern = priv/quota/messages table = quota2 > username_field = username value_field = messages } > > > what is actually done with this table? > > thanks > > > > >dict-sql converts the mappings into SQL statements. Aki
On 2/12/19 12:38 PM, Aki Tuomi via dovecot wrote:>> On 12 February 2019 at 18:23 Robert Moskowitz via dovecot <dovecot at dovecot.org> wrote: >> >> >> Does dovecot compute that values for quota2 with each email it updates >> for the user?? Or only an incremental change? >> >> I ask because I am looking at migrating all the user mail from the old >> server to the new and building a new sql database.? All I see is: >> >> dovecot-dict-sql.conf.ext: connect = host=/var/lib/mysql/mysql.sock >> dbname=postfix user=postfix password=$Postfix_Database_Password map { >> pattern = priv/quota/storage table = quota2 username_field = username >> value_field = bytes } map { pattern = priv/quota/messages table = quota2 >> username_field = username value_field = messages } >> >> >> what is actually done with this table? >> >> thanks >> >> >> >> >> > dict-sql converts the mappings into SQL statements.But does dovecot check out the current bytes used and # of messages and resets quota2, or only uses this latest operation (add message, delete message...) to adjust quota2? If the later how to reset quota2 to the current reality? thanks