Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to install hakatime #92

Open
BreizhHardware opened this issue Feb 7, 2024 · 2 comments
Open

Unable to install hakatime #92

BreizhHardware opened this issue Feb 7, 2024 · 2 comments

Comments

@BreizhHardware
Copy link

BreizhHardware commented Feb 7, 2024

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 ...
@mujx
Copy link
Owner

mujx commented Feb 17, 2024

Did you try to access the web page to verify if it's working? That logline doesn't mean it's not accessible or stuck.

@BreizhHardware
Copy link
Author

Yes I have try and nothing appen

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants