New slave pg_hba.conf error

UCS - Univention Corporate Server
,
#1

Hello i install a new slave but i’m having issues in the updates

Processing triggers for systemd (232-25+deb9u4A~4.3.1.201808081329) ...
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 578, in main
    connection = open_database_connection(config_registry, pkgdbu=False)
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 560, in open_database_connection
    connection = pgdb.connect(database=connectstring)
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1615, in connect
    cnx = _connect(dbname, dbhost, dbport, dbopt, dbuser, dbpasswd)
pg.InternalError: FATAL:  no pg_hba.conf entry for host "192.168.103.2", user "MPAVDC1$", database "pkgdb", SSL on

 dist-update finished at Mon Jan 21 16:23:20 2019...
done

I already try follow this Problem: Can not Install Software but i get an error

root@MPAVDC1:~# univention-pkgdb-scan --db-server 'ccmdc01.ccm.local' --add 'MPAVDC1$'
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 576, in main
    connection = open_database_connection(config_registry, pkgdbu=True)
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 554, in open_database_connection
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
IOError: [Errno 2] No such file or directory: '/etc/postgresql/pkgdb.secret'
#2

Hi,

the database server is ccmdc01.ccm.local, correct? Try to execute this command then on this server.

/CV

#3

I have done it… don’t return error, but the slave still have the same error during the update

File: /etc/apt/sources.list.d/15_ucs-online-version.list
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 578, in main
    connection = open_database_connection(config_registry, pkgdbu=False)
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 560, in open_database_connection
    connection = pgdb.connect(database=connectstring)
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1615, in connect
    cnx = _connect(dbname, dbhost, dbport, dbopt, dbuser, dbpasswd)
pg.InternalError: FATAL:  no pg_hba.conf entry for host "192.168.103.2", user "MPAVDC1$", database "pkgdb", SSL on

21.01.19 17:27:53.640  DEBUG_INIT
**** Starting univention-updater with parameter=['/usr/share/univention-updater/univention-updater', 'net', '--updateto', '4.3-2', '--silent']
Version=4.3
Patchlevel=2
starting net mode
--->DBG:update_available(mode=net, cdrom_mount_point=/media/cdrom, iso=None)
Checking network repository
Update hold at 4.3-2, next 4.3-3 is after 4.3-2
#4

Other issue in the same server…

image

Setting up univention-management-console (10.0.6-18A~4.3.0.201901151044) ...
Processing triggers for python-support (1.0.15.18.201403132013) ...
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 578, in main
    connection = open_database_connection(config_registry, pkgdbu=False)
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 560, in open_database_connection
    connection = pgdb.connect(database=connectstring)
  File "/usr/lib/python2.7/dist-packages/pgdb.py", line 1615, in connect
    cnx = _connect(dbname, dbhost, dbport, dbopt, dbuser, dbpasswd)
pg.InternalError: FATAL:  no pg_hba.conf entry for host "192.168.103.2", user "MPAVDC1$", database "pkgdb", SSL on

root@MPAVDC1:~# univention-pkgdb-scan --db-server 'ccmdc01.ccm.local' --add 'MPAVDC1$'
Traceback (most recent call last):
  File "/usr/sbin/univention-pkgdb-scan", line 37, in <module>
    univention.pkgdb.main()
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 576, in main
    connection = open_database_connection(config_registry, pkgdbu=True)
  File "/usr/lib/pymodules/python2.7/univention/pkgdb.py", line 554, in open_database_connection
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
IOError: [Errno 2] No such file or directory: '/etc/postgresql/pkgdb.secret'
root@MPAVDC1:~#
Mastodon