I have a question， I build the Signoz in my EKS cluster。 I try to let the Signoz client to external clickhouse cloud link，but always have error，the Signoz only support clickhouse EC2 instance？

Please share full error details

“level”“error”,“timestamp”“2024-08-26T062517.126Z”,“caller”“basemigrator/migrator.go26",“msg”:“Failed to create clickhouse connection”,“migrator”“logs”,“error”“failed to ping clickhouse: dial tcp 10.189.6.133:9000: 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:26\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.createNewMigrator\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:58\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:31\nmain.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:120\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267”} {“level”“error”,“timestamp”“2024-08-26T062517.126Z”,“caller”“migrationmanager/manager.go60",“msg”:“Failed to create base migrator”,“migrator”“logs”,“error”“failed to ping clickhouse: dial tcp 10.189.6.133:9000: i/o timeout”,“stacktrace”:“github.com/SigNoz/signoz-otel-collector/migrationmanager.createNewMigrator\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:60\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:31\nmain.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:120\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267”} {“level”“error”,“timestamp”“2024-08-26T062517.126Z”,“caller”“migrationmanager/manager.go33",“msg”:“Failed to create logs migrator”,“component”“migrationmanager”,“error”“failed to ping clickhouse: dial tcp 10.189.6.133:9000: i/o timeout”,“stacktrace”:“github.com/SigNoz/signoz-otel-collector/migrationmanager.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:33\nmain.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go:120\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267”} {“level”“fatal”,“timestamp”“2024-08-26T062517.126Z”,“caller”“signozschemamigrator/migrate.go122",“msg”:“Failed to create migration manager”,“component”:“migrate cli”,“error”:“failed to ping clickhouse: dial tcp 10.189.6.133:9000: i/o timeout”,“stacktrace”“main.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go122\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267"}

This seems like a networking issue you need to fix from your side.

I don’t think so, the click house cloud don’t have the tcpPort 9000 config, it only have 8443 https port

This link is for cli but that applies everwhere https://clickhouse.com/docs/en/interfaces/cli#gather-your-connection-details. You can get the URL for native protocol

thanks for the pointer, I have try the 9440 port, I can telnet the 9440 port from signoz side, but still have error : 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:26\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.createNewMigrator\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go:58\ngithub.com/SigNoz/signoz-otel-collector/migrationmanager.New\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go31\nmain.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go120\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.13/x64/src/runtime/proc.go:267

That's outdated. The basic support is added here https://github.com/SigNoz/signoz/pull/4178