Skip to main content
Solved

Cognite DB Extractor error

G
Committed

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)?
 

Best answer by Murad Sæter

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

 

View original
Did this topic help you find an answer to your question?

3 replies

Murad Sæter
Practitioner
  • Murad Sæter
  • Practitioner
  • 48 replies
  • Answer
  • June 25, 2024

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

 

Andre Alves
G
2 people like this
  • Andre Alves
    Andre Alves
  • G
    GOlivera
S
Committed
Forum|alt.badge.img+1

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

Murad Sæter
Mithila Jayalath
2 people like this
  • Murad Sæter
    Murad Sæter
  • Mithila Jayalath
    Mithila Jayalath
Murad Sæter
Practitioner
  • Murad Sæter
  • Practitioner
  • 48 replies
  • February 14, 2025

This is strange, python requests package has REQUESTS_CA_BUNDLE in their documentation as well https://requests.readthedocs.io/en/latest/user/advanced/

 

(and I have used REQUESTS_CA_BUNDLE myself)

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings