Bug 48677 – univention-pkgdb-scan fails on fresh installed memberserver

Bug 48677 - univention-pkgdb-scan fails on fresh installed memberserver


Summary:	univention-pkgdb-scan fails on fresh installed memberserver

Status:	RESOLVED WONTFIX

Product:	UCS
Classification:	Unclassified
Component:	UMC - Software monitor
Version:	UCS 4.3
Hardware:	amd64 All

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	UMC maintainers
QA Contact:	UMC maintainers

URL:	https://help.univention.com/t/new-sla...
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2019-02-14 11:51 CET by office
Modified:	2021-05-14 16:38 CEST (History)
CC List:	2 users (show)

See Also:	50937
What kind of report is it?:	Bug Report
What type of bug is this?:	6: Setup Problem: Issue for the setup process
Who will be affected by this bug?:	4: Will affect most installed domains
How will those affected feel about the bug?:	2: A Pain – users won’t like this once they notice it
User Pain:	0.274
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description office 2019-02-14 11:51:10 CET

Yesterday I setup a new memberserver. The setup went well, but on console I can see errors when using "univention-install"

I have the errors mesages not available anymore, but there is the same problem described in the forum: https://help.univention.com/t/new-slave-pg-hba-conf-error/10977

--- 

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

---

Comment 1 office 2019-02-14 11:55:21 CET

as suggested by @Christian_Voelker I ran "univention-pkgdb-scan --db-server 'database-host' --add 'slave$'", which fixed the issue.

The process gave the output "user slave$ added to group ..."

Comment 2 Ingo Steuwer

2021-05-14 16:38:27 CEST

This issue has been filed against UCS 4.3.

UCS 4.3 is out of maintenance and many UCS components have changed in later releases. Thus, this issue is now being closed.

If this issue still occurs in newer UCS versions, please use "Clone this bug" or reopen it and update the UCS version. In this case please provide detailed information on how this issue is affecting you.