我按照Clickhouse网站上的说明安装了Clickhouse,但是当我运行clickhouse-client时,连接被拒绝:
root@guest:~# clickhouse-client
ClickHouse client version 1.1.54198.
Connecting to localhost:9000.
Code: 210. DB::NetException: Connection refused: (localhost:9000, 127.0.0.1)
服务器似乎正在运行:
root@guest:~# systemctl status clickhouse-server.service
● clickhouse-server.service - LSB: Yandex clickhouse-server daemon
Loaded: loaded (/etc/init.d/clickhouse-server; bad; vendor preset: enabled)
Active: active (exited) since Tue 2017-04-04 01:41:48 EDT; 28min ago
Docs: man:systemd-sysv-generator(8)
更新:似乎Clickhouse服务器找不到所需的一切:
root@guest:~# /etc/init.d/clickhouse-server condstart
Start clickhouse-server service: Include not found: clickhouse_remote_servers
Include not found: clickhouse_compression
Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
No directory, logging in with HOME=/
DONE
Ubuntu 16.04软件包有问题吗?
最佳答案
原来,默认配置尝试绑定到ipv6地址[:: 1]:
<Error> Application: Net Exception: Cannot assign requested address: [::1]:8123
从
/etc/clickhouse-server/config.xml
删除相关的行将其修复。