Hello,
today I hat to shutdown and restart my nextcloudpi server due to some work at power supply.
When shutting down (via nextcloudpi web ui button) I was wondering how much time it needed to shutdown. After restart now I am facing the problem, that when calling the IP adress I get the error 503 service unavailable.
Unfortunately in nextcloupi’s dashboard, everything seems to be fine. A restart I already tried. ncp-report is attached below. The shown folder for database logs is also on my raspberry pi empty…
Is there a crash in my database?
Does anyone have an idea what has happened during shutdown and how to solve?
Thanks in advance
Christian
NextcloudPi diagnostics
grep: /etc/apache2/sites-available/nextcloud.conf: No such file or directory
NextcloudPi version v1.54.2
NextcloudPi image
OS Armbian 22.11.0-trunk Bullseye \l . 5.10.144-meson64 (aarch64)
automount no
USB devices none
datadir /media/2022HDD/ncdata/data
data in SD no
data filesystem ext2/ext3
data disk usage 1.5T/5.5T
rootfs usage 19G/29G
swapfile /var/swap
dbdir /var/lib/mysql
Nextcloud check ok
Nextcloud version 28.0.5.1
HTTPD service up
PHP service up
MariaDB service up
Redis service up
HPB service up
Postfix service up
Internet check ok
Public IPv4 ***REMOVED SENSITIVE VALUE***
Public IPv6 ***REMOVED SENSITIVE VALUE***
Port 80 open
Port 443 open
IP ***REMOVED SENSITIVE VALUE***
Gateway ***REMOVED SENSITIVE VALUE***
Interface eth0
Certificates ***REMOVED SENSITIVE VALUE***
NAT loopback no
Uptime 12min
Nextcloud configuration
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": {
"0": "localhost",
"7": "nextcloudpi",
"5": "nextcloudpi.local",
"8": "nextcloudpi.lan",
"3": "nextcloudpi",
"11": "88.72.53.109",
"1": "192.168.188.58",
"14": "nextcloudpi",
"20": "worldcloud.spdns.de"
},
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "28.0.5.1",
"overwrite.cli.url": "https:\/\/nextcloudpi\/",
"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***"
},
"tempdirectory": "\/media\/2022HDD\/ncdata\/data\/tmp",
"mail_smtpmode": "smtp",
"mail_smtpauthtype": "LOGIN",
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"preview_max_x": 2048,
"preview_max_y": 2048,
"preview_max_memory": 4096,
"preview_max_filesize_image": 256,
"jpeg_quality": 60,
"overwriteprotocol": "https",
"trusted_proxies": "***REMOVED SENSITIVE VALUE***",
"maintenance": false,
"logfile": "\/media\/2022HDD\/ncdata\/data\/nextcloud.log",
"htaccess.RewriteBase": "\/",
"mail_sendmailmode": "smtp",
"mail_smtpsecure": "tls",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "587",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"default_phone_region": "DE",
"theme": "",
"memories.exiftool": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/exiftool-aarch64-glibc",
"loglevel": 0,
"data-fingerprint": "962078b523d39716b33cc8f1f325cad7",
"memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-aarch64",
"memories.db.triggers.fcu": true
}
}
HTTPd logs
[Thu Jul 18 09:09:32.727019 2024] [core:error] [pid 3627080:tid 3627134] [client 206.189.233.163:51896] AH10244: invalid URI path (/cgi-bin/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/.%2e/bin/sh)
[Thu Jul 18 09:09:32.967719 2024] [core:error] [pid 3627082:tid 3627147] [client 206.189.233.163:51910] AH10244: invalid URI path (/cgi-bin/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/%%32%65%%32%65/bin/sh)
[Sat Jul 20 13:11:40.741733 2024] [mpm_event:notice] [pid 3355860:tid 3355860] AH00492: caught SIGWINCH, shutting down gracefully
[Sat Jul 20 13:11:48.723585 2024] [ssl:warn] [pid 2381:tid 2381] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sat Jul 20 13:11:48.728332 2024] [ssl:error] [pid 2381:tid 2381] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=odroidhc4 / issuer: CN=odroidhc4 / serial: 584898CC3C484501A30136A84D36FE5DBEDB4A6E / notbefore: Oct 3 22:35:47 2022 GMT / notafter: Sep 30 22:35:47 2032 GMT]
[Sat Jul 20 13:11:48.728404 2024] [ssl:error] [pid 2381:tid 2381] AH02604: Unable to configure certificate localhost:4443:0 for stapling
[Sat Jul 20 13:11:48.801382 2024] [ssl:warn] [pid 2669:tid 2669] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sat Jul 20 13:11:48.801745 2024] [ssl:error] [pid 2669:tid 2669] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=odroidhc4 / issuer: CN=odroidhc4 / serial: 584898CC3C484501A30136A84D36FE5DBEDB4A6E / notbefore: Oct 3 22:35:47 2022 GMT / notafter: Sep 30 22:35:47 2032 GMT]
[Sat Jul 20 13:11:48.801799 2024] [ssl:error] [pid 2669:tid 2669] AH02604: Unable to configure certificate localhost:4443:0 for stapling
[Sat Jul 20 13:11:48.810640 2024] [mpm_event:notice] [pid 2669:tid 2669] AH00489: Apache/2.4.61 (Debian) OpenSSL/1.1.1w configured -- resuming normal operations
[Sat Jul 20 13:11:48.810742 2024] [core:notice] [pid 2669:tid 2669] AH00094: Command line: '/usr/sbin/apache2'
[Sat Jul 20 15:40:42.821317 2024] [mpm_event:notice] [pid 2669:tid 2669] AH00492: caught SIGWINCH, shutting down gracefully
[Sat Jul 20 15:40:49.506796 2024] [ssl:warn] [pid 2445:tid 2445] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sat Jul 20 15:40:49.515851 2024] [ssl:error] [pid 2445:tid 2445] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=odroidhc4 / issuer: CN=odroidhc4 / serial: 584898CC3C484501A30136A84D36FE5DBEDB4A6E / notbefore: Oct 3 22:35:47 2022 GMT / notafter: Sep 30 22:35:47 2032 GMT]
[Sat Jul 20 15:40:49.515909 2024] [ssl:error] [pid 2445:tid 2445] AH02604: Unable to configure certificate localhost:4443:0 for stapling
[Sat Jul 20 15:40:49.592271 2024] [ssl:warn] [pid 2686:tid 2686] AH01909: localhost:4443:0 server certificate does NOT include an ID which matches the server name
[Sat Jul 20 15:40:49.592707 2024] [ssl:error] [pid 2686:tid 2686] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: CN=odroidhc4 / issuer: CN=odroidhc4 / serial: 584898CC3C484501A30136A84D36FE5DBEDB4A6E / notbefore: Oct 3 22:35:47 2022 GMT / notafter: Sep 30 22:35:47 2032 GMT]
[Sat Jul 20 15:40:49.592757 2024] [ssl:error] [pid 2686:tid 2686] AH02604: Unable to configure certificate localhost:4443:0 for stapling
[Sat Jul 20 15:40:49.600529 2024] [mpm_event:notice] [pid 2686:tid 2686] AH00489: Apache/2.4.61 (Debian) OpenSSL/1.1.1w configured -- resuming normal operations
[Sat Jul 20 15:40:49.600753 2024] [core:notice] [pid 2686:tid 2686] AH00094: Command line: '/usr/sbin/apache2'
Database logs
tail: cannot open '/var/log/mysql/*.log' for reading: No such file or directory
Nextcloud logs
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 60041","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 75325","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 75326","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 75327","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Run OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications job with ID 75327","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"Finished OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications job with ID 75327 in 0 seconds","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 79518","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"wdWidc5konJqoCjIVXio","level":0,"time":"2024-07-20T13:51:32+00:00","remoteAddr":"","user":"--","app":"cron","method":"","url":"--","message":"CLI cron call has selected job with ID 79956","userAgent":"--","version":"28.0.5.1","data":{"app":"cron"}}
{"reqId":"Wypqeak2iqc3Xu3EJ5l6","level":0,"time":"2024-07-20T13:51:53+00:00","remoteAddr":"","user":"--","app":"music","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"Wypqeak2iqc3Xu3EJ5l6","level":0,"time":"2024-07-20T13:51:53+00:00","remoteAddr":"","user":"--","app":"polls","method":"","url":"--","message":"no user found, returned fake user","userAgent":"--","version":"28.0.5.1","data":{"app":"polls"}}
{"reqId":"Jwe923hpoGzk01E99drc","level":0,"time":"2024-07-20T13:53:48+00:00","remoteAddr":"","user":"--","app":"music","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"Jwe923hpoGzk01E99drc","level":0,"time":"2024-07-20T13:53:49+00:00","remoteAddr":"","user":"--","app":"polls","method":"","url":"--","message":"no user found, returned fake user","userAgent":"--","version":"28.0.5.1","data":{"app":"polls"}}
{"reqId":"CktUYbmVYFMMgdTJPsDt","level":0,"time":"2024-07-20T13:53:50+00:00","remoteAddr":"","user":"--","app":"music","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"CktUYbmVYFMMgdTJPsDt","level":0,"time":"2024-07-20T13:53:51+00:00","remoteAddr":"","user":"--","app":"polls","method":"","url":"--","message":"no user found, returned fake user","userAgent":"--","version":"28.0.5.1","data":{"app":"polls"}}
{"reqId":"37wyxBj48mssC8ZljcAn","level":0,"time":"2024-07-20T13:53:52+00:00","remoteAddr":"","user":"--","app":"music","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"37wyxBj48mssC8ZljcAn","level":0,"time":"2024-07-20T13:53:52+00:00","remoteAddr":"","user":"--","app":"polls","method":"","url":"--","message":"no user found, returned fake user","userAgent":"--","version":"28.0.5.1","data":{"app":"polls"}}
{"reqId":"ZpvBcOsUzHuvPpNOZXco0QAABAw","level":0,"time":"2024-07-20T13:53:52+00:00","remoteAddr":"::1","user":"--","app":"music","method":"GET","url":"/index.php/apps/notify_push/test/cookie","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"ZpvBcesUzHuvPpNOZXco0gAABg0","level":0,"time":"2024-07-20T13:53:53+00:00","remoteAddr":"1.2.3.4","user":"--","app":"music","method":"GET","url":"/index.php/apps/notify_push/test/remote","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"nqvQGIxEgUQo7qmH1ZLC","level":0,"time":"2024-07-20T13:53:56+00:00","remoteAddr":"","user":"--","app":"music","method":"","url":"--","message":"/appinfo/app.php is deprecated, use \\OCP\\AppFramework\\Bootstrap\\IBootstrap on the application class instead.","userAgent":"--","version":"28.0.5.1","data":{"app":"music"}}
{"reqId":"nqvQGIxEgUQo7qmH1ZLC","level":0,"time":"2024-07-20T13:53:56+00:00","remoteAddr":"","user":"--","app":"polls","method":"","url":"--","message":"no user found, returned fake user","userAgent":"--","version":"28.0.5.1","data":{"app":"polls"}}
