Fwd: [GENERAL] Trying to get SSPI/JDBC working
| От | Dave Cramer | 
|---|---|
| Тема | Fwd: [GENERAL] Trying to get SSPI/JDBC working | 
| Дата | |
| Msg-id | CADK3HHKpzxtK+ay_qzGWfLUVbLK=sSBq7+g=uKnLhBs+ZiWLnw@mail.gmail.com обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working
            		
            		 | 
		
| Список | pgsql-jdbc | 
Better luck on this list.
		
	---------- Forwarded message ----------
From: Dave Rosckes <dave.rosckes@gmail.com>
Date: 2 December 2014 at 11:10
Subject: [GENERAL] Trying to get SSPI/JDBC working
To: pgsql-general@postgresql.org
From: Dave Rosckes <dave.rosckes@gmail.com>
Date: 2 December 2014 at 11:10
Subject: [GENERAL] Trying to get SSPI/JDBC working
To: pgsql-general@postgresql.org
I am new to Postgresql.  I have a postgres server running on a windows platform.  The DBs will not have any remote access, only users logged onto the localhost will have access.  SSPI seems like a great authentication protocol to use in this case.
I believe I have followed all the instructions on how to get this to work:
Postgresql: postgresql-9.3.4-4-windows-x64 
Updated pg_hba.conf to have the following lines:
host    all             all             127.0.0.1/32            sspi
host    all             all             ::1/128                     md5
Created role that matches userid via pgAdmin III
JDBC connection url: "jdbc:postgresql://localhost/postgresDB?integratedSecurity=true"
JDBC jar: postgresql-9.3-1100.jdbc4.jar
Looking in the pglog all I see is:
CST FATAL:  SSPI authentication failed for user "roscked"
CST DETAIL: Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 sspi"
CST DETAIL: Connection matched pg_hba.conf line 80: "host all all 127.0.0.1/32 sspi"
The exception I see:
org.postgresql.util.PSQLException: GSS Authentication failed
Any guidance on how to get more information on the failure, or suggestion on what I am doing wrong would be greatly appreciated.
В списке pgsql-jdbc по дате отправления: