Re: Connecting to postgresql using SSPI via JDBC

Поиск
Список
Период
Сортировка
От Idan Miller
Тема Re: Connecting to postgresql using SSPI via JDBC
Дата
Msg-id AANLkTimQVhyCQM66uHG6X2ryoEzQsxLXom2zQW1BRY5i@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Connecting to postgresql using SSPI via JDBC  (Kris Jurka <books@ejurka.com>)
Ответы Re: Connecting to postgresql using SSPI via JDBC
Список 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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: pljava and postgresql 8.4.4 compile errors
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: Connecting to postgresql using SSPI via JDBC