I am trying to connect from Squirrel to phoenix and it errors out with
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: java.io.IOException: Login failure for [email protected] from keytab /Users/smanjee/keytabs/keytab
at org.apache.hadoop.security.UserGroupInformation.loginUserFromKeytab(UserGroupInformation.java:921)
at org.apache.hadoop.security.SecurityUtil.login(SecurityUtil.java:242)
at org.apache.hadoop.hbase.security.User$SecureHadoopUser.login(User.java:386)
at org.apache.hadoop.hbase.security.User.login(User.java:253)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:380)
... 17 more
Caused by: javax.security.auth.login.LoginException: Unable to obtain password from user
at com.sun.security.auth.module.Krb5LoginModule.promptForPass(Krb5LoginModule.java:897)
I verified by keytab file looks good by issuing a curl webhdfs against to cluster with success. What am i missing here?
I think this is permission issue for the principal smanjee for Phoenix service. Can you try the following from the same node where you have squirrel and after kinit try accessing your phoenix service from command line. I think it would still fail and once you resolve that with proper permissions for this user, your squirrel issue would be resolved too. Hope this helps.
kinit -ket <your keytab file> [email protected]
@Sunile Manjee
Just tried on my cluster
$ kdestroy
[root@host ~]# sudo su - smanjee
[smanjee@host ~]$ kinit
Password for smanjee@HORTONWORKS:
[smanjee@host ~]$ klist
Ticket cache: FILE:/tmp/krb5cc_49393
Default principal: smanjee@HORTONWORKS
Valid starting Expires Service principal
11/28/16 17:06:44 11/29/16 03:06:44 krbtgt/ HORTONWORKS@HORTONWORKS
Tell me whether it worked out for you
Terms & Conditions
Privacy Policy and Data Policy
Unsubscribe / Do Not Sell My Personal Information
Supported Browsers Policy
Apache Hadoop
and associated open source project names are trademarks of the
Apache Software Foundation. For a complete list of trademarks, click here.
