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 at scom.ca On 5/23/2022 3:20 AM, Aki Tuomi wrote:> > >> On 22/05/2022 02:32 Coy Hile <coy.hile at 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 at 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 at 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 at scom.ca > > On 5/23/2022 3:20 AM, Aki Tuomi wrote: >> >> >>> On 22/05/2022 02:32 Coy Hile <coy.hile at 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 at 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 at 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 at coyhile.com -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 488 bytes Desc: Message signed with OpenPGP URL: <https://dovecot.org/pipermail/dovecot/attachments/20220523/afc9be02/attachment.sig>