Re: Connecting to postgresql using SSPI via 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(at)ejurka(dot)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
>