S
S
Sergey Savostin2021-03-09 14:48:28
JDBC
Sergey Savostin, 2021-03-09 14:48:28

Connecting to Clickhouse with Dbeaver via SSH?

Initial data:
Client:
DBeaver CE 21.0.0.202103021012 (Mac OS)
JDBС ru.yandex.clickhouse.ClickHouseDriver 0.2.6 (tried also 0.2.5)
SSH tunnel (works exactly)
I connect to jdbc:clickhouse://127.0.0.1: 8123
Server:
Linux 5.4
Clickhouse server 21.2.5.5
clickhouse-jdbc-bridge is not needed right?

When connected:

Unexpected driver error occurred while connecting to the database
  ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 127.0.0.1, port: 44965; Connection reset
  ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 127.0.0.1, port: 44965; Connection reset
    ClickHouse exception, code: 1002, host: 127.0.0.1, port: 44965; Connection reset
    ClickHouse exception, code: 1002, host: 127.0.0.1, port: 44965; Connection reset
      Connection reset
      Connection reset

Why is the port not 3128? Moreover, it is different every time. Or is it local?
According to "ClickHouse exception, code: 1002" Google gives a lot of different things.

On server
curl http://127.0.0.1:8123
Ok.

Firewall turned off.

Has anyone been able to connect like this?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Slach, 2021-11-13
@Slach

618fb8e7c73c9053017279.png
Did you forget your username by chance?
Port 44965 is weird

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question