Unable to install hakatime #92
Description
Hello, I have tried to deploy hakatime using the docker compose file located in the README.MD but it stuck on Starting hakatime server ...
Here is my log:
root@docker2:~# docker compose -f ./docker-compose-deploy.yml up
[+] Running 3/3
✔ Volume "root_deploy_db_data" Created 0.0s
✔ Container haka_db Created 0.5s
✔ Container hakatime Created 0.5s
Attaching to haka_db, hakatime
hakatime | HAKA_DB_HOST: haka_db
hakatime | HAKA_DB_PORT: 5432
hakatime | HAKA_DB_USER: test
hakatime | HAKA_DB_NAME: test
hakatime | Waiting for the PostgreSQL service to become available ...
haka_db | The files belonging to this database system will be owned by user "postgres".
haka_db | This user must also own the server process.
haka_db |
haka_db | The database cluster will be initialized with locale "en_US.utf8".
haka_db | The default database encoding has accordingly been set to "UTF8".
haka_db | The default text search configuration will be set to "english".
haka_db |
haka_db | Data page checksums are disabled.
haka_db |
haka_db | fixing permissions on existing directory /var/lib/postgresql/data ... ok
haka_db | creating subdirectories ... ok
haka_db | selecting dynamic shared memory implementation ... posix
haka_db | selecting default max_connections ... 100
haka_db | selecting default shared_buffers ... 128MB
haka_db | selecting default time zone ... UTC
haka_db | creating configuration files ... ok
haka_db | running bootstrap script ... ok
haka_db | sh: locale: not found
haka_db | 2024-02-07 17:33:33.847 UTC [30] WARNING: no usable system locales were found
haka_db | performing post-bootstrap initialization ... ok
haka_db | syncing data to disk ... ok
haka_db |
haka_db |
haka_db | Success. You can now start the database server using:
haka_db |
haka_db | pg_ctl -D /var/lib/postgresql/data -l logfile start
haka_db |
haka_db | initdb: warning: enabling "trust" authentication for local connections
haka_db | You can change this by editing pg_hba.conf or using the option -A, or
haka_db | --auth-local and --auth-host, the next time you run initdb.
haka_db | waiting for server to start....2024-02-07 17:33:36.423 UTC [36] LOG: starting PostgreSQL 12.17 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit
haka_db | 2024-02-07 17:33:36.427 UTC [36] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
haka_db | 2024-02-07 17:33:36.452 UTC [37] LOG: database system was shut down at 2024-02-07 17:33:34 UTC
haka_db | 2024-02-07 17:33:36.460 UTC [36] LOG: database system is ready to accept connections
haka_db | done
haka_db | server started
haka_db | CREATE DATABASE
haka_db |
haka_db |
haka_db | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
haka_db |
haka_db | waiting for server to shut down....2024-02-07 17:33:36.866 UTC [36] LOG: received fast shutdown request
haka_db | 2024-02-07 17:33:36.871 UTC [36] LOG: aborting any active transactions
haka_db | 2024-02-07 17:33:36.880 UTC [36] LOG: background worker "logical replication launcher" (PID 43) exited with exit code 1
haka_db | 2024-02-07 17:33:36.880 UTC [38] LOG: shutting down
haka_db | 2024-02-07 17:33:36.920 UTC [36] LOG: database system is shut down
haka_db | done
haka_db | server stopped
haka_db |
haka_db | PostgreSQL init process complete; ready for start up.
haka_db |
haka_db | 2024-02-07 17:33:37.008 UTC [1] LOG: starting PostgreSQL 12.17 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit
haka_db | 2024-02-07 17:33:37.008 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
haka_db | 2024-02-07 17:33:37.009 UTC [1] LOG: listening on IPv6 address "::", port 5432
haka_db | 2024-02-07 17:33:37.016 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
haka_db | 2024-02-07 17:33:37.061 UTC [51] LOG: database system was shut down at 2024-02-07 17:33:36 UTC
haka_db | 2024-02-07 17:33:37.076 UTC [1] LOG: database system is ready to accept connections
hakatime | Connected to PostgreSQL
haka_db | 2024-02-07 17:33:37.215 UTC [59] ERROR: relation "users" does not exist at character 22
haka_db | 2024-02-07 17:33:37.215 UTC [59] STATEMENT: select count(*) from users
hakatime | ERROR: relation "users" does not exist
hakatime | LINE 1: select count(*) from users
hakatime | ^
hakatime | Database test does not exist. Initializing database ...
hakatime | BEGIN
hakatime | CREATE TABLE
hakatime | CREATE TABLE
hakatime | CREATE TABLE
hakatime | CREATE TABLE
hakatime | CREATE TABLE
hakatime | CREATE INDEX
hakatime | CREATE EXTENSION
hakatime | CREATE TABLE
hakatime | COMMIT
hakatime | Database test initialized
hakatime | Running migrations from files found in /app/migrations
hakatime | Initializing schema
hakatime | Migrations schema initialized
hakatime | Executing: 00001-add-tags.sql
hakatime | Adding '00001-add-tags.sql' to schema_migrations with checksum '"wDEDYHIMlMhgupK95xXXbQ=="'
hakatime | Executed: 00001-add-tags.sql
hakatime | Executing: 00002-add-token-name.sql
hakatime | Adding '00002-add-token-name.sql' to schema_migrations with checksum '"CMlXJxnilQ25c0PbjnSxMw=="'
hakatime | Executed: 00002-add-token-name.sql
hakatime | Executing: 00003-rename-empty-project.sql
hakatime | Adding '00003-rename-empty-project.sql' to schema_migrations with checksum '"BQGiYxpiw+J/hR+z3GmcEQ=="'
hakatime | Executed: 00003-rename-empty-project.sql
hakatime | Migrations applied successfully
hakatime | Starting hakatime server ...