question Re: Error while Setting up ODBC in Support Questions

Error while Setting up ODBC

GoldDigger — Thu, 30 Mar 2023 15:44:47 GMT

I am getting following error message while trying to set up ODBC.

I am using SSL connection to connect.

[Cloudera] [ImpalaODBC] (100) Error from the Impala Thrift API: authorize: cannot authorize peer

Re: Error while Setting up ODBC

VidyaSargur — Thu, 30 Mar 2023 16:56:57 GMT

@GoldDigger Welcome to our community! To help you get the best possible answer, I have tagged in our Impala experts @ChethanYM, @Chella @ShankerSharma who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Re: Error while Setting up ODBC

ChethanYM — Fri, 31 Mar 2023 09:51:43 GMT

Hi,

What is the authentication mechanism given in driver?

Can you change the Authentication in driver to Kerberos and provide the user kerberos credentials user and give a try?

Regards,

Chethan YM

Re: Error while Setting up ODBC

GoldDigger — Fri, 31 Mar 2023 17:11:47 GMT

@ChethanYM I am using Authentication mechanism as User Name and Password. As per company policy that's only valid mechanism to be use.

Re: Error while Setting up ODBC

GoldDigger — Mon, 03 Apr 2023 14:38:59 GMT

Thanks I was able to resolve the issue. It needed another tick in enable SSL.