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

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

pauljoshiva — Tue, 21 Apr 2026 07:44:05 GMT

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.

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

venkatsambath — Wed, 22 Feb 2023 20:12:08 GMT

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

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

DianaTorres — Mon, 27 Feb 2023 17:16:23 GMT

@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