[Pkg-nagios-devel] Bug#830888: icinga2-ido-pgsql: dbconfig configuration fails with unix sockets

[Christoph Anton Mitterer]

Even if one enables TCP, it doesn't work:
2016-07-12 18:45:55 CEST [8172-2] icinga at template1 LOG:  connection authorized: user=icinga database=template1 SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)
2016-07-12 18:45:55 CEST [8202-1] [unknown]@[unknown] LOG:  connection received: host=::1 port=39691
2016-07-12 18:45:55 CEST [8202-2] icinga at template1 LOG:  connection authorized: user=icinga database=template1 SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)
2016-07-12 18:45:55 CEST [8202-3] icinga at template1 ERROR:  permission denied
2016-07-12 18:45:55 CEST [8202-4] icinga at template1 STATEMENT:  ALTER USER "icinga"
2016-07-12 18:45:55 CEST [8246-1] [unknown]@[unknown] LOG:  connection received: host=::1 port=39692
2016-07-12 18:45:55 CEST [8246-2] icinga at template1 LOG:  connection authorized: user=icinga database=template1 SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, compression=off)
2016-07-12 18:45:55 CEST [8246-3] icinga at template1 ERROR:  permission denied to create role
2016-07-12 18:45:55 CEST [8246-4] icinga at template1 STATEMENT:  CREATE USER "icinga" WITH PASSWORD 'VfCrhGSrkbDW'



It tries to create roles as icinga (even though I've given postgres as
db admin user)... and even though I've left the password empty, it
tries to apply one, which is not ideal either.


Cheers,
Chris.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5930 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-nagios-devel/attachments/20160712/c24c48ab/attachment-0001.bin>