Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CACZgR251x2PXkDmu8ywc8WTUDcovYaFGbXmTfPdF6j2y=_ONmA@mail.gmail.com>
References: 
 <CAPCS4qo1jpaAYJd5kvgqTY=UO4kFw_8cDqXUsh7zAkODt48dew@mail.gmail.com>
	<CACZgR251x2PXkDmu8ywc8WTUDcovYaFGbXmTfPdF6j2y=_ONmA@mail.gmail.com>
Date: Tue, 24 Nov 2015 07:16:59 -0500
Message-ID: 
 <CAPCS4qoN11=cKJrkncZCaxHF0-ugXN9ZEArqN+jx8ocLbF45WQ@mail.gmail.com>
Subject: Re: Unable to connect to beeline after kerberos is installed
From: Kumar Jayapal <kjayapal17@gmail.com>
To: user@hive.apache.org
Cc: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a11c15ed287b8db0525485151

--001a11c15ed287b8db0525485151
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello Arpan and Neeraj,

Thanks for the response.  I have checked the setting in hive and sentry on
my production servers they are exactly the same. It works find in Prod but
not in my test environment. Is there any thing else I am missing.

Thanks
Jay


Thanks
Jay

On Tue, Nov 24, 2015 at 3:24 AM, Arpan Rajani <arpan.rajani@whishworks.com>
wrote:

> Hi Jay,
>
> I faced this and fixed yesterday.
> There are two things.
>
> 1)Before connecting to Hive server do you have a valid TGT?
> Do $ kinit user@Realm.com and get a valid TGT
>
> 2) in the jdbc connect string use the hive principle
> Use  "!connect
> jdbc:hive2://<host>:<port>/<db>;principal=3D<Server_Principal_of_HiveServ=
er2>=E2=80=9D.
>
>
> Please make sure it is the hive=E2=80=99s principal, not the user's.
>
> Restart the affected services. And it should work.
>
> Regards,
> Arpan
> On 24 Nov 2015 1:55 am, "Kumar Jayapal" <kjayapal17@gmail.com> wrote:
>
>> Unable to connect to beeline after kerberos is installed I am getting
>> this error. Let me know if an one has resolution for it.
>>
>> *Error: Could not open client transport with JDBC Uri:
>> jdbc:hive2://hiven001.np.mmc.com:10000/
>> <http://hiven001.np.mmc.com:10000/>: Peer indicated failure: Unsupported
>> mechanism type PLAIN (state=3D08S01,code=3D0)*
>>
>>
>> 2015-11-24 00:54:21,869 ERROR org.apache.thrift.server.TThreadPoolServer=
:
>> Error occurred during processing of message.
>> java.lang.RuntimeException:
>> org.apache.thrift.transport.TTransportException: Unsupported mechanism t=
ype
>> PLAIN
>>         at
>> org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TS=
aslServerTransport.java:219)
>>         at
>> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssuming=
TransportFactory$1.run(HadoopThriftAuthBridge.java:739)
>>         at
>> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssuming=
TransportFactory$1.run(HadoopThriftAuthBridge.java:736)
>>         at java.security.AccessController.doPrivileged(Native Method)
>>         at javax.security.auth.Subject.doAs(Subject.java:356)
>>         at
>> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformatio=
n.java:1651)
>>         at
>> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssuming=
TransportFactory.getTransport(HadoopThriftAuthBridge.java:736)
>>         at
>> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPool=
Server.java:268)
>>         at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.jav=
a:1145)
>>         at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja=
va:615)
>>         at java.lang.Thread.run(Thread.java:745)
>> Caused by: org.apache.thrift.transport.TTransportException: Unsupported
>> mechanism type PLAIN
>>         at
>> org.apache.thrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTran=
sport.java:232)
>>         at
>> org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(=
TSaslServerTransport.java:138)
>>         at
>> org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271)
>>         at
>> org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTranspo=
rt.java:41)
>>         at
>> org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TS=
aslServerTransport.java:216)
>>         ... 10 more
>>
>>
>>
>>
>>
>>
>>
>> Thanks
>> Jay
>>
>
> The contents of this e-mail are confidential and for the exclusive use of
> the intended recipient. If you receive this e-mail in error please delete
> it from your system immediately and notify us either by e-mail or
> telephone. You should not copy, forward or otherwise disclose the content
> of the e-mail. The views expressed in this communication may not
> necessarily be the view held by WHISHWORKS.

--001a11c15ed287b8db0525485151
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><br></div><div>Hello Arpan and Neeraj,</div><div><br>=
</div><div>Thanks for the response.=C2=A0 I have checked the setting in hiv=
e and sentry on my production servers they are exactly the same. It works f=
ind in Prod=C2=A0but not in my=C2=A0test environment. Is there any thing el=
se I am missing.</div><div><br></div><div>Thanks</div><div>Jay</div></div><=
div class=3D"gmail_extra"><br clear=3D"all"><div><div class=3D"gmail_signat=
ure"><div dir=3D"ltr"><div><br></div><div><br></div><div><br></div><div><br=
></div><div><br></div><div><br></div><div><br></div><div><br></div>Thanks<d=
iv>Jay</div></div></div></div>
<br><div class=3D"gmail_quote">On Tue, Nov 24, 2015 at 3:24 AM, Arpan Rajan=
i <span dir=3D"ltr">&lt;<a href=3D"mailto:arpan.rajani@whishworks.com" targ=
et=3D"_blank">arpan.rajani@whishworks.com</a>&gt;</span> wrote:<br><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc s=
olid;padding-left:1ex"><p dir=3D"ltr">Hi Jay, </p>
<p dir=3D"ltr">I faced this and fixed yesterday. <br>
There are two things. </p>
<p dir=3D"ltr">1)Before connecting to Hive server do you have a valid TGT? =
<br>
Do $ kinit user@Realm.com and get a valid TGT </p>
<p dir=3D"ltr">2) in the jdbc connect string use the hive principle <br>
Use=C2=A0 &quot;!connect jdbc:hive2://&lt;host&gt;:&lt;port&gt;/&lt;db&gt;;=
principal=3D&lt;Server_Principal_of_HiveServer2&gt;=E2=80=9D. </p>
<p dir=3D"ltr">Please make sure it is the hive=E2=80=99s principal, not the=
 user&#39;s. </p>
<p dir=3D"ltr">Restart the affected services. And it should work. </p>
<p dir=3D"ltr">Regards, <br>
Arpan <br>
</p><div><div class=3D"h5">
<div class=3D"gmail_quote">On 24 Nov 2015 1:55 am, &quot;Kumar Jayapal&quot=
; &lt;<a href=3D"mailto:kjayapal17@gmail.com" target=3D"_blank">kjayapal17@=
gmail.com</a>&gt; wrote:<br type=3D"attribution"><blockquote class=3D"gmail=
_quote" style=3D"margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-colo=
r:rgb(204,204,204);border-left-width:1px;border-left-style:solid"><div dir=
=3D"ltr"><div>Unable to connect to beeline after kerberos is installed I am=
 getting this error. Let me know if an one has resolution for it.</div><div=
><br></div><div><div><div dir=3D"ltr"><div><div><b>Error: Could not open cl=
ient transport with JDBC Uri: jdbc:hive2://<a href=3D"http://hiven001.np.mm=
c.com:10000/" target=3D"_blank">hiven001.np.mmc.com:10000/</a>: Peer indica=
ted failure: Unsupported mechanism type PLAIN (state=3D08S01,code=3D0)</b><=
/div></div><div><br></div><div><br></div><div><div>2015-11-24 00:54:21,869 =
ERROR org.apache.thrift.server.TThreadPoolServer: Error occurred during pro=
cessing of message.</div><div>java.lang.RuntimeException: org.apache.thrift=
.transport.TTransportException: Unsupported mechanism type PLAIN</div><div>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSaslServerTrans=
port$Factory.getTransport(TSaslServerTransport.java:219)</div><div>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridg=
e$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:739=
)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.hive.thrift.Ha=
doopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThrift=
AuthBridge.java:736)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.security=
.AccessController.doPrivileged(Native Method)</div><div>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 at javax.security.auth.Subject.doAs(Subject.java:356)</div><div>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.security.UserGroupInformat=
ion.doAs(UserGroupInformation.java:1651)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssu=
mingTransportFactory.getTransport(HadoopThriftAuthBridge.java:736)</div><di=
v>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.server.TThreadPoolServer=
$WorkerProcess.run(TThreadPoolServer.java:268)</div><div>=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolE=
xecutor.java:1145)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.util.concu=
rrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)</div><div>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.lang.Thread.run(Thread.java:745)</div><=
div>Caused by: org.apache.thrift.transport.TTransportException: Unsupported=
 mechanism type PLAIN</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.t=
hrift.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)=
</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSasl=
ServerTransport.handleSaslStartMessage(TSaslServerTransport.java:138)</div>=
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSaslTransp=
ort.open(TSaslTransport.java:271)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at =
org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.=
java:41)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transpo=
rt.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)=
</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 ... 10 more</div><div><br></div></di=
v><div><br></div><div><br></div><div><br></div><div><br></div><div><br></di=
v><div><br></div>Thanks<div>Jay</div></div></div></div>
</div>
</blockquote></div>

<br>
</div></div><span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif=
">The contents of this e-mail are confidential and for the exclusive use of=
 the intended recipient. If you receive this e-mail in error please delete =
it from your system immediately and notify us either by e-mail or telephone=
. You should not copy, forward or otherwise disclose the content of the e-m=
ail. The views expressed in this communication may not necessarily be the v=
iew held by WHISHWORKS.</span></blockquote></div><br></div>

--001a11c15ed287b8db0525485151--