replication newbie: some beginner questions

[Stefan G. Weichinger]

Am 21.04.20 um 11:49 schrieb Stefan G. Weichinger:

> I will connect both dovecots to the same instance of mariadb which
> should let them know about all the existing mailboxes ... and then I
> will see.
> 
> My question around the sieve-scripts is still open ... I assume I will
> maybe try to replicate a sub-set of the mailboxes, check things ... and
> then decide how to proceed.

So far it works great, only two mailboxes marked inactive via
postfixadmin are skipped at sync.

Do I have to enable them to get them synced as well?

My queries:

user_query = SELECT '/home/vmail/%d/%u' as home,
'maildir:/home/vmail/%d/%u' as mail, 5000 AS uid, 5000 AS gid,
concat('dirsize:storage=',  quota) AS quota FROM mailbox WHERE (username
= '%u' OR username = '%u at mydomain.tld') AND active = '1'

password_query = SELECT username as user, password, '/home/vmail/%d/%u'
as userdb_home, 'maildir:/home/vmail/%d/%u' as userdb_mail, 5000 as
userdb_uid, 5000 as userdb_gid FROM mailbox WHERE (username = '%u' OR
username = '%u at mydomain.tld') AND active = '1'

iterate_query = SELECT username as user FROM mailbox