Skip site navigation (1) Skip section navigation (2)

Re: Connecting to postgresql using SSPI via JDBC

From: Kris Jurka <books(at)ejurka(dot)com>
To: Idan Miller <idan(dot)miller(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connecting to postgresql using SSPI via JDBC
Date: 2010-06-16 18:32:47
Message-ID: alpine.BSO.2.00.1006161427230.8108@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

pgsql-jdbc by date

Next:From: Chris BrowneDate: 2010-06-16 19:45:09
Subject: Re: Java .pgpass reader
Previous:From: Scott LangleyDate: 2010-06-16 18:07:12
Subject: Java .pgpass reader

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group