ClickHouse on Ubuntu 24.04 LTS — Support & Quick Start

At a glance

Application ports	8123 (HTTP interface), 9000 (native TCP)
Admin credential file	sudo cat /var/lib/clickhouse/admin-password
Sign in as	default (ClickHouse `default` user; password generated at first boot)
Service(s)	clickhouse-server
Configuration	/etc/clickhouse-server/config.d/listen.xml (listen_host 0.0.0.0); /etc/clickhouse-server/users.d/default-password.xml (SHA-256 of the generated password)
Logs	/var/log/clickhouse-server/clickhouse-server.log; journalctl -u clickhouse-server -f
Version	ClickHouse 24.12 (24.12.3.47, official deb stable repository)
Platform	Ubuntu 24.04 LTS

Quick start

1. SSH into the VM with the username and key you chose at deploy.
2. ClickHouse runs as the `clickhouse-server` systemd service, listening on all interfaces (HTTP 8123, native 9000); the in-image ufw allows both — the NSG keeps them closed until you open them.
3. Connect with `clickhouse-client --user default --password "$(sudo cat /var/lib/clickhouse/admin-password)"`, create your first table, and load data via INSERT or the HTTP interface.

First login / credentials

This image generates its admin credential on the VM at first boot — nothing is pre-set. SSH into the VM with the username + key you chose at deploy, then print the generated credential:

ssh <your-username>@<VM-IP>
sudo cat /var/lib/clickhouse/admin-password

Sign in as default (ClickHouse `default` user; password generated at first boot).

1. Print the generated password of the `default` user from the file.
2. Connect locally: clickhouse-client --user default --password "$(sudo cat /var/lib/clickhouse/admin-password)" (HTTP: curl -u default:<pw> 'http://127.0.0.1:8123/?query=SELECT%201').
3. Create dedicated users (CREATE USER … IDENTIFIED BY …), change the default password, and delete the file before exposing 8123/9000.

This is the password of the ClickHouse `default` user, generated at first boot (stored as a SHA-256 hash in /etc/clickhouse-server/users.d/default-password.xml). Create dedicated users and change it before exposing 8123/9000.

Troubleshooting

Symptom	Check	Fix
`clickhouse-client` says authentication failed for default	sudo cat /var/lib/clickhouse/admin-password	The default user has a generated password on this image: pass it with --password.

Still stuck?

Email support@dcassociatesgroup.com (response within 1 business day) or send a message via the contact form. Include the offer name, VM size, region, and any log output — sudo journalctl -u <service> -n 100 usually tells the story.