App is not starting with docker + nginx #4330

chavda-bhavik · 2024-07-10T02:58:31Z

chavda-bhavik
Jul 10, 2024

I'm following the instructions to self-host plausible, but running sudo docker compose up -d shows 502 Bad gateway error in nginx.

Here is the output of sudo docker-compose logs --follow,

community-edition-plausible_events_db-1  | Processing configuration file '/etc/clickhouse-server/config.xml'.
community-edition-plausible_db-1         | The files belonging to this database system will be owned by user "postgres".
community-edition-plausible_db-1         | This user must also own the server process.
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | The database cluster will be initialized with locale "en_US.utf8".
community-edition-plausible_db-1         | The default database encoding has accordingly been set to "UTF8".
community-edition-plausible_db-1         | The default text search configuration will be set to "english".
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | Data page checksums are disabled.
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | fixing permissions on existing directory /var/lib/postgresql/data ... ok
community-edition-plausible-1            | Loading plausible..
community-edition-plausible-1            | Starting dependencies..
community-edition-plausible-1            | Starting repos..
community-edition-plausible-1            | create Plausible.Repo database if it doesn't exist
community-edition-plausible-1            | 02:40:55.014 [error] Postgrex.Protocol (#PID<0.168.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "plausible_db" does not exist
community-edition-plausible-1            | 02:40:55.014 [error] Postgrex.Protocol (#PID<0.167.0>) failed to connect: ** (Postgrex.Error) FATAL 3D000 (invalid_catalog_name) database "plausible_db" does not exist
community-edition-plausible-1            | 02:40:55.047 [error] Ch.Connection (#PID<0.174.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.3.3.102 (official build))
community-edition-plausible_db-1         | creating subdirectories ... ok
community-edition-plausible_db-1         | selecting dynamic shared memory implementation ... posix
community-edition-plausible_db-1         | selecting default max_connections ... 100
community-edition-plausible_db-1         | selecting default shared_buffers ... 128MB
community-edition-plausible_db-1         | selecting default time zone ... UTC
community-edition-plausible_db-1         | creating configuration files ... ok
community-edition-plausible_db-1         | running bootstrap script ... ok
community-edition-plausible_db-1         | sh: locale: not found
community-edition-plausible_db-1         | 2024-07-10 02:40:43.459 UTC [35] WARNING:  no usable system locales were found
community-edition-plausible_db-1         | performing post-bootstrap initialization ... ok
community-edition-plausible_db-1         | initdb: warning: enabling "trust" authentication for local connections
community-edition-plausible_db-1         | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
community-edition-plausible_db-1         | syncing data to disk ... ok
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | Success. You can now start the database server using:
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         |     pg_ctl -D /var/lib/postgresql/data -l logfile start
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | waiting for server to start....2024-07-10 02:40:44.282 UTC [41] LOG:  starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
community-edition-plausible_db-1         | 2024-07-10 02:40:44.286 UTC [41] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
community-edition-plausible_db-1         | 2024-07-10 02:40:44.296 UTC [44] LOG:  database system was shut down at 2024-07-10 02:40:43 UTC
community-edition-plausible_db-1         | 2024-07-10 02:40:44.311 UTC [41] LOG:  database system is ready to accept connections
community-edition-plausible_db-1         |  done
community-edition-plausible_db-1         | server started
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | waiting for server to shut down....2024-07-10 02:40:44.383 UTC [41] LOG:  received fast shutdown request
community-edition-plausible_db-1         | 2024-07-10 02:40:44.386 UTC [41] LOG:  aborting any active transactions
community-edition-plausible_db-1         | 2024-07-10 02:40:44.392 UTC [41] LOG:  background worker "logical replication launcher" (PID 47) exited with exit code 1
community-edition-plausible_db-1         | 2024-07-10 02:40:44.394 UTC [42] LOG:  shutting down
community-edition-plausible_db-1         | 2024-07-10 02:40:44.398 UTC [42] LOG:  checkpoint starting: shutdown immediate
community-edition-plausible-1            | 
community-edition-plausible-1            | 02:40:55.047 [error] Ch.Connection (#PID<0.175.0>) failed to connect: ** (Ch.Error) Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE) (version 24.3.3.102 (official build))
community-edition-plausible-1            | 
community-edition-plausible-1            | create Plausible.IngestRepo database if it doesn't exist
community-edition-plausible-1            | Creation of Db successful!
community-edition-plausible-1            | Loading plausible..
community-edition-plausible-1            | Starting dependencies..
community-edition-plausible-1            | Starting repos..
community-edition-plausible-1            | Running migrations for Elixir.Plausible.Repo
community-edition-plausible-1            | Backfilling legacy site import across 0 sites (DRY RUN: false)...
community-edition-plausible-1            | Finished backfilling sites.
community-edition-plausible-1            | Adjusting end dates of 0 site imports (DRY RUN: false)...
community-edition-plausible-1            | Finished adjusting end dates of site imports.
community-edition-plausible-1            | Finished
community-edition-plausible-1            | Running migrations for Elixir.Plausible.IngestRepo
community-edition-plausible-1            | warning: code block contains unused literal "Migration adds a ALIAS columns needed to keep DB schema and api\nproperty naming in sync to reduce overhead in code.\n" (remove the literal or assign it to _ to avoid warnings)
community-edition-plausible-1            | └─ lib/plausible-0.0.1/priv/ingest_repo/migrations/20240502115822_alias_api_prop_names.exs: Plausible.IngestRepo.Migrations.AliasApiPropNames (module)
community-edition-plausible-1            | 
community-edition-plausible-1            |     list-partitions Done!
community-edition-plausible-1            | 
community-edition-plausible-1            | ------------------------------------------------------------------------------
community-edition-plausible-1            |     get-sessions-table-settings Done!
community-edition-plausible-1            | 
community-edition-plausible-1            | ------------------------------------------------------------------------------
community-edition-plausible-1            |     drop-sessions-tmp-table Done!
community-edition-plausible-1            | 
community-edition-plausible-1            | ------------------------------------------------------------------------------
community-edition-plausible-1            |     create-sessions-tmp-table Done!
community-edition-plausible-1            | 
community-edition-plausible-1            | ------------------------------------------------------------------------------
community-edition-plausible-1            |     exchange-sessions-tables Done!
community-edition-plausible-1            | 
community-edition-plausible-1            | ------------------------------------------------------------------------------
community-edition-plausible-1            | Migration done!
community-edition-plausible-1            | Migrations successful!
community-edition-plausible_db-1         | 2024-07-10 02:40:44.422 UTC [42] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.006 s, sync=0.004 s, total=0.029 s; sync files=2, longest=0.002 s, average=0.002 s; distance=0 kB, estimate=0 kB; lsn=0/14EFC28, redo lsn=0/14EFC28
community-edition-plausible_db-1         | 2024-07-10 02:40:44.436 UTC [41] LOG:  database system is shut down
community-edition-plausible_db-1         |  done
community-edition-plausible_db-1         | server stopped
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | PostgreSQL init process complete; ready for start up.
community-edition-plausible_db-1         | 
community-edition-plausible_db-1         | 2024-07-10 02:40:44.542 UTC [1] LOG:  starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
community-edition-plausible_db-1         | 2024-07-10 02:40:44.542 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
community-edition-plausible_db-1         | 2024-07-10 02:40:44.544 UTC [1] LOG:  listening on IPv6 address "::", port 5432
community-edition-plausible_db-1         | 2024-07-10 02:40:44.552 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
community-edition-plausible_db-1         | 2024-07-10 02:40:44.562 UTC [55] LOG:  database system was shut down at 2024-07-10 02:40:44 UTC
community-edition-plausible_db-1         | 2024-07-10 02:40:44.578 UTC [1] LOG:  database system is ready to accept connections
community-edition-plausible_db-1         | 2024-07-10 02:40:54.969 UTC [60] FATAL:  database "plausible_db" does not exist
community-edition-plausible_db-1         | 2024-07-10 02:40:54.971 UTC [59] FATAL:  database "plausible_db" does not exist
community-edition-plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
community-edition-plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/logging.xml'.
community-edition-plausible_events_db-1  | Logging warning to /var/log/clickhouse-server/clickhouse-server.log
community-edition-plausible_events_db-1  | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.072985 [ 1 ] {} <Warning> Application: Listen [::]:9009 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.091634 [ 1 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.091730 [ 1 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.176002 [ 1 ] {} <Warning> Application: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.176688 [ 1 ] {} <Warning> Application: Listen [::]:9000 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.177365 [ 1 ] {} <Warning> Application: Listen [::]:9004 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
community-edition-plausible_events_db-1  | 2024.07.10 02:40:44.178297 [ 1 ] {} <Warning> Application: Listen [::]:9005 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
community-edition-plausible_events_db-1  | 2024.07.10 02:40:54.997503 [ 48 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
community-edition-plausible_events_db-1  | 
community-edition-plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
community-edition-plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
community-edition-plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
community-edition-plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
community-edition-plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
community-edition-plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
community-edition-plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
community-edition-plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
community-edition-plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
community-edition-plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
community-edition-plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
community-edition-plausible_events_db-1  | 11. ? @ 0x00007f275ccd2609
community-edition-plausible_events_db-1  | 12. ? @ 0x00007f275cbf7353
community-edition-plausible_events_db-1  |  (version 24.3.3.102 (official build))
community-edition-plausible_events_db-1  | 2024.07.10 02:40:54.997569 [ 47 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
community-edition-plausible_events_db-1  | 
community-edition-plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
community-edition-plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
community-edition-plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
community-edition-plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
community-edition-plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
community-edition-plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
community-edition-plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
community-edition-plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
community-edition-plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
community-edition-plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
community-edition-plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
community-edition-plausible_events_db-1  | 11. ? @ 0x00007f275ccd2609
community-edition-plausible_events_db-1  | 12. ? @ 0x00007f275cbf7353
community-edition-plausible_events_db-1  |  (version 24.3.3.102 (official build))
community-edition-plausible_db-1         | 2024-07-10 02:45:44.662 UTC [53] LOG:  checkpoint starting: time

My plausible-conf.env has follow values,

BASE_URL=https://analytics.[DOMAIN].com
SECRET_KEY_BASE=cqGNW...8nAE
DISABLE_REGISTRATION=false
PORT=3333
TOTP_VAULT_KEY=eoW3My...bhbLQ=
CLICKHOUSE_DATABASE_URL=http://community-edition-plausible_events_db-1:8123/plausible_events_db

docker-compose.yml file has this content,

services:
  plausible_db:
    # Plausible v2.1.1 was tested against PostgreSQL versions 15 and 16
    # https://github.com/plausible/analytics/blob/v2.1.1/.github/workflows/elixir.yml#L21-L32
    image: postgres:16-alpine
    restart: always
    volumes:
      - db-data:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=postgres

  plausible_events_db:
    image: clickhouse/clickhouse-server:24.3.3.102-alpine
    restart: always
    volumes:
      - event-data:/var/lib/clickhouse
      - event-logs:/var/log/clickhouse-server
      - ./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:
    image: ghcr.io/plausible/community-edition:v2.1.1
    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
    ports:
      - 127.0.0.1:3333:8000
    env_file:
      - plausible-conf.env

volumes:
  db-data:
    driver: local
  event-data:
    driver: local
  event-logs:
    driver: local

[Given new clickhouse database url because docker was starting clickhouse with community-edition-plausible_events_db-1 name.]

Any idea on how to fix 502 bad gateway error? Thank you so much in advance!

Answered by ruslandoga

Jul 10, 2024

👋 @chavda-bhavik

PORT=3333 means Plausible would bind to 0.0.0.0:3333 in the container but you map it to 8000 from the host with 127.0.0.1:3333:8000. If nginx proxies to localhost:8000, the correct ports would be 127.0.0.1:8000:3333

View full answer

ruslandoga · 2024-07-10T03:03:29Z

ruslandoga
Jul 10, 2024
Collaborator

👋 @chavda-bhavik

PORT=3333 means Plausible would bind to 0.0.0.0:3333 in the container but you map it to 8000 from the host with 127.0.0.1:3333:8000. If nginx proxies to localhost:8000, the correct ports would be 127.0.0.1:8000:3333

4 replies

ruslandoga Jul 10, 2024
Collaborator

CLICKHOUSE_DATABASE_URL=http://community-edition-plausible_events_db-1:8123/plausible_events_db is likely unnecessary.

chavda-bhavik Jul 10, 2024
Author

@ruslandoga 👋

I Can't express my happiness seeing your quick answer and finding the solution. The app started successfully, thank you so much!

chavda-bhavik Jul 10, 2024
Author

Should I close this discussion?

ruslandoga Jul 10, 2024
Collaborator

Up to you :)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

App is not starting with docker + nginx #4330

{{title}}

Replies: 1 comment 4 replies

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

App is not starting with docker + nginx #4330

chavda-bhavik Jul 10, 2024

Replies: 1 comment · 4 replies

ruslandoga Jul 10, 2024 Collaborator

ruslandoga Jul 10, 2024 Collaborator

chavda-bhavik Jul 10, 2024 Author

chavda-bhavik Jul 10, 2024 Author

ruslandoga Jul 10, 2024 Collaborator

chavda-bhavik
Jul 10, 2024

Replies: 1 comment 4 replies

ruslandoga
Jul 10, 2024
Collaborator

ruslandoga Jul 10, 2024
Collaborator

chavda-bhavik Jul 10, 2024
Author

chavda-bhavik Jul 10, 2024
Author

ruslandoga Jul 10, 2024
Collaborator