Internal Server Error, can't fix it

ℹ️ Support
,
1

Nextcloud version (eg, 29.0.5): 30.1
Operating system and version (eg, Ubuntu 24.04): Ubuntu Jammy LST 22.04.3
Apache or nginx version (eg, Apache 2.4.25): N/A(Nginx Proxy Manager)
PHP version (eg, 8.3): 8.2.25

The issue you are facing:

root@angel-linux-intel:/var/www/nextcloud.[Redacted by Mod/JK]# sudo -u www-data php occ files:scan --all
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1698] Access denied for user 'nextcloud'@'localhost' in /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/DB/Connection.php:233
Stack trace:
#0 /var/www/nextcloud.[Redacted by Mod/JK]/3rdparty/doctrine/dbal/src/Connection.php(453): OC\DB\Connection->connect()
#1 /var/www/nextcloud.[Redacted by Mod/JK]/3rdparty/doctrine/dbal/src/Connection.php(411): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/nextcloud.[Redacted by Mod/JK]/3rdparty/doctrine/dbal/src/Connection.php(318): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/DB/Connection.php(899): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/DB/ConnectionAdapter.php(235): OC\DB\Connection->getDatabaseProvider()
#5 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/DB/QueryBuilder/QueryBuilder.php(96): OC\DB\ConnectionAdapter->getDatabaseProvider()
#6 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/AppConfig.php(1211): OC\DB\QueryBuilder\QueryBuilder->expr()
#7 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/AppConfig.php(237): OC\AppConfig->loadConfig()
#8 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/AppConfig.php(1351): OC\AppConfig->searchValues()
#9 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/App/AppManager.php(126): OC\AppConfig->getValues()
#10 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/App/AppManager.php(147): OC\App\AppManager->getInstalledAppsValues()
#11 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/legacy/OC_App.php(191): OC\App\AppManager->getInstalledApps()
#12 /var/www/nextcloud.[Redacted by Mod/JK]/lib/private/AppFramework/Bootstrap/Coordinator.php(48): OC_App::getEnabledApps()
#13 /var/www/nextcloud.[Redacted by Mod/JK]/lib/base.php(657): OC\AppFramework\Bootstrap\Coordinator->runInitialRegistration()
#14 /var/www/nextcloud.[Redacted by Mod/JK]/lib/base.php(1132): OC::init()
#15 /var/www/nextcloud.[Redacted by Mod/JK]/console.php(28): require_once('...')
#16 /var/www/nextcloud.[Redacted by Mod/JK]/occ(11): require_once('...')
#17 {main}root@angel-linux-intel:/var/www/nextcloud.[Redacted by Mod/JK]#

Is this the first time you’ve seen this error? (Y/N): N(Fixed it before, can’t now)

Steps to replicate it:

  1. Installed Nextcloud like 3 years ago, every login today would get a CRF Token error, updated nextcloud, then updated PHP version and error is gone.
  2. But files were no loner accessible, I could see folders/file names, but shares, viewing them, etc was a no-go.
  3. So I tried to fix it. forgot what I did then, and continued to get a Internal Server Error. Purged MariaDB(MySQL) and tried to create a new one, but to no avail will it connect.

The output of your Nextcloud log in Admin > Logging:

N/A, can't login

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

<?php
$CONFIG = array (
  'instanceid' => '[Redacted by Mod/JK]',
  'passwordsalt' => '[Redacted by Mod/JK]',
  'secret' => '[Redacted by Mod/JK]',
  'trusted_domains' => 
  array (
    0 => '10.0.0.6:8443',
    1 => 'nextcloud.[Redacted by Mod/JK]',
    3 => 'share.[Redacted by Mod/JK]',
    4 => 'nextcloud.[Redacted by Mod/JK]',
    5 => 'cloud.[Redacted by Mod/JK]',
    6 => 'cloud.[Redacted by Mod/JK]',
    7 => 'share.[Redacted by Mod/JK]',
  ),
  'trusted_proxies' => 
  array (
    0 => '127.0.0.1',
    1 => '10.0.0.6',
  ),
  'datadirectory' => '/var/www/nextcloud.[Redacted by Mod/JK]/data',
  'dbtype' => 'mysql',
  'version' => '30.0.1.2',
  'overwrite.cli.url' => 'https://cloud.[Redacted by Mod/JK]',
  'dbname' => 'nextcloud',
  'dbhost' => '127.0.0.1',
  'dbport' => '3308',
  'dbtableprefix' => 'nextcloud_',
  'mysql.utf8mb4' => 'false',
  'dbuser' => 'nextcloud',
  'dbpassword' => '********************',
  'installed' => true,
  'overwriteprotocol' => 'https',
  'auth.bruteforce.protection.enabled' => 'false',
  'ratelimit.protection.enabled' => 'false',
  'default_phone_region' => 'US',
  'filelocking.enabled' => 'true',
  'memcache.locking' => '\OC\Memcache\Redis',
  'redis' => 
  array (
    'host' => '127.0.0.1',
    'port' => 25600,
    'timeout' => 0.0,
    'password' => '***************',
  ),
  'theme' => '',
  'maintenance' => false,
  'maintenance_window_start' => 1,
  'loglevel' => 0,
  'mail_from_address' => 'nextcloud',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => '[Redacted by Mod/JK]',
  'mail_smtphost' => '45.79.13.17',
  'mail_smtpport' => '465',
  'mail_smtpsecure' => 'ssl',
  'mail_smtpauth' => 1,
  'mail_smtpname' => 'nextcloud@[Redacted by Mod/JK]',
  'mail_smtppassword' => '*****************',
  'app_install_overwrite' => 
  array (
    0 => 'cfg_share_links',
  ),
);

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

NA/Nginx proxy Manager(Don't know were those logs are.)

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

N/A no file called that in that directory.
2

So uum, I did a backup on my VM, but this was what originally happened when I logged in
So its still happening

3

I restored a backup from proxmox and found out it was add-on apps causing issues.
It’s fixed now. Thx

4

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