Dbeaver连接不上远程服务器部署的Clickhouse问题

别先生

发布于 2021-03-02 10:41:19

12K0

发布于 2021-03-02 10:41:19

文章被收录于专栏：别先生别先生

1、Clickhouse连接端口默认8123，但是Clickhouse默认情况下不允许其他设备进行http连接，所以需要更改clickhouse的默认配置:

1 [root@master local]# vim /etc/clickhouse-server/config.xml

新增一行，默认是注释的，让本地服务可以远程连接远程部署的Clickhouse服务，如下所示：

如果不添加上面的配置，远程连接，报下面的错误，如下所示：

1 Unexpected driver error occurred while connecting to the database
2   ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
3   ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
4     ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
5     ClickHouse exception, code: 210, host: 192.168.110.133, port: 8123; Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
6       Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
7       Connect to 192.168.110.133:8123 [/192.168.110.133] failed: Connection refused: connect
8         Connection refused: connect
9         Connection refused: connect

2、Dbeaver连接Clickhouse的时候，所需的jar包通过Dbeaver可能下载不下来，此时可以先下载下来，然后手动依赖即可，不过有的需要下载的jar包很多，这个时候可以根据maven工程下载到本地，然后挑出来放到自己的目录，然后进行手动依赖即可。

 1 <project xmlns="http://maven.apache.org/POM/4.0.0"
 2     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 3     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
 4     <modelVersion>4.0.0</modelVersion>
 5     <groupId>com.bie</groupId>
 6     <artifactId>clickhouse</artifactId>
 7     <version>0.0.1-SNAPSHOT</version>
 8 
 9     <dependencies>
10         <dependency>
11             <groupId>ru.yandex.clickhouse</groupId>
12             <artifactId>clickhouse-jdbc</artifactId>
13             <version>0.2.6</version>
14         </dependency>
15     </dependencies>
16 </project>

具体手动依赖，如下所示：