R Shell and Kerberos Ticket

Question

I have a hive connection via JDBC in RStudio without problems, I create Kerberos ticket in Tools < Shell: kinit and all working fine, I can use Kerberos TGT.

But if I make the same method via shell/ssh and loading R in terminal (Not RStudio), R can't use Kerberos TGT File and fails.

How can i use the Kerberos ticket?

> [user@server ~]$: kinit
>
> Password for user@domain:  --i put the password--
>
> [user@server ~]$: R 
>
> -- R load --
>
> \> source('samecode.r')
>
> Error Caused by: java.sql.SQLException: Could not create secure connection to jdbc:hive2:....etc

Any idea? This error happens in RStudio if we not create the ticket, but when it's created in tools>shell all work fine, in console its impossible. I try to create it with

 system('kinit');

And create the ticket fine, but can't use it in the rest of the code.

Answer 1

Hi you can create a kerberos ticket within R with a keytab file and this command :

system("kinit [email protected] -k -t username.keytab")

To create the keytab you have to do this via shell :

ktutil
ktutil:  addent -password -p [email protected] -k 1 -e rc4-hmac
Password for [email protected]: [enter your password]
ktutil:  addent -password -p [email protected] -k 1 -e aes256-cts
Password for [email protected]: [enter your password]
ktutil:  wkt username.keytab
ktutil:  quit 

All the steps for creating a keytab are explained here

And the keytab file must be in your working directory.