Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SSL_MODE destination settings Clickhouse #79

Open
agilRom1 opened this issue Feb 15, 2024 · 1 comment
Open

SSL_MODE destination settings Clickhouse #79

agilRom1 opened this issue Feb 15, 2024 · 1 comment

Comments

@agilRom1
Copy link

          Similar issue here too. I can set NO SSL and NO TUNNEL settings using the TF provider, but as shown in the screenshots above, it seems to be ignore. Additionally, if I test the connection, it fails (the connection test). However, if I manually set NO SSL and NO TUNNEL in the UI and change _nothing_ else, the test connection suceeds.

Originally posted by @alex-gregory-unmind in #26 (comment)

@agilRom1
Copy link
Author

I am trying to make trivial connection in Airbyte using Terraform.
Using the right documentation...from https://registry.terraform.io/providers/airbytehq/airbyte/latest/docs/resources/destination_clickhouse

resource "airbyte_destination_clickhouse" "my_destination_clickhouse" { configuration = { database = "...my_database..." host = "...my_host..." jdbc_url_params = "...my_jdbc_url_params..." password = "...my_password..." port = 8123 tunnel_method = { no_tunnel = {} } username = "Rhianna_Leannon" } definition_id = "2c276398-b468-48ad-b426-53c327fa18b5" name = "Gerardo Corwin" workspace_id = "4f41e22e-39b6-461a-89af-71290b2c6d65" }

But when I test the connection, I get the strange error:
"Unsupported or unrecognized SSL message, server ClickHouseNode [uri=https://localhost:8123/default, options={sslmode=NONE,socket_timeout=3000000}]"

As sslmodeis not a required param for clickhouse, I tried to set it from mssql/postgres/mysql syntax but it always end up like "NONE".

Same like @alex-gregory-unmind in #26 (comment) ...

When I toggle on/off SSL connection in Airbyte UI... Connection test finish successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant