question Re: Having trouble configuring hive odbc driver - SASL for Authentication in Archives of Support Questions (Read Only)

Having trouble configuring hive odbc driver - SASL for Authentication

kajar001 — Wed, 09 Dec 2015 21:59:29 GMT

Hi,

While trying to configure the odbc driver, I get the following error:

Driver Version: V2.0.5.1005
Running connectivity tests...
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Hortonworks][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. This error might be due to the server is not using SASL for authentication
TESTS COMPLETED WITH ERROR.

Does anyone know how to go about this. Appreciate your help.

Thanks

Re: Having trouble configuring hive odbc driver - SASL for Authentication

jstraub — Thu, 10 Dec 2015 06:22:26 GMT

Could you please validate your endpoints and make sure all the hostnames are correct?

If your env. is kerberized, then your ODBC Driver config file should a similar DSN as follows:

Description=Hortonworks Hive ODBC Driver DSN
Driver=/usr/lib/hive/lib/native/Linux-i386-32/libhortonworkshiveodbc32.so
DriverUnicodeEncoding=1
HOST=hive.example.com
PORT=10000
Schema=default
FastSQLPrepare=0
UseNativeQuery=0
HiveServerType=2
AuthMech=1
KrbHostFQDN=kdc.example.com
KrbServiceName=hive
KrbRealm=EXAMPLE.COM
UID=test

Could you share your ODBC configuration?

Re: Having trouble configuring hive odbc driver - SASL for Authentication

somyaspandey — Sat, 13 May 2017 04:12:08 GMT

Hi @Jonas Straub

My env. is kerberized I am able to successfully connect through authentication mechanism "Kerberos" . When i am trying to use authentication mechanism "User Name" I get following error -

[Hortonworks][ThriftExtension] (2) Error occured during authentication.

How can I resolve this issue ? Thanks!

Re: Having trouble configuring hive odbc driver - SASL for Authentication

snanubala — Wed, 14 Jun 2017 20:52:40 GMT

Hi Somya Pandey,

Could you please tell if you are able to resolve your issue.. and the resolution steps if so. Thanks.

Re: Having trouble configuring hive odbc driver - SASL for Authentication

mnath — Sat, 31 Mar 2018 06:05:03 GMT

@Somya Pandey

did this ever get resolved for you. Please share your resolution, if so. thanks.