Re: Connecting to postgresql using SSPI via JDBC - Mailing list pgsql-jdbc

From Idan Miller
Subject Re: Connecting to postgresql using SSPI via JDBC
Date
Msg-id AANLkTimQVhyCQM66uHG6X2ryoEzQsxLXom2zQW1BRY5i@mail.gmail.com
Whole thread Raw
In response to Re: Connecting to postgresql using SSPI via JDBC  (Kris Jurka <books@ejurka.com>)
Responses Re: Connecting to postgresql using SSPI via JDBC
List pgsql-jdbc
Thanks!

As far as I know, I an configure gssapi on windows as well, right?
So techincaly, if I manage to do so, I will get the same "sspi like" authentication, right?

Idan.

On Wed, Jun 16, 2010 at 9:32 PM, Kris Jurka <books@ejurka.com> wrote:


On Wed, 16 Jun 2010, Idan Miller wrote:

I've got a postgresql configured with sspi authentication.
The authentication works usng psql, however, when attempting to connect via
the jdbc driver I get this exception:

"org.postgresql.util.PSQLException: The authentication type 9 is not
supported. Check that you have configured the pg_hba.conf file to include
the client's IP address or subnet, and that it is using an authentication
scheme supported by the driver."

Does the jdbc driver simply not support sspi?

The JDBC driver supports gssapi, but not sspi.  It's possible that the existing gssapi support could be used to implement sspi, but no one has tried that.

Does it support ldap?


Yes, no specific client support is needed for LDAP authentication, that is all done server side.  Using LDAP transmits the password from the driver to the server in plaintext form, so you should use a SSL connection if you're worried about security.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: pljava and postgresql 8.4.4 compile errors
Next
From: Kris Jurka
Date:
Subject: Re: Connecting to postgresql using SSPI via JDBC