Hello Everyone, has anyone succeeded with connecting Airbyte to GCP Cloud SQL database? I can’t connect to it. I’m using Kustomize to apply custom connection credentials

│ 2023-01-10T15:16:35.983Z    ERROR    Unable to create SQL database.    {"error": "unable to connect to DB, tried default DB names: postgres,defaultdb, errors: [pq: pg_hba.conf rejects connection for host \"**\", user \"airbyte\", database \"postgres\", no encryption pq: pg_hba.conf rejects connection for host \"**\", user \"airbyte\", database \"defaultdb\", no encryption]", "logging-call-at": "handler.go:97"}
2023/01/10 15:16:36 Loading config; env=docker,zone=,configDir=config                                                                                                                                                     
2023/01/10 15:16:36 Loading config files=[config/docker.yaml]

Hello Mateusz, are you following a doc that you can link here?

Unfortunately, your docs cover only Docker Compose installation, where I’m running my instance on Kubernetes. I’m aware that issue is SSL-related, but can’t find correct config to leverage Docker-compose solution described in your docs - https://docs.airbyte.com/operator-guides/configuring-airbyte-db

That's great to hear! Could you please give me more details on how you resolved this? It would be really helpful for the community.

Long story short we had to pass connection to Cloud SQL database using private network route to leverage SSL certificate. We run our Airbyte on GKE K8s

Got it, thanks!