Unexpected packet from server localhost:9000, ::1

Suman Reddy

unread,

May 23, 2018, 10:08:47 AM5/23/18

to ClickHouse

Hi,

I have installed clickhouse as per the instructions here https://github.com/Altinity/clickhouse-rpm-install.

I have also enabled <listen_host>::</listen_host> in /etc/clickhouse-server/config.xml.

it started fine as below:

sudo /etc/init.d/clickhouse-server restart
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
DONE

But, when i start client it fails as below:

sudo clickhouse-client
ClickHouse client version 1.1.54383.
Connecting to localhost:9000.
Code: 102. DB::NetException: Unexpected packet from server localhost:9000, ::1 (expected Hello or Exception, got Unknown packet)

Saptarshi Gan

unread,

Jun 12, 2018, 4:23:54 AM6/12/18

to ClickHouse

I think it's trying to listen on your ipv6 interface for connections.disable it in config.xml if you're not using ipv6. just keep <listen_host>127.0.0.1</listen_host>

Oleg A

unread,

Jun 18, 2018, 8:36:25 AM6/18/18

to ClickHouse

Please show server log about startup and client connect.

Also maybe you have other software listening on port 9000 ? you can try change port in config <tcp_port>9000</tcp_port>

среда, 23 мая 2018 г., 17:08:47 UTC+3 пользователь Suman Reddy написал:

Reply all

Reply to author

Forward