Re: Problem w/ IDENT authentication - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Problem w/ IDENT authentication
Date
Msg-id 29756.1090863711@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem w/ IDENT authentication  (Ian Pilcher <i.pilcher@comcast.net>)
Responses Re: Problem w/ IDENT authentication
List pgsql-jdbc
Ian Pilcher <i.pilcher@comcast.net> writes:
> All I see in the syslog for a failed connection is:

> Jul 26 11:22:48 home postgres[24968]: [30-1] LOG:  00000: connection
> received: host=127.0.0.1 port=34676
> Jul 26 11:22:48 home postgres[24968]: [30-2] LOCATION:  BackendFork,
> postmaster.c:2395
> Jul 26 11:22:51 home postgres[24968]: [31-1] FATAL:  28000: IDENT
> authentication failed for user "tomcat4"
> Jul 26 11:22:51 home postgres[24968]: [31-2] LOCATION:  auth_failed,
> auth.c:395

> This doesn't tell me anything that I didn't already know.

Sometimes life's like that ;-).  But actually this does tell something:
the lack of any additional log message implies that we did get a
response from the ident server, since ident_inet() will bleat about
connection failures and so forth.  What I conclude is that ident is not
reporting tomcat4 as the owner of the tomcat process, but something
else.  Perhaps root?  How is the tomcat stuff getting launched, anyway?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Charset problem on WHERE clause
Next
From: Yi LIN
Date:
Subject: Re: conflict txns in serialization isolation