Connecting to ClickHouse from external network

[Oleg K]

Hi!

I've just installed ClickHouse and trying to connect from external network to http port.

I connect to default http port (8123) with no problem from localhost.

When connecting from outside, I get no response. All firewalls are open for port 8123.

When searching for a solution I found this post:

https://groups.google.com/d/msg/clickhouse/MJJIVpOoanU/KuafrWt0BQAJ

It says "Ensure ClickHouse listen on both 127.0.0.1 and external IP (so you can connect from another server)."

Looks like it may be my issue too.

So, how can I make CH listen on external IP?

Or, maybe it is some other issue?

Thank you,

Oleg

[Vitaliy Lyudvichenko]

You could set 

    <listen_host>::</listen_host>

    <listen_host>0.0.0.0</listen_host>

in config.xml to listen all interfaces.

By-default it listens only localhost: https://github.com/yandex/ClickHouse/blob/e03ae570f7a760a4acedbea77e5063a99a9b15e2/dbms/src/Server/config.xml#L65

вторник, 28 ноября 2017 г., 1:41:31 UTC+3 пользователь Oleg K написал:

[Oleg K]

Thank you!

Just in case:

"::" and "0.0.0.0" mean the same?