Re: Connecting to postgresql using SSPI via 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