Streamlit fails with SSL: CERTIFICATE_VERIFY_FAILED when launched from virtual environment, yet runs fine otherwise

Using Streamlit
1

All,

The issue:
When streamlit is installed into virtual environment, the app fails with SSL: CERTIFICATE_VERIFY_FAILED. However, when very same app is launched outside of virtual env, all works well.
The app connects to company Snowflake account.

  1. Why would SSL: CERTIFICATE_VERIFY_FAILED be raised only when streamlit started from venv?
  2. Any thought how to address this issue?

Error body:
File “/home//GitHub/sf_cortex_venv/.venv/lib/python3.10/site-packages/urllib3/util/retry.py”, line 519, in increment

  • raise MaxRetryError(_pool, url, reason) from reason # type: ignore[arg-type]*
    urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host=‘ACCOUNT_ID_dev.us-east-1.privatelink.snowflakecomputing.com’, port=443): Max retries exceeded with url: /api/v2/cortex/analyst/message (Caused by SSLError(SSLCertVerificationError(1, “[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Hostname mismatch, certificate is not valid for ‘ACCOUNT_ID_dev.us-east-1.privatelink.snowflakecomputing.com’. (_ssl.c:1007)”)))

Thank you

3 Likes
2

Adding

import ssl

ssl._create_default_https_context = ssl._create_unverified_context

seems to work well!