Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: dave(dot)rosckes(at)gmail(dot)com
Cc: Dave Cramer <pg(at)fastcrypt(dot)com>, PgJDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working
Date: 2014-12-03 11:22:30
Message-ID: 547EF276.3060805@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

> JDBC connection url:
> "jdbc:postgresql://localhost/postgresDB?integratedSecurity=true"

I don't know where you got "integratedSecurity=true". The only reference
I can find to that is in Microsoft's documentation for MS SQL server.
There is no such parameter in PgJDBC, nor in core PotsgreSQL.

Until very recently (i.e. last week) PgJDBC did not support SSPI
natively. It was potentially possible to use it via direct access to the
Kerberos ticket, but it required lots of setup and was generally painful
and impractical.

I implemented SSPI support for PgJDBC a few weeks ago, and merged it
into the core driver this week. If you download the latest git tree of
PgJDBC and compile it, you will be able to use SSPI. No additional
parameters should be required.

There is not yet a binary release of the driver with SSPI support, but
it's pretty easy to compile PgJDBC if you've used git before. Just clone
the repository from https://github.com/pgjdbc/pgjdbc and then "ant -lib
lib all" in the source tree. You can also "ant -lib lib dist" if you
want to make a distribution zip file. See the README shown at the bottom
of https://github.com/pgjdbc/pgjdbc for more details.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-12-03 11:40:27 Re: TRUNCATE and CREATE TABLE LIKE for foreign tables
Previous Message sri harsha 2014-12-03 11:22:17 TRUNCATE and CREATE TABLE LIKE for foreign tables

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2014-12-03 11:24:49 Re: performance question: protocol v2 vs v3
Previous Message Adrian Klaver 2014-12-02 20:40:41 Re: Trying to get SSPI/JDBC working