Google cloud sql Postgres python connector ssl error

Google Cloud Database
6

If you’re using Python 3.10, ssl.PROTOCOL_TLS_CLIENT should be ok. . Here are a few things you can try:

  • Check your Python installation’s certificate store: Python uses its own certificate store independent of your operating system’s certificate store. If the certificate store of your Python installation is out of date or corrupted, it could lead to this error. You can update the certificate store for Python using the certifi package. You can install it with pip:

pip install --upgrade certifi
``

  • Verify the SSL_CERT_FILE environment variable: If the SSL_CERT_FILE environment variable is set in your system, make sure it points to the correct location of the CA certificates file.
  • Disable SSL verification (not recommended for production): As a last resort, and only for local development, you can try disabling SSL verification by setting the PYTHONHTTPSVERIFY environment variable to 0. This is generally not recommended as it makes your connections insecure, but can help you debug if the issue is with SSL verification:

export PYTHONHTTPSVERIFY=0

If still getting you an error, could you please share the exact error message you’re getting?