Problem w/ IDENT authentication

From: Ian Pilcher <i(dot)pilcher(at)comcast(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem w/ IDENT authentication
Date: 2004-07-26 08:53:38
Message-ID: ce2gqj$8df$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I am trying to set up IDENT authentication for Tomcat 5 on my Fedora
Core 2 system. I've added the appropriate line to pg_hba.conf:

host tomcat4 tomcat4 127.0.0.1 255.255.255.255 ident sameuser

This works as expected from a console:

[root(at)home webapps]# su tomcat4
sh-2.05b$ psql -h localhost tomcat4
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

tomcat4=>

In my servlet I try to get a connection:

db = DriverManager.getConnection("jdbc:postgresql:tomcat4",
"tomcat4", "");

And I get the following:

org.postgresql.util.PSQLException: A connection error has occurred:
org.postgresql.util.PSQLException: FATAL: IDENT authentication
failed for user "tomcat4"

I've verified that the servlet does run as tomcat4 by writing a
temporary file.

TIA for any ideas!

--
========================================================================
Ian Pilcher i(dot)pilcher(at)comcast(dot)net
========================================================================

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Amit Ray 2004-07-26 09:35:38 JDBC Rowsets running out of memory when dealing with large tables
Previous Message cby_y 2004-07-26 07:34:31 questions