question Re: Impala ODBC connection fails with ssl errors. in Support Questions

Impala ODBC connection fails with ssl errors.

Harish19 — Mon, 05 Aug 2019 16:39:03 GMT

Hi Team,

Impala ODBC driver connection fails with SSL error.

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

Re: Impala ODBC connection fails with ssl errors.

Bildervic — Mon, 05 Aug 2019 11:34:56 GMT

hi @Harish19
check here :
https://community.cloudera.com/t5/forums/forumtopicprintpage/board-id/Questions/message-id/13133/print-single-message/true/page/1

Re: Impala ODBC connection fails with ssl errors.

Tomas79 — Tue, 06 Aug 2019 15:25:33 GMT

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.

EricL — Fri, 09 Aug 2019 08:58:38 GMT

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.

Harish19 — Tue, 13 Aug 2019 06:52:54 GMT

Hi ,

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

Re: Impala ODBC connection fails with ssl errors.

Harish19 — Tue, 13 Aug 2019 06:58:06 GMT

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.

EricL — Tue, 13 Aug 2019 23:44:56 GMT

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