Error installing pixelfed / psql error

What type of hardware are you using: Virtual machine
What YunoHost version are you running: 12.0.10
What app is this about: Pixelfed

Describe your issue

Hello.

On a clean install of Yunohost I am trying to install Pixelfed, but I always get this error:

psql: error: failed to connect to server on socket “/var/run/postgresql/.s.PGSQL.5432”: FATAL: Peer authentication failed for user “pixelfed”.

I have searched the forums and can’t seem to find any information.

The version of pixelfed I am trying to install is 0.12.4~ynh1

Do you have any idea what could be happening and how can I fix it?

Thank you very much in advance!

Share relevant logs or error messages

https://paste.yunohost.org/raw/kikecoyaco

Bumping this. Same errors on same version here. Peertube install went fine but PixelFed is failing.

Hi ogps, neverwas,

Welcome to the forums!

What an unlucky coincidence that two new members have the same problem.

I just tried installing Pixelfed on a newly installed Yunohost, hoping to catch the error. Unfortunately enough, Pixelfed was installed successfully.

There don’t seem to be very any changes to the repository between your post and my attempt, the last change was a week ago. That one only touched documentation, changing PHP8.2 to PHP8.3. It did lead me to check your log for the PHP version. It is 8.3 everywhere, except for one check for existence (it checks for existence of 8.2, instead of 8.3):

2025-01-17 09:16:30,277: DEBUG - + ynh_app_setting_set --app=pixelfed --key=phpversion --value=8.3
2025-01-17 09:16:30,614: DEBUG - + test -e /usr/bin/php8.2

It is a minor bug, and can have consequences, but not with the symptoms you describe.

@neverwas: would you mind posting a link to your log as well, to see that the problem has the same cause?

@both_of_you: would you mind re-trying the installation? For me it worked, though it was the first app to install on this server. Perhaps there is some interference in your cases.

Here is a copy of my log:

Share relevant logs or error messages

https://paste.yunohost.org/raw/yorazubewe
[/quote]

I notice both of you have these lines at the end of the log:

@ogps :


2025-01-17 09:24:28,856: DEBUG -   Client ID ....... 1
2025-01-17 09:24:28,860: DEBUG -   Client secret ... 5NxiOrMSENDrWlNaxo63rIbRMI7v7fPsw32jVcEU

@neverwas :


2025-01-17 17:07:55,401: DEBUG -   Client ID .......1
2025-01-17 17:07:55,401: DEBUG -   Client secret ...THIvcwNpAdkdfkNHabQr1s2LoCzTKjCMACbyAw6h

The exciting bit being not that the passwords differ, but that the Client ID is 1. @neverwas already installed Peertube, so I’d expected Client ID 2

I installed a second Pixelfed, to try it out. This one also installed correctly, leaving no log.

Now I removed both Pixelfeds, and installed Peertube followed by Pixelfed. Somewhat contrary to my expectation, that also went flawless. Good news, of course, but no help for either of you.

Are there any warnings/errors in the diagnosis?

Hello

You are going to have to excuse me. My instance of yunohost did not really have a clean install, curiously like @neverwas I also had peertube installed, and then I tried to install pixelfed and it failed me with the logs you have seen above.

So I deleted and reinstalled yunohost, installing pixelfed first and this time the installation worked correctly. Then I installed peertube and it also installed correctly.

The problem seems that if I installed peertube first was in the client id?

For me the problem has been solved, thanks for your help.

1 Like

Hi ogps,

Good to read that your problem has been resolved, although ‘delete and start from scratch’ is not a satisfying solution :wink:

If it was, than that has been fixed: I could install first Peertube and then Pixelfed without a problem.

Have lots of fun with your Yunohost!

1 Like