Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAPCS4qo1jpaAYJd5kvgqTY=UO4kFw_8cDqXUsh7zAkODt48dew@mail.gmail.com>
References: 
 <CAPCS4qo1jpaAYJd5kvgqTY=UO4kFw_8cDqXUsh7zAkODt48dew@mail.gmail.com>
Date: Tue, 24 Nov 2015 08:24:18 +0000
Message-ID: 
 <CACZgR251x2PXkDmu8ywc8WTUDcovYaFGbXmTfPdF6j2y=_ONmA@mail.gmail.com>
Subject: Re: Unable to connect to beeline after kerberos is installed
From: Arpan Rajani <arpan.rajani@whishworks.com>
To: user@hive.apache.org
Cc: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a1134f9da702d7a0525451143

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

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_HiveServer=
2>=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 thi=
s
> 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 ty=
pe
> PLAIN
>         at
> org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSa=
slServerTransport.java:219)
>         at
> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingT=
ransportFactory$1.run(HadoopThriftAuthBridge.java:739)
>         at
> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingT=
ransportFactory$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(UserGroupInformation=
.java:1651)
>         at
> org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingT=
ransportFactory.getTransport(HadoopThriftAuthBridge.java:736)
>         at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolS=
erver.java:268)
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java=
:1145)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav=
a: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(TSaslTrans=
port.java:232)
>         at
> org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(T=
SaslServerTransport.java:138)
>         at
> org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271)
>         at
> org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTranspor=
t.java:41)
>         at
> org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSa=
slServerTransport.java:216)
>         ... 10 more
>
>
>
>
>
>
>
> Thanks
> Jay
>

--=20
The contents of this e-mail are confidential and for the exclusive use of=
=20
the intended recipient. If you receive this e-mail in error please delete=
=20
it from your system immediately and notify us either by e-mail or=20
telephone. You should not copy, forward or otherwise disclose the content=
=20
of the e-mail. The views expressed in this communication may not=20
necessarily be the view held by WHISHWORKS.

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

<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 class=3D"gmail_quote">On 24 Nov 2015 1:55 am, &quot;Kumar Jayapal&quot=
; &lt;<a href=3D"mailto:kjayapal17@gmail.com">kjayapal17@gmail.com</a>&gt; =
wrote:<br type=3D"attribution"><blockquote class=3D"gmail_quote" style=3D"m=
argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"l=
tr"><div>Unable to connect to beeline after kerberos is installed I am gett=
ing 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 client =
transport with JDBC Uri: jdbc:hive2://<a href=3D"http://hiven001.np.mmc.com=
:10000/" target=3D"_blank">hiven001.np.mmc.com:10000/</a>: Peer indicated f=
ailure: 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 processi=
ng of message.</div><div>java.lang.RuntimeException: org.apache.thrift.tran=
sport.TTransportException: Unsupported mechanism type PLAIN</div><div>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSaslServerTranspor=
t$Factory.getTransport(TSaslServerTransport.java:219)</div><div>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$S=
erver$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:739)</=
div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.hive.thrift.Hadoo=
pThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAut=
hBridge.java:736)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.security.Ac=
cessController.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.UserGroupInformation=
.doAs(UserGroupInformation.java:1651)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumin=
gTransportFactory.getTransport(HadoopThriftAuthBridge.java:736)</div><div>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.server.TThreadPoolServer$W=
orkerProcess.run(TThreadPoolServer.java:268)</div><div>=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec=
utor.java:1145)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.util.concurre=
nt.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 me=
chanism type PLAIN</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thri=
ft.transport.TSaslTransport.sendAndThrowMessage(TSaslTransport.java:232)</d=
iv><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSaslSer=
verTransport.handleSaslStartMessage(TSaslServerTransport.java:138)</div><di=
v>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.TSaslTransport=
.open(TSaslTransport.java:271)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org=
.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.jav=
a:41)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.thrift.transport.=
TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216)</d=
iv><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 ... 10 more</div><div><br></div></div><=
div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><=
div><br></div>Thanks<div>Jay</div></div></div></div>
</div>
</blockquote></div>

<br>
<span style=3D"color:rgb(34,34,34);font-family:arial,sans-serif">The conten=
ts of this e-mail are confidential and for the exclusive use of the intende=
d 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 vie=
ws expressed in this communication may not necessarily be the view held by =
WHISHWORKS.</span>
--001a1134f9da702d7a0525451143--