OnlyOffice app installation unavailable on Synology NAS

DarkAngel · July 3, 2022, 1:30pm

Hello everyone,

I am currently facing an issue and I did not find any relevant information about it (I hope I did not miss anything…).

Here is my setup:

Nextcloud version : 24.0.2
Operating system and version : DSM 6.2.3-25426 (Synology NAS)
Apache version : Apache 2.4.43
PHP version : 7.4
Nextcloud is not installed via Docker

The issue:

I am not able to install OnlyOffice app. If I understood well, it should be already available with this version of nextcloud. However, I can’t see it in my list of applications. Moreover, I don’t have any button to add a new app on my interface (maybe I am missing something there):

I tried to install it manually using the command lines occ app:install documentserver_community and occ app:install onlyoffice (from the nextcloud documentation) but I have the message that these apps can’t be installed.

If anyone has a clue about how to resolve this issue, I would really appreciate it

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

<?php
$CONFIG = array (
  'instanceid' => 'content removed by Mod/JK',
  'passwordsalt' => 'content removed by Mod/JK',
  'secret' => 'content removed by Mod/JK',
  'trusted_domains' => 
  array (
    0 => 'xxx',
    1 => 'xxx',
  ),
  'datadirectory' => '/volume1/NextCloud',
  'dbtype' => 'mysql',
  'version' => '24.0.2.1',
  'overwrite.cli.url' => 'xxx',
  'dbname' => 'NextCloud',
  'dbhost' => '127.0.0.1:3307',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'xxx',
  'dbpassword' => 'xxx',
  'installed' => true,
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
  'updater.secret' => 'content removed by Mod/JK',
);

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

2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.372834 2022] [proxy_fcgi:error] [pid 17705:tid 140599168558848] [client 192.168.1.254:56986] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.374785 2022] [proxy_fcgi:error] [pid 17705:tid 140599093024512] [client 192.168.1.254:56992] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.667647 2022] [proxy_fcgi:error] [pid 17705:tid 140599134988032] [client 192.168.1.254:57004] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.680964 2022] [proxy_fcgi:error] [pid 17705:tid 140599076239104] [client 192.168.1.254:57010] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.851242 2022] [proxy_fcgi:error] [pid 17705:tid 140599067846400] [client 192.168.1.254:57022] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:48+02:00 Atlantis [Sun Jul 03 16:00:48.958497 2022] [proxy_fcgi:error] [pid 17705:tid 140599330068224] [client 192.168.1.254:57028] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.136168 2022] [proxy_fcgi:error] [pid 17705:tid 140599051060992] [client 192.168.1.254:57034] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.246712 2022] [proxy_fcgi:error] [pid 17705:tid 140599338460928] [client 192.168.1.254:57040] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.455913 2022] [proxy_fcgi:error] [pid 17705:tid 140599059453696] [client 192.168.1.254:57056] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.554939 2022] [proxy_fcgi:error] [pid 17705:tid 140599151773440] [client 192.168.1.254:57062] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.719377 2022] [proxy_fcgi:error] [pid 17705:tid 140599185344256] [client 192.168.1.254:57068] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:49+02:00 Atlantis [Sun Jul 03 16:00:49.839307 2022] [proxy_fcgi:error] [pid 17705:tid 140599025882880] [client 192.168.1.254:57076] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.017543 2022] [proxy_fcgi:error] [pid 17705:tid 140599218915072] [client 192.168.1.254:57082] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.148572 2022] [proxy_fcgi:error] [pid 17705:tid 140599244093184] [client 192.168.1.254:57090] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.340064 2022] [proxy_fcgi:error] [pid 17705:tid 140599210522368] [client 192.168.1.254:57096] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.468713 2022] [proxy_fcgi:error] [pid 17705:tid 140599126595328] [client 192.168.1.254:57102] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.647828 2022] [proxy_fcgi:error] [pid 17705:tid 140599042668288] [client 192.168.1.254:57108] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:50+02:00 Atlantis [Sun Jul 03 16:00:50.782043 2022] [proxy_fcgi:error] [pid 17705:tid 140599193736960] [client 192.168.1.254:57114] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:51+02:00 Atlantis [Sun Jul 03 16:00:51.064481 2022] [proxy_fcgi:error] [pid 17705:tid 140599235700480] [client 192.168.1.254:57120] AH01071: Got error 'PHP message: PHP Fatal error:  Uncaught Doctrine\\DBAL\\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused in /volume1/web/nextcloud/lib/private/DB/Connection.php:139\nStack trace:\n#0 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /volume1/web/nextcloud/lib/private/DB/Connection.php(261): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /volume1/web/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /volume1/web/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(281): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /volume1/web/nextcloud/lib/private/AppConfig.php(411): OC\\DB\\QueryBuilder\\QueryBuilder->execute()\n#6 /volume1/web/nextcloud/l...'
2022-07-03T16:00:51+02:00 Atlantis [Sun Jul 03 16:00:51.204148 2022] [proxy_fcgi:error] [pid 17705:tid 140599227307776] (70008)Partial results are valid but processing is incomplete: [client 192.168.1.254:57012] AH01075: Error dispatching request to : (reading input brigade)
2022-07-03T16:00:51+02:00 Atlantis [Sun Jul 03 16:00:51.205632 2022] [proxy_fcgi:error] [pid 17705:tid 140599160166144] (70008)Partial results are valid but processing is incomplete: [client 192.168.1.254:57050] AH01075: Error dispatching request to : (reading input brigade)
2022-07-03T16:11:28+02:00 Atlantis [Sun Jul 03 16:11:27.308983 2022] [proxy_fcgi:error] [pid 17705:tid 140599185344256] (70007)The timeout specified has expired: [client 192.168.1.254:34200] AH01075: Error dispatching request to : (polling)
2022-07-03T16:11:30+02:00 Atlantis [Sun Jul 03 16:11:30.797912 2022] [proxy_fcgi:error] [pid 17705:tid 140599134988032] (70007)The timeout specified has expired: [client 192.168.1.254:34124] AH01075: Error dispatching request to : (polling)
2022-07-03T16:11:36+02:00 Atlantis [Sun Jul 03 16:11:36.568875 2022] [proxy_fcgi:error] [pid 17705:tid 140599042668288] (70007)The timeout specified has expired: [client 192.168.1.254:34128] AH01075: Error dispatching request to : (polling)
2022-07-03T16:17:51+02:00 Atlantis [Sun Jul 03 16:17:51.758962 2022] [proxy_fcgi:error] [pid 17705:tid 140599160166144] (70007)The timeout specified has expired: [client 192.168.1.254:37320] AH01075: Error dispatching request to : (polling)
2022-07-03T16:17:51+02:00 Atlantis [Sun Jul 03 16:17:51.668885 2022] [proxy_fcgi:error] [pid 17705:tid 140599109809920] (70007)The timeout specified has expired: [client 192.168.1.254:37316] AH01075: Error dispatching request to : (polling)
2022-07-03T16:18:00+02:00 Atlantis [Sun Jul 03 16:18:00.379934 2022] [proxy_fcgi:error] [pid 17705:tid 140599151773440] (70007)The timeout specified has expired: [client 192.168.1.254:37344] AH01075: Error dispatching request to : (polling)
2022-07-03T16:18:55+02:00 Atlantis [Sun Jul 03 16:18:55.104876 2022] [proxy_fcgi:error] [pid 17705:tid 140599118202624] (70007)The timeout specified has expired: [client 192.168.1.254:37800] AH01075: Error dispatching request to : (polling)
2022-07-03T17:24:52+02:00 Atlantis [Sun Jul 03 17:24:52.003911 2022] [proxy_fcgi:error] [pid 13296:tid 140599025882880] (70007)The timeout specified has expired: [client 192.168.1.91:44830] AH01075: Error dispatching request to : (polling)
2022-07-03T17:32:21+02:00 Atlantis [Sun Jul 03 17:32:21.815441 2022] [proxy_fcgi:error] [pid 13296:tid 140599076239104] (70007)The timeout specified has expired: [client 192.168.1.254:48632] AH01075: Error dispatching request to : (polling)

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.

Erreur	no app in context	Sabre\DAV\Exception\BadRequest: Expected filesize of 6245405 bytes but read (from Nextcloud client) and wrote (to Nextcloud storage) 49152 bytes. Could either be a network problem on the sending side or a problem writing to the storage on the server side.	
2022-07-03T16:12:04+0200
Fatal	webdav	Sabre\DAV\Exception: Error while copying file to target location (copied: -1 bytes, expected filesize: 1084787 bytes)	
2022-07-03T16:08:26+0200
Erreur	no app in context	Sabre\DAV\Exception: Error while copying file to target location (copied: -1 bytes, expected filesize: 1084787 bytes)	
2022-07-03T16:08:26+0200
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress	
2022-07-03T16:00:46+0200
Fatal	webdav	OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away	
2022-07-03T16:00:46+0200
Fatal	webdav	Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused	
2022-07-03T16:00:45+0200
Erreur	no app in context	Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away	
2022-07-03T16:00:45+0200
Fatal	webdav	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress	
2022-07-03T16:00:45+0200
Erreur	no app in context	Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress	
2022-07-03T16:00:45+0200
Fatal	webdav	Sabre\DAV\Exception: Error while copying file to target location (copied: -1 bytes, expected filesize: 1084787 bytes)	
2022-07-03T15:40:09+0200
Erreur	no app in context	Sabre\DAV\Exception: Error while copying file to target location (copied: -1 bytes, expected filesize: 1084787 bytes)	
2022-07-03T15:40:09+0200
Erreur	internet_connection_check	GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: certificate has expired (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://www.nextcloud.com/	
2022-07-03T15:18:02+0200
Erreur	PHP	PHP Startup: Unable to load dynamic library 'mysql.so' (tried: /usr/local/lib/php74/modules/mysql.so (/usr/local/lib/php74/modules/mysql.so: cannot open shared object file: No such file or directory), /usr/local/lib/php74/modules/mysql.so.so (/usr/local/lib/php74/modules/mysql.so.so: cannot open shared object file: No such file or directory)) at Unknown#0	
2022-07-03T13:44:24+0200
Erreur	internet_connection_check	GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: certificate has expired (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://www.nextcloud.com/	
2022-07-03T13:41:11+0200
Erreur	PHP	PHP Startup: Unable to load dynamic library 'mysql.so' (tried: /usr/local/lib/php74/modules/mysql.so (/usr/local/lib/php74/modules/mysql.so: cannot open shared object file: No such file or directory), /usr/local/lib/php74/modules/mysql.so.so (/usr/local/lib/php74/modules/mysql.so.so: cannot open shared object file: No such file or directory)) at Unknown#0	
2022-07-03T13:40:15+0200
Erreur	internet_connection_check	GuzzleHttp\Exception\RequestException: cURL error 60: SSL certificate problem: certificate has expired (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://www.nextcloud.com/	
2022-07-03T13:37:40+0200

just · July 3, 2022, 2:35pm

Hi @DarkAngel,
You are missing the required support template. Please fill this form out and edit into your post to include logs.

It is fully possible that the synology fully lacks the capacity to run the office suite, which requires a couple gigs of ram and cpu cores to run at all.

DarkAngel · July 3, 2022, 4:08pm

Hi @just,
Thanks for your answer and sorry for the rooky mistake. I edited my post with the info required

JimmyKater · July 3, 2022, 8:21pm

@DarkAngel

sadly you forgot to remove some sensitve data from your posting. I did that for you. But please regard your instance as possibly compromised from now on.

Apart from that: Running NC natively under DSM is not tested and not recommended so far.
Of course one CAN do that and there are several tutorials out the on how to achieving that goal. But since DSM is handling some stuff differenty from other systems some of the suggestions here might not be helpful at all.

What you CAN do instead… You could run NC in a VM… It’ll run like a charm there. Even with Collabora (or OnlyOffice) enabled. Try offical NC-VM by Hanssonit (40GB is for free)

Good luck
JK

DarkAngel · July 3, 2022, 9:02pm

@JimmyKater
Thanks for your answer and your removal of my information. I was not aware these parameters were sensitive. I am kind of new on Nextcloud, but if I understand correctly, these parameters can’t be regenerated. So, do I have to install a new instance of nextcloud to avoid my data to be compromised ?

As for the main subject of the topic: I indeed follow one of those many tutorial to install NC like that on DSM. Unfortunately, none of them were saying that this was not the right way to do…
I am not a huge fan of a freemium solution, and I want to handle more than 40Gb of data. Is there any other good way to install NC on DSM without having this kind of restriction ?

szaimen · July 4, 2022, 4:45pm

Nextcloud AIO may also be a solution.

JimmyKater · July 4, 2022, 5:33pm

you could easily add more storage…
or you’d do it like @szaimen suggested…

DarkAngel · July 4, 2022, 5:52pm

@szaimen
Thanks a lot, I dit not this project on GitHub. I will take a close look at it !

@JimmyKater
Oh sorry, I thought the 40GB were a limit and we could not have more, I misunderstood, my mistake ! Thanks for you help
Just a last question for you as you said that my instance of NC can be compromised. Should I install again NC or is there a way to change these parameters that I shared ?

JimmyKater · July 4, 2022, 6:02pm

change instance ID:

updating secret:
Documentation on regenerating `secret` in config.php · Issue #7311 · nextcloud/server · GitHub

but wells since it seems that you’re still at the very beginning, I’d suggest to completely start over again with one of the two options you were suggested