dbt deps returns an error related to SSL Cert verification when behind VPN

[jordanperr]

When trying to build the entr_runtime image behind a corporate VPN, you will receive the following error:

External connection exception occurred: HTTPSConnectionPool(host='hub.getdbt.com', port=443): Max retries exceeded with url: /api/v1/index.json (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1129)')))

I have tried the following to fix this:

1. Install our root cert in the docker image following guidelines from stack overflow.

USER root
ADD MyRootCA.crt /usr/local/share/ca-certificates/MyRootCA.crt
RUN chmod 644 /usr/local/share/ca-certificates/MyRootCA.crt && update-ca-certificates

2. Set the environment variable REQUESTS_CA_BUNDLE to this cert:

REQUESTS_CA_BUNDLE=/usr/local/share/ca-certificates/MyRootCA.crt dbt deps

Possibly related to:

• [CT-2292] [Bug] HTTPSConnectionPool(host='hub.getdbt.com', port=443): Max retries exceeded with url: /api/v1/index.json (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED]  dbt-labs/dbt-core#7153
• SSL certificate verification errors when trying to run Python models  databricks/dbt-databricks#305