Hi Team, I am installing signoz with external clic...
# support
s
Hi Team, I am installing signoz with external clickhouse server. I am facing an issue. Getting below error:
Copy code
kubectl logs -f my-release-signoz-otel-collector-54bf55dbb9-ckqmz

Defaulted container "my-release-signoz-otel-collector" out of: my-release-signoz-otel-collector, my-release-signoz-otel-collector-init (init)
2023-04-07T02:08:48.916Z	info	service/telemetry.go:111	Setting up own telemetry...
2023-04-07T02:08:48.916Z	info	service/telemetry.go:141	Serving Prometheus metrics	{"address": "0.0.0.0:8888", "level": "Basic"}
2023-04-07T02:08:48.916Z	info	components/components.go:30	Stability level of component is undefined	{"kind": "exporter", "data_type": "traces", "name": "clickhousetraces", "stability": "Undefined"}
Error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": error connecting to primary db: code: 170, message: Requested cluster 'cluster' not found
2023/04/07 02:08:48 application run finished with error: cannot build pipelines: failed to create "clickhousetraces" exporter, in pipeline "traces": error connecting to primary db: code: 170, message: Requested cluster 'cluster' not found
My override file:
Copy code
global:
  storageClass: gp2
  cloud: aws

clickhouse:
  enabled: false
  cloud: other


externalClickhouse:
  host: 54.75.80.150
  cluster: events 
  user: xxxxxx
  password: xxxxxxxxxxxxxxx
  secure: false
  verify: false
  httpPort: 8123
  tcpPort: 9000

allowedNetworkIps:
    - "0.0.0.0/0"
I really appreciate your kind response.
s
There should be a cluster named with
cluster
s
where? my clickhouse cluster name is event
s
SigNoz needs a cluster named with
cluster
. Create one if it doesn’t exist.
s
Copy code
Environment:
      CLICKHOUSE_HOST:                  54.75.70.130
      CLICKHOUSE_PORT:                  9000
      CLICKHOUSE_HTTP_PORT:             8123
      CLICKHOUSE_CLUSTER:               events
      CLICKHOUSE_DATABASE:              signoz_metrics
      CLICKHOUSE_TRACE_DATABASE:        signoz_traces
      CLICKHOUSE_USER:                  admin
      CLICKHOUSE_PASSWORD:              2kkkkkkkb9
      CLICKHOUSE_SECURE:                false
      CLICKHOUSE_VERIFY:                false
      K8S_NODE_NAME:                     (v1:spec.nodeName)
      K8S_POD_IP:                        (v1:status.podIP)
      K8S_POD_NAME:                     my-release-signoz-otel-collector-54bf55dbb9-ckqmz (v1:metadata.name)
      K8S_POD_UID:                       (v1:metadata.uid)
      K8S_NAMESPACE:                    platform (v1:metadata.namespace)
      K8S_CLUSTER_NAME:
      SIGNOZ_COMPONENT:                 otel-collector
      OTEL_RESOURCE_ATTRIBUTES:         host.name=$(K8S_NODE_NAME),signoz.component=$(SIGNOZ_COMPONENT),k8s.cluster.name=$(K8S_CLUSTER_NAME),k8s.pod.uid=$(K8S_POD_UID),k8s.pod.ip=$(K8S_POD_IP)
      LOW_CARDINAL_EXCEPTION_GROUPING:  false
this is my env for otel collector
ok let me change the name of my clickhouse cluster
I will update once I get the name updated.
a
cluster name cannot be different than
cluster
s
Thanks alot, Let me bring up the cluster
Thanks a lot @Ankit Nayan and @Srikanth Chekuri. Really really appreciate your help. It is now working. You guys are rock. Now I will change zooker because I want to use using clickhouse-keeper. and will change query service endpoint to point to my external database