Title
r
Raviteja Chavali
04/25/2022, 3:27 PMHello Team, I've started exploring SigNoz, i wanted to connect to clickhouse DB, i am unable to connect(using signoz docker compose) . can anyone help me connecting to clickhouse db?
p
Prashant Shahi
04/25/2022, 4:10 PMHey @Raviteja Chavali!
You can
execclickhouse-clientdocker exec -it clickhouse-setup_clickhouse_1 bash
root@d68a4a5c8d59:/# clickhouse-client
ClickHouse client version 21.12.3.32.armprestable.arm (altinity build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.12.3 revision 54452.
d68a4a5c8d59 :)r
Raviteja Chavali
04/25/2022, 4:15 PMHi @Prashant Shahi thanks for quick response, so my scenario here is, as Grafana supports clickhouse datasource, I want to connect my clickhouse from Grafana and compare with signoz.
why grafana: we are already using it and wanted to see how signoz wins before we take a call.
p
Prashant Shahi
04/25/2022, 4:47 PMThat would be possible. However, it is not recommended since you would have the overhead of manually updating queries with schema changes across different SigNoz versions.
a
Ankit Nayan
04/25/2022, 4:55 PM@Raviteja Chavali you might want to expose the ports of clickhouse at https://github.com/SigNoz/signoz/blob/main/deploy/docker/clickhouse-setup/docker-compose.yaml#L6 and the connect using any client
a
alan
04/25/2022, 8:44 PM@Ankit Nayan root@uls-tst01-gen1-7b64d94f9c-2zlr8:/# uname -a
Linux uls-tst01-gen1-7b64d94f9c-2zlr8 5.4.0-1025-gkeop #26~18.04.1-Ubuntu SMP Mon Oct 4 03:14:34 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
root@uls-tst01-gen1-7b64d94f9c-2zlr8:/#r
Raviteja Chavali
04/26/2022, 3:30 AM@Ankit Nayan thanks, will check and get back to you.