Support Questions

Find answers, ask questions, and share your expertise

Hive Kerberos ODBC setup Windows 10 and create/show roles and users

Explorer

The problem I am running into is that I have turned on Kerberos

but now I can't create Roles, Show users Show Roles...I can not create roles or users...may be I am new to this and missing some basics. Also since I turned on Kerberos  I can't use my ODBC drivers, I am sure it is all related.

 

I am using Cloudera 5.13,  I have not turned on Sentry Yet....

2 REPLIES 2

Explorer

To set up the Kerberos configuration file in the default location:

  1. Obtain a krb5.conf configuration file. You can obtain this file from your Kerberos administrator, or from the /etc/krb5.conf folder on the machine that is hosting the Hive Server 2 instance.
  2. Rename the configuration file from krb5.conf to krb5.ini.
  3. Copy the krb5.ini file to the C:\ProgramData\MIT\Kerberos5 directory and overwrite the empty sample file.

To set up the Kerberos configuration file in a custom location:

  1. Obtain a krb5.conf configuration file. You can obtain this file from your Kerberos administrator, or from the /etc/krb5.conf folder on the machine that is hosting the Hive Server 2 instance.
  2. Place the krb5.conf file in an accessible directory and make note of the full path name.
  3. Open the System window:
    • If you are using Windows 7 or earlier, click Start Windows Start button, then right-click Computer, and then click Properties.
    • Or, if you are using Windows 8 or later, right-click This PC on the Start screen, and then click Properties.
  4. Click Advanced System Settings.
  5. In the System Properties dialog box, click the Advanced tab and then click Environment Variables.
  6. In the Environment Variables dialog box, under the System Variables list, click New.
  7. In the New System Variable dialog box, in the Variable Name field, type KRB5_CONFIG.
  8. In the Variable Value field, type the full path to the krb5.conf file.
  9. Click OK to save the new variable.
  10. Make sure that the variable is listed in the System Variables list.
  11. Click OK to close the Environment Variables dialog box, and then click OK to close the System Properties dialog box.

Explorer

Where do you specify KeyTab file?

I can't install MIT kerberos on my windows 10 (no admin privileges ), though I have kinit/klist in jdk8 folders

 

thanks

Andy