question Re: Cannot connect to Impala via ODBC in Archives of Support Questions (Read Only)

Cannot connect to Impala via ODBC

Tomas79 — Fri, 16 Sep 2022 13:30:35 GMT

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

Re: Cannot connect to Impala via ODBC

AcharkiMed — Wed, 25 Jul 2018 16:45:47 GMT

Hi @Tomas79

Check the value of your params

SSL=
UseSASL=

in odbc.ini

Re: Cannot connect to Impala via ODBC

Hadoopuser — Mon, 11 Feb 2019 06:52:37 GMT

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

Re: Cannot connect to Impala via ODBC

Hadoopuser — Thu, 28 Feb 2019 06:32:48 GMT

Re: Cannot connect to Impala via ODBC

Hadoopuser — Thu, 28 Feb 2019 06:43:20 GMT

@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

Re: Cannot connect to Impala via ODBC

Hadoopuser — Sat, 02 Mar 2019 04:18:07 GMT

Yes