clickhouse-在启用listen host 0.0.0.0之后，客户端无法登录

Question

在Hyper-V虚拟机的Ubuntu18.04.2上安装ClickHouse后，我在虚拟机内部使用clickhouse-client进行连接，它工作得很好。

我使用主机中的浏览器打开http://127.27.16.11:8123，它显示ERR_CONNECTION_REFUSED错误。然后编辑/etc/ clickhouse-server /config.xml，取消注释0.0.0.0并重新启动clickhouse-server。我刷新了浏览器，它显示了OK状态。

但是，当我在虚拟机中使用clickhouse-client再次连接服务器时，它提示连接被拒绝。有没有办法同时启用本地和远程连接？

我还尝试启用IPv4和IPv6 :：0.0.0.0

ubuntu02:/$ clickhouse-client
ClickHouse client version 19.11.3.11 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.11.3 revision 54423.

ubuntu02 :) quit
Bye.

ubuntu02:/$ sudo vi /etc/clickhouse-server/config.xml
[sudo] password for panco:

##uncomment
<listen_host>0.0.0.0</listen_host>

ubuntu02:/$ ping ubuntu02
PING ubuntu02 (172.27.16.11) 56(84) bytes of data.
64 bytes from ubuntu02 (172.27.16.11): icmp_seq=1 ttl=64 time=0.015 ms
64 bytes from ubuntu02 (172.27.16.11): icmp_seq=2 ttl=64 time=0.040 ms
^C
--- ubuntu02 ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3039ms
rtt min/avg/max/mdev = 0.015/0.033/0.040/0.012 ms

ubuntu02:/$ sudo service clickhouse-server restart

ubuntu02:/$ clickhouse-client
ClickHouse client version 19.11.3.11 (official build).
Connecting to localhost:9000 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9000)

代码: 210。DB::NetException:连接被拒绝(localhost:9000)

Answer 1

找到了答案，我太专注于我使用的那些IP是IPv4，实际上，Ubuntu默认安装时启用了IPv6。它只是简单地取消对这一行的注释

<listen_host>::</listen_host> 

问题解决了。无论如何，感谢Slesh的友好回复。

Answer 2

您可以指定几个要侦听的主机。尝试此配置：

<!-- Listen specified host. use :: (wildcard IPv6 address), if you want to accept connections both with IPv4 and IPv6 from everywhere. -->
<listen_host>::</listen_host>
<!-- Default values - try listen localhost on ipv4 and ipv6: -->
<listen_host>::1</listen_host>
<listen_host>127.0.0.1</listen_host>

Answer 3

试试这个：

clickhouse-client -h 127.0.0.1