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)?
Cognite DB Extractor error
Userlevel 2
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 variable
REQUESTS_CA_BUNDLE=path_to_pem_file
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.