I seem to have got replication working from an older instance to a newer one (insofar as the data are present on the new box) that I’m looking to stand up to replace a newer box. In this case, nothing is configured to talk to the new machine yet, so the replication is unidirectional (old -> new).
However, I’m seeing an error like like this repeatedly in syslog:
2022-05-21T23:23:15.295252+00:00 basement-imap01 dovecot: doveadm(hile@coyhile.com): Error: sync: User has no mail_replica in userdb
What setting did I miss?
kdoveconf -n # 2.3.7.2 (3c910f64b): /etc/dovecot/dovecot.conf # Pigeonhole version 0.5.7.2 () # OS: Linux 5.4.0-110-generic x86_64 Ubuntu 20.04.4 LTS # Hostname: basement-imap01.coyhile.com doveadm_password = # hidden, use -P to show it mail_location = maildir:~/Maildir mail_privileged_group = mail namespace inbox { inbox = yes location = mailbox Drafts { special_use = \Drafts } mailbox Junk { special_use = \Junk } mailbox Sent { special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-ldap.conf.ext driver = ldap } protocols = " imap lmtp" service aggregator { fifo_listener replication-notify-fifo { mode = 0666 user = vmail } unix_listener replication-notify { mode = 0666 user = vmail } } service doveadm { inet_listener { port = 12345 } user = vmail } service replicator { unix_listener replicator-doveadm { mode = 0666 } } ssl_cert =
Is that error something that I can (for the moment) ignore since I’m explicitly NOT trying to have this host replicate data anywhere, or do I need to tweak something?
-- Coy Hile coy.hile@coyhile.com
On 22/05/2022 02:32 Coy Hile coy.hile@coyhile.com wrote:
I seem to have got replication working from an older instance to a newer one (insofar as the data are present on the new box) that I’m looking to stand up to replace a newer box. In this case, nothing is configured to talk to the new machine yet, so the replication is unidirectional (old -> new).
However, I’m seeing an error like like this repeatedly in syslog:
2022-05-21T23:23:15.295252+00:00 basement-imap01 dovecot: doveadm(hile@coyhile.com): Error: sync: User has no mail_replica in userdb
What setting did I miss?
plugin { mail_replica = <value here> }
https://doc.dovecot.org/settings/plugin/replication-plugin/
Aki
On May 23, 2022, at 3:20 AM, Aki Tuomi aki.tuomi@open-xchange.com wrote:
On 22/05/2022 02:32 Coy Hile coy.hile@coyhile.com wrote:
I seem to have got replication working from an older instance to a newer one (insofar as the data are present on the new box) that I’m looking to stand up to replace a newer box. In this case, nothing is configured to talk to the new machine yet, so the replication is unidirectional (old -> new).
However, I’m seeing an error like like this repeatedly in syslog:
2022-05-21T23:23:15.295252+00:00 basement-imap01 dovecot: doveadm(hile@coyhile.com): Error: sync: User has no mail_replica in userdb
What setting did I miss?
plugin { mail_replica = <value here> }
https://doc.dovecot.org/settings/plugin/replication-plugin/
Aki
The way I read that, it configures a location to where a machine will replicate data. At present, I’m trying to turn up the new box slowly (haven’t yet configured LDA or appropriate TLS settings, for example), so my intent was that this host not replicate any of its data anywhere, yet. Eventually, I’ll have data moving hostA <—> hostB bidirectionally.
Is the phased approach I was trying to take not something supported?
-- Coy Hile coy.hile@coyhile.com
ok there is more to replica setup
user-db error seems to indicate the sql iterate it not setup or not returning stuff properly
can you specify what you are using for a sql setup (if any)
can help from there?
Happy Monday !!! Thanks - paul
Paul Kudla
Scom.ca Internet Services http://www.scom.ca 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3
Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 Email paul@scom.ca
On 5/23/2022 3:20 AM, Aki Tuomi wrote:
On 22/05/2022 02:32 Coy Hile coy.hile@coyhile.com wrote:
I seem to have got replication working from an older instance to a newer one (insofar as the data are present on the new box) that I’m looking to stand up to replace a newer box. In this case, nothing is configured to talk to the new machine yet, so the replication is unidirectional (old -> new).
However, I’m seeing an error like like this repeatedly in syslog:
2022-05-21T23:23:15.295252+00:00 basement-imap01 dovecot: doveadm(hile@coyhile.com): Error: sync: User has no mail_replica in userdb
What setting did I miss?
plugin { mail_replica = <value here> }
https://doc.dovecot.org/settings/plugin/replication-plugin/
Aki
my apologies i read through the other posts after responding
you are using ldap ?
Happy Monday !!! Thanks - paul
Paul Kudla
Scom.ca Internet Services http://www.scom.ca 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3
Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 Email paul@scom.ca
On 5/23/2022 11:00 AM, Paul Kudla (SCOM.CA Internet Services Inc.) wrote:
ok there is more to replica setup
user-db error seems to indicate the sql iterate it not setup or not returning stuff properly
can you specify what you are using for a sql setup (if any)
can help from there?
Happy Monday !!! Thanks - paul
Paul Kudla
Scom.ca Internet Services http://www.scom.ca 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3
Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 Email paul@scom.ca
On 5/23/2022 3:20 AM, Aki Tuomi wrote:
On 22/05/2022 02:32 Coy Hile coy.hile@coyhile.com wrote:
I seem to have got replication working from an older instance to a newer one (insofar as the data are present on the new box) that I’m looking to stand up to replace a newer box. In this case, nothing is configured to talk to the new machine yet, so the replication is unidirectional (old -> new).
However, I’m seeing an error like like this repeatedly in syslog:
2022-05-21T23:23:15.295252+00:00 basement-imap01 dovecot: doveadm(hile@coyhile.com): Error: sync: User has no mail_replica in userdb
What setting did I miss?
plugin { mail_replica = <value here> }
https://doc.dovecot.org/settings/plugin/replication-plugin/
Aki
On May 23, 2022, at 11:00 AM, Paul Kudla (SCOM.CA Internet Services Inc.) paul@scom.ca wrote:
ok there is more to replica setup
user-db error seems to indicate the sql iterate it not setup or not returning stuff properly
can you specify what you are using for a sql setup (if any)
can help from there?
Ah, on the new side, I am using LDAP, rather than SQL, setup thusly in dovecot-ldap.conf.ext (once I removed all the comments and blank lines):
'/^$/d' hosts = ldap.coyhile.com dn = uid=dovecotquery,ou=people,dc=coyhile,dc=com dnpass = [redacted] base = ou=People,dc=coyhile,dc=com scope = subtree user_filter = (&(objectClass=posixAccount)(uid=%n)) pass_attrs = uid=%n,userPassword=password pass_filter = (&(objectClass=posixAccount)(uid=%n)) iterate_attrs = maildrop=user iterate_filter = (objectClass=posixAccount)
-- Coy Hile coy.hile@coyhile.com
So are you ok now
I'm a postgresql kinda guy never got around to ldap as that was mostly windows based!
fyi
Happy Monday !!! Thanks - paul
Paul Kudla
Scom.ca Internet Services http://www.scom.ca 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3
Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 Email paul@scom.ca
On 5/23/2022 11:18 AM, Coy Hile wrote:
On May 23, 2022, at 11:00 AM, Paul Kudla (SCOM.CA Internet Services Inc.) paul@scom.ca wrote:
ok there is more to replica setup
user-db error seems to indicate the sql iterate it not setup or not returning stuff properly
can you specify what you are using for a sql setup (if any)
can help from there?
Ah, on the new side, I am using LDAP, rather than SQL, setup thusly in dovecot-ldap.conf.ext (once I removed all the comments and blank lines):
'/^$/d' hosts = ldap.coyhile.com dn = uid=dovecotquery,ou=people,dc=coyhile,dc=com dnpass = [redacted] base = ou=People,dc=coyhile,dc=com scope = subtree user_filter = (&(objectClass=posixAccount)(uid=%n)) pass_attrs = uid=%n,userPassword=password pass_filter = (&(objectClass=posixAccount)(uid=%n)) iterate_attrs = maildrop=user iterate_filter = (objectClass=posixAccount)
-- Coy Hile coy.hile@coyhile.com
On May 23, 2022, at 11:42 AM, Paul Kudla (SCOM.CA Internet Services Inc.) paul@scom.ca wrote:
So are you ok now
I don’t know that. I don’t know if what I’m trying to do is actually supported as yet. I’m going to setup the downstream replica for this box after I finish work today and try to cut-over to this new setup completely. If the error message goes away once I’ve configured bidirectional replication, I’d say I’m good, but we’ll find that out empirically.
Appreciate your help, Paul and Aki. The replication seems to work, but I still see that particular error. Need to test that one more thing is working on the new box.
-- Coy Hile coy.hile@coyhile.com
participants (3)
-
Aki Tuomi
-
Coy Hile
-
Paul Kudla (SCOM.CA Internet Services Inc.)