Trying to get SSPI/JDBC working - Mailing list pgsql-general

From Dave Rosckes
Subject Trying to get SSPI/JDBC working
Date
Msg-id CAEtyQx12UkS=wDFUTjwEVNggza_Oc8KMQBptRbdgj7-90=Ei8w@mail.gmail.com
Whole thread Raw
Responses Re: Trying to get SSPI/JDBC working
List pgsql-general
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"

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-general by date:

Previous
From: Eric Svenson
Date:
Subject: Re: Problem with pg_dump and decimal mark
Next
From: Rémi Cura
Date:
Subject: update several columns from function returning several values