Error connecting to ClickHouse database on non-standard port

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

When trying to connect Airbyte to ClickHouse on a non-standard port (9440), an error is encountered due to the port not being the default HTTP port (8123). The error message indicates the need to use port 8123 for HTTP connections. The user is looking for guidance on how to resolve this issue.


Question

Hey :wave: I’m new to airbyte and wanted to test it with clickhouse
I have all my credentials tested and connectivity form the machine to the database
When I try to set the connection I see this error in the logs
error":{"message":"State code: 07000; Error code: 9000; Message: Port 9000 is for clickhouse-client program\nYou must use port 8123 for HTTP.\n, server ClickHouseNode
I’m connecting to port 9440 cause the instance is available only on this port and it have to be a secure connection in the cli all works when I use --secure option but in airbyte it gives the error

can anyone point me to the right direction how to solve it ?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["clickhouse-connector", "port-error", "secure-connection", "non-standard-port"]
2

I’d guess that the cli is “clickhouse-client program”, whereas Airbyte is not. It is trying to communicate with your installation via HTTP and Clickhouse is listening to HTTP requests on port 8123. I think you’ll need to allow traffic on this port and then try again.
This is just a suggestion though. I never used Airbyte with ClickHouse before

3

I see so I would have to drop the security

4

Well, having a port open doesn’t necessarily mean you have less security. I’d check with management before opening a new port though

5

I was able to use 8443 port