Accessing Clickhouse Collector for Custom Dashboard

TLDR Div wanted to access the clickhouse collector on their server for custom dashboard creation. Alexei clarified that they needed to connect to a clickhouse server instead, and Div successfully connected at port 9000.

Photo of Div
Div
Wed, 31 May 2023 15:03:25 UTC

Hi team, I want to query the clickhouse collector running on my server with the signoz, how to access it ? its running on port 4318, the reason I want to do this is to play with some clickhouse queries so I can write my custom dashboard.

Photo of Div
Div
Wed, 31 May 2023 15:04:02 UTC

```clickhouse-client --host=localhost --port=4317``` would this work ?

Photo of Alexei
Alexei
Wed, 31 May 2023 15:10:06 UTC

given that you said it is on port 4318 you might want to change your port option

Photo of Div
Div
Wed, 31 May 2023 15:19:14 UTC

not working

Photo of Div
Div
Wed, 31 May 2023 15:19:40 UTC

```ClickHouse client version 22.2.2.1. Connecting to localhost:4318 as user default.``` stuck on this step

Photo of Alexei
Alexei
Wed, 31 May 2023 15:21:44 UTC

i just reread what you are trying to do, clickhouse collector isn’t clickhouse, that is an OpenTelemetry binary that collects traces/metrics. You would want to connect to a clickhouse server with the clickhouse-client

Photo of Div
Div
Wed, 31 May 2023 15:24:56 UTC

ahh, thanks got it working at port 9000

Photo of Div
Div
Wed, 31 May 2023 15:24:58 UTC

my bad