Internal error if I want log in

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version: 19.0.4.2
Operating system and version: Ubuntu 18.04.5 LTS
Apache version: Apache/2.4.46 (Ubuntu)
PHP Version => 7.2.34-8+ubuntu18.04.1+deb.sury.org+1

The issue you are facing:

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): YES

Steps to replicate it:

  1. sudo systemctl restart apache2 && systemctl restart mariadb
  2. rm /var/lib/mysql/tc.log
  3. remove all php and install new (apt-get install php7.1-fpm php7.1 php7.1-xml php7.1 php7.1-cgi php7.1-cli php7.1-gd php7.1-curl php7.1-zip php7.1-mysql php7.1-mbstring)

The first issue I saw when I add a new User. Then I found the second issue with not enough space. I’ve removed some files from nextcloud/data and finally add more storage.
I’m trying to find solutions and apter this bellow system works 1 day :slightly_smiling_face:
Currently I have still a problem and I don’t know this fix it

 1865  rm /var/lib/mysql/tc.log
 1866  sudo systemctl restart mysql.service
 1868  sudo systemctl restart apache2
 1869  sudo apt install xml-core php7.3-xml php7.3-zip php7.3-mbstring php7.3-mysql php7.3-gd php7.3-curl php7.3-intl
 1870  sudo systemctl restart apache2
 1871  sudo systemctl status mysql.service
 1874  zgrep -E "^(Remove:|Purge)" /var/log/apt/history.log*
 1875  su -u www-data php /var/www/html/nextcloud/occ maintenance:repair
 1876  cd /var/www/html/nextcloud/
 1882  sudo -u www-data php occ maintenance:repair
 1883  sudo -u www-data php occ check
 1884  rm /var/lib/mysql/tc.log
 1886  sudo systemctl status mariadb
 1887  sudo systemctl
 1888  df -h
 1889  mc
 1890  df -h
 1891  reboot
 1892  zgrep -E "^(Remove:|Purge)" /var/log/apt/history.log*
 1893  /var/log/apt/history.log:Remove: php7.3-xml:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), php7.3-zip:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), php7.3-mbstring:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), sgml-base:amd64 (1.29), php7.0-gd:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893), libicu64:amd64 (64.1-0.1+0~20190410090943.5+stretch~1.gbp38f694), php7.3-mysql:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), php7.3-gd:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), php7.3-curl:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), php7.3-intl:amd64 (7.3.15-4+0~20200224.55+debian9~1.gbpbea824), xml-core:amd64 (0.17), php7.0-mbstring:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893), php7.0-curl:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893), php7.0-zip:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893), php7.0-intl:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893), php7.0-mysql:amd64 (7.0.33-25+0~20200225.32+debian9~1.gbpa11893)
 1895  clear
 1896  ls -l /var/www/html/nextcloud/
 1904  sudo -u www-data php /var/www/nextcloud/occ files:scan --all
 1905  cd /var/www/nextcloud/
 1906  cd /var/www/html/nextcloud/
 1909  sudo -u www-data php ./occ files:scan --all
 1910  sudo systemctl restart apache2
 1911  systemctl restart mariadb

The output of your Nextcloud log in Admin > Logging:
tail -f /var/www/html/nextcloud/data/nextcloud.log | jq

{
  
      {
        "file": "/var/www/html/nextcloud/lib/private/Files/Stream/Encryption.php",
        "line": 501,
        "function": "decrypt",
        "class": "OCA\\Encryption\\Crypto\\Encryption",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/nextcloud/lib/private/Files/Stream/Encryption.php",
        "line": 299,
        "function": "readCache",
        "class": "OC\\Files\\Stream\\Encryption",
        "type": "->",
        "args": []
      },
      {
        "function": "stream_read",
        "class": "OC\\Files\\Stream\\Encryption",
        "type": "->",
        "args": [
          8192
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/icewind/streams/src/Wrapper.php",
        "line": 91,
        "function": "fread",
        "args": [
          null,
          8192
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/icewind/streams/src/CallbackWrapper.php",
        "line": 98,
        "function": "stream_read",
        "class": "Icewind\\Streams\\Wrapper",
        "type": "->",
        "args": [
          8192
        ]
      },
      {
        "function": "stream_read",
        "class": "Icewind\\Streams\\CallbackWrapper",
        "type": "->",
        "args": [
          8192
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/sabre/http/lib/Sapi.php",
        "line": 108,
        "function": "stream_copy_to_stream",
        "args": [
          null,
          null,
          3867
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 492,
        "function": "sendResponse",
        "class": "Sabre\\HTTP\\Sapi",
        "type": "::",
        "args": [
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 251,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          {
            "__class__": "Sabre\\HTTP\\Request"
          },
          {
            "__class__": "Sabre\\HTTP\\Response"
          }
        ]
      },
      {
        "file": "/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 319,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/nextcloud/apps/dav/lib/Server.php",
        "line": 320,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/nextcloud/remote.php",
        "line": 167,
        "args": [
          "/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/html/nextcloud/apps/encryption/lib/Crypto/Crypt.php",
    "Line": 503,
    "Hint": "Zła sygnatura",
    "CustomMessage": "--"
  },
  "userAgent": "Mozilla/5.0 (Windows) mirall/3.0.3stable-Win64 (build 20201029) (Nextcloud)",
  "version": "19.0.4.2"
}
{
  "reqId": "Xyica6av9unln9XWJ9O6",
  "level": 3,
  "time": "2020-12-22T21:54:39+00:00",
  "remoteAddr": "1.2.3.4",
  "user": "JACK",
  "app": "PHP",
  "method": "GET",
  "url": "/remote.php/dav/files/JACK/Foto/IMG-20200514-WA0005.jpg",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "Mozilla/5.0 (Windows) mirall/3.0.3stable-Win64 (build 20201029) (Nextcloud)",
  "version": "19.0.4.2"
}
{
  "reqId": "IFKzY2u2rW3Q3ER9teL2",
  "level": 3,
  "time": "2020-12-22T21:54:39+00:00",
  "remoteAddr": "1.2.3.4",
  "user": "JACK",
  "app": "PHP",
  "method": "GET",
  "url": "/remote.php/dav/files/JACK/Foto/IMG-20200514-WA0006.jpg",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "Mozilla/5.0 (Windows) mirall/3.0.3stable-Win64 (build 20201029) (Nextcloud)",
  "version": "19.0.4.2"
}
{
  "reqId": "HA9yhn3myTrzfR5XVu9w",
  "level": 3,
  "time": "2020-12-22T21:55:26+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "--",
  "version": "19.0.4.2"
}
{
  "reqId": "Rnn4kdsttw7vkGVUBrUh",
  "level": 3,
  "time": "2020-12-22T22:10:18+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "--",
  "version": "19.0.4.2"
}
{
  "reqId": "4CxNjpCmn5d8m5FvIFuL",
  "level": 3,
  "time": "2020-12-22T22:11:16+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "--",
  "version": "19.0.4.2"
}
{
  "reqId": "Bo6pOlql84RuqvxfK7SI",
  "level": 3,
  "time": "2020-12-22T22:18:25+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "PHP",
  "method": "",
  "url": "--",
  "message": "Module 'apc' already loaded at Unknown#0",
  "userAgent": "--",
  "version": "19.0.4.2"

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'oc5r89eyfbgj',
  'passwordsalt' => 'pFW//nsId3csE3jUv9TEmbSy4d45ij',
  'secret' => '3zkXsBPZ0ZuoLEZS6pjbC1WqE7Cs7rH30aYowD+f0RpiPLg3',
  'trusted_domains' =>
  array (
    0 => '1.2.3.4',
    1 => 'nextcloud.superdomain.pl',
  ),
  'datadirectory' => '/var/www/html/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '19.0.4.2',
  'overwrite.cli.url' => 'http://1.2.3.4',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'dbuser' => 'nextcloud',
  'dbpassword' => 'QpOuCjq2jP9ss32342342423Tr9qTRjUu',
  'installed' => true,
  'app_install_overwrite' =>
  array (
    0 => 'admin_notifications',
    1 => 'ocsms',
    2 => 'spgverein',
    3 => 'activitylog',
    4 => 'ocr',
    5 => 'twofactor_rcdevsopenotp',
    6 => 'files_accesscontrol',
    7 => 'dashboard',
    8 => 'radio',
    9 => 'dashboardcharts',
  ),
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_smtphost' => 'smtp.gmail.com',
  'mail_smtpport' => '465',
  'mail_smtpauth' => 1,
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpsecure' => 'ssl',
  'mail_smtpname' => 'jackjack@gmail.com',
  'mail_smtppassword' => 'secret',
  'mail_from_address' => 'jackjack@gmail',
  'mail_domain' => 'gmail.com',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'logfile' => '/var/log/nextcloud.log',
  'logfilemode' => 0640,
  'updater.secret' => '$2y$10$x2W6/oYYhDgZl5z/CUX8uedQpbW6XWLHMA2mxOrurb7hxfxhG2G5a',
);

The output of your Apache/nginx/system log in /var/log/____:

{"file":"/var/www/html/nextcloud/lib/base.php","line":1094,"function":"init","class":"OC","type":"::","args":[]},{"file":"/var/www/html/nextcloud/index.php","line":35,"args":["/var/www/html/nextcloud/lib/base.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":67,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36 Edg/87.0.664.66","version":"19.0.4.2"}, referer: https://nextcloud.jacksite.pl/
[Tue Dec 22 23:11:15.103668 2020] [php7:notice] [pid 17057] [client 1.2.3.4:58786] {"reqId":"ndrISOFkVicLiowo2qC5","level":3,"time":"2020-12-22T23:11:15+00:00","remoteAddr":"1.2.3.4","user":"--","app":"core","method":"GET","url":"/index.php","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/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":889,"function":"connect","class":"OC\\\\DB\\\\Connection","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/DB/Connection.php","line":194,"function":"executeQuery","class":"Doctrine\\\\DBAL\\\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[],null]},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":200,"function":"executeQuery","class":"OC\\\\DB\\\\Connection","type":"->","args":["SELECT * FROM `oc_appconfig`",[],[]]},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":216,"function":"execute","class":"Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/AppConfig.php","line":331,"function":"execute","class":"OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/AppConfig.php","line":109,"function":"loadConfigValues","class":"OC\\\\AppConfig","type":"->","args":[]},{"file":"/var/www/html/nextcloud/lib/private/AppConfig.php","line":287,"function":"getApps","class":"OC\\\\AppConfig","type":"->","args":[]},

Please use the search function of the forum, which you find in the upper right corner of your screen, to find an answer on your question. You should find a bunch of matches, because this kind of question is being asked and answered at least once per week.

1 Like

sorry
i read a lot of post and i still cant repair my server.
Could you help me?
now i have information like bellow

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.

now I see this is biggest problem because :frowning:

Unit mariadb.service could not be found.

Please close this post because I need to reinstall operating system
byee