You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Sumanta Gh <su...@tcs.com> on 2018/07/23 05:11:40 UTC

Phoenix 5 connection URL issue

Hi, 

I am trying to connect a Kerberos enabled Hbase 2.0 cluster from Phoenix 5.0 client (sqlline).

This is my connection URL -

jdbc:phoenix:Zk1,Zk2,Zk3:2181:/hbase:sumanta@EXAMPLE.COM:~/sumanta.keytab 

I am getting following error in SqlLine.

Error: ERROR 102 (08001): Malformed connection url

Could anybody let me know if the correct connection URL.

Regards
 Sumanta Ghosh
 Innovations Lab
 Tata Consultancy Services
 Ph:- +91 33 6688 4689
 Mailto: sumanta.gh@tcs.com
 Website: http://www.tcs.com
 ____________________________________________
 Experience certainty.	IT Services
 			Business Solutions
 			Consulting
 ____________________________________________
 
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you



Re: Phoenix 5 connection URL issue

Posted by Josh Elser <el...@apache.org>.
Use the absolute path to your keytab, not the tilde character to refer 
to your current user's home directory.

On 7/23/18 1:11 AM, Sumanta Gh wrote:
> Hi,
> 
> I am trying to connect a Kerberos enabled Hbase 2.0 cluster from Phoenix 
> 5.0 client (sqlline).
> 
> This is my connection URL -
> 
> jdbc:phoenix:Zk1,Zk2,Zk3:2181:/hbase:sumanta@EXAMPLE.COM 
> <ma...@TCUPIOT.COM>:~/sumanta.keytab
> 
> I am getting following error in SqlLine.
> 
> Error: ERROR 102 (08001): Malformed connection url
> 
> Could anybody let me know if the correct connection URL.
> 
> Regards
> Sumanta Ghosh
> Innovations Lab
> Tata Consultancy Services
> Ph:- +91 33 6688 4689
> Mailto: sumanta.gh@tcs.com <ma...@tcs.com>
> Website: http://www.tcs.com
> ____________________________________________
> Experience certainty. IT Services
> Business Solutions
> Consulting
> ____________________________________________
> 
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>