dovecot - Apr 2020 - replication newbie: some beginner questions

Am 17.04.20 um 03:37 schrieb @lbutlr:
> On 15 Apr 2020, at 07:50, Stefan G. Weichinger <lists at xunil.at>
> wrote:
>> So I think about how to get the mailboxes from A to B.
>> 
>> We use one UID afaik:
>> 
>> mail_home = /home/vmail/%d/%u mail_location = maildir:~
>> 
>> I read about dsync and wonder:
>> 
>> * does it make sense in this case to set up replication and let
>> the servers replicate at first while still running on the old
>> server?
> 
> I ave done this (dovevot mailers under a email user) and I simply
> used rsync to copy the mail to the new machine.
> 
> Once I had synced, I then synced again, shutdown the mail server,
> synced on last time, and started the mail server on the new hardware.
> The last sync only had to catch up a few emails, so all told I was
> down for a shorter time than a simple reboot.
> 
> That said, doing it via replication would have been ?better? but in
> my case wasn?t worth the time it would have taken to setup, test,
> test, backup all the mail an extra time anyway, and then implement.
thanks for that feedback

Today I will setup the new server and try to enable replication.

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.

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

Am 22.04.20 um 09:41 schrieb Stefan G. Weichinger:
> iterate_query = SELECT username as user FROM mailbox
Ok, we enabled the 2 users and they synced (after a restart of one
dovecot, btw).

What irritates me:

on the new server I find less files in /home/vmail than on the old server.

So something is skipped or so.

I try to compare now ..