Connecting to clickhouse via dbeaver?

Question

Docker

Hello!
Can't connect to ClickHouse (KX) in Dbeaver. What I do:
1. Run KX in docker:

docker run -d -p 8123:8123 --name clickhouse-server yandex/clickhouse-server

2. I create a connection in DBeaver:

3. I perform a connection test, and I get an error:

Unexpected driver error occurred while connecting to database ClickHouse exception, message: Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect, host: localhost, port: 8123; Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect ClickHouse exception, message: Connect to localhost:8123 [localhost/0 :0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect, host: localhost, port: 8123; Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect Connect to localhost:8123 [localhost/0:0:0: 0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect
ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, message: Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0 .0.1] failed: Connection refused: connect, host: localhost, port: 8123; Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect
ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, message : Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect, host: localhost, port: 8123; Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0.0.1] failed: Connection refused: connect
Connect to localhost:8123 [localhost/0:0:0:0:0:0:0:1, localhost/127.0. 0.1] failed: Connection refused: connect
Connection refused: connect
Connection refused: connect

Container info:

Driver updated.
Please advise what is the problem.

Answer 1

KX tries to bind to the IPv6 address [:: 1] by default:
You need to find the line 0.0.0.0 in the /etc/clickhouse-server/config.xml file and uncomment it. Then restart the service.