Cognite DB Extractor error

Question

I'm trying to run the Cognite DB Extractor via CMD window (as administrator, as local user...) but I get always this error (see log):

requests.exceptions.SSLError: HTTPSConnectionPool(host='datamosaix-prod.us.auth0.com', port=443): Max retries exceeded with url: /oauth/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1007)')))
[1288] Failed to execute script '__main__' due to unhandled exception!

I think this is because a proxy server is being used to access the internet from this VM. However, I'm using the same VM as the PI extractor and that is running fine (I had to do some settings in the PiExtractor.exe.config file in the bin folder of PI extractor as documented)

I have set the following windows environment variables (This worked on the OPC UA extractor VM):

HTTP_PROXY
HTTPS_PROXY
ALL_PROXY

I have installed root CA certificate of Proxy (ZSCALER) for local user account, for computer account and for service account
No success

Anything else that needs to be configured for this DB extractor (when using a proxy)?

Murad Sæter · Accepted Answer

The Cognite DB extractor is python based and doesn’t use the windows certificate store.With python’s requests module you can use the env variableREQUESTS_CA_BUNDLE=path_to_pem_file

SteveDelVecchio · Answer

Hello,There’s an error in this anwser the actual name for the environment variable is REQUEST_CA_BUNDLE. I have wasted a lot of time because of this naming being wrong because I had the same issue as GOlivera on my end.PI ASSETFRAMEWORK and PI ARCHIVE was working and not DB Extractor.Good day to all

Sign up

Welcome to Cognite Hub