DataGrip Mac Kerberos Authentication with PostgreSQL
Answered
When trying to connect to your Postgres server via DataGrip on a Mac, we get the error below. We are currently using GSS Kerberos Authentication.
[08006] GSS Authentication failed
Any idea on what needs to be configured in DataGrip on the Mac for this to work? Or is it the default PostgreSQL drivers that don't support kerberos?
Please sign in to leave a comment.
Hi,
Could you attach full IDE log?
Could you specify postgresql driver version you use?
How did you set up your SSL settings?
Thank you.
How do I go about getting a full IDE log?
Our postgres servers doesn't use SSL, so I am not sure what you are asking here.
the postgressql driver version is 42.1.1 (the latest)
Hi,
Here it is:
Thank you.
I have uploaded the log to dropbox for you to download.
https://www.dropbox.com/s/z5i8yhvpiubjnh2/idea.log?dl=0
@Brady Clifford Hi,
Could you try to connect with other tools?
Read:
for a possible solution.
Thank you.
Following these links you sent me, how do I include a JAAS config with a DataGrip connection?
@Brady Cliffrod Hi,
According to documentation https://docs.oracle.com/javase/7/docs/technotes/guides/security/jgss/tutorials/LoginConfigFile.html you should specify
-Djava.security.auth.login.configin your connection VM options:Thank you.
How would I go about adding this to DataGrip under the JDBC settings?:
System.setProperty(“java.security.krb5.realm”, realm);
System.setProperty(“java.security.krb5.kdc”, kdc);
@ Brady Clifford
Put the following into VM options: