You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by anil gupta <an...@gmail.com> on 2014/05/02 00:17:03 UTC
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
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 <an...@gmail.com> 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
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
Posted by anil gupta <an...@gmail.com>.
Hi James,
Yah, the patch is ready. I'll remove some unwanted log statement from my
code and submit it over weekend for review.
Also, i compiled Phoenix with HBase0.94.19 on my machine and used
phoenix-client.jar(instead of phoenix-client-without-hbase.jar) to connect
to a secure cluster. I was able to connect to secure cluster without
hacking the classpath. :)
So, maybe we should plan to update phoenix to HBase0.94.19 release.
Thanks,
Anil Gupta
On Fri, May 2, 2014 at 6:19 PM, James Taylor <ja...@apache.org> wrote:
> Awesome, Anil! Congrats. Is your patch on PHOENIX-19 current and ready for
> review? There have been a few fixes in the area of properties, so suspect
> you won't need the work around you have in there for
> QueryConnectionServicesImpl.
>
> Thanks, and great job!
>
> James
>
>
> On Thu, May 1, 2014 at 3:17 PM, anil gupta <an...@gmail.com> 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 <anilgupta84@gmail.com
> >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
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
Posted by anil gupta <an...@gmail.com>.
Hi James,
Yah, the patch is ready. I'll remove some unwanted log statement from my
code and submit it over weekend for review.
Also, i compiled Phoenix with HBase0.94.19 on my machine and used
phoenix-client.jar(instead of phoenix-client-without-hbase.jar) to connect
to a secure cluster. I was able to connect to secure cluster without
hacking the classpath. :)
So, maybe we should plan to update phoenix to HBase0.94.19 release.
Thanks,
Anil Gupta
On Fri, May 2, 2014 at 6:19 PM, James Taylor <ja...@apache.org> wrote:
> Awesome, Anil! Congrats. Is your patch on PHOENIX-19 current and ready for
> review? There have been a few fixes in the area of properties, so suspect
> you won't need the work around you have in there for
> QueryConnectionServicesImpl.
>
> Thanks, and great job!
>
> James
>
>
> On Thu, May 1, 2014 at 3:17 PM, anil gupta <an...@gmail.com> 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 <anilgupta84@gmail.com
> >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
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
Posted by James Taylor <ja...@apache.org>.
Awesome, Anil! Congrats. Is your patch on PHOENIX-19 current and ready for
review? There have been a few fixes in the area of properties, so suspect
you won't need the work around you have in there for
QueryConnectionServicesImpl.
Thanks, and great job!
James
On Thu, May 1, 2014 at 3:17 PM, anil gupta <an...@gmail.com> 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 <an...@gmail.com>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
>
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
Posted by James Taylor <ja...@apache.org>.
Awesome, Anil! Congrats. Is your patch on PHOENIX-19 current and ready for
review? There have been a few fixes in the area of properties, so suspect
you won't need the work around you have in there for
QueryConnectionServicesImpl.
Thanks, and great job!
James
On Thu, May 1, 2014 at 3:17 PM, anil gupta <an...@gmail.com> 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 <an...@gmail.com>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
>
Re: Use SQuirell to connect to Phoenix to a Secure HBase cluster
Posted by anil gupta <an...@gmail.com>.
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
<sa...@badgeville.com>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 <an...@gmail.com> 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 <an...@gmail.com>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