admin管理员组文章数量:1608635
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/POM/4.0.0" 2 xmlns:xsi="http://www.w3/2001/XMLSchema-instance" 3 xsi:schemaLocation="http://maven.apache/POM/4.0.0 https://maven.apache/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>
具体手动依赖,如下所示:
嗯,上面的方法确实有点麻烦,如果想省事,可以使用此链接下载即可:
https://jar-download/?search_box=clickhouse-jdbc
本文标签: 连接不上服务器DBeaverclickhouse
版权声明:本文标题:Dbeaver连接不上远程服务器部署的Clickhouse问题 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1728550572a1163379.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论