Clickhouse Collector- local variable 'response'

[Sajjad12518]

I have issue in connecting with Clickhouse, when I run
docker-compose -f docker/demo.yaml up -d odd-collector
nothing happen and in the log I got this error
odd-collector-1 | 2024-11-06 07:38:46.166 | ERROR | odd_collector_sdk.collector:run:140 - local variable 'response' referenced before assignment

This is the configuration I used in collector_config
platform_host_url: http://localhost:8080
default_pulling_interval: 10
token: "FtxaHSiDSibuTIJGTsFA6rpihBKFy4uEOfvXMzEZ"
plugins:

• type: clickhouse
  name: clickhouse_demo
  description: "demo" # Optional string
  host: y2gdfztnob.europe-west4.gcp.clickhouse.cloud
  port: 8443
  database: public
  user: default
  password: 12345
  secure: False
  verify: True
  query_limit: 0 # Optional string, default 0

[RamanDamayeu]

Thank you @Sajjad12518 for opening the issue. The error message suggests that it was not a proper error handling. To fix this error handling we could use this #116
Once it’s released we could further investigate the root cause of the issue.
Thanks @ValeriyWorld for proposed changes.

[ValeriyWorld]

Hello, @Sajjad12518. I have created a newer release of our sdk and generic odd-collector (to the 0.1.67 version). So you may update this one for improved error handling from the sdk side.
Also I have checked Clickhouse adapter. I can confirm that both - connecting to the Clickhouse as a docker service and as a cloud solution - works. I have managed to connect to the databases, run the collector and get the results in the Platform.
As of my investigation, that error massage that you have got may be caused by the wrong platform_host_url configuration or even not running ODD Platform. Can you confirm, that the platform_host_url is configured correctly and it is http://localhost:8080/ in your case?
If you are using Mac OS and run Platform in the docker, you should try http://docker.for.mac.localhost:8080, it could helps.