Internal Server Error, NexCloud Fail

Specs :computer:

Nextcloud version: 24.0.6.1
Operating system and version: 20.04 - Host
Apache or nginx version: lightspeed server running this
PHP version: 8.0.23

The issue :anger:

NextCloud failed completely, after adding the calendar app.
I installed the app, and it failed…
Manually removing the app won’t help also

Is this the first time you’ve seen this error? YES

Log :open_file_folder:

it’s too long so this is the log:

config.php :gear:

<?php
$CONFIG = array (
  'instanceid' => 'amzingnetwork',
  'passwordsalt' => 'Cat',
  'secret' => 'Mouse',
  'trusted_domains' => 
  array (
    0 => 'url',
  ),
  'datadirectory' => '/home/u367654687/domains/ims/public_html/team-hub/data',
  'dbtype' => 'mysql',
  'version' => '24.0.6.1',
  'overwrite.cli.url' => 'some URL Nothing To Wory about',
  'dbname' => 'u367654687_workhub',
  'dbhost' => 'localhost:3306',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'WTF-WHY-WHOULD-I-SHARE-THIS',
  'dbpassword' => 'WTF-WHY-WHOULD-I-SHARE-THIS',
  'installed' => true,
  'twofactor_enforced' => 'false',
  'twofactor_enforced_groups' => 
  array (
  ),
  'twofactor_enforced_excluded_groups' => 
  array (
  ),
  'mail_smtpmode' => 'sendmail',
  'mail_sendmailmode' => 'smtp',
  'mail_from_address' => 'team',
  'mail_domain' => 'ims-network.net',
  'app_install_overwrite' => 
  array (
    0 => 'caniupdate',
  ),
  'maintenance' => false,
);

Update 22/10/2022 12:28

I can load the login screen, and it fails after a user is logging
not sure what’s going on… it might have disconnected from the SQL database while downloading the calendar

Update 20/10/2022 13:00

It is SQL Reicing the process limit that I assigned to it (I have a max of 25), with its strange because it means that NextCloud takes a lot of connections from the database and it may be not optimized.

I would suggest optimizing the script and making sure that all of the connections are closed immediately once they are finished.

Not sure how many processes dose Nextcloud even uses, but more than 20 at a time, is not optimized.

If you get an Internal Server Error there should be an entry in the webserver’s error.log. Without that it anybody’s guess, what’s happening here.

Where do I see the log?
I think that I will just reinstall it and the problem will solve itself.
Maybe it was a problem on that server, I am switching it and it will be a dedicated server for nextcloud.
I will just do a simple docker installation and it will solve all my problems :slight_smile:

Try NC AiO (all in one), available as docker as well

yep,

This makes the installation simple and fast, wish I knew this when deploying the old version

sudo docker run \
--sig-proxy=false \
--name nextcloud-aio-mastercontainer \
--restart always \
--publish 80:80 \
--publish 8080:8080 \
--publish 8443:8443 \
--volume nextcloud_aio_mastercontainer:/mnt/docker-aio-config \
--volume /var/run/docker.sock:/var/run/docker.sock:ro \
nextcloud/all-in-one:latest

only thing is that you can’t change the ports

This is not true. See all-in-one/reverse-proxy.md at main · nextcloud/all-in-one · GitHub

1 Like

What Happened Here :question:

The issue :lady_beetle:

It is SQL Reicing the process limit that I assigned to it (I have a max of 25), with its strange because it means that NextCloud takes a lot of connections from the database and it may be not optimized.

The solution :white_check_mark:

Just use the docker setup and I recommend also getting
https://docs.portainer.io/v/ce-2.11/start/install
to manage all the dockers.

Help Links

and if you need reverse proxy here are the docs

Yep, it was caused by a poor database configuration, now I have a dedicated server for Nexhub running on docker, and it manages everything
makes life so much simpler, which is all you need sometime :wink:

1 Like