Clickhouse #1697
Description
Activity
The clickhouse script is ready for testing:
bash -c "$(curl -fsSL https://github.com/community-scripts/ProxmoxVED/raw/main/ct/clickhouse.sh)"
Default credentials:
Username: defaultThe default user 'default' has no password. Set a password for production use.
During setup you can optionally install ClickStack (HyperDX UI + OTel Collector + MongoDB) for full observability. This requires 4 CPU, 8GB RAM, and 30GB disk.Note: This is not in the official repo yet—it's just a dev version! After merging into ProxmoxVE, it will need to be recreated.
Install works with one issue, update and webui function as expected.
The Webui and API urls are backwards in the output:
🚀 ClickHouse setup has been successfully initialized!
💡 Access HyperDX UI using the following URL:
🌐 http://192.168.0.69:8080
💡 ClickHouse HTTP API:
🌐 http://192.168.0.69:8123✔️ Setup Node.js 22 ✔️ Initialized ClickHouse Schema ✔️ Deployed: otelcol (0.151.0) ✔️ Configured OTel Collector ✔️ Deployed: clickstack (@hyperdx/cli@0.4.0) ⏳ Enabling CorepackPreparing yarn@4.13.0 for immediate activation... ✔️ Enabled Corepack ⏳ Building HyperDX➤ YN0065: Yarn will periodically gather anonymous telemetry: https://yarnpkg.com/advanced/telemetry ➤ YN0065: Run yarn config set --home enableTelemetry 0 to disable ➤ YN0000: · Yarn 4.13.0 ➤ YN0000: ┌ Resolution step ➤ YN0000: └ Completed in 0s 516ms ➤ YN0000: ┌ Post-resolution validation ➤ YN0060: │ mongodb is listed by your project with version 6.16.0 (pe60f6b), which doesn't satisfy what connect-mongo and other dependencies request (^4.4.1). ➤ YN0060: │ next is listed by your project with version 16.1.7 (p97e968), which doesn't satisfy what next-query-params and other dependencies request (^14.1.0). ➤ YN0060: │ react is listed by your project with version 19.2.3 (p2be0df), which doesn't satisfy what @tanstack/react-virtual and other dependencies request (but they have non-overlapping ranges!). ➤ YN0060: │ react-dom is listed by your project with version 19.2.3 (p37b38e), which doesn't satisfy what @tanstack/react-virtual and other dependencies request (but they have non-overlapping ranges!). ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide @codemirror/language (pd34e88), requested by @codemirror/autocomplete. ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide @codemirror/view (p410ec6), requested by @uiw/react-codemirror. ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide @lezer/common (pebabfe), requested by @codemirror/autocomplete. ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide @types/node (p3a7706), requested by knip. ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide eslint (p533f6f), requested by @eslint-react/eslint-plugin and other dependencies. ➤ YN0002: │ @hyperdx/app@workspace:packages/app doesn't provide webpack (p7aef86), requested by @storybook/addon-styling-webpack and other dependencies. ➤ YN0002: │ hyperdx@workspace:. doesn't provide typescript (p4698d0), requested by typescript-eslint. ➤ YN0086: │ Some peer dependencies are incorrectly met by your project; run yarn explain peer-requirements <hash> for details, where <hash> is the six-letter p-prefixed code. ➤ YN0086: │ Some peer dependencies are incorrectly met by dependencies; run yarn explain peer-requirements for details. ➤ YN0000: └ Completed ➤ YN0000: ┌ Fetch step ➤ YN0013: │ 2529 packages were added to the project (+ 1.18 GiB). ➤ YN0000: └ Completed in 27s 586ms ➤ YN0000: ┌ Link step ➤ YN0007: │ nx@npm:21.3.11 [45436] must be built because it never has been before or the last one failed ➤ YN0007: │ esbuild@npm:0.27.1 must be built because it never has been before or the last one failed ➤ YN0007: │ protobufjs@npm:7.5.2 must be built because it never has been before or the last one failed ➤ YN0007: │ msw@npm:2.3.0 [98307] must be built because it never has been before or the last one failed ➤ YN0007: │ esbuild@npm:0.27.4 must be built because it never has been before or the last one failed ➤ YN0007: │ esbuild@npm:0.25.1 must be built because it never has been before or the last one failed ➤ YN0007: │ protobufjs@npm:6.11.4 must be built because it never has been before or the last one failed ➤ YN0007: │ sharp@npm:0.34.5 must be built because it never has been before or the last one failed ➤ YN0007: │ core-js-pure@npm:3.37.1 must be built because it never has been before or the last one failed ➤ YN0007: │ protobufjs@npm:7.5.3 must be built because it never has been before or the last one failed ➤ YN0007: │ @scarf/scarf@npm:1.4.0 must be built because it never has been before or the last one failed ➤ YN0007: │ unrs-resolver@npm:1.11.1 must be built because it never has been before or the last one failed ➤ YN0000: └ Completed in 33s 380ms ➤ YN0000: · Done with warnings in 1m 2s CLI Building entry: src/guards.ts, src/macros.ts, src/queryParser.ts, src/rawSqlParams.ts, src/sqlFormatter.ts, src/types.ts, src/validation.ts, src/clickhouse/browser.ts, src/clickhouse/index.ts, src/clickhouse/node.ts, src/core/histogram.ts, src/core/linkTemplate.ts, src/core/linkUrlBuilder.ts, src/core/materializedViews.ts, src/core/metadata.ts, src/core/renderChartConfig.ts, src/core/utils.ts, src/drain/config.ts, src/drain/drain.ts, src/drain/index.ts, src/drain/log-cluster.ts, src/drain/lru-cache.ts, src/drain/masking.ts, src/drain/node.ts, src/drain/template-miner.ts CLI Using tsconfig: tsconfig.json CLI tsup v8.4.0 CLI Using tsup config: /opt/clickstack/packages/common-utils/tsup.config.ts CLI Target: es2022 CLI Cleaning output folder CJS Build start ESM Build start CJS dist/drain/template-miner.js 364.00 B CJS dist/core/utils.js 2.16 KB CJS dist/drain/config.js 178.00 B CJS dist/drain/drain.js 260.00 B CJS dist/chunk-UK6JS3QY.js 2.34 KB CJS dist/drain/log-cluster.js 169.00 B CJS dist/chunk-PPIKEHOH.js 2.03 KB CJS dist/chunk-4S7NGOPO.js 352.00 B CJS dist/chunk-5CFDOSQL.js 4.86 KB CJS dist/drain/lru-cache.js 167.00 B CJS dist/chunk-G5BIG2AN.js 2.61 KB CJS dist/drain/masking.js 217.00 B CJS dist/drain/node.js 163.00 B CJS dist/clickhouse/index.js 1.23 KB CJS dist/drain/index.js 792.00 B CJS dist/chunk-DBDYKVVO.js 990.00 B CJS dist/clickhouse/node.js 971.00 B CJS dist/core/histogram.js 305.00 B CJS dist/core/linkUrlBuilder.js 1.18 KB CJS dist/chunk-QCGQXSGE.js 1.36 KB CJS dist/core/linkTemplate.js 384.00 B CJS dist/core/materializedViews.js 560.00 B CJS dist/guards.js 339.00 B CJS dist/core/metadata.js 536.00 B CJS dist/macros.js 281.00 B CJS dist/core/renderChartConfig.js 854.00 B CJS dist/rawSqlParams.js 495.00 B CJS dist/queryParser.js 532.00 B CJS dist/sqlFormatter.js 238.00 B CJS dist/validation.js 330.00 B CJS dist/clickhouse/browser.js 3.17 KB CJS dist/types.js 5.27 KB CJS dist/chunk-DICCJULV.js 7.87 KB CJS dist/chunk-U65WVHY2.js 72.23 KB CJS dist/chunk-OEZUGL5F.js 18.44 KB CJS dist/chunk-XSPFZE62.js 303.00 B CJS dist/chunk-VXPFG6S4.js 26.24 KB CJS dist/chunk-WVA66XTC.js 163.00 B CJS ⚡️ Build success in 263ms ESM dist/chunk-KB3NUAWC.mjs 2.05 KB ESM dist/drain/log-cluster.mjs 62.00 B ESM dist/clickhouse/index.mjs 807.00 B ESM dist/core/histogram.mjs 190.00 B ESM dist/chunk-LDZPUEZM.mjs 1.26 KB ESM dist/drain/lru-cache.mjs 60.00 B ESM dist/chunk-D6PEKZL5.mjs 1.59 KB ESM dist/chunk-DLL7QVIY.mjs 4.61 KB ESM dist/chunk-L67JXUPL.mjs 313.00 B ESM dist/drain/masking.mjs 87.00 B ESM dist/chunk-FBUUBHGS.mjs 117.00 B ESM dist/chunk-VCFZEHEA.mjs 836.00 B ESM dist/drain/node.mjs 56.00 B ESM dist/clickhouse/node.mjs 808.00 B ESM dist/core/linkUrlBuilder.mjs 886.00 B ESM dist/core/linkTemplate.mjs 185.00 B ESM dist/chunk-GQZCE57Q.mjs 967.00 B ESM dist/core/renderChartConfig.mjs 546.00 B ESM dist/core/materializedViews.mjs 355.00 B ESM dist/core/metadata.mjs 336.00 B ESM dist/guards.mjs 163.00 B ESM dist/queryParser.mjs 332.00 B ESM dist/macros.mjs 157.00 B ESM dist/rawSqlParams.mjs 269.00 B ESM dist/sqlFormatter.mjs 121.00 B ESM dist/validation.mjs 245.00 B ESM dist/types.mjs 2.94 KB ESM dist/clickhouse/browser.mjs 1.86 KB ESM dist/chunk-IRI7PQV5.mjs 5.79 KB ESM dist/chunk-MQUM7KWB.mjs 207.00 B ESM dist/chunk-TWQEUCWM.mjs 16.11 KB ESM dist/chunk-PZOFGBMF.mjs 21.00 KB ESM dist/chunk-4P4RYM5H.mjs 62.81 KB ESM dist/core/utils.mjs 1.39 KB ESM dist/drain/template-miner.mjs 245.00 B ESM dist/drain/config.mjs 71.00 B ESM dist/drain/index.mjs 439.00 B ESM dist/drain/drain.mjs 147.00 B ESM ⚡️ Build success in 264ms DTS Build start DTS ⚡️ Build success in 24398ms DTS dist/drain/index.d.ts 393.00 B DTS dist/guards.d.ts 786.00 B DTS dist/macros.d.ts 400.00 B DTS dist/queryParser.d.ts 6.18 KB DTS dist/rawSqlParams.d.ts 1.12 KB DTS dist/sqlFormatter.d.ts 65.00 B DTS dist/validation.d.ts 148.00 B DTS dist/clickhouse/browser.d.ts 894.00 B DTS dist/clickhouse/node.d.ts 723.00 B DTS dist/core/histogram.d.ts 7.52 KB DTS dist/core/linkTemplate.d.ts 866.00 B DTS dist/core/linkUrlBuilder.d.ts 673.00 B DTS dist/core/materializedViews.d.ts 2.31 KB DTS dist/core/renderChartConfig.d.ts 3.31 KB DTS dist/core/utils.d.ts 8.29 KB DTS dist/types.d.ts 1.11 MB DTS dist/drain/lru-cache.d.ts 985.00 B DTS dist/drain/masking.d.ts 677.00 B DTS dist/drain/template-miner.d.ts 947.00 B DTS dist/drain/config.d.ts 594.00 B DTS dist/drain/drain.d.ts 1.26 KB DTS dist/drain/log-cluster.d.ts 243.00 B DTS dist/drain/node.d.ts 125.00 B DTS dist/core/metadata.d.ts 415.00 B DTS dist/clickhouse/index.d.ts 868.00 B DTS dist/index-ckhAcjFb.d.ts 15.35 KB DTS dist/drain/index.d.mts 400.00 B DTS dist/guards.d.mts 787.00 B DTS dist/macros.d.mts 401.00 B DTS dist/queryParser.d.mts 6.18 KB DTS dist/rawSqlParams.d.mts 1.12 KB DTS dist/sqlFormatter.d.mts 65.00 B DTS dist/validation.d.mts 148.00 B DTS dist/clickhouse/browser.d.mts 896.00 B DTS dist/clickhouse/node.d.mts 725.00 B DTS dist/core/histogram.d.mts 7.52 KB DTS dist/core/linkTemplate.d.mts 866.00 B DTS dist/core/linkUrlBuilder.d.mts 674.00 B DTS dist/core/materializedViews.d.mts 2.31 KB DTS dist/core/renderChartConfig.d.mts 3.31 KB DTS dist/core/utils.d.mts 8.29 KB DTS dist/types.d.mts 1.11 MB DTS dist/drain/lru-cache.d.mts 985.00 B DTS dist/drain/masking.d.mts 677.00 B DTS dist/drain/template-miner.d.mts 951.00 B DTS dist/drain/config.d.mts 594.00 B DTS dist/drain/drain.d.mts 1.27 KB DTS dist/drain/log-cluster.d.mts 243.00 B DTS dist/drain/node.d.mts 125.00 B DTS dist/core/metadata.d.mts 417.00 B DTS dist/clickhouse/index.d.mts 870.00 B DTS dist/index-rTdJ55RQ.d.mts 15.35 KB ✖️ HyperDX API build failed: build/index.js not found ✖️ Installation failed in container 107 (exit code: 1) ✔ Installation log: /tmp/install-5f2b58b9-combined.log Error: General error / Operation not permitted What would you like to do? 1) Remove container and exit 2) Keep container for debugging 3) Retry with verbose mode (full rebuild) 4) Retry with DNS override in LXC (8.8.8.8 / 1.1.1.1) Select option [1-4] (default: 1, auto-remove in 60s): 2 Container 107 kept for debugging root@hub:~#` ⚙️ Using Default Settings on node pve2
💡 PVE Version 9.1.19 (Kernel: 6.17.13-3-pve)
🆔 Container ID: 113
🖥️ Operating System: debian (13)
📦 Container Type: Unprivileged
💾 Disk Size: 30 GB
🧠 CPU Cores: 4
🛠️ RAM Size: 8192 MiB
🚀 Creating a ClickHouse LXC using the above default settings✔️ Storage local (Free: 20.1GB Used: 16.6GB) [Template]
✔️ Storage LVM (Free: 885.9GB Used: 68.0GB) [Container]
✔️ Storage 'LVM' (lvm) validated
✔️ Template storage 'local' validated
✔️ Cluster is quorate
✔️ Template search completed
✔️ Template debian-13-standard_13.1-2_amd64.tar.zst [local]
✔️ LXC Container 113 was successfully created.
✔️ Started LXC Container
✔️ Network in LXC is reachable (ping)
✔️ Customized LXC Container
✔️ Set up Container OS
✔️ Network Connected: 172.16.201.222
✔️ IPv4 Internet Connected
✖️ IPv6 Internet Not Connected
✔️ Git DNS: github.com:(✔️ ) raw.githubusercontent.com:(✔️ ) api.github.com:(✔️ ) git.community-scripts.org:(✔️ )
✔️ Updated Container OS
✔️ Setup ClickHouse 26.5.1.882
✔️ Configured ClickHouse
✔️ Installed Dependencies
✔️ Setup MongoDB 8.0
✔️ Setup Node.js 22
✔️ Initialized ClickHouse Schema
✔️ Deployed: otelcol (0.152.1)
✔️ Configured OTel Collector
✔️ Deployed: clickstack (@hyperdx/otel-collector@2.27.0)
✔️ Enabled Corepack
✖️ HyperDX API build failed: build/index.js not found
✖️ Installation failed in container 113 (exit code: 1)✔ Installation log: /tmp/install-a2663108-combined.log
Error: General error / Operation not permitted
What would you like to do?
- Remove container and exit
- Keep container for debugging
- Retry with verbose mode (full rebuild)
- Retry with DNS override in LXC (8.8.8.8 / 1.1.1.1)
Select option [1-4] (default: 1, auto-remove in 60s):
✔️ Container 113 removed`I have the same issue
ive shorten clickhouse for now. its bare metal clickhouse without hyperDX.
you can try again @Qwekkeboom @ankur-paan
maybe i add it later, it causes with every version into new issues
A PR has been created for clickhouse: community-scripts/ProxmoxVE#15045
Merged with #15045 in ProxmoxVE
Files deleted with PR #1917
Name of the Script
Clickhouse
Script Type
CT (LXC Container)
📋 Script Details
ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real-time.