Certificate verification failed while connecting to Cloudera Impala connector.
Article ID: KB0079184
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Cloudera Impala | All Versions |
| Spotfire Web Player | - |
Description
While connecting to the Impala data source via ODBC connection i.e. using system/user ODBC with SSL, the connection is working but with Impala connector connection, it is throwing below error
The data source does not exist or it does not respond. External error: ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_connect: certificate verify failed ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_connect: certificate verify failed
Issue/Introduction
Certificate verification failed while connecting to Cloudera Impala connector giving error "ERROR [HY000] [Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: SSL_connect: certificate verify failed"
Environment
All Supported OS
Resolution
Check below points on both Spotfire Analyst and Node Manager machines to resolve above error :
1) In the User/System DSN, we can add a certificate path from any drive location, for example: D:\TIBCO_bundle.pem whereas the Impala connector picks the required certificate always from the driver installation path(Example: C:\Program Files\Cloudera ODBC Driver for Impala\lib). So, make sure that the correct certificate is present inside the driver installation directory.
2) It is also possible, that multiple certificate files are present inside the installation directory of Impala driver but TIBCO Spotfire Impala connector always makes use of certificate having the name 'cacerts.pem'.
1) In the User/System DSN, we can add a certificate path from any drive location, for example: D:\TIBCO_bundle.pem whereas the Impala connector picks the required certificate always from the driver installation path(Example: C:\Program Files\Cloudera ODBC Driver for Impala\lib). So, make sure that the correct certificate is present inside the driver installation directory.
2) It is also possible, that multiple certificate files are present inside the installation directory of Impala driver but TIBCO Spotfire Impala connector always makes use of certificate having the name 'cacerts.pem'.
Additional Information
Feedback
Yes
No
Powered by
