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 dc02.some.com
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
ALTER ROLE
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2228, in _wrap_pool_connect
return fn()
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 425, in connect
return _ConnectionFairy._checkout(self)
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 822, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 554, in checkout
rec = pool._do_get()
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 1346, in _do_get
return self._create_connection()
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 370, in _create_connection
return _ConnectionRecord(self)
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 499, in __init__
self.__connect(first_connect_check=True)
File "/usr/lib/python3/dist-packages/sqlalchemy/pool.py", line 701, in __connect
connection = pool._invoke_creator(self)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 437, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib/python3/dist-packages/psycopg2/__init__.py", line 130, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL: no pg_hba.conf entry for host "192.168.0.15", user "admindiary", database "admindiary", SSL on
FATAL: no pg_hba.conf entry for host "192.168.0.15", 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