airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.33k stars 4.16k forks source link

[platform] Using external database without SSL #48504

Open wornjs opened 2 weeks ago

wornjs commented 2 weeks ago

Helm Chart Version

1.2.0

What step the error happened?

On deploy

Relevant information

When using an external database, airbyte-temporal is deployed with the assumption that SSL is always enabled, which causes connectivity issues with the database.

link

{{- if eq .Values.global.database.type "external" }}
        # Assume an external database requires SSL.
          - name: POSTGRES_TLS_ENABLED
            value: "true"
          - name: POSTGRES_TLS_DISABLE_HOST_VERIFICATION
            value: "true"
          - name: SQL_TLS_ENABLED
            value: "true"
          - name: SQL_TLS_DISABLE_HOST_VERIFICATION
            value: "true"
{{- end }}

Relevant log output

bgroff commented 15 hours ago

If you set the value of database.type: internal does this solve your issue? Do you want to be able to use ssl for the Airbyte Config database but not SSL for Temporal?