Trying to get SSPI/JDBC working

From: Dave Rosckes <dave(dot)rosckes(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trying to get SSPI/JDBC working
Date: 2014-12-02 16:10:05
Message-ID: CAEtyQx12UkS=wDFUTjwEVNggza_Oc8KMQBptRbdgj7-90=Ei8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2014-12-02 16:15:00 update several columns from function returning several values
Previous Message Tom Lane 2014-12-02 15:51:49 Re: Auto vacuum not running -- Could not bind socket for statistics collector

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2014-12-02 16:25:09 Fwd: [GENERAL] Trying to get SSPI/JDBC working
Previous Message rapidtransit440 2014-11-26 00:29:09 Re: Having issues with tests