[S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.

OlivierW — Wed, 22 Sep 2021 10:05:08 GMT

Hello,

I'm trying to use a ODBC connexion with SAP BI 4.2 app, on linux environment.

Here are my settings :

--------- odbc.ini file -----------------

[ODBC Data Sources]
Impala=Simba Impala ODBC Driver (64-bit)

[Impala_TEST]
Description=Simba Impala ODBC Driver (64-bit)
Driver=/data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/libimpalaodbc_sb64.so
HiveServerType=2
ServiceDiscoveryMode=0
Host=portalgps.idf.fr.gin.intraorange
Port=443
schema=default
AuthMech=4
KrbFQDN=_HOST
UID=hive
ThriftTransport=2
HttpPath=/knox/cdp-proxy-api/hive

ServiceDiscoveryMode=0
AllowSelfSignedServerCert=1
UseNativeQuery=1

SSL=1
AllowSelfSignedCerts=1
CAIssuedCertNamesMismatch=1
TrustedCerts=/data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/cacerts.pem
TwoWaySSL=0

--------- odbcinst.ini -----------------
[ODBC Drivers]
Simba Impala ODBC Driver 64-bit=Installed
Impala_TEST=Installed

[Simba Impala ODBC Driver 64-bit]
Description=Simba Impala ODBC Driver (64-bit)
Driver=/data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/libimpalaodbc_sb64.so

[Impala_TEST]
Description=Simba Impala ODBC Driver (64-bit)
Driver=/data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/libimpalaodbc_sb64.so

------------

check that the certificate file cacerts.pem exists and is on 777 rights :

[admin@DVO1T-CMS04 bin]$ ll /data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/cacerts.pem
-rwxrwxrwx 1 admin admin 5844 Sep 21 16:54 /data/BO/sap_bobj/enterprise_xi40/linux_x64/odbc/simbaimpala/2.0/lib/cacerts.pem

Test with unixODBC isql :

[admin@DVO1T-CMS04 bin]$ isql -v Impala_TEST <myuser> <password>
[S1000][unixODBC][SAP][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

Does anyone know what's wrong on my setting ?

Thank you

Re: [S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.

OlivierW — Tue, 28 Sep 2021 12:48:16 GMT

Nobody has the same issue ?

Re: [S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.

OlivierW — Thu, 07 Oct 2021 08:58:00 GMT

Problem solved. Was due to the bad format (special characters) of pem file.

I close the question.

question Re: [S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location. in Support Questions

[S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.

Re: [S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.

Re: [S1000][unixODBC][SAP][DriverSupport] (1140) Unable to load CA certificates from certs file location.