Admin diary on 5.0.3-660 failing on replica

when placing in a replica of your AD on a different subnet/site, the admin diary does nto function

the new site shows an error

univention-join-hooks: looking for hook type "join/pre-joinscripts" on
Found hooks:
RUNNING 60univention-admin-diary-backend.inst
2023-05-08 10:49:11.589737907+08:00 (in joinscript_init)
createuser: creation of new role failed: ERROR:  role "admindiary" already exists
createdb: database creation failed: ERROR:  database "admindiary" already exists
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/", line 2228, in _wrap_pool_connect
    return fn()
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 425, in connect
    return _ConnectionFairy._checkout(self)
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 822, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 554, in checkout
    rec = pool._do_get()
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 1346, in _do_get
    return self._create_connection()
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 370, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 499, in __init__
  File "/usr/lib/python3/dist-packages/sqlalchemy/", line 701, in __connect
    connection = pool._invoke_creator(self)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib/python3/dist-packages/sqlalchemy/engine/", line 437, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib/python3/dist-packages/psycopg2/", line 130, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  no pg_hba.conf entry for host "", user "admindiary", database "admindiary", SSL on
FATAL:  no pg_hba.conf entry for host "", user "admindiary", database "admindiary", SSL off

also following the settings for the above note ,
the port settings inside teh univention config reg, show port 10514, this is not shown in the note and does not seem correct for a postgresql database

Hi , is there any update on this? Having the same issue. Thanks.

had to go in manually & change the config to point to the database on the master.