Hello Team! I was following this document which guide us to send node exporter data to SigNoz. I have noticed that on step Find Metrics available in Signoz at:

2. Connect to clickhouse instance in SigNoz

Copy code

./clickhouse client --host <SigNoz IP>  --port 9001

We see that the document indicate us to connect on port 9001 of SigNoz IP but when I try to run it on lab environment I got this:

[root@localhost /]# clickhouse client --host localhost --port 9001

ClickHouse client version 22.4.4.7 (official build).

Connecting to 127.0.0.1:9001 as user default.

Code: 210. DB:NetException Connection refused (172.18.0.3:9001). (NETWORK_ERROR)

As per my Docker environment I have this IP address to my ClickHouse server:

[root@localhost /]# docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

c683e0184777 yandex/clickhouse-server:21.12.3.32 "/entrypoint.sh" 13 hours ago Up 43 minutes (healthy) 8123/tcp, 9000/tcp, 9009/tcp clickhouse-setup-clickhouse-1

[root@localhost /]# docker inspect -f '{{range.NetworkSettings.Networks}}{{.IPAddress}}{{end}}' c683e0184777

172.18.0.3

Checking the ClickHouse server config file I see below reference for ports:

<http_port>8123</http_port>

<tcp_port>9000</tcp_port>

<interserver_http_port>9009</interserver_http_port>

Which seems to match the ports seen on docker ps above. When I run the connection command with container IP and port 9000 the connection is successfull:

[root@localhost /]# clickhouse client --host 172.18.0.3 --port 9000

ClickHouse client version 22.4.4.7 (official build).

Connecting to 172.18.0.3:9000 as user default.

Connected to ClickHouse server version 21.12.3 revision 54452.

This is a documentation inconsistency or a particularity on my lab environment? If so, should I update the documentation to guide user to follow my steps? Many thanks!

Hello @Hercules Gabriel da Silva e Mazucato!! We don't expose ClickHouse ports anymore. You follow either of the following to get the metrics: 1. Expose ports • install clickhouse-client • expose clickhouse ports in SigNoz

docker-compose

file • connect to clickhouse • run the clickhouse query to list metrics 2. Exec to the ClickHouse container • exec to clickhouse container

docker exec -it clickhouse-setup_clickhouse_1 bash

• run the pre-existing clickhouse-client • run the clickhouse query to list metrics Also, you could use the following updated query to list metrics:

select DISTINCT(JSONExtractString(time_series.labels,'__name__')) as metrics from signoz_metrics.time_series

It would be much appreciated if you could update the documentation. This is the website repository: https://github.com/SigNoz/signoz.io Thanks

Hi @Prashant Shahi! Thank you for the follow-up! I will update the article tonight. Many thanks!

@Hercules Gabriel da Silva e Mazucato Just checking if you are planning to work on updating the docs, or we should do this at our end 🙂

Hello @Pranay! I've just updated the docs with https://github.com/SigNoz/signoz.io/pull/282