You are not logged in.

#1 2024-12-30 06:45:59

beef
Member
Registered: 2016-04-28
Posts: 25

[Solved] nextcloud + postgresql gives internal error

Hey,

I am trying to set up nextcloud locally on my arch laptop.

I followed the excellent wiki article (https://wiki.archlinux.org/title/Nextcloud) installed nextcloud, php-legacy, opted for postgresql as the database, FPM (php-legacy-fpm) as the application server, and nginx as the webserver.
After setting up nextcloud, database, application server and webserver (everything until wiki section 6), I wanted to make sure that my local installation works and opened https://localhost to see if I can reach the nextcloud web interface.

When using postgresql, I only see this error in the browser: "The server encountered an internal error and was unable to complete your request. ..."
When I switched from postgresql to MariaDB/MySQL (removing and reinstalling nextcloud, rerunning the occ command), it works!

Hence, I suspect that I made a mistake while setting up postgresql.

Is it correct to set

 occ ... --database-host=/run/postgresql 

when postgresql only listens on a local unix socket ?

Last edited by beef (2024-12-30 18:22:58)

Offline

#2 2024-12-30 18:21:58

beef
Member
Registered: 2016-04-28
Posts: 25

Re: [Solved] nextcloud + postgresql gives internal error

I should have followed the instructions more carefully (see https://wiki.archlinux.org/title/Nextcl … cloud.conf):

The settings php_value[...] and php_flag[..] must be consistent with the corresponding settings in /etc/webapps/nextcloud/php.ini (but not /etc/php-legacy/php-fpm.ini).

After I activated the pdo_pgsql instead of the pdo_mysql extension in nexcloud.conf, to be consistent with the previously adapted /etc/webapps/nextcloud/php.ini, everything works as expected.

Offline

Board footer

Powered by FluxBB