I am trying configure Toad for Hadoop SQL part. Kerberos in enabled in my cluster.

I can see that Toad generates JDBC string ending with ...; auth=kerberos;kerberosAuthType=fromSubject

When I testing this string in my beeline:

[margroo@hadoopnn1 ~]$ klist
Ticket cache: FILE:/tmp/krb5cc_1414255929
Default principal: marg...@realm.com

Valid starting       Expires              Service principal
09/16/2016 14:25:45  09/17/2016 00:25:45 krbtgt/realm....@realm.com
        renew until 09/23/2016 14:25:39

I am getting error:

javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]

When removing last part then it works:

0: jdbc:hive2://hadoopnn1.example.com:10000/ (closed)> !connect jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com Connecting to jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com Enter username for jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com: Enter password for jdbc:hive2://hadoopnn1.example.com:10000/;principal=hive/_h...@testhadoop.com:
Connected to: Apache Hive (version
Driver: Hive JDBC (version
1: jdbc:hive2://hadoopnn1.example.com:10000/>

The problem is that Toad for Hadoop forcing ... auth=kerberos;kerberosAuthType=fromSubject

Margus (margusja) Roo
skype: margusja
+372 51 48 780

Reply via email to