Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot connect to Impala via ODBC

Solved Go to solution
Highlighted

Cannot connect to Impala via ODBC

Master Collaborator

Hi,

 does anybody know what exactly this error means?

[Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SASL(-1): generic failure: Failed to initialize security context: No credentials are available in the security package

 

I have a ODBC driver 2.5.41 connecting to Impala daemon, the user has a valid ticket in the Windows machine, but the driver refuse to connect. Mechanism is Kerberos, service name, keytab .. all configured in ODBC Setup.

 

The impala daemon does not show any particular meaningful message in the logs about the login attempt,

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Cannot connect to Impala via ODBC

Expert Contributor

Hi @Tomas79

Check the value of your params

SSL=
UseSASL=

in odbc.ini

View solution in original post

5 REPLIES 5
Highlighted

Re: Cannot connect to Impala via ODBC

Expert Contributor

Hi @Tomas79

Check the value of your params

SSL=
UseSASL=

in odbc.ini

View solution in original post

Highlighted

Re: Cannot connect to Impala via ODBC

Explorer

Hi

 

What are the values to be passed for these parameters

 

 

SSL= 1
UseSASL=0

 

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

Re: Cannot connect to Impala via ODBC

Explorer

<used SASL>

Highlighted

Re: Cannot connect to Impala via ODBC

Explorer

@Hadoopuser wrote:

Hi

 

What are the values to be passed for these parameters

 

 

SSL= 1
UseSASL=0

 

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



<used SASL>

Highlighted

Re: Cannot connect to Impala via ODBC

Explorer
Yes
Don't have an account?
Coming from Hortonworks? Activate your account here