Error connecting to ClickHouse server with Airbyte destination configuration

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

Summary

The user is facing an error while trying to configure a destination in Airbyte with ClickHouse server. The error message indicates a connection timeout issue.


Question

Hello Team,
I try to to the thing with ClickHouse server on local.
The server is running at localhost:9000 and localhost:8123 is retuning OK.
After that i follow the documentation on the website to create airbyte_user.
But when i try to configure a destination with the following schema :

Port 8123
DB Name db_mutualisee
User airbyte_user
SSH Tunnel Method No Tunnel```
I receive this Error :
```Could not connect with provided configuration. java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60007ms (total=0, active=0, idle=0, waiting=0)```
What should i do ?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1727693513691649) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["clickhouse-server", "airbyte-destination", "connection-error", "configuration", "java-sql-transient-connection-exception"]
</sub>
2

Airbyte installed by abctl?

3

I cannot do that anymore ?

4

Airbyte is inside Docker container (abctl creates kind cluster https://kind.sigs.k8s.io/ Kubernetes on Docker), so different things are in different networks

5

Instead of localhost / 127.0.0.1, check host.docker.internal

6

https://stackoverflow.com/questions/24319662/from-inside-of-a-docker-container-how-do-i-connect-to-the-localhost-of-the-mach

7

Ok thanks i try this technic then

8

Seem to work thanks !