Skip to main content
pauljoshiva
Silver ⭐️⭐️⭐️
Feb 10, 2023 5:56 PM UTC
Question

Could not create more than one ticket for multiple users in MIT Kerberos for Hive ODBC connection

I've installed and configured MIT Kerberos for Windows Hive ODBC connection.

I could not create Kerberos ticket for more than one user, the new ticket created overwrites the existing ticket. Hence multiple user accessing that Windows machine could not obtain a valid ticket to connect to Hive ODBC connections.

I've set krbs.conf from the Hive server and KRB5CCNAME is set to C:\temp\krb5cache.

Please let me know how to configure this to have more valid tickets for each user.

2 replies

venkatsambath
Gold ⭐️⭐️⭐️
Gold ⭐️⭐️⭐️
Feb 22, 2023 8:12 PM UTC

Hi. Yeah its expected when you have the common path for tgt cache for multiple user. Can you make the location unique for each different user - I haven't tested but I see an option in this link https://gpdb.docs.pivotal.io/6-3/admin_guide/kerberos-win-client.html 

Set up the Kerberos credential cache file. On the Windows system, set the environment variable KRB5CCNAME to specify the file system location of the cache file. The file must be named krb5cache. This location identifies a file, not a directory, and should be unique to each login on the server. When you set KRB5CCNAME, you can specify the value in either a local user environment or within a session. For example, the following command sets KRB5CCNAME in the session:

set KRB5CCNAME=%USERPROFILE%\krb5cache

Translate
DianaTorres
Community Manager
Community Manager
Feb 27, 2023 5:16 PM UTC

@pauljoshiva  Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks

 
Translate
Regards, Diana Torres, Senior Community Moderator