Подключение к clickhouse через dbeaver?

Question

[albertalexandrov]

Всем привет!

Не могу подключиться к ClickHouse (КХ) в Dbeaver. Что я делаю:

1. Запускаю КХ в докере:

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

2. Создаю в DBeaver connection:



3. Выполняю тест соединения, и получаю ошибку:

Unexpected driver error occurred while connecting to database
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
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
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

Информация о контейнере:



Драйвер обновлял.

Прошу подсказать, в чем проблема.

Answer 1

[RelieveRz]

КХ по умолчанию пытается привязаться к IPv6-адресу [:: 1]:

Нужно в файле /etc/clickhouse-server/config.xml найти строку 0.0.0.0 и раскомментировать ее. После этого перезагрузить сервис.