Ident Connections With Tomcat and Postgresql
От | Sam Elsamman |
---|---|
Тема | Ident Connections With Tomcat and Postgresql |
Дата | |
Msg-id | 157342620712060642i69edd0b8l6d1c070e7ab8b3ab@mail.gmail.com обсуждение исходный текст |
Список | 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@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@host3 ~]# This is a weird one. Thanks in advance for any help on this.
В списке pgsql-jdbc по дате отправления: