Package: icinga-idoutils
Version: 1.6.1-2
Severity: important

Hi.

This may likely be an issue in dbconfig-common, but I have not much clue about 
it
so I report it first here.
Please redirect if I'm right.

All this is with PostgreSQL.


When configuring the DB automatically, it offers to do this via unix socets and
even suggests this as default.

However, at some stage it still tries to access it via TCP/IP and fails 
miserably
if TCP/IP is not enabled at all in PostgreSQL, or if there is just not access
allowed on it (no "trust" methond or nur running local identd).


Marking this as major, as it seems to make the normal default (unix socket only)
impossible and basically forces one to enable rather insecure auth methods
(trust or weak password based) or installing a local identd for no reason.


The PostgreSQL log shows this:
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=template1
2012-02-14 02:10:30 CET LOG:  disconnection: session time: 0:00:00.002 
user=postgres database=template1 host=[local]
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=template1
2012-02-14 02:10:30 CET ERROR:  role "icingaidoutils" does not exist
2012-02-14 02:10:30 CET STATEMENT:  ALTER USER "icingaidoutils"
2012-02-14 02:10:30 CET LOG:  disconnection: session time: 0:00:00.002 
user=postgres database=template1 host=[local]
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=template1
2012-02-14 02:10:30 CET LOG:  disconnection: session time: 0:00:00.033 
user=postgres database=template1 host=[local]
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=template1
2012-02-14 02:10:30 CET LOG:  disconnection: session time: 0:00:00.021 
user=postgres database=template1 host=[local]
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=template1
2012-02-14 02:10:30 CET LOG:  disconnection: session time: 0:00:00.002 
user=postgres database=template1 host=[local]
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=icinga
2012-02-14 02:10:30 CET FATAL:  database "icinga" does not exist
2012-02-14 02:10:30 CET LOG:  connection received: host=[local]
2012-02-14 02:10:30 CET LOG:  connection authorized: user=postgres 
database=postgres
2012-02-14 02:10:31 CET LOG:  disconnection: session time: 0:00:00.967 
user=postgres database=postgres host=[local]
2012-02-14 02:10:31 CET LOG:  connection received: host=[local]
2012-02-14 02:10:31 CET LOG:  connection authorized: user=postgres 
database=icinga
2012-02-14 02:10:31 CET LOG:  disconnection: session time: 0:00:00.002 
user=postgres database=icinga host=[local]
2012-02-14 02:10:31 CET LOG:  connection received: host=::1 port=45713
2012-02-14 02:10:31 CET FATAL:  no pg_hba.conf entry for host "::1", user 
"icingaidoutils", database "icinga", SSL on
2012-02-14 02:10:31 CET LOG:  connection received: host=::1 port=45714
2012-02-14 02:10:31 CET FATAL:  no pg_hba.conf entry for host "::1", user 
"icingaidoutils", database "icinga", SSL off



Cheers,
Chris.



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to