Hi Sanjeev, Are you using a secure cluster? I assume you are not. Please make sure that you copy the configuration files in(on a Mac) /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib directory and copy the phoenix-client.jar file in same directory. Basically, the hbase conf files should be in classpath of Squirell.
jdbc:*phoenix*:zk_host1,zk_host2(provide all the hostnames that are running ZK): port of zk(usually 2181): rootdir of hbase in HDFS(usually its "/hbase") Hope this helps. ~Anil On Fri, May 2, 2014 at 5:29 PM, Sanjeev Chakravarty <[email protected]>wrote: > Hi Anil, > > Glad to hear that you were able to make Squirrel work. I'm struggling to > make it work with my cluster, I'm using HBase 0.98.0 and Phoneix 4.0.0 > > Could you provide me with the values you provided to this construct? > > jdbc:*phoenix*:<ZK>:<port>:<rootdir>:<keytab>:<principal> > > Thanks, > > Sanjeev Chakravarty > Principal Member of Staff > Badgeville > > On May 1, 2014, at 3:17 PM, anil gupta <[email protected]> wrote: > > Woohoo..Got it working on a secure cluster. I had a mistake in connection > string. > I was missing ":phoenix" in my connection string. > Now, it works with this connection string: > jdbc:*phoenix*:<ZK>:<port>:<rootdir>:<keytab>:<principal> > > > > > > > > On Wed, Apr 30, 2014 at 11:54 AM, anil gupta <[email protected]>wrote: > >> Hi All, >> >> I was successful in connecting Phoenix to secure as part of my effort >> with Phoenix-19 jira. This was done using command line. >> Now, i want to use SQuirell to connect to a Secure HBase using Phoenix. >> Here is what i did: >> >> 1. I recompiled Phoenix with HBase0.94.19(HBase version with security >> stuff as default build) >> 2. I added the Phoenix JDBC client driver in SQuirel. >> 3. I put conf files for my secure cluster under lib directory so that >> they are in classpath. >> 4. In the connection URL i am passing: >> jdbc:<ZK>:<port>:<rootdir>:<keytab>:<principal> >> Note: I dont pass any parameters in UserName and Password for connection. >> Is that right? >> >> Can anyone tell me what extra steps i need to take? I am pretty new to >> Squirell. >> >> Squirel is running on Mac. I am using cdh4.6. >> >> -- >> Thanks & Regards, >> Anil Gupta >> > > > > -- > Thanks & Regards, > Anil Gupta > > > -- Thanks & Regards, Anil Gupta
