Skip to main content
GoldDigger
Gold ⭐️
Mar 30, 2023 3:44 PM UTC
Solved

Error while Setting up ODBC

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

GoldDigger
Gold ⭐️
Apr 3, 2023 2:39 PM UTC

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

4 replies

VidyaSargur
Community Manager
Community Manager
Mar 30, 2023 4:56 PM UTC

@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.

Translate
Regards, Vidya Sargur Madabhushi| Senior Community Manager | Was your question answered? Make sure to mark the answer as the Best Answer. If you find a reply useful, say thanks by clicking on the thumbs up button.
ChethanYM
Gold ⭐️
Gold ⭐️
Mar 31, 2023 9:51 AM UTC

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

Translate
GoldDigger
Gold ⭐️
Mar 31, 2023 5:11 PM UTC

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

Translate
GoldDigger
GoldDiggerAuthorAnswer
Gold ⭐️
Apr 3, 2023 2:39 PM UTC

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

Translate