Internal server error after update [nextcloudpi]

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
1

Hello, I’m quite new to Nextcloud. I have installed nextcloudpi on a rapsberry pi 4. Everything was working fine since I just updated nextcloudpi, nextcloud and all the apps from ncp-config (by ssh).

Nextcloud version : 20.0.8.1
Operating system and version : Nextcloupi
PHP version : 7.3.27-1~deb10u1

When I try to access to my nextcloud page I get an internal server error. (This is the first time I see this error)

Here is the result of ncp-report : pastebin

The output of your config.php

<?php
$CONFIG = array (
  'passwordsalt' => XXXXX',
  'secret' => 'XXXXX',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    5 => 'nextcloudpi.local',
    7 => 'nextcloudpi',
    8 => 'nextcloudpi.lan',
    11 => 'XXXXX',
    1 => '192.168.1.X',
    3 => 'XXXXX',
    2 => 'XXXXX',
    12 => 'XXXXX',
    20 => 'XXXXX',
    21 => 'XXXXX',
  ),
  'datadirectory' => '/var/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '20.0.8.1',
  'overwrite.cli.url' => 'XXXXX',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'ncadmin',
  'dbpassword' => 'XXXXX',
  'installed' => true,
  'instanceid' => 'XXXXX',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
    'timeout' => 0.0,
    'password' => 'XXXXX',
  ),
  'tempdirectory' => '/var/www/nextcloud/data/tmp',
  'mail_smtpmode' => 'smtp',
  'mail_from_address' => 'XXXXX',
  'mail_domain' => 'XXXXX',
  'preview_max_x' => '2048',
  'preview_max_y' => '2048',
  'jpeg_quality' => '60',
  'overwriteprotocol' => 'https',
  'loglevel' => '2',
  'log_type' => 'file',
  'maintenance' => false,
  'htaccess.RewriteBase' => '/',
  'mail_sendmailmode' => 'smtp',
  'mail_smtpauthtype' => 'PLAIN',
  'mail_smtphost' => 'XXXXX',
  'mail_smtpport' => '465',
  'music.lastfm_api_key' => 'XXXXX',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'XXXXX',
  'mail_smtppassword' => 'XXXXX',
  'mail_smtpsecure' => 'ssl',
  'theme' => '',
  'updater.secret' => 'XXXXX',
);

The output of /var/log/apache2/error.log:

[Sun Feb 28 00:00:07.794793 2021] [mpm_event:notice] [pid 762:tid 547799913840] AH00489: Apache/2.4.38 (Debian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Feb 28 00:00:07.794887 2021] [core:notice] [pid 762:tid 547799913840] AH00094: Command line: '/usr/sbin/apache2'
[Sun Feb 28 01:19:04.529709 2021] [authz_host:error] [pid 6382:tid 546559730064] [client 183.136.225.46:33047] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 01:19:04.529836 2021] [authz_core:error] [pid 6382:tid 546559730064] [client 183.136.225.46:33047] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 01:19:11.390556 2021] [authz_host:error] [pid 6381:tid 546920452496] [client 183.136.225.46:29344] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 01:19:11.390683 2021] [authz_core:error] [pid 6381:tid 546920452496] [client 183.136.225.46:29344] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 04:10:21.118540 2021] [authz_host:error] [pid 6381:tid 545980928400] [client 183.136.225.46:46396] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 04:10:21.118726 2021] [authz_core:error] [pid 6381:tid 545980928400] [client 183.136.225.46:46396] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 04:10:22.587570 2021] [authz_host:error] [pid 6381:tid 547471565200] [client 183.136.225.46:1953] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 04:10:22.587729 2021] [authz_core:error] [pid 6381:tid 547471565200] [client 183.136.225.46:1953] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 04:10:28.164809 2021] [authz_host:error] [pid 6382:tid 546584908176] [client 183.136.225.46:2119] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name
[Sun Feb 28 04:10:28.164986 2021] [authz_core:error] [pid 6382:tid 546584908176] [client 183.136.225.46:2119] AH01630: client denied by server configuration: /var/www/ncp-web/favicon.ico
[Sun Feb 28 08:43:08.966382 2021] [authz_host:error] [pid 6382:tid 547463164304] [client 183.136.225.46:12885] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 08:43:08.966571 2021] [authz_core:error] [pid 6382:tid 547463164304] [client 183.136.225.46:12885] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 08:43:12.143074 2021] [authz_host:error] [pid 6382:tid 546559730064] [client 183.136.225.46:27900] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 08:43:12.143196 2021] [authz_core:error] [pid 6382:tid 546559730064] [client 183.136.225.46:27900] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 08:43:18.865319 2021] [authz_host:error] [pid 6382:tid 546551337360] [client 183.136.225.46:28378] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name
[Sun Feb 28 08:43:18.865504 2021] [authz_core:error] [pid 6382:tid 546551337360] [client 183.136.225.46:28378] AH01630: client denied by server configuration: /var/www/ncp-web/favicon.ico
[Sun Feb 28 09:19:51.354348 2021] [authz_core:error] [pid 6382:tid 547054670224] [client 162.142.125.53:57900] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 09:19:51.817200 2021] [authz_core:error] [pid 6382:tid 546601693584] [client 162.142.125.53:52220] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 09:59:43.509348 2021] [authz_host:error] [pid 6382:tid 547513602448] [client 139.28.219.84:42196] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 09:59:43.510051 2021] [authz_core:error] [pid 6382:tid 547513602448] [client 139.28.219.84:42196] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 09:59:43.596424 2021] [authz_host:error] [pid 6382:tid 547513602448] [client 139.28.219.84:42196] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 09:59:43.596505 2021] [authz_core:error] [pid 6382:tid 547513602448] [client 139.28.219.84:42196] AH01630: client denied by server configuration: /var/www/ncp-web/favicon.ico, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 10:04:48.463326 2021] [authz_host:error] [pid 6381:tid 547723485584] [client 139.28.219.84:42378] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 10:04:48.463444 2021] [authz_core:error] [pid 6381:tid 547723485584] [client 139.28.219.84:42378] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 10:04:48.562883 2021] [authz_host:error] [pid 6381:tid 547723485584] [client 139.28.219.84:42378] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 10:04:48.562953 2021] [authz_core:error] [pid 6381:tid 547723485584] [client 139.28.219.84:42378] AH01630: client denied by server configuration: /var/www/ncp-web/favicon.ico, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 10:04:55.411815 2021] [authz_host:error] [pid 6382:tid 547547206032] [client 139.28.219.84:42380] AH01753: access check of 'localhost' to / failed, reason: unable to get the remote host name
[Sun Feb 28 10:04:55.411929 2021] [authz_core:error] [pid 6382:tid 547547206032] [client 139.28.219.84:42380] AH01630: client denied by server configuration: /var/www/ncp-web/
[Sun Feb 28 10:04:55.472307 2021] [authz_host:error] [pid 6382:tid 547547206032] [client 139.28.219.84:42380] AH01753: access check of 'localhost' to /favicon.ico failed, reason: unable to get the remote host name, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 10:04:55.472380 2021] [authz_core:error] [pid 6382:tid 547547206032] [client 139.28.219.84:42380] AH01630: client denied by server configuration: /var/www/ncp-web/favicon.ico, referer: https://kuluse.mooo.com:4443/
[Sun Feb 28 12:01:59.726515 2021] [mpm_event:notice] [pid 762:tid 547799913840] AH00491: caught SIGTERM, shutting down
[Sun Feb 28 12:02:15.163411 2021] [ssl:warn] [pid 603:tid 548474865008] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Feb 28 12:02:15.203552 2021] [ssl:warn] [pid 746:tid 548474865008] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Feb 28 12:02:15.207766 2021] [mpm_event:notice] [pid 746:tid 548474865008] AH00489: Apache/2.4.38 (Debian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Feb 28 12:02:15.207895 2021] [core:notice] [pid 746:tid 548474865008] AH00094: Command line: '/usr/sbin/apache2'
[Sun Feb 28 12:06:34.185238 2021] [mpm_event:notice] [pid 746:tid 548474865008] AH00493: SIGUSR1 received.  Doing graceful restart
[Sun Feb 28 12:06:34.210289 2021] [ssl:warn] [pid 746:tid 548474865008] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sun Feb 28 12:06:34.211484 2021] [mpm_event:notice] [pid 746:tid 548474865008] AH00489: Apache/2.4.38 (Debian) OpenSSL/1.1.1d configured -- resuming normal operations
[Sun Feb 28 12:06:34.211513 2021] [core:notice] [pid 746:tid 548474865008] AH00094: Command line: '/usr/sbin/apache2'

The output of /var/log/apache2/nc-error.log:

[Sun Feb 28 10:04:22.143719 2021] [access_compat:error] [pid 6382:tid 547622773136] [client 139.28.219.84:29892] AH01797: client denied by server configuration: /var/www/nextcloud/data/.ocdata
[Sun Feb 28 10:47:52.636269 2021] [access_compat:error] [pid 6382:tid 547597595024] [client 139.28.219.84:37652] AH01797: client denied by server configuration: /var/www/nextcloud/data/.ocdata
[Sun Feb 28 10:47:56.254046 2021] [access_compat:error] [pid 6382:tid 547522003344] [client 139.28.219.84:37652] AH01797: client denied by server configuration: /var/www/nextcloud/data/.ocdata
[Sun Feb 28 10:48:18.724005 2021] [access_compat:error] [pid 6381:tid 547564007824] [client 139.28.219.84:39916] AH01797: client denied by server configuration: /var/www/nextcloud/data/.ocdata
[Sun Feb 28 11:53:14.651709 2021] [core:crit] [pid 6381:tid 547740270992] (13)Permission denied: [client 139.28.219.84:33814] AH00529: /var/www/nextcloud/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/var/www/nextcloud/' is executable

The output of /var/log/syslog : pastebin

Thank you very much in advance for your help !

2

Are you able to access the NCP Panel or is this also not working?

I am still playing with my new installation and had the error also.
After getting a short heart attack i checked the update section and ran it gain.

Finally after a reboot the site was accessible again

3

No i’m not :confused: I get this message :

Forbidden 
You don't have permission to access this resource.

I think this was already the case before, but I’m not sure.

I tried to re-run the updates from ncp-config (ssh) but nothing happenned since the system is up to date.

Thank you for your answer anyway, I feel less alone

4

This seem to be a permission issue. Strange.
As i am pretty new, i am sorry not able to help. So far no idea…

5

Probably, I hope somebody will be able to help.
Thank you anyway :slightly_smiling_face:

6

hello, today i had the same problem and some servers are down since today. In my case it was the solution that i new installed redis on all servers:
apt install php7.3-redis

Current the same problem on my other servers. In nextcloudpi i have unattanded-upgrades active, and that since years. Debian Buster 10 ist the basesystem and it was ever reliable. Can somebody explain why came suddenly this issue?
Is this a Bug in automated update/upgrade-process?

1 Like
7

Hello @ncape and thank you, it indeed seems related.

However I’m unable to install php7.3-redis :

$ sudo apt-get install php7.3-redis
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Note, selecting 'php-redis' instead of 'php7.3-redis'
php-redis is already the newest version (4.2.0-1).
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

Also, it seems related to this but I don’t really know what to do.

PHP is in version 7.3 and php-redis is in version 4.2.0-1

8

It seems that I have both, php and php7.3 installed. Is this normal ?

$ dpkg -s php7.3 | grep -i version
Version: 7.3.27-1~deb10u1
 have at least one of the four server-side versions of the PHP interpreter

$ dpkg -s php | grep -i version
Version: 2:7.3+69
 PHP version (currently 7.3).

The 7.3 version is in use :

$ php --version
PHP 7.3.27-1~deb10u1 (cli) (built: Feb 13 2021 16:31:40) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.27, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.3.27-1~deb10u1, Copyright (c) 1999-2018, by Zend Technologies
9

what say the log of /var/www/nextcloud/data/nextcloud.log when do you go on your nextcloud site?
What says: systemctl status php7.3-fpm

10 
$ systemctl status php7.3-fpm
● php7.3-fpm.service - The PHP 7.3 FastCGI Process Manager
   Loaded: loaded (/lib/systemd/system/php7.3-fpm.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2021-02-28 18:38:01 GMT; 21min ago
     Docs: man:php-fpm7.3(8)
 Main PID: 570 (php-fpm7.3)
   Status: "Processes active: 0, idle: 6, Requests: 84, slow: 0, Traffic: 0req/sec"
    Tasks: 7 (limit: 4915)
   CGroup: /system.slice/php7.3-fpm.service
           ├─570 php-fpm: master process (/etc/php/7.3/fpm/php-fpm.conf)
           ├─904 php-fpm: pool www
           ├─905 php-fpm: pool www
           ├─906 php-fpm: pool www
           ├─907 php-fpm: pool www
           ├─908 php-fpm: pool www
           └─910 php-fpm: pool www

Feb 28 18:38:00 nextcloudpi systemd[1]: Starting The PHP 7.3 FastCGI Process Manager...
Feb 28 18:38:01 nextcloudpi systemd[1]: Started The PHP 7.3 FastCGI Process Manager.

$ sudo tail -n 5 /var/www/nextcloud/data/nextcloud.log
{"reqId":"REQID","level":3,"time":"2021-02-28T18:55:42+00:00","remoteAddr":"IPADRESS","user":"USERNAME","app":"index","method":"GET","url":"/apps/files/","message":{"Exception":"Doctrine\\DBAL\\Exception\\TableNotFoundException","Message":"An exception occurred while executing 'SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL' with params [\"USERNAME\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL' with params [\"USERNAME\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist",{"errorInfo":["42S02",1146,"Table 'nextcloud.oc_talk_participants' doesn't exist"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":149,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["42S02",1146,"Table 'nextcloud.oc_talk_participants' doesn't exist"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL' with params [\"USERNAME\"]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist"]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":914,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["42S02",1146,"Table 'nextcloud.oc_talk_participants' doesn't exist"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",{"1":"USERNAME"}]},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",["USERNAME"],[2],null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = :dcValue1) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",{"dcValue1":"USERNAME"},{"dcValue1":2}]},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->","args":["USERNAME",10,null,-1,0]},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->","args":["USERNAME",10,null,-1]},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Mount\\Manager"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME","/USERNAME/files"]},{"file":"/var/www/nextcloud/lib/base.php","line":1007,"function":"setupFS","class":"OC_Util","type":"::","args":[]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":42,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist","Code":"42S02","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",["USERNAME"],[2],null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = :dcValue1) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",{"dcValue1":"USERNAME"},{"dcValue1":2}]},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->","args":["USERNAME",10,null,-1,0]},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->","args":["USERNAME",10,null,-1]},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Mount\\Manager"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME","/USERNAME/files"]},{"file":"/var/www/nextcloud/lib/base.php","line":1007,"function":"setupFS","class":"OC_Util","type":"::","args":[]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":129,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_talk_participants' doesn't exist","Code":"42S02","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":127,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":906,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = ?) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",["USERNAME"],[2],null]},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT `r`.*, `p`.* FROM `oc_talk_rooms` `r` LEFT JOIN `oc_talk_participants` `p` ON (`p`.`user_id` = :dcValue1) AND (`p`.`room_id` = `r`.`id`) WHERE `p`.`user_id` IS NOT NULL",{"dcValue1":"USERNAME"},{"dcValue1":2}]},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Manager.php","line":294,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/nextcloud/apps/spreed/lib/Share/RoomShareProvider.php","line":779,"function":"getRoomsForParticipant","class":"OCA\\Talk\\Manager","type":"->","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1332,"function":"getSharedWith","class":"OCA\\Talk\\Share\\RoomShareProvider","type":"->","args":["USERNAME",10,null,-1,0]},{"file":"/var/www/nextcloud/apps/files_sharing/lib/MountProvider.php","line":80,"function":"getSharedWith","class":"OC\\Share20\\Manager","type":"->","args":["USERNAME",10,null,-1]},{"file":"/var/www/nextcloud/lib/private/Files/Config/MountProviderCollection.php","line":119,"function":"getMountsForUser","class":"OCA\\Files_Sharing\\MountProvider","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Storage\\StorageFactory"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":452,"function":"addMountForUser","class":"OC\\Files\\Config\\MountProviderCollection","type":"->","args":[{"__class__":"OC\\User\\User"},{"__class__":"OC\\Files\\Mount\\Manager"}]},{"file":"/var/www/nextcloud/lib/private/Files/Filesystem.php","line":377,"function":"initMountPoints","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME"]},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":322,"function":"init","class":"OC\\Files\\Filesystem","type":"::","args":["USERNAME","/USERNAME/files"]},{"file":"/var/www/nextcloud/lib/base.php","line":1007,"function":"setupFS","class":"OC_Util","type":"::","args":[]},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":127}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; rv:78.0) Gecko/20100101 Firefox/78.0","version":"20.0.8.1"
11

Reading state information… Done
Note, selecting ‘php-redis’ instead of ‘php7.3-redis’
hmmm :confused:
What says: systemctl status redis-server

12 
$ systemctl status redis-server
● redis-server.service - Advanced key-value store
   Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor preset: enabled)
   Active: active (running) since Sun 2021-02-28 18:38:38 GMT; 38min ago
     Docs: http://redis.io/documentation,
           man:redis-server(1)
  Process: 1231 ExecStart=/usr/bin/redis-server /etc/redis/redis.conf (code=exited, status=0/SUCCES
 Main PID: 1261 (redis-server)
    Tasks: 4 (limit: 4915)
   CGroup: /system.slice/redis-server.service
           └─1261 /usr/bin/redis-server 127.0.0.1:0

Feb 28 18:38:38 nextcloudpi systemd[1]: Starting Advanced key-value store...
Feb 28 18:38:38 nextcloudpi systemd[1]: redis-server.service: Can't open PID file /run/redis/redis-
Feb 28 18:38:38 nextcloudpi systemd[1]: Started Advanced key-value store.

(Thank you @ncape for investigating)

13

Sorry to insist, but can somebody help ?
I have no idea what is going on and some user are also trying to connect without success.

Thank you in advance !

14

I tried to read all your topic, I’m not sure you have exactly the same trouble than I had yesterday.

Mine was that Nextcloud and Redis were using 2 different versions of PHP (PHP 7.4 for NC and PHP8.0 for Redis).

I realised it cause Nextcloud was working back if I commented the lines about cache :

config.php

#‘memcache.local’ => ‘\OC\Memcache\Redis’,
#‘memcache.locking’ => ‘\OC\Memcache\Redis’,
#‘redis’ =>
#array (
#‘host’ => ‘/var/run/redis/redis.sock’,
#‘port’ => 0,
#‘timeout’ => 0.0,
#‘password’ => ‘XXXXX’,
#),

You’re using PHP7.3. I suggest you to upgrade your PHP version to 8. You’re maybe not obliged to do it now but it will be necessary in the future, this is why I’m advising you to do it. If it’s not the problem, you will know PHP version was not the solution.

I can shortly describe you the procedure:

  • Install PHP8.0 and all dependencies required by Nextcloud (you can list your actual modules for know what to install with : dpkg -l | grep php )
  • Activate PHP8.0 and disable old version
  • Reconfigure PHP.ini in /etc/php/apache2/ for the “memory_limit”
  • Test with “php -v” if the good version is running

I’ve tried to summary this :

Try to script

apt-get update
apt-get upgrade

sudo add-apt-repository ppa:ondrej/php # The repo for PHP8.0
sudo apt-get update

sudo apt install libapache2-mod-php8.0
sudo apt install php8.0-gd php8.0-mysql php8.0-curl php8.0-mbstring php8.0-intl
sudo apt install php8.0-gmp php8.0-bcmath php-imagick php8.0-xml php8.0-zip

sudo a2enmod php8.0 #Load the module for Apache
sudo a2dismod php7.3 #Unload the old version
sudo systemctl restart apache2

I’m not a pro, but I think there is not big mistakes in these instructions. Maybe someone can approve it.

One more time, this solution worked for it was a PHP problem version.
I hope it will help you

15

Thank you for your reply @xetyr but you’re right it is not the same issue.

It seems that the issue is with Talk. I desactivated the app and it works again.
So I’m looking closer to this post which adresses my issue.

I continue this thread here.

16

Thank you very much for your post.
My server was down for 2 days cause of updating php to version 8. After downgrading to 7.4 it was neither reachable. Now, after installing php7.4-redis, the server is up again :heart_eyes:

Hint for other users:
with “whereis php” you can check which versions an sub-packages of php are installed. Yo you can check if e.g. php7.4-redis is on your machine.