Nextcloud version (eg, 20.0.5): 20.0.8.1
Operating system and version (eg, Ubuntu 20.04): 20.04.2 LTS
Apache or nginx version (eg, Apache 2.4.25): 2.4.41
PHP version (eg, 7.4): 7.4.3
The issue you are facing:
When I try to access my nextcloud, I get the following error in my browser:
Internal Server Error
The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.
Is this the first time you’ve seen this error? (Y/N): Y
Steps to replicate it:
- go to teufel-cloud.ddns.net
The output of your Nextcloud log in Admin > Logging:
since I can’t log, here’re the last two lines of the nextcloud.log (the rest seems to be the exact same error):
{"reqId":"so34f1LJkeEC2bmalPcs","level":3,"time":"2021-04-12T17:29:12+00:00","remoteAddr":"79.217.46.13","user":"--","app":"core","method":"GET","url":"/","message":{"Exception":"Doctrine\\DBAL\\DBALException","Message":"Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1449,"function":"connect","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":892,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":345,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":110,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":301,"function":"getApps","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":949,"function":"getValues","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":668,"function":"getAppVersions","class":"OC_App","type":"::"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1677,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":854,"function":"getMemCacheFactory","class":"OC\\Server","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":56,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":177,"function":"get","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":114,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1886,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":370,"function":"getAppManager","class":"OC\\Server","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Util.php","line":1460,"function":"getEnabledApps","class":"OC_App","type":"::"},{"file":"/var/www/nextcloud/lib/public/Util.php","line":516,"function":"needUpgrade","class":"OC_Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Template.php","line":117,"function":"needUpgrade","class":"OCP\\Util","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Template.php","line":78,"function":"initTemplateEngine","class":"OC_Template","type":"::"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_Template.php","line":322,"function":"__construct","class":"OC_Template","type":"->"},{"file":"/var/www/nextcloud/index.php","line":63,"function":"printExceptionErrorPage","class":"OC_Template","type":"::"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":72,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.116 Safari/537.36","version":"20.0.8.1"}
{"reqId":"QA1E2o1SHaH0rx7cwOzx","level":3,"time":"2021-04-12T17:30:01+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":{"Exception":"Doctrine\\DBAL\\DBALException","Message":"Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory","Code":0,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1449,"function":"connect","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":892,"function":"getWrappedConnection","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":202,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":206,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":217,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":345,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":110,"function":"loadConfigValues","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppConfig.php","line":301,"function":"getApps","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/legacy/OC_App.php","line":949,"function":"getValues","class":"OC\\AppConfig","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":668,"function":"getAppVersions","class":"OC_App","type":"::"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1677,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1017,"function":"getMemCacheFactory","class":"OC\\Server","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1977,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Files/View.php","line":118,"function":"getLockingProvider","class":"OC\\Server","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":395,"function":"__construct","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":155,"function":"OC\\{closure}","class":"OC\\Server","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php","line":118,"function":"OC\\AppFramework\\Utility\\{closure}","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":122,"function":"offsetGet","class":"Pimple\\Container","type":"->"},{"file":"/var/www/nextcloud/lib/private/ServerContainer.php","line":156,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->"},{"file":"/var/www/nextcloud/lib/private/Server.php","line":1324,"function":"query","class":"OC\\ServerContainer","type":"->"},{"file":"/var/www/nextcloud/lib/base.php","line":595,"function":"boot","class":"OC\\Server","type":"->"},{"file":"/var/www/nextcloud/lib/base.php","line":1091,"function":"init","class":"OC","type":"::"},{"file":"/var/www/nextcloud/cron.php","line":42,"args":["/var/www/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/DB/Connection.php","Line":72,"CustomMessage":"--"},"userAgent":"--","version":"20.0.8.1"}
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'ocfehyzxc5ql',
'passwordsalt' => '***',
'secret' => '***',
'trusted_domains' =>
array (
0 => 'teufel-cloud.ddns.net',
),
'datadirectory' => 'dir',
'dbtype' => 'mysql',
'version' => '20.0.8.1',
'overwrite.cli.url' => 'http://teufel-cloud.ddns.net',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'user',
'dbpassword' => '***',
'installed' => true,
'mail_from_address' => 'cloud',
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'mail_domain' => 'domain',
'mail_smtpsecure' => 'tls',
'mail_smtphost' => 'smtp.gmail.com',
'mail_smtpport' => '587',
'twofactor_enforced' => 'false',
'twofactor_enforced_groups' =>
array (
),
'twofactor_enforced_excluded_groups' =>
array (
),
'mail_smtpauthtype' => 'LOGIN',
'mail_smtpauth' => 1,
'mail_smtpname' => 'mailadress',
'mail_smtppassword' => '***',
'maintenance' => false,
'theme' => '',
'loglevel' => 2,
'memcache.local' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => '127.0.0.1',
'port' => 6379,
),
'memcache.locking' => '\\OC\\Memcache\\Redis',
);
The output of your Apache/nginx/system log in /var/log/____:
[Mon Apr 12 14:50:19.880061 2021] [ssl:warn] [pid 1066] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 14:50:19.939332 2021] [ssl:warn] [pid 1116] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 14:50:19.942505 2021] [mpm_prefork:notice] [pid 1116] AH00163: Apa
che/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Mon Apr 12 14:50:19.942525 2021] [core:notice] [pid 1116] AH00094: Command li
ne: '/usr/sbin/apache2'
[Mon Apr 12 15:58:45.624454 2021] [mpm_prefork:notice] [pid 1116] AH00169: cau
ght SIGTERM, shutting down
[Mon Apr 12 15:59:12.682155 2021] [ssl:warn] [pid 1055] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 15:59:12.789355 2021] [ssl:warn] [pid 1058] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 15:59:12.792375 2021] [mpm_prefork:notice] [pid 1058] AH00163: Apa
che/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Mon Apr 12 15:59:12.792398 2021] [core:notice] [pid 1058] AH00094: Command li
ne: '/usr/sbin/apache2'
[Mon Apr 12 16:44:59.214170 2021] [mpm_prefork:notice] [pid 1058] AH00169: cau
ght SIGTERM, shutting down
[Mon Apr 12 16:45:25.582138 2021] [ssl:warn] [pid 1039] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 16:45:25.714336 2021] [ssl:warn] [pid 1048] AH01909: 127.0.0.1:443
:0 server certificate does NOT include an ID which matches the server name
[Mon Apr 12 16:45:25.717152 2021] [mpm_prefork:notice] [pid 1048] AH00163: Apa
che/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations
[Mon Apr 12 16:45:25.717175 2021] [core:notice] [pid 1048] AH00094: Command li
ne: '/usr/sbin/apache2'
[Mon Apr 12 16:52:38.452074 2021] [php7:warn] [pid 1057] [client 79.217.46.13:
44208] PHP Warning: Cannot modify header information - headers already sent b
y (output started at /var/www/nextcloud/index.php:32) in /var/www/nextcloud/li
b/private/legacy/OC_Template.php on line 350
[Mon Apr 12 16:52:38.807194 2021] [php7:warn] [pid 1057] [client 79.217.46.13:
44208] PHP Warning: Cannot modify header information - headers already sent b
y (output started at /var/www/nextcloud/index.php:32) in /var/www/nextcloud/li
b/private/legacy/OC_Template.php on line 350
[Mon Apr 12 17:36:03.603891 2021] [php7:error] [pid 46224] [client 150.138.145
.3:55012] script '/var/www/html/elrekt.php' not found or unable to stat
[Mon Apr 12 17:36:04.120473 2021] [php7:error] [pid 1058] [client 150.138.145.
3:34030] script '/var/www/html/index.php' not found or unable to stat
In the mysql error.log I found this:
Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
2021-04-12T18:23:49.875730Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (
mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 88202
2021-04-12T18:23:49.882503Z 1 [System] [MY-013576] [InnoDB] InnoDB initializat
ion has started.
2021-04-12T18:23:50.355729Z 1 [System] [MY-013577] [InnoDB] InnoDB initializat
ion has ended.
2021-04-12T18:23:50.449080Z 0 [System] [MY-011323] [Server] X Plugin ready for
connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/m
ysqlx.sock
mysqld: File './binlog.001665' not found (OS errno 2 - No such file or directo
ry)
2021-04-12T18:23:50.478767Z 0 [ERROR] [MY-010958] [Server] Could not open log
file.
2021-04-12T18:23:50.478921Z 0 [ERROR] [MY-010041] [Server] Can't init tc log
2021-04-12T18:23:50.479209Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-04-12T18:23:52.015735Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld:
Shutdown complete (mysqld 8.0.23-0ubuntu0.20.04.1) (Ubuntu).
Since the nextcloud.log says
"Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2002] No such file or directory"
and the mysql error.log didn’t find this binlog file, I suppose that is my problem. But sadly I wasn’t able to figure out, how to fix this yet. So I really hope you guys can help me with that.
Thanks in advance!
UPDATE:
I found a solution for the mysql error. I just needed to clear out the binlog.index file. Then after a restart of mysql it worked again. Sadly this didn’t do the trick and I still get this internal server error.
Please find the updated nextcloud.log below:
Thanks!