search

cube-js / cube

📊 Cube — Universal semantic layer platform for AI, BI, spreadsheets, and embedded analytics
https://cube.dev
Other
18.03k stars 1.78k forks source link

Unable to connect with ClickHouse #7525

Open dostiyadav opened 11 months ago

dostiyadav commented 11 months ago

I have both ClickHouse and Cube within the same cluster. While I can successfully establish a telnet connection to the ClickHouse host from the Cube container, I am still unable to connect to ClickHouse. Getting below error msg: image Cube logs: cube.txt Below are the configuration added in cube helm in values.yaml datasources: default: type: clickhouse host: "host.test.local" port: "443" name: "default" user: "default" pass: "PWD@123"
clickhouse: readonly: true

On Browser console getting 500 Internal Server error https://host.test.local/playground/db-schema 500 (Internal Server Error)

igorlukanin commented 11 months ago

Hi @dostiyadav 👋 I see that you're specifying 443 as the port so I guess you'd like to use SSL to connect. Have you also set the necessary environment variable for that? https://cube.dev/docs/product/configuration/data-sources/clickhouse#ssl