Reply
Explorer
Posts: 11
Registered: ‎01-31-2019

[unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation:

[ Edited ]

Hi,

I am using Hive/Impala ODBC Connection. I am able to connect with Hive ODBC and not with Impala ODBC

 

I am getting the following error.

 

[unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation: Preauthentication failed (SQL-HY000)

 

DBI connect('dsnname',username,...) failed: [unixODBC][Cloudera][ThriftExtension] (2) Error occured during authentication. (SQL-28000) .

 

[unixODBC][Cloudera][ThriftExtension] (6) Error occurred while contacting server: SSL_connect: error code: 0. This could be because you are trying to establish a SSL connection to a server that does not have SSL enabled. (SQL-HY000)

 

What are the parameters i need to check in odbc.ini file?

 

using same Kinit for Hive and Impala.

 

How to trouble shoot this issue?

 

 

Can anyone help? 

 

Thanks.

 

Explorer
Posts: 11
Registered: ‎01-31-2019

Re: [unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation:

TEUtils::DeriveKerberosHostFQDN: Special value _HOST specified for Host FQDN connfiguration. Using abcde for Host FQDN instead.

ERROR Connection::SQLConnectW: [Cloudera][ThriftExtension] (2) Error occured during authentication.


DSConnecionUtils::ReadConnectionSetting: Successfully read AuthMech from connection string/DSN.
DSConnectionUtils::ReadBooleanSetting: +++++ enter +++++
TRACE DSConnectionUtils::ReadSetting: +++++ enter +++++
DEBUG DSConnecionUtils::ReadSetting: Reading UseSASL from connection string/DSN.
TRACE DSConnectionUtils::ReadConnectionSetting: +++++ enter +++++
TRACE DSConnectionUtils::ReadConnectionSetting: +++++ enter +++++
DEBUG DSConnecionUtils::ReadConnectionSetting: UseSASL not available from connection string/DSN. Trying the aliases if any.
DEBUG DSConnecionUtils::ReadConnectionSetting: No alias available for UseSASL.
DEBUG DSConnecionUtils::ReadSetting: UseSASL not available from connection string/DSN. Reading it from driver wide configurations.
TRACE DSConnectionUtils::ReadDriverWideSetting: +++++ enter +++++
DEBUG DSConnecionUtils::ReadDriverWideSetting: UseSASL not available from driver-wide configurations. Trying the aliases if any.
DEBUG DSConnecionUtils::ReadDriverWideSetting: No alias available for UseSASL.
TRACE DSConnectionUtils::ReadUTF8StringSetting: +++++ enter +++++
TRACE DSConnectionUtils::ReadSetting: +++++ enter +++++
DEBUG DSConnecionUtils::ReadSetting: Reading UID from connection string/DSN.

Explorer
Posts: 11
Registered: ‎01-31-2019

Re: [unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation:

[unixODBC][Cloudera][ThriftExtension] (6) Error occurred while contacting server: SSL_connect: error code: 0. This could be because you are trying to establish a SSL connection to a server that does not have SSL enabled.

 

 

when

 

Description=
Driver=
HOST=

PORT=
Database=dbname
AuthMech=4
UID=username
PWD=password
SSL=1
CAIssuedCertNamesMismatch=1
TrustedCerts=
KrbFQDN=
KrbRealm=
KrbServiceName=
TSaslTransportBufSize=1000
RowsFetchedPerBlock=10000
SocketTimeout=0
StringColumnLength=32767
UseNativeQuery=0

Highlighted
Explorer
Posts: 11
Registered: ‎01-31-2019

Re: [unixODBC][Cloudera][KerberosSupport] Error occurred during Kerberos library operation:


DBI connect() failed: [unixODBC][Cloudera][ThriftExtension] (5) Error occurred while contacting server:
No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

 

 


DBI connect('',...) failed: [unixODBC][Cloudera][KerberosSupport] (0) Error occurred during Kerberos library operation: Preauthentication failed


DBI connect('',...) failed: [unixODBC][Cloudera][ThriftExtension] (5) Error occurred while contacting server: No more data to read..
This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

DBI connect('',...) failed: [unixODBC][Cloudera][ThriftExtension] (2) Error occured during authentication.