TerraMaster Forum

Bug Reports, Operation Guides, and Experience Sharing
https://forum.terra-master.com/en/

[ Nextcloud ] Self-hosted productivity platform

https://forum.terra-master.com/en/viewtopic.php?t=1619

Page 6 of 11

Re: [ Nextcloud ][ 23.0.3.0 ] Self-hosted productivity platform

Posted: 29 Mar 2022, 00:21
by outkastm
forward the port 31443 on your router to your NAS IP, edit the nextcloud conf and add you domain name to trusted domains array

Image

Re: [ Nextcloud ][ 23.0.4.0 ] Self-hosted productivity platform

Posted: 27 Apr 2022, 06:12
by outkastm
up to 23.0.4.0

Re: [ Nextcloud ][ 23.0.4.0 ] Self-hosted productivity platform

Posted: 09 May 2022, 20:17
by super-6-1
I'm getting this error and not sure what to do to fix it.

Code: Select all

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.
Here are a few entries from the error log

Code: Select all

  
[Mon May 09 08:07:17.051749 2022] [php7:error] [pid 4912] [client 192.168.1.84:48853] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:30.878357 2022] [php7:error] [pid 4911] [client 192.168.1.84:57272] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:30.907485 2022] [php7:error] [pid 4910] [client 192.168.1.84:50835] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:31.976774 2022] [php7:error] [pid 1472] [client 192.168.1.84:57274] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:10:17.832471 2022] [mpm_prefork:notice] [pid 4734] AH00169: caught SIGTERM, shutting down
[Mon May 09 08:10:32.071240 2022] [ssl:warn] [pid 20226] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:10:32.071404 2022] [ssl:warn] [pid 20226] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:10:32.208712 2022] [ssl:warn] [pid 20227] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:10:32.208760 2022] [ssl:warn] [pid 20227] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:10:32.793358 2022] [mpm_prefork:notice] [pid 20227] AH00163: Apache/2.4.51 (Unix) OpenSSL/1.1.1i PHP/7.4.26 configured -- resuming normal operations
[Mon May 09 08:10:32.793439 2022] [core:notice] [pid 20227] AH00094: Command line: '/usr/local/apache24/sys/bin/httpd -f /mnt/appdata/MOD_CONFIG/Nextcloud_okm/httpd.conf'
[Mon May 09 08:12:11.716271 2022] [mpm_prefork:notice] [pid 20227] AH00169: caught SIGTERM, shutting down
[Mon May 09 08:12:36.822329 2022] [ssl:warn] [pid 20746] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:12:36.822430 2022] [ssl:warn] [pid 20746] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:12:36.956575 2022] [ssl:warn] [pid 20747] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:12:36.956627 2022] [ssl:warn] [pid 20747] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:12:37.065258 2022] [mpm_prefork:notice] [pid 20747] AH00163: Apache/2.4.51 (Unix) OpenSSL/1.1.1i PHP/7.4.26 configured -- resuming normal operations
[Mon May 09 08:12:37.065362 2022] [core:notice] [pid 20747] AH00094: Command line: '/usr/local/apache24/sys/bin/httpd -f /mnt/appdata/MOD_CONFIG/Nextcloud_okm/httpd.conf'

Re: [ Nextcloud ][ 23.0.4.0 ] Self-hosted productivity platform

Posted: 09 May 2022, 20:40
by super-6-1
super-6-1 wrote: ↑09 May 2022, 20:17 I'm getting this error and not sure what to do to fix it.

Code: Select all

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.
Here are a few entries from the error log

Code: Select all

  
[Mon May 09 08:07:17.051749 2022] [php7:error] [pid 4912] [client 192.168.1.84:48853] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:30.878357 2022] [php7:error] [pid 4911] [client 192.168.1.84:57272] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:30.907485 2022] [php7:error] [pid 4910] [client 192.168.1.84:50835] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:07:31.976774 2022] [php7:error] [pid 1472] [client 192.168.1.84:57274] 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 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php:87\nStack trace:\n#0 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1519): OC\\DB\\Connection->connect()\n#1 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1041): Doctrine\\DBAL\\Connection->getWrappedConnection()\n#2 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php(237): Doctrine\\DBAL\\Connection->executeQuery('SELECT * FROM `...', Array, Array, NULL)\n#3 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php(345): OC\\DB\\Connection->executeQuery('SELECT * FROM `...', Array, Array)\n#4 /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(287): Doctrine\\DBAL\\Query\\QueryBuilder->execute()\n#5 /mnt/ in /mnt/md1/application/Nextcloud_okm/bin/nextcloud/lib/private/DB/Connection.php on line 87
[Mon May 09 08:10:17.832471 2022] [mpm_prefork:notice] [pid 4734] AH00169: caught SIGTERM, shutting down
[Mon May 09 08:10:32.071240 2022] [ssl:warn] [pid 20226] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:10:32.071404 2022] [ssl:warn] [pid 20226] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:10:32.208712 2022] [ssl:warn] [pid 20227] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:10:32.208760 2022] [ssl:warn] [pid 20227] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:10:32.793358 2022] [mpm_prefork:notice] [pid 20227] AH00163: Apache/2.4.51 (Unix) OpenSSL/1.1.1i PHP/7.4.26 configured -- resuming normal operations
[Mon May 09 08:10:32.793439 2022] [core:notice] [pid 20227] AH00094: Command line: '/usr/local/apache24/sys/bin/httpd -f /mnt/appdata/MOD_CONFIG/Nextcloud_okm/httpd.conf'
[Mon May 09 08:12:11.716271 2022] [mpm_prefork:notice] [pid 20227] AH00169: caught SIGTERM, shutting down
[Mon May 09 08:12:36.822329 2022] [ssl:warn] [pid 20746] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:12:36.822430 2022] [ssl:warn] [pid 20746] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:12:36.956575 2022] [ssl:warn] [pid 20747] AH01906: www.example.com:31443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Mon May 09 08:12:36.956627 2022] [ssl:warn] [pid 20747] AH01909: www.example.com:31443:0 server certificate does NOT include an ID which matches the server name
[Mon May 09 08:12:37.065258 2022] [mpm_prefork:notice] [pid 20747] AH00163: Apache/2.4.51 (Unix) OpenSSL/1.1.1i PHP/7.4.26 configured -- resuming normal operations
[Mon May 09 08:12:37.065362 2022] [core:notice] [pid 20747] AH00094: Command line: '/usr/local/apache24/sys/bin/httpd -f /mnt/appdata/MOD_CONFIG/Nextcloud_okm/httpd.conf'
I did the upgrade and the issue is fixed, ignore this!

Re: [ Nextcloud ][ 23.0.4.0 ] Self-hosted productivity platform

Posted: 09 May 2022, 21:02
by wayneeden
{L_BUTTON_AT}outkastm

could you give me another link for download
cause i can't download,thanks

Re: [ Nextcloud ][ 23.0.4.0 ] Self-hosted productivity platform

Posted: 09 May 2022, 21:09
by outkastm
download link work's fine

Re: [ Nextcloud ][ 24.0.0.0 ] Self-hosted productivity platform

Posted: 11 May 2022, 15:56
by outkastm
up to 24.0.0.0

Image

Re: [ Nextcloud ][ 24.0.1.0 ] Self-hosted productivity platform

Posted: 29 May 2022, 07:26
by outkastm
update to 24.0.1.0

Re: [ Nextcloud ][ 24.0.1.0 ] Self-hosted productivity platform

Posted: 31 May 2022, 23:15
by super-6-1
Curious to know of there is a fix for this? Updated to the latest version in hopes it fixed it but sadly it didn't. here is the error log.

Code: Select all

<br />
<b>Warning</b>:  fopen(/usr/local/Nextcloud_okm/bin/error_log): failed to open stream: No such file or directory in <b>/usr/www/modules/Nextcloud_okm/www/5.php</b> on line <b>86</b><br />

Re: [ Nextcloud ][ 24.0.1.0 ] Self-hosted productivity platform

Posted: 31 May 2022, 23:20
by outkastm
The lack of log file it means the app has never started.
Do you have also the latest apache24 app installed?
All times are UTC+08:00
Page 6 of 11

Powered by phpBB® Forum Software © phpBB Limited