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