Bug 47085 – pkgdb/columns: Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb.secret'

Bug 47085 - pkgdb/columns: Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb.secret'


Summary:	pkgdb/columns: Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb....

Status:	RESOLVED WONTFIX

Product:	UCS
Classification:	Unclassified
Component:	UMC - Software monitor
Version:	UCS 4.3
Hardware:	Other Linux

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

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-05-25 20:41 CEST by Johannes Keiser
Modified:	2021-05-14 16:38 CEST (History)
CC List:	1 user (show)

See Also:
What kind of report is it?:	Bug Report
What type of bug is this?:	4: Minor Usability: Impairs usability in secondary scenarios
Who will be affected by this bug?:	1: Will affect a very few 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.046
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:	2019031421001671, 2018051421000277, 2020070721000577, 2020070721000559, 2020070721000568, 2020070721000541, 2020082421000659
Bug group (optional):	Error handling, External feedback
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 Johannes Keiser

2018-05-25 20:41:34 CEST

Version: 4.3-0 errata28 (Neustadt)

Interner Server-Fehler in "pkgdb/columns".
Request: pkgdb/columns

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 182, in _recv
    self.handle(msg)
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 292, in handle
    self.__handler.init()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 214, in init
    self.connect()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 231, in connect
    self.dbConnection = updb.open_database_connection(self.ucr, pkgdbu=True)
  File "%PY2.7%/univention/pkgdb.py", line 554, in open_database_connection
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
IOError: [Errno 2] Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb.secret'

Comment 1 Johannes Keiser

2019-03-22 15:35:52 CET

Reported again: Version: 4.4-0 errata5 (Blumenthal)

Interner Server-Fehler in "pkgdb/proposals".
Request: pkgdb/proposals

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 186, in _recv
    self.handle(msg)
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 296, in handle
    self.__handler.init()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 214, in init
    self.connect()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 231, in connect
    self.dbConnection = updb.open_database_connection(self.ucr, pkgdbu=True)
  File "%PY2.7%/univention/pkgdb.py", line 554, in open_database_connection
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
IOError: [Errno 2] Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb.secret'

Role: domaincontroller_master

Comment 2 Christian Castens

2020-08-21 11:01:47 CEST

reported again:
Version: 4.4-4 errata648 (Blumenthal)

Error:
Interner Server-Fehler in "pkgdb/keys".
Request: pkgdb/keys

Traceback (most recent call last):
  File "%PY2.7%/univention/management/console/base.py", line 359, in __error_handling
    six.reraise(etype, exc, etraceback)
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 198, in _recv
    self.handle(msg)
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 268, in handle
    six.reraise(self.__init_etype, self.__init_exc, self.__init_etraceback)
  File "%PY2.7%/univention/management/console/protocol/modserver.py", line 309, in handle
    self.__handler.init()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 214, in init
    self.connect()
  File "%PY2.7%/univention/management/console/modules/pkgdb/__init__.py", line 231, in connect
    self.dbConnection = updb.open_database_connection(self.ucr, pkgdbu=True)
  File "%PY2.7%/univention/pkgdb.py", line 555, in open_database_connection
    connection_info['password'] = open(password_file, 'rb').read().rstrip('\n')
IOError: [Errno 2] Datei oder Verzeichnis nicht gefunden: '/etc/postgresql/pkgdb.secret'

Role: domaincontroller_master

Comment 3 Christian Castens

2020-08-26 15:32:49 CEST

reported again:
Version: 4.4-5 errata712 (Blumenthal)

Error:
Interner Server-Fehler in "pkgdb/columns".
Request: pkgdb/columns

Role: domaincontroller_master

Comment 4 Ingo Steuwer

2021-05-14 16:38:06 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.