Hi Imran, Since 4.1 release, connecting to a secure HBase cluster is supported by Phoenix. Can you try using sqlline and invoke it by command: sqlline.py jdbc:phoenix:<quorom>:<port>:<rootNode>:<principal>:<keytab> Please report back the outcome. Also, are you able to connect to hbase from the node without using Phoenix? Maybe, there is a firewall or kerberos client is not setup.
Thanks, Anil Gupta On Thu, Dec 18, 2014 at 2:45 PM, Alex Kamil <[email protected]> wrote: > > Imran, Are you able to connect with sqlline following these instructions > http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html > ? > also see previous threads > <https://www.google.com/webhp?sourceid=chrome-instant&rlz=1CAASUA_enUS609US609&ion=1&espv=2&ie=UTF-8&safe=active&ssui=on#q=apache%2Bhbase%2Bphoenix%2Bsecure%2Bkerberos+&safe=active&ssui=on> > for debugging tips > > > On Thu, Dec 18, 2014 at 11:37 AM, Imran Mohammed <[email protected]> > wrote: >> >> Hey, >> >> >> >> I'm using Phoenix 4.XX on CDH5 Hbase 0.98 cluster. >> >> >> >> On our sandbox environment which is a non-secure cluster , I'm able to >> connect through squirrel without any problem. >> >> >> >> But on our production environment which is a secure cluster it’s not >> working. I'm providing keytab and principal as part of my JDBC url but no >> luck. >> >> >> >> Can someone help with some guideance on this. >> >> >> >> Please find the stack trace below >> >> >> >> >> >> java.util.concurrent.TimeoutException >> >> at >> java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:258) >> >> at java.util.concurrent.FutureTask.get(FutureTask.java:119) >> >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) >> >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) >> >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) >> >> at >> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> >> at >> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) >> >> at java.util.concurrent.FutureTask.run(FutureTask.java:166) >> >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) >> >> at java.lang.Thread.run(Thread.java:722) >> >> >> >> Regards, >> >> Imran A Mohammed. >> >> >> > -- Thanks & Regards, Anil Gupta
