Internal Server Error when logging in

I don’t know what caused this. I set up OwnCloud successfully two weeks ago and today I upgraded some Linux packages and installed openHAB on the same server.
After rebooting I got

Unfortunately I don’t know how to output the error in English.
I was assuming this happens due to a conflict with openHAB, but since it runs on port 8080, there should be no conflict.
To be sure I disabled the openHAB service, but the error persists.

Where should I start with searching for the error?

Server configuration

Operating system: Arch Linux

Web server: nginx

Database: mariadb

PHP version: php-7.4

ownCloud version: 10.7

Updated from an older ownCloud or fresh install: fresh install

Where did you install ownCloud from: tarball from ownlocud page

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

Can’t login

The content of config/config.php:


<?php
$CONFIG = array (
  'instanceid' => 'oc77ueacqiva',
  'passwordsalt' => 'someletters',
  'secret' => 'somecharacters',
  'trusted_domains' => 
  array (
    0 => 'someurl',
  ),
  'datadirectory' => '/srv/http/owncloud/data',
  'overwrite.cli.url' => 'https://someurl',
  'dbtype' => 'mysql',
  'version' => '10.7.0.4',
  'dbname' => 'owncloud',
  'dbhost' => 'localhost',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'user',
  'dbpassword' => 'somePassword',
  'logtimezone' => 'UTC',
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/srv/http/owncloud/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 => 
    array (
      'path' => '/srv/http/owncloud/apps-external',
      'url' => '/apps-external',
      'writable' => true,
    ),
  ),
  'installed' => true,
  'theme' => '',
  'loglevel' => 0,
  'maintenance' => false,
);

Log in to the web-UI with an administrator account and click on
‘admin’ → ‘Generate Config Report’ → ‘Download ownCloud config report’
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

ATTENTION: Do not post your config.php file in public as is. Please use one of the
above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove all host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.


**List of activated apps:**
I can't login to the web UI

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.


**Are you using external storage, if yes which one:** No

**Are you using encryption:** no

**Are you using an external user-backend, if yes which one:** No

Client configuration

Browser: Chrome

Operating system: Arch Linux

Logs

Web server error log

No error log available. Only access.log, which is too long

ownCloud log (data/owncloud.log)

The log has a size of 200MB which is impossible to paste even one pastebin.com 

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log

Hi coldspar29

with the issue template which was provided when you opened this issue and which - unfortunately - you decided not to fill out.

Without the knowledge of your ownCloud version, OS, and especially logs we cannot help.

Please provide at least the above information and search owncloud.log for exceptions.

Wild guess: you had your PHP upgraded to 8.x which is not compatible with ownCloud. If this is the case downgrade to e.g. php 7.4

1 Like

I have tried collecting what is demanded, but all the logs are insanely huge and impossible to post. I have never seen a log file with 200MB size. Regarding php, I have Arch Linux and the php-7.4 package is provided for legacy support. This can’t be the issue.

I’d recommend skimming the last few hundred lines only, for errors that might be relevant to your issue. This you could post.

1 Like

Here are the last 100 lines of the owncloud.log

@alfredb Is it safe to provide the access.log?

For internal server errors, I’s start searching within owncloud.log. Avoid posting real domain names and/or IP addresses

1 Like

Hey,

i think the following from the provided log file could be the source of the internal server error as it also contains a mention of a oc_accounts table:

An exception occurred while executing 'UPDATE `oc_accounts` SET `last_login` = ? WHERE `id` = ?' with params [1627119425, 1]:\\n\\nSQLSTATE[HY000]: General error: 4047 InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

As this message is originating from the database i think you could have a look into your database manual to see if this error is mentioned there and what can be done / configured on database side to solve this.

Which one, would be of interest.

Thank you for the support but I switched to Nextcloud by now.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.