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.

Impala ODBC connection fails with ssl errors.

Impala ODBC connection fails with ssl errors.

Explorer

cdsw1.PNG

 

Hi Team,

 

Impala ODBC driver connection fails with SSL error.

 

Note: we haven't enabled SSL for any of the service in the cluster.

6 REPLIES 6
Highlighted

Re: Impala ODBC connection fails with ssl errors.

Explorer

Re: Impala ODBC connection fails with ssl errors.

Master Collaborator

But from the error message it looks like the service is using SSL. Are you sure that you are not using the ClouderaManager's Auto TLS feature? Verify it in the Impala Service configuration.

Re: Impala ODBC connection fails with ssl errors.

Guru
Hi,

Please also check what was the error reported on the Impala side in Impala Daemon logs, which is normally under /var/log/impalad. You need to know which host you connect to, and if you use LB, you need to trace it as it might be hard to determine.

Check in your ODBC driver if you have SSL connection ticked something in the configuration.

Cheers
Eric

Re: Impala ODBC connection fails with ssl errors.

Explorer

Hi ,

@Tomas79  No where in the cluster SSl is enabled for any of the service.

Re: Impala ODBC connection fails with ssl errors.

Explorer

Hi @EricL 

I dont see any error related to SSL in impala daemon logs,we haven't checked anything related to SSL in ODBC driver settings.

Note: He connected successfully a few days ago ,but all of a sudden this issue raised.

 

Thanks

Re: Impala ODBC connection fails with ssl errors.

Guru
Hi @Harish19,

There is SSL Options button somewhere in the ODBC driver configuration window, please click through and confirm if you have SSL enabled on the client side.

Cheers
Eric