Dear Community,
after upgrading Nextcloudpi to 0.61.1 I cannot access my Nextcloud or the Web-Interface anymore and get a “connection refused” error in the browser.
sudo ncp-report --> HTTPD seems to be down
pi@nextcloudpi:~ $ sudo ncp-report
<--! Paste this in GitHub report -->
<details>
<summary>NextCloudPi diagnostics</summary>
NextCloudPi version v0.66.1
NextCloudPi image NextCloudPi_10-23-18
distribution Raspbian GNU/Linux 9 \n \l
automount yes
USB devices none
datadir /var/www/nextcloud/data
data in SD yes
data filesystem ext2/ext3
data disk usage 2.4G/118G
rootfs usage 2.4G/118G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 14.0.3.0
HTTPD service down
PHP service up
MariaDB service up
Redis service up
Postfix service up
internet check ok
port check 80 closed
port check 443 closed
IP ***REMOVED SENSITIVE VALUE***
gateway ***REMOVED SENSITIVE VALUE***
interface eth0
certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
uptime 3:21
</details>
<details>
<summary>Nextcloud configuration</summary>
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": {
"0": "localhost",
"5": "nextcloudpi.local",
"7": "nextcloudpi",
"8": "nextcloudpi.lan",
"1": "192.168.1.100",
"3": "rbey.ddns.net",
"2": "rbey.ddns.net",
"4": "rbey.ddns.net"
},
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "14.0.3.0",
"overwrite.cli.url": "https:\/\/rbey.ddns.net\/",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"memcache.local": "\\OC\\Memcache\\Redis",
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***"
},
"mail_smtpmode": "sendmail",
"mail_smtpauthtype": "LOGIN",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"overwriteprotocol": "https",
"loglevel": "2",
"log_type": "file"
}
}
</details>
<details>
<summary>HTTPd logs</summary>
</details>
<details>
<summary>Database logs</summary>
2018-11-06 9:25:18 1988296720 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-11-06 9:25:18 1988296720 [Note] InnoDB: The InnoDB memory heap is disabled
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-06 9:25:18 1988296720 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Using Linux native AIO
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Using generic crc32 instructions
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Completed initialization of buffer pool
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-06 9:25:18 1988296720 [Note] InnoDB: 128 rollback segment(s) are active.
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Waiting for purge to start
2018-11-06 9:25:18 1988296720 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 703831457
2018-11-06 9:25:18 1988296720 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-06 9:25:18 1379922736 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-11-06 9:25:18 1988296720 [Note] Server socket created on IP: '127.0.0.1'.
2018-11-06 9:25:18 1988296720 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.35-MariaDB-1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Raspbian testing-staging
</details>
<details>
<summary>Nextcloud logs</summary>
{"reqId":"W9iTdt@meSiWWjfp@HNZFAAAVQ8","level":3,"time":"2018-10-30T17:23:02+00:00","remoteAddr":"92.194.31.150","user":"richi","app":"PHP","method":"POST","url":"\/index.php\/apps\/music\/api\/scan","message":"Undefined index: filesize at \/var\/www\/nextcloud\/apps\/music\/3rdparty\/getID3\/getid3\/module.tag.apetag.php#25","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\/20100101 Firefox\/63.0","version":"14.0.3.0"}
{"reqId":"W9iT3t@meSiWWjfp@HNZPwAAVQ8","level":3,"time":"2018-10-30T17:24:48+00:00","remoteAddr":"92.194.31.150","user":"richi","app":"PHP","method":"POST","url":"\/index.php\/apps\/music\/api\/scan","message":"Undefined index: filesize at \/var\/www\/nextcloud\/apps\/music\/3rdparty\/getID3\/getid3\/module.tag.apetag.php#25","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\/20100101 Firefox\/63.0","version":"14.0.3.0"}
{"reqId":"W9iUDd@meSiWWjfp@HNZUQAAShY","level":3,"time":"2018-10-30T17:25:34+00:00","remoteAddr":"92.194.31.150","user":"richi","app":"PHP","method":"POST","url":"\/index.php\/apps\/music\/api\/scan","message":"Undefined index: filesize at \/var\/www\/nextcloud\/apps\/music\/3rdparty\/getID3\/getid3\/module.tag.apetag.php#25","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\/20100101 Firefox\/63.0","version":"14.0.3.0"}
{"reqId":"W9iUwd@meSiWWjfp@HNZnwAAVxY","level":3,"time":"2018-10-30T17:28:39+00:00","remoteAddr":"92.194.31.150","user":"richi","app":"PHP","method":"POST","url":"\/index.php\/apps\/music\/api\/scan","message":"Undefined index: filesize at \/var\/www\/nextcloud\/apps\/music\/3rdparty\/getID3\/getid3\/module.tag.apetag.php#25","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\/20100101 Firefox\/63.0","version":"14.0.3.0"}
{"reqId":"W9iVQN@meSiWWjfp@HNZ2QAARg8","level":3,"time":"2018-10-30T17:30:41+00:00","remoteAddr":"92.194.31.150","user":"richi","app":"PHP","method":"POST","url":"\/index.php\/apps\/music\/api\/scan","message":"Undefined index: filesize at \/var\/www\/nextcloud\/apps\/music\/3rdparty\/getID3\/getid3\/module.tag.apetag.php#25","userAgent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:63.0) Gecko\/20100101 Firefox\/63.0","version":"14.0.3.0"}
</details>
Apache2 status
pi@nextcloudpi:~ $ sudo systemctl status apache2.service
â—Ź apache2.service - LSB: Apache2 web server
Loaded: loaded (/etc/init.d/apache2; generated; vendor preset: enabled)
Active: active (exited) since Tue 2018-11-06 09:24:55 UTC; 3h 26min ago
Docs: man:systemd-sysv-generator(8)
Process: 601 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/apache2.service
Nov 06 09:24:55 nextcloudpi systemd[1]: Starting LSB: Apache2 web server...
Nov 06 09:24:55 nextcloudpi systemd[1]: Started LSB: Apache2 web server.
/var/log/apache2/error.log is empty.
/var/log/apache2/error.log.1 gives:
pi@nextcloudpi:~ $ tail -40 /var/log/apache2/error.log.1
[Mon Nov 05 06:25:02.323426 2018] [ssl:warn] [pid 9967:tid 1995747728] AH01882: Init: this version of mod_ssl was compiled against a newer library (OpenSSL 1.1.0h 27 Mar 2018, version currently loaded is OpenSSL 1.1.0f 25 May 2017) - may result in undefined or erroneous behavior
[Mon Nov 05 06:25:02.327127 2018] [ssl:warn] [pid 9967:tid 1995747728] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Mon Nov 05 06:25:02.328971 2018] [mpm_event:notice] [pid 9967:tid 1995747728] AH00489: Apache/2.4.34 (Raspbian) OpenSSL/1.1.0f configured -- resuming normal operations
[Mon Nov 05 06:25:02.329010 2018] [core:notice] [pid 9967:tid 1995747728] AH00094: Command line: '/usr/sbin/apache2'
[Mon Nov 05 06:26:17.325902 2018] [mpm_event:notice] [pid 9967:tid 1995747728] AH00491: caught SIGTERM, shutting down
Any help is very much appreciated.