Failed to connect to `host=/var/run/postgresql

Support apps
,
1

What type of hardware are you using: Old laptop or computer
What YunoHost version are you running: 12
What app is this about: pufferpanel

Describe your issue

I made some changes to Yunohost to solve a problem with Joplin. It was about deleting an old version of postgresql and changing the port for the right version.
Post : After installing Joplin : "Error: Postgres version not supported" - #13 by blodarn

Before making those changes, I had set up a minecraft server and a teamspeak server. They still work lol
My problem is that I can no longer access to the admin panel of Pufferpanel with the credentials that I was using before. Each time I try, I get “Database is not available”.

It’s something related to the fact I removed an old version of Postgres.

failed to connect to `host=/var/run/postgresql

Share relevant logs or error messages

“Unknown error” message after each attempt to log in.

Here is the log after I tried to log in with the credentials I set up when I installed Pufferpanel.

Nov 04 18:36:11 systemd[1]: Stopping pufferpanel.service - pufferpanel...
Nov 04 18:36:11 pufferpanel[470348]: [INFO] 2024/11/04 18:36:11 Shutting down...
Nov 04 18:36:11 pufferpanel[470348]: [DEBUG] 2024/11/04 18:36:11 stopping http server
Nov 04 18:36:11 pufferpanel[470348]: [DEBUG] 2024/11/04 18:36:11 stopping sftp server
Nov 04 18:36:11 pufferpanel[470348]: [DEBUG] 2024/11/04 18:36:11 stopping servers
Nov 04 18:36:11 pufferpanel[470348]: [DEBUG] 2024/11/04 18:36:11 stopping database connections
Nov 04 18:36:11 systemd[1]: pufferpanel.service: Deactivated successfully.
Nov 04 18:36:11 systemd[1]: Stopped pufferpanel.service - pufferpanel.
Nov 04 18:36:11 systemd[1]: pufferpanel.service: Consumed 21.102s CPU time.
Nov 04 18:36:11 systemd[1]: Started pufferpanel.service - pufferpanel.
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: oauthCreated
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: oauthDeleted
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: passwordChanged
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: otpDisabled
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: removedFromServer
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: login
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: otpEnabled
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: passwordReset
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: emailChanged
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: deletedServer
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: accountCreation
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 Email template registered: addedToServer
Nov 04 18:36:11 pufferpanel[599786]: [DEBUG] 2024/11/04 18:36:11 openat2 enabled
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Loading existing key
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Started SFTP Server on 0.0.0.0:5657
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Attempting to load 07418afd.json
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Loaded server 07418afd
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Attempting to load 617a7f39.json
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Loaded server 617a7f39
Nov 04 18:36:11 pufferpanel[599786]: [INFO] 2024/11/04 18:36:11 Listening for HTTP requests on 127.0.0.1:19271
Nov 04 18:43:10 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:10 Error connecting to database: failed to connect to `host=/var/run/postgresql user=pufferpanel database=pufferpanel`: failed SASL auth (FATAL: password authentication failed for user "pufferpanel" (SQLSTATE 28P01))
Nov 04 18:43:10 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:10 Database not available: database not available
Nov 04 18:43:10 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:10 database not available
Nov 04 18:43:10 pufferpanel[599786]: [GIN] 2024/11/04 - 18:43:10 | 500 |   11.417295ms |  24.200.201.149 | GET      "/api/config"
Nov 04 18:43:12 pufferpanel[599786]: [GIN] 2024/11/04 - 18:43:12 | 304 |     141.114µs |  24.200.201.149 | GET      "/service-worker.js"
Nov 04 18:43:16 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:16 Error connecting to database: failed to connect to `host=/var/run/postgresql user=pufferpanel database=pufferpanel`: failed SASL auth (FATAL: password authentication failed for user "pufferpanel" (SQLSTATE 28P01))
Nov 04 18:43:16 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:16 Database not available: database not available
Nov 04 18:43:16 pufferpanel[599786]: [ERROR] 2024/11/04 18:43:16 database not available
Nov 04 18:43:16 pufferpanel[599786]: [GIN] 2024/11/04 - 18:43:16 | 500 |   11.546907ms |  24.200.201.149 | POST     "/auth/login"
3

Backup of initial files for Pufferpanel

sudo cp -r /etc/pufferpanel /etc/pufferpanel_backup
sudo cp -r /home/yunohost.app/pufferpanel /home/yunohost.app/pufferpanel_backup

Uninstall PufferPanel, which will remove application files but leave your data directory intact.

sudo apt remove pufferpanel --purge

sudo apt update

Reinstall PufferPanel via Yunohost admin panel

Stop service of Pufferpanel via Yunohost admin panel

Transfer backup file to active folder of Pufferpanel :

sudo rsync -av /home/yunohost.app/pufferpanel_backup/ /home/yunohost.app/pufferpanel/

Grant Ownership to the PufferPanel Directory

sudo chown -R pufferpanel:pufferpanel /home/yunohost.app/pufferpanel

Pufferpanel back online but nothing in servers and templates section.
The files are there but not detected…

4

By checking the logs, servers are loaded but not shown in Pufferpanel :frowning:

Nov 04 23:47:35 systemd[1]: Started pufferpanel.service - pufferpanel.

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: emailChanged

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: oauthCreated

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: oauthDeleted

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: otpDisabled

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: addedToServer

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: passwordChanged

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: deletedServer

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: otpEnabled

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: removedFromServer

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: accountCreation

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: passwordReset

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 Email template registered: login

Nov 04 23:47:35 pufferpanel[676259]: [DEBUG] 2024/11/04 23:47:35 openat2 enabled

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Loading existing key

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Started SFTP Server on 0.0.0.0:5657

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Attempting to load 07418afd.json

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Loaded server 07418afd

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Attempting to load 617a7f39.json

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Loaded server 617a7f39

Nov 04 23:47:35 pufferpanel[676259]: [INFO] 2024/11/04 23:47:35 Listening for HTTP requests on 127.0.0.1:19271

sudo -u postgres psql -d pufferpanel -c "SELECT * FROM servers;"
could not change directory to "/root": Permission denied
 name | identifier | node_id | ip | port | type | created_at | updated_at
------+------------+---------+----+------+------+------------+------------
(0 rows)
5

Gave up. I reinstalled everything.

6

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.