Changes

Migration to Official ClickHouse Image

• Migrated from deprecated bitnami/clickhouse and bitnamilegacy/clickhouse images to official clickhouse/clickhouse-server:lts image
• Updated default Docker image in base migration to use official image for all new installations
• Created automatic migration for existing ClickHouse instances

Database Schema

• Added clickhouse_db column to standalone_clickhouses table with default value 'default'
• Updated base migration to include new column for fresh installations
• Migration automatically adds column to existing installations

Model Updates (app/Models/StandaloneClickhouse.php)

• Updated persistent volume mount path from /bitnami/clickhouse to /var/lib/clickhouse
• Updated connection string generation to use new clickhouse_db field
• Added fallback to 'default' database when clickhouse_db is null

Action Updates (app/Actions/Database/StartClickhouse.php)

• Updated environment variables to official ClickHouse format:
  • CLICKHOUSE_ADMIN_USER → CLICKHOUSE_USER
  • CLICKHOUSE_ADMIN_PASSWORD → CLICKHOUSE_PASSWORD
  • Added CLICKHOUSE_DB variable for database name configuration
• Updated healthcheck command to include --user parameter for compatibility

Migration Logic

• Created migration 2025_01_15_000001_migrate_clickhouse_to_official_image.php that:
  • Adds clickhouse_db column to existing tables
  • Updates all existing Bitnami instances to official image
  • Migrates persistent volume mount paths automatically
  • Includes full rollback support for safe deployment
• Removed obsolete migration 2025_10_03_154100_update_clickhouse_image.php

Issues

• fix #7110
• /claim #7110

Summary by CodeRabbit

• New Features

  • Support for configurable ClickHouse database name with a sensible default.

• Bug Fixes

  • Health checks now authenticate using admin credentials.

• Chores

  • Migrate deployments to the official ClickHouse image and update default image.
  • Align environment variable names with the official image.
  • Update storage mount path to the official image’s default.

• Tests

  • Added unit tests covering DB URL construction, defaults, visibility, and assignment.