[ Nextcloud ] Self-hosted productivity platform

Discussion on apps, protocols, APIs, specifications, and more. You are welcome to join us as a TOS app developer!
User avatar
outkastm
Posts: 1186
Joined: 29 Dec 2020, 23:52

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

Post 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
User avatar
super-6-1
Posts: 31
Joined: 11 Nov 2021, 05:30

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

Post 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'

    
User avatar
super-6-1
Posts: 31
Joined: 11 Nov 2021, 05:30

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

Post 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!
User avatar
wayneeden
Posts: 7
Joined: 19 Apr 2022, 13:47

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

Post by wayneeden »

{L_BUTTON_AT}outkastm

could you give me another link for download
cause i can't download,thanks
User avatar
outkastm
Posts: 1186
Joined: 29 Dec 2020, 23:52

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

Post by outkastm »

download link work's fine
User avatar
outkastm
Posts: 1186
Joined: 29 Dec 2020, 23:52

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

Post by outkastm »

update to 24.0.1.0
User avatar
super-6-1
Posts: 31
Joined: 11 Nov 2021, 05:30

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

Post 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 />
User avatar
outkastm
Posts: 1186
Joined: 29 Dec 2020, 23:52

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

Post by outkastm »

The lack of log file it means the app has never started.
Do you have also the latest apache24 app installed?
Post Reply