oliverguenther
commented
5 months ago Hi @suisou , I can't reproduce this error.
I've followed your steps, and you can connect with this password
kubectl exec -n openproject my-openproject-postgresql-0 -it bash
PG_PASS=$POSTGRES_PASSWORD psql -U openproject
k8s: version 1.28.2 containerd :1.6.27-1 helm :v3.14.0 install steps: 1、download openproject-4.4.0.tgz. 2、tar xzvf openproject-4.4.0.tgz. 3、 cd openproject 4、 helm upgrade --create-namespace --namespace openproject --install my-openproject . the echos: Release "my-openproject" does not exist. Installing it now. coalesce.go:289: warning: destination for memcached.service.sessionAffinity is a table. Ignoring non-table value () NAME: my-openproject LAST DEPLOYED: Fri Jan 19 12:29:43 2024 NAMESPACE: openproject STATUS: deployed REVISION: 1 NOTES: Thank you for installing OpenProject 🎉 You can access it via https://openproject.example.com/
Summary:
OpenProject: 13-slim PostgreSQL: 15.4.0-debian-11-r45 Memcached: 1.6.23-debian-11-r0
10 mins later:
memcached and postgresql pod running.
but the worker and web pod Init:Error.
the worker logs: Defaulted container "openproject" out of: openproject, wait-for-db (init) Error from server (BadRequest): container "openproject" in pod "openproject-worker-7666d94b85-jmnvv" is waiting to start: PodInitializing
the postgres logs: 2024-01-19 02:58:43.826 GMT [1] LOG: pgaudit extension initialized 2024-01-19 02:58:43.891 GMT [1] LOG: starting PostgreSQL 15.4 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit 2024-01-19 02:58:43.892 GMT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-01-19 02:58:43.892 GMT [1] LOG: listening on IPv6 address "::", port 5432 2024-01-19 02:58:43.938 GMT [1] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2024-01-19 02:58:44.236 GMT [91] LOG: database system was shut down at 2024-01-19 02:58:20 GMT 2024-01-19 02:58:45.166 GMT [1] LOG: database system is ready to accept connections 2024-01-19 02:58:50.597 GMT [101] FATAL: password authentication failed for user "openproject" 2024-01-19 02:58:50.597 GMT [101] DETAIL: Role "openproject" does not exist. Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2024-01-19 02:58:50.897 GMT [102] FATAL: password authentication failed for user "openproject" 2024-01-19 02:58:50.897 GMT [102] DETAIL: Role "openproject" does not exist.
the rest logs are same as 3 lines above.
I have enter the worker pod by: kubectl exec -n openproject my-openproject-postgresql-0 -it bash
I have no name!@my-openproject-postgresql-0:/opt/bitnami/postgresql/bin$ psql -U openproject Password for user openproject: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: password authentication failed for user "openproject"
I use the secret my-openproject-postgresql password. but can't login.
I try the command : psql -U postgres ,but fail too.