Re: Error while connecting postgres db with Kerberos autentification

Sorry for confusing you.

When I try to connect to DB with DBeaver, which uses jdbc driver, error comes out:

GSS Authentication failed
javax.security.auth.login.LoginException: No LoginModules configured for pgjdbc
[cid:image001(dot)png(at)01D2DBB4(dot)CA5AF300]

What is “pgjdbc”?

С уважением,
Лёсин Евгений
Главный специалист службы СДБО ФЛ, ИБ «Открытие Онлайн»
Вн. 18-6734
Моб. +7 900 312 22 20

From: davecramer(at)gmail(dot)com [mailto:davecramer(at)gmail(dot)com] On Behalf Of Dave Cramer
Sent: Friday, June 02, 2017 3:21 PM
To: Лёсин Евгений Андреевич
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Error while connecting postgres db with Kerberos autentification

On 2 June 2017 at 07:11, Лёсин Евгений Андреевич <Evgeniy(dot)Lesin(at)open(dot)ru<mailto:Evgeniy(dot)Lesin(at)open(dot)ru>> wrote:

* JDBC driver build number - postgresql-42.1.1
* Server version – 9.5
* Exact error message and stacktrace - below
* What you were doing, ideally in code form

Sorry for my English.
DB is configured to except connections only with ssl and kerberos. I'm trying to connect tj this DB with my AD user and get this error:

GSS Authentication failed
javax.security.auth.login.LoginException: No LoginModules configured for pgjdbc

jaasAplicationName property in Driver properties is not set. If I change it, for example, to "123", then error changes to

GSS Authentication failed
javax.security.auth.login.LoginException: No LoginModules configured for 123

Where should I create "pgjdbc" or "123" for DBeaver to understand what I want?

I know the problem is in jdbc driver. BUT we have it working on our prod servers.
We have a file, which has this in it:

pgjdbc {
com.sun.security.auth.module.Krb5LoginModule required
doNotPrompt=true
useTicketCache=true
renewTGT=true
debug=true
client=true;
};

and everything works!

I am unclear. Do you have this working or not ?

Dave