Bug 46570 – pykota db user creation fails

Bug 46570 - pykota db user creation fails


Summary:	pykota db user creation fails

Status:	CLOSED FIXED

Product:	UCS
Classification:	Unclassified
Component:	Printserver - pykota
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-4

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-03-09 13:00 CET by Felix Botner
Modified:	2018-03-14 14:38 CET (History)
CC List:	0 users

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
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-03-09 13:00:03 CET

dpkg-maintscript-helper: error: old-conffile 'etc/postgresql/8.4/main/pg_hba.conf.d/11-pg_hba.conf' is not an absolute path
Multifile: /etc/postgresql/9.6/main/pg_hba.conf
psql:/usr/share/pykota/postgresql/pykota-postgresql.sql:39: FEHLER:  unbekannte Rollenoption »nocreateuser«
ZEILE 1: ...WITH UNENCRYPTED PASSWORD 'readonlypw' NOCREATEDB NOCREATEUS...
                                                              ^
psql:/usr/share/pykota/postgresql/pykota-postgresql.sql:40: FEHLER:  unbekannte Rollenoption »nocreateuser«
ZEILE 1: ...ITH UNENCRYPTED PASSWORD 'readwritepw' NOCREATEDB NOCREATEUS...
                                                              ^
psql:/usr/share/pykota/postgresql/pykota-postgresql.sql:185: FEHLER:  Rolle »pykotaadmin« existiert nicht
psql:/usr/share/pykota/postgresql/pykota-postgresql.sql:186: FEHLER:  Rolle »pykotaadmin« existiert ni

Comment 1 Felix Botner

2018-03-09 13:02:35 CET

seems that posgres >= 9.6 no longer supports "NOCREATEUSER" in "CREATE USER"

Comment 2 Felix Botner

2018-03-09 17:02:49 CET

copied pykota-postgresql.sql from pykota to univention-printquotadb 
removed NOCREATEUS

Comment 3 Stefan Gohmann

2018-03-10 21:37:23 CET

Tests: OK, I've installed a UCS 4.3 and tested the printquota settings for one user.

Changelog: OK

Comment 4 Stefan Gohmann

2018-03-14 14:38:19 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".