CA Certificates Error when trying to connect with Impala Driver LINUX

mv3 — Tue, 31 Mar 2020 20:01:32 GMT

I followed the instructions here for setting up and configuring the Impala driver on Linux. When I test the connection using the isql command line utility I get the following error:

[S1000][unixODBC][Cloudera][DriverSupport] (1140) Unable to load CA certificates from certs file location. Please ensure the file exists, has read permission, and has the correct PEM format. [ISQL]ERROR: Could not SQLConnect

My odbc.ini looks like this:

[ODBC Data Sources] [hadoop] Driver=Cloudera ODBC Driver for Impala 64-bit AllowHostNameCNMismatch=1 AllowSelfSignedServerCert=1 AuthMec=3 CheckCertRevocation=1 DelegateKrbCreds=0 Host={myhost} KrbFQDN=_HOST KrbRealm={myrealm} KrbServiceName=impala Min_TLS=1.2 Port=21050 ServicePrincipalCanonicalization=1 SSL=1 TrustedCerts=/opt/cloudera/impalaodbc/lib/64/cacerts.pem UseKeytab=0 UseOnlySSPI=1 UseSASL=1 UseSystemTrustStore=1

And the permission on /opt/cloudera/imapalaodbc/lib/64/cacerts.pem is set to 777:

-rwxrwxrwx 1 userXXX groupXXX 246K Dec 31 2018 /opt/cloudera/impalaodbc/lib/64/cac erts.pem

Can anyone help resolve this error? The cacerts.pem file has the right permission and the file certainly exists.

Re: CA Certificates Error when trying to connect with Impala Driver LINUX

mv3 — Tue, 31 Mar 2020 17:52:43 GMT

Oops. Reading the docs it mentions "UseSystemTrustStore" is only valid for windows. Removing this value from by odbc.ini fixes this issue.

question Re: CA Certificates Error when trying to connect with Impala Driver LINUX in Support Questions

CA Certificates Error when trying to connect with Impala Driver LINUX

Re: CA Certificates Error when trying to connect with Impala Driver LINUX