From: | "Sam Elsamman" <elsamman(at)sitemagix(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Ident Connections With Tomcat and Postgresql |
Date: | 2007-12-06 14:42:32 |
Message-ID: | 157342620712060642i69edd0b8l6d1c070e7ab8b3ab@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Has anyone had experience with IDENT authentication and JDBC with
Tomcat 5.5 and Postresql 8.2 using postgresql-8.2-506.jdbc3?
I set ident accross the board in pga_pg_hba.conf and restarted postgres
I set up an Ident service and I am able to connect using Ident with
su tomcat
psql -h locahost tomcat_test
But when I connect using JDBC under tomcat
String loginUser = "tomcat";
String loginUrl = "jdbc:postgresql://127.0.0.1/tomcat_test";
try
{
Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl, loginUser, "");
}
I get "Ident authentication failed for user tomcat"
When I log at the postgres log I see:
LOG: invalidly formatted response from Ident server: "47537 , 5432 :
ERROR :NO-USER
"
FATAL: Ident authentication failed for user "tomcat"
LOG: invalidly formatted response from Ident server: "47541 , 5432 :
ERROR :NO-USER
"
I started Tomcat using jsvc and confirmed it is running as tomcat and
confirmed via System.getProperty("user.name") I was running as tomcat.
Also when I test ident standalone I get what appears to be good output
[root(at)host3 ~]# telnet localhost 113
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
47568,5432
47568 , 5432 : USERID : Linux :tomcat
Connection closed by foreign host.
[root(at)host3 ~]#
This is a weird one. Thanks in advance for any help on this.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Koczan | 2007-12-06 16:13:56 | Re: JDBC and GSSAPI/Krb5 |
Previous Message | Usama Dar | 2007-12-06 12:28:29 | Re: java.io.EOFException |