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