BUG #18335: JDBC Postgress Kerberos authentication does'nt work without JAAS

Started by PG Bug reporting formabout 2 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 18335
Logged by: Anu K
Email address: anushaumapathi@gmail.com
PostgreSQL version: 16.0
Operating system: Windows
Description:

Hello,

I need to connect to Postgres through a JDBC connection in Kerberos mode.
This is successful only using the JAAS configuration file. Is there way
without using the JAAS conf file I can set
this property in the program that are listed in JAAS conf file.
My required is not to profile the static JAAS file instead I need to send
the properties.
The tickecache and just the login module?
Properties properties = new Properties();
properties.setProperty("cache",
"C:\\temp\\postgresk\\krb5cache");
properties.setProperty("loginmodule",
"com.sun.security.auth.module.Krb5LoginModule");
pgjdbc {
com.sun.security.auth.module.Krb5LoginModule required
debug=true
refreshKrb5Config=true
doNotPrompt=true
useTicketCache=true
useKeyTab=false
client=true
ticketCache="C:\\temp\\postgresk\\krb5cache";
};

#2Dave Cramer
pg@fastcrypt.com
In reply to: PG Bug reporting form (#1)
Re: BUG #18335: JDBC Postgress Kerberos authentication does'nt work without JAAS

On Tue, 6 Feb 2024 at 04:33, PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 18335
Logged by: Anu K
Email address: anushaumapathi@gmail.com
PostgreSQL version: 16.0
Operating system: Windows
Description:

Hello,

I need to connect to Postgres through a JDBC connection in Kerberos mode.
This is successful only using the JAAS configuration file. Is there way
without using the JAAS conf file I can set
this property in the program that are listed in JAAS conf file.
My required is not to profile the static JAAS file instead I need to send
the properties.
The tickecache and just the login module?
Properties properties = new Properties();
properties.setProperty("cache",
"C:\\temp\\postgresk\\krb5cache");
properties.setProperty("loginmodule",
"com.sun.security.auth.module.Krb5LoginModule");
pgjdbc {
com.sun.security.auth.module.Krb5LoginModule required
debug=true
refreshKrb5Config=true
doNotPrompt=true
useTicketCache=true
useKeyTab=false
client=true
ticketCache="C:\\temp\\postgresk\\krb5cache";
};

As far as I know that is the only way to use JAAS on windows.

Dave