Raspberry Pi + Cloudflare tunnel issue while docker compose

[paullotz]

Raspberry Pi + Cloudflare tunnel issue while docker compose

[ruslandoga]

Adding DATABASE_URL and CLICKHOUSE_DATABASE_URL set to default values wouldn't really change anything.

I'm going to close this issue as it's not related to Plausible but rather to ClickHouse. You might have a better chance of getting help in finding an image that works on Raspberry Pi on https://github.com/clickhouse/clickhouse or https://t.me/clickhouse_en

[paullotz]

Output from sudo docker container ls:

85689772ac39 ghcr.io/plausible/community-edition:v2.1.0 "/entrypoint.sh sh -…" 9 minutes ago Up 4 seconds 127.0.0.1:8000->8000/tcp hosting-plausible-1

72f62ddc7c1c clickhouse/clickhouse-server:24.3.3.102-alpine "/entrypoint.sh" 9 minutes ago Restarting (132) 58 seconds ago hosting-plausible_events_db-1

aa611a6fb187 postgres:16-alpine "docker-entrypoint.s…" 9 minutes ago Up 9 minutes 5432/tcp hosting plausible_db-1

[ruslandoga]

👋 @paullotz

Plausible fails because it cannot connect to ClickHouse (Ch.Connection (#PID<0.174.0>) failed to connect).
ClickHouse cannot be connected to because it is not running (Restarting (132)).
ClickHouse is not running because it uses illegal instructions (exit code 132).

This is probably relevant: plausible/analytics#3817 (comment)

[wreidlinger]

@paullotz I think a had a similar issue first running the containers.
Guess adding DATABASE_URL and CLICKHOUSE_DATABASE_URL did the trick.
This URLs has to fit with your docker-compose config.

• plausible-conf.env

BASE_URL=https://plausible.mydomain.com
SECRET_KEY_BASE=***
TOTP_VAULT_KEY=***
DISABLE_REGISTRATION=true
DATABASE_URL=postgres://postgres:postgres@plausible_db:5432/plausible_db
CLICKHOUSE_DATABASE_URL=http://plausible_events_db:8123/plausible_events_db

• docker-compose.yml

name: plausible
services:
# **************************************
# MAILSERVICE
# **************************************
  mail:
    image: sverzegnassi/smtp
    container_name: plausible_mail
    hostname: smtpmail
    restart: always
    env_file:
      - plausible-conf.env
   
# **************************************
# DATABASE
# **************************************
  plausible_db:
    image: postgres:14-alpine
    container_name: plausible_db
    hostname: postgres
    restart: always
    volumes:
      - ./data/db-plausible:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=postgres

# **************************************
# EVENTS DATABASE
# **************************************
  plausible_events_db:
    image: clickhouse/clickhouse-server:23.3.7.5-alpine
    container_name: plausible_events_db
    hostname: clickhouse
    restart: always
    volumes:
      - ./data/db-clickhouse:/var/lib/clickhouse
      - ./clickhouse/clickhouse-config.xml:/etc/clickhouse-server/config.d/logging.xml:ro
      - ./clickhouse/clickhouse-user-config.xml:/etc/clickhouse-server/users.d/logging.xml:ro
    ulimits:
      nofile:
        soft: 262144
        hard: 262144

# **************************************
# PLAUSIBLE SERVICE
# **************************************
  plausible:
    image: ghcr.io/plausible/community-edition:latest
    container_name: plausible_plausible
    hostname: plausible
    restart: always
    command: sh -c "sleep 10 && /entrypoint.sh db createdb && /entrypoint.sh db
      migrate && /entrypoint.sh run"
    depends_on:
      - plausible_db
      - plausible_events_db
      - mail
    ports:
      - 127.0.0.1:8000:8000
    env_file:
      - plausible-conf.env

Hope this helps.

[ruslandoga]

The solution seems to be to build your own ClickHouse image. Please see ClickHouse/ClickHouse#50852