clickhouse系列之二:clickhouse遇到的報錯問題及解決方法

問題一,啟動報錯

啟動參數:

sudo clickhouse-server --config-file=/etc/clickhouse-server/config.xml

解決辦法,已經有了提示,Run under ‘sudo -u clickhouse’.

修改後啟動參數:

sudo -u clickhouse clickhouse-server --config-file=/etc/clickhouse-server/config.xml

成功啟動.

問題二,spark寫入報錯

ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 1.1.1.1, port: 8123; Connect to 1.1.1.1:8123 [/1.1.1.1] failed: Connection refused: connect
	at ru.yandex.clickhouse.ClickHouseConnectionImpl.initTimeZone(ClickHouseConnectionImpl.java:91)
	at ru.yandex.clickhouse.ClickHouseConnectionImpl.<init>(ClickHouseConnectionImpl.java:75)
	at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:58)
	at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:50)
	at ru.yandex.clickhouse.ClickHouseDriver.connect(ClickHouseDriver.java:32)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:270)
           

1.建立ClickHouse通用配置檔案vi /etc/metrika.xml，在檔案中添加如下内容：

<yandex>
	<networks>
	<ip>::/0</ip>
	</networks>
</yandex>
           

2.打開ClickHouse使用者配置檔案vi /etc/clickhouse-server/users.xml，找到networks節點，確定該節點下的ip節點值為::/0：

<networks incl="networks" replace="replace">
  <ip>::/0</ip>
</networks>
           

3.打開ClickHouse配置檔案vi /etc/clickhouse-server/config.xml，找到listen_host節點，将其值修改為::