Hello everyone , i'am trying to setup a remote cli...
# support
l
Hello everyone , i'am trying to setup a remote clickhouse but i get this error . i'm using the docker standalone version and replaced all tcplocalhost9000 by "tcp://ncabm9jg:9000?username=default&password=sdfgsdfg". I don't have anything blocking outgoing traffic from my machine but still it seems that the otel-migrator cannot connect to the database ... any help ? Thank you {"level":"error","timestamp":"2024-02-05T122734.110Z","caller":"basemigrator/migrator.go:27","msg":"Failed to create clickhouse connection","migrator":"logs","error":"failed to ping clickhouse: dial tcp 35.201.102.659000 i/o timeout","stacktrace":"github.com/SigNoz/signoz-otel-collector/migrationmanager/migrators/basemigrator.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/migrators/basemigrator/migrator.go:27\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.createNewMigrator\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:57\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go30\nmain.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go102\nruntime.main\n\t/opt/hostedtoolcache/go/1.20.12/x64/src/runtime/proc.go:250"}
image.png
p
That looks alright to me. @dhawal can you please look into this?
l
Thank you , for the query-service i'm using also the remote clickhouse url , and storage=clickhouse
the docker "ps -a" result
p
secured clickhouse (such as ClickHouse Cloud) is not yet supported.
d
hi @L Omary, can you try connecting to the remote clickhouse host with the clickhouse client using just the host url(please pass the same string as you did here)
as @Prashant Shahi mentioned, we dont support secured ch host yet..are you using something similar?
l
image.png
i'm trying to connect to ClickHouse Cloud on native port 9000
so i understand that this is not supported for now and there is no workaround like disabling SSL/TLS or something ?
d
@Prashant Shahi 👆
d
@Prashant Shahi Is this supported now with this change? https://github.com/SigNoz/signoz/pull/4178
p
The changes for query-service side is done however, signoz-otel-collector side changes are yet to be picked. https://github.com/SigNoz/signoz-otel-collector/issues/46
d
p
Yes, that seems like it.
d
Great! @Srikanth Chekuri FYI on this same request. Is there an approximate timeline for this?