Connection to ClickHouse fails with SSL error #25009
Description
I have deployed OpenMetadata using quickstart guide.(https://docs.open-metadata.org/latest/quick-start/local-docker-deployment)
I also modified it a bit to not use hardcoded credentials in docker compose and added Nginx, where SSL termination happens.
What is the issue:
When trying to configure ClickHouse connector using HTTPS(http is forbidden), it returns the following error "Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1017)'))"
I may suppose such behavior happening due to certificates being issued by custom CA. I tried to add root CA to both openmetadata and ingestion using keytool for openmetadata container and update-ca-certificates for Airflow container, but the error persists.
UPD: Curl from container internal terminal returns Ok. The issue is with the Airflow python application itself.
Maybe I missed some configuration variable? What is the recommended approach to proceed with in such scenarios?