Quota count and clone questions

[Robert Moskowitz]

all this almost reads like I can drop maintaining the quota2 table?

 From https://wiki.dovecot.org/Quota/Count

mailbox_list_index = yes
# Avoid spending excessive time waiting for the quota calculation to 
finish when
# mails' vsizes aren't already cached. If this many mails are opened, 
finish the
# quota calculation on background in indexer-worker process. Mail 
deliveries will
# be assumed to succeed, and explicit quota lookups will return internal 
error.
mail_vsize_bg_after_count = 100

seems to belong in 10-mail.conf.  That is where those var are shown.

But:


plugin {
   # 10MB quota limit
   quota = count:User quota
   quota_rule = *:storage=10M

   # This is required - it uses "virtual sizes" rather than "physical 
sizes" for quota counting:
   quota_vsizes = yes
}

I am having problems with.  Right now for quota I have:

plugin {
         quota = dict:user::proxy::sqlquota
         trash = /etc/dovecot/dovecot-trash.conf.ext
}

How do I reconcile these two?

Then for clone:  https://wiki.dovecot.org/Plugins/QuotaClone

how does:

mail_plugins = $mail_plugins quota quota_clone
plugin {
   quota_clone_dict = redis:host=127.0.0.1:port=6379
}

get replaced with something for mysql?

dovecot-sql.conf.ext:

driver = mysql
connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix 
password=$Postfix_Database_Password
default_pass_scheme = $cryptsha-CRYPT
# following should all be on one line.
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'
# following should all be on one line
user_query = SELECT concat('/home/vmail/', maildir) as home, 
concat('maildir:/home/vmail/', maildir) as mail, 101 AS uid, 12 AS gid, 
CONCAT('*:messages=30000:bytes=', quota) as quota_rule FROM mailbox 
WHERE username = '%u' AND active = '1'

and

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
}



thanks