Permission denied / Could not connect to PostgreSQL / Unable to connect to http://127.0.0.1:22900/ (v200-alpha-14)

[sudo-joe]

Hello
just installed v200-alpha-14 on an Ubuntu 22.04 Desktop live system (booted from USB stick) and get some errors.....

Is probabaly the first error after entering 'sudo -u postgres psql' (Permission denied) the problem?

Thank's a lot in advance!

ubuntu@ubuntu:~/Desktop$ sudo -u postgres psql
could not change directory to "/home/ubuntu/Desktop": Permission denied
psql (14.13 (Ubuntu 14.13-0ubuntu0.22.04.1))
Type "help" for help.

postgres=# 
postgres=# CREATE DATABASE nzyme;
CREATE DATABASE
postgres=#  
postgres=# CREATE USER nzyme WITH ENCRYPTED PASSWORD 'a1b2c3d4';
CREATE ROLE
postgres=#  
postgres=# GRANT ALL PRIVILEGES ON DATABASE nzyme TO nzyme;
GRANT
postgres=# \q
ubuntu@ubuntu:~/Desktop$ 
ubuntu@ubuntu:~/Desktop$ sudo systemctl enable nzyme
Created symlink /etc/systemd/system/multi-user.target.wants/nzyme.service → /lib/systemd/system/nzyme.service.
ubuntu@ubuntu:~/Desktop$ 
ubuntu@ubuntu:~/Desktop$ sudo systemctl start nzyme
ubuntu@ubuntu:~/Desktop$  
ubuntu@ubuntu:~/Desktop$ sudo systemctl status nzyme
● nzyme.service - Nzyme
     Loaded: loaded (/lib/systemd/system/nzyme.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2024-08-23 07:56:34 UTC; 9s ago
       Docs: https://github.com/lennartkoopmann/nzyme
   Main PID: 9944 (nzyme)
      Tasks: 22 (limit: 18946)
     Memory: 198.5M
        CPU: 4.976s
     CGroup: /system.slice/nzyme.service
             ├─9944 /bin/sh /usr/share/nzyme/bin/nzyme
             └─9945 /usr/bin/java -Xms1g -Xmx1g -XX:-OmitStackTraceInFastThrow -jar -Dlog4j.configurationFile=file:///etc/nzyme/log4j2-debian.>

Aug 23 07:56:34 ubuntu systemd[1]: Started Nzyme.
Aug 23 07:56:35 ubuntu nzyme[9945]: WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
...skipping...

[Firefox]
http://127.0.0.1:22900/

-> Unable to connect

ubuntu@ubuntu:~$ sudo tail -f /var/log/nzyme/nzyme.log
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258) ~[nzyme-2.0.0-alpha.14.jar:?]
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) ~[nzyme-2.0.0-alpha.14.jar:?]
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:263) ~[nzyme-2.0.0-alpha.14.jar:?]
	at org.postgresql.Driver.makeConnection(Driver.java:443) ~[nzyme-2.0.0-alpha.14.jar:?]
	at org.postgresql.Driver.connect(Driver.java:297) ~[nzyme-2.0.0-alpha.14.jar:?]
	at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]
	at java.sql.DriverManager.getConnection(DriverManager.java:251) ~[java.sql:?]
	at org.jdbi.v3.core.Jdbi.lambda$create$0(Jdbi.java:122) ~[nzyme-2.0.0-alpha.14.jar:?]
	at org.jdbi.v3.core.Jdbi.open(Jdbi.java:319) ~[nzyme-2.0.0-alpha.14.jar:?]
	... 2 more
2024-08-23T07:58:12.335+0000 [main] WARN  app.nzyme.core.database.DatabaseImpl - Could not connect to PostgreSQL. Retrying.
org.jdbi.v3.core.ConnectionException: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "nzyme"
	at org.jdbi.v3.core.Jdbi.open(Jdbi.java:341) ~[nzyme-2.0.0-alpha.14.jar:?]

[lennartkoopmann]

FATAL: password authentication failed for user "nzyme"

This means that you are not providing the correct password for PostgreSQL user nzyme. You set it to a1b2c3d4 in the copy of commands you provided. Make sure it's set to the same value in your nzyme configuration file.

[sudo-joe]

Make sure it's set to the same value in your nzyme configuration file.
Thank's a lot Lennart for the help! Problem is solved :)