Quota count and clone questions

[Robert Moskowitz]

I figured out that I can't just drop maintaining quota2 if I want 
postfixadmin to report the quota status.

I also figured out a way to run a test on my config guesses.  I will try 
to fit it in today, or tomorrow.  But any advise to the questions below 
are welcomed!

On 2/13/19 8:53 PM, Robert Moskowitz via dovecot wrote:
> 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
>
>
>
>
>
>
>
>