Bug 46055 – postgresql not running during setup - pkgdb installations fails

Bug 46055 - postgresql not running during setup - pkgdb installations fails


Summary:	postgresql not running during setup - pkgdb installations fails

Status:	CLOSED FIXED

Product:	UCS
Classification:	Unclassified
Component:	PostgreSQL
Version:	UCS 4.3
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS 4.3
Assigned To:	Felix Botner
QA Contact:	Stefan Gohmann

URL:
Keywords:	interim-2

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-01-16 17:38 CET by Felix Botner
Modified:	2018-03-14 14:38 CET (History)
CC List:	2 users (show)

See Also:
What kind of report is it?:	Development Internal
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
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
pkgdb.png (33.24 KB, image/png) 2018-01-16 17:38 CET, Felix Botner	Details
View All 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 Felix Botner

2018-01-16 17:38:11 CET

Created attachment 9347 [details]
pkgdb.png

See screenshot, univention-pkgdb creates psql users in the postinst, but postgresql seems to be not running

Installation from DVD with pkgdb

Comment 1 Florian Best

2018-01-16 17:52:50 CET

Probably the same issue as Bug #45905?!
The service is started via "invoke-rc.d" and therefore not started by systemd because the debian installer runs in a chroot environment.

Comment 2 Felix Botner

2018-01-16 19:35:08 CET

(In reply to Florian Best from comment #1)
> Probably the same issue as Bug #45905?!
> The service is started via "invoke-rc.d" and therefore not started by
> systemd because the debian installer runs in a chroot environment.

probably, this was an installation and i got the error in the system setup step (before the first reboot)

Comment 3 Felix Botner

2018-01-18 19:04:14 CET

We need this for the install tests!

Comment 4 Felix Botner

2018-01-19 16:11:07 CET

fixed in univention-postgresql (as in Bug #45905)

Comment 5 Felix Botner

2018-01-22 12:20:08 CET

still not working, the join of univention-pkgdb during the installation fails

22.01.18 00:50:56.135  LISTENER    ( WARN    ) : finished initializing module libvirtd-acl with rv=0
22.01.18 00:50:56.135  LISTENER    ( WARN    ) : initializing module pkgdb
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 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:  Peer-Authentifizierung fÃ¼r Benutzer Â»pkgdbuÂ« fehlgeschlagen

Comment 6 Felix Botner

2018-01-23 09:12:28 CET

univention-pkgdb  69d22ad71b750db2b61d10c04e0a9dae77091ba2
restart postgresql in postinst

Comment 7 Stefan Gohmann

2018-01-30 15:39:23 CET

OK, works. Changelog: OK

Comment 8 Stefan Gohmann

2018-03-14 14:38:13 CET

UCS 4.3 has been released:
 https://docs.software-univention.de/release-notes-4.3-0-en.html
 https://docs.software-univention.de/release-notes-4.3-0-de.html

If this error occurs again, please use "Clone This Bug".