| 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: | Whole Thread | Raw Message | 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
========================================================================
| 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 |