Hi,

I presume you figured this out after all this time, but in any case.

Since quota_clone is not cumulative, it always inserts new record with actual quota, to be able to get correct results in postfixadmin one must: DROP TRIGGER mergequota2 ON quota2;

And to prevent ERROR: duplicate key value violates unique constraint "quota2_pkey": CREATE FUNCTION public.clone_quota2() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN UPDATE quota2 SET bytes = NEW.bytes, messages = NEW.messages WHERE username = NEW.username; IF found THEN RETURN NULL; ELSE RETURN NEW; END IF; END; $$;

And then: CREATE TRIGGER clonequota2 BEFORE INSERT ON quota2 FOR EACH ROW EXECUTE PROCEDURE public.clone_quota2() ;

And finally just put: quota_clone_dict = proxy::sqlquota

Hope this helps somebody trying to figure out this too.

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