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
>
>
>
>
>
>
>
>