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@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@mydomain.tld') AND active = '1'
iterate_query = SELECT username as user FROM mailbox