@nebulon huge thanks for the assistance!
My poor attempt at adding a cloud backup caused the error as stated. ty for the prompt and friendly assistance 
Latest posts made by joesitsolutions
-
RE: my.cloudron.tld is not accessibleposted in Support
-
RE: my.cloudron.tld is not accessibleposted in Support
@nebulon doing as requested
root@cloudron:~# cd /home/yellowtent/platformdata/collectd/collectd.conf.d/ root@cloudron:/home/yellowtent/platformdata/collectd/collectd.conf.d# grep f1fff4243dd29c177ec2167b33b1f25c9e98158f6a84aa7706daf4bb89df188d * root@cloudron:/home/yellowtent/platformdata/collectd/collectd.conf.d# ls -la total 28 drwxr-xr-x 2 yellowtent yellowtent 4096 Mar 10 14:38 . drwxr-xr-x 3 yellowtent yellowtent 4096 Dec 18 01:10 .. -rw-r--r-- 1 yellowtent yellowtent 1175 Mar 10 14:38 0708633b-f7ec-4a01-9d38-20690f924ade.conf -rw-r--r-- 1 yellowtent yellowtent 1175 Feb 23 15:05 119a7c1a-f70a-4933-bd82-4fec92fe981a.conf -rw-r--r-- 1 yellowtent yellowtent 1175 Mar 10 13:50 69dfed39-c1a3-441c-90b7-8b8eb3ccad8b.conf -rw-r--r-- 1 yellowtent yellowtent 138 Dec 18 01:11 cloudron-backup.conf -rw-r--r-- 1 yellowtent yellowtent 1175 Feb 8 15:07 f17bb001-deeb-4120-ba11-55ef90f0e3b4.conf root@cloudron:/home/yellowtent/platformdata/collectd/collectd.conf.d#That file appears to not exist. I'll enable ssh and send through an email now.
Feel free to message or reach out if you need more input from me. -
RE: my.cloudron.tld is not accessibleposted in Support
@nebulon uncertain on how to stop / start apps as I cant access the my.cloudron.com.au side of things.
Docker shows this:
root@cloudron:~# docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 2b22cebcd8dd cloudron/org.getgrav.cloudronapp:20220208-133214-844e92676 "/bin/sh -c 'echo '=…" 29 hours ago Exited (0) 15 hours ago f17bb001-deeb-4120-ba11-55ef90f0e3b4-grav_scheduler 443c1145e43f cloudron/net.freescout.cloudronapp:20220223-121510-86737ae89 "/bin/sh -c /app/pkg…" 29 hours ago Exited (0) 15 hours ago 119a7c1a-f70a-4933-bd82-4fec92fe981a-housekeeping b811af4c3a3e cloudron/com.grafana.cloudronapp:20220224-180629-5687a838f "/app/pkg/start.sh" 2 days ago Up 6 hours 0708633b-f7ec-4a01-9d38-20690f924ade 85baeb1e8340 cloudron/redis:3.0.4 "/app/code/start.sh" 2 days ago Up 6 hours 3000/tcp, 6379/tcp redis-0708633b-f7ec-4a01-9d38-20690f924ade 75cadb64d6b8 cloudron/louislam.uptimekuma.app:20220209-152854-0147f4790 "/app/pkg/start.sh" 2 days ago Up 6 hours 69dfed39-c1a3-441c-90b7-8b8eb3ccad8b a75d5ca8221c cloudron/net.freescout.cloudronapp:20220223-121510-86737ae89 "/app/pkg/start.sh" 2 weeks ago Up 6 hours 119a7c1a-f70a-4933-bd82-4fec92fe981a 6620dc0b8126 cloudron/mail:3.5.0 "/app/code/start.sh" 3 weeks ago Up 6 hours mail e596de9e8743 cloudron/org.getgrav.cloudronapp:20220208-133214-844e92676 "/app/pkg/start.sh" 4 weeks ago Up 6 hours f17bb001-deeb-4120-ba11-55ef90f0e3b4 39f11158be76 cloudron/sftp:3.4.2 "/app/code/start.sh" 2 months ago Up 6 hours 0.0.0.0:222->22/tcp, :::222->22/tcp sftp 3b1a13866b42 cloudron/graphite:3.0.1 "/app/code/start.sh" 2 months ago Up 6 hours 127.0.0.1:2003-2004->2003-2004/tcp, 127.0.0.1:8417->8000/tcp graphite f75c940bc6be cloudron/mongodb:4.0.2 "/app/code/start.sh" 2 months ago Up 6 hours mongodb 55cda1c3bf9f cloudron/postgresql:4.1.1 "/app/code/start.sh" 2 months ago Up 6 hours 3000/tcp, 5432/tcp postgresql 8a5049411810 cloudron/mysql:3.0.7 "/app/code/start.sh" 2 months ago Up 6 hours mysql d0dac59c07e4 cloudron/turn:1.3.1 "/app/code/start.sh" 2 months ago Up 6 hours turn root@cloudron:~#These appear to all be running. Or at least appear to have all my apps running as expected. I can go to all of my apps/sites aside from my.cloudron.com.au side of things.
I do see two stopped containers at the top. Is it possible that these are stuck?
-
RE: my.cloudron.tld is not accessibleposted in Support
First regarding
/home/yellowtent/box/src/scripts/restartservice.sh: line 20: BOX_ENV: unbound variable`please to not run shell scripts like that directly, the
start.shis a bit special but otherwise it may be risky to run them directly as mostly they are only tested to be run from other code or scripts. Maybe we can add safeguard checks early on to avoid this.Regarding the main issue, looks like fro both cases
collectddoes not start, this may be caused by outdated or broken config files.For a start, can you check
journalctl -u collectdand the main log file at/home/yellowtent/platformdata/logs/collectd/collectd.log?Sorry, wasn't aware of not running those shell scripts but definitely something to take a note of.
journalctl -u collectd
Output:root@cloudron:~# journalctl -u collectd -- Logs begin at Sun 2022-03-13 06:27:27 UTC, end at Sun 2022-03-13 09:27:33 UTC. -- -- No entries -- root@cloudron:~# systemctl status collectd ● collectd.service - Statistics collection and monitoring daemon Loaded: loaded (/lib/systemd/system/collectd.service; enabled; vendor preset: enabled) Active: inactive (dead) Docs: man:collectd(1) man:collectd.conf(5) https://collectd.org root@cloudron:~#Contents of "/home/yellowtent/platformdata/logs/collectd/collectd.log"
(might be very long)[done in pastebin due to size]
Pastebin linkAlso I attempted to start it manually as a test.
root@cloudron:~# journalctl -u collectd -- Logs begin at Sun 2022-03-13 06:27:27 UTC, end at Sun 2022-03-13 09:30:47 UTC. -- Mar 13 09:30:42 cloudron systemd[1]: Dependency failed for Statistics collection and monitoring daemon. Mar 13 09:30:42 cloudron systemd[1]: collectd.service: Job collectd.service/start failed with result 'dependency'. root@cloudron:~#Please let me know if you'd like the information in a different format or in a file form. Thanks for the assistance.
-
RE: my.cloudron.tld is not accessibleposted in Support
Hi, sorry to add onto an existing ticket.
I'm also experiencing the same/similar error.
2022-03-13T03:42:22.037Z box:settings initCache: pre-load settings 2022-03-13T03:42:22.070Z box:tasks stopAllTasks: stopping all tasks 2022-03-13T03:42:22.070Z box:shell stopTask spawn: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_BAD_FIELD_ERROR: Unknown column 'sourceJson' in 'field list'","nestedError":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlMessage":"Unknown column 'sourceJson' in 'field list'","sqlState":"42S22","index":0,"sql":"INSERT INTO eventlog (id, action, sourceJson, dataJson) VALUES ('7ce937d3-c09e-4b93-9399-1f36d8e3b92b', 'cloudron.update.finish', '{\\\"username\\\":\\\"cron\\\",\\\"userId\\\":null,\\\"ip\\\":null}', '{\\\"errorMessage\\\":\\\"\\\",\\\"oldVersion\\\":\\\"7.0.4\\\",\\\"newVersion\\\":\\\"7.1.3\\\"}')"},"code":"ER_BAD_FIELD_ERROR","sqlMessage":"Unknown column 'sourceJson' in 'field list'"} at main (/home/yellowtent/box/box.js:47:41) at processTicksAndRejections (node:internal/process/task_queues:96:5) 2022-03-13T03:42:23.188Z box:server ========================================== 2022-03-13T03:42:23.189Z box:server Cloudron 7.1.3 2022-03-13T03:42:23.190Z box:server ========================================== 2022-03-13T03:42:23.290Z box:settings initCache: pre-load settings 2022-03-13T03:42:23.322Z box:tasks stopAllTasks: stopping all tasks 2022-03-13T03:42:23.323Z box:shell stopTask spawn: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_BAD_FIELD_ERROR: Unknown column 'sourceJson' in 'field list'","nestedError":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlMessage":"Unknown column 'sourceJson' in 'field list'","sqlState":"42S22","index":0,"sql":"INSERT INTO eventlog (id, action, sourceJson, dataJson) VALUES ('9ca2798c-b843-4562-abe1-54a6db9fa69f', 'cloudron.update.finish', '{\\\"username\\\":\\\"cron\\\",\\\"userId\\\":null,\\\"ip\\\":null}', '{\\\"errorMessage\\\":\\\"\\\",\\\"oldVersion\\\":\\\"7.0.4\\\",\\\"newVersion\\\":\\\"7.1.3\\\"}')"},"code":"ER_BAD_FIELD_ERROR","sqlMessage":"Unknown column 'sourceJson' in 'field list'"} at main (/home/yellowtent/box/box.js:47:41) at processTicksAndRejections (node:internal/process/task_queues:96:5)This was after a recent Ubuntu security update and reboot. There is plenty of storage on the system.
root@cloudron:~# systemctl status collectd ● collectd.service - Statistics collection and monitoring daemon Loaded: loaded (/lib/systemd/system/collectd.service; enabled; vendor preset: enabled) Active: inactive (dead) Docs: man:collectd(1) man:collectd.conf(5) https://collectd.org Mar 13 03:40:23 cloudron systemd[1]: Dependency failed for Statistics collection and monitoring daemon. Mar 13 03:40:23 cloudron systemd[1]: collectd.service: Job collectd.service/start failed with result 'dependency'. Mar 13 03:44:21 cloudron systemd[1]: Dependency failed for Statistics collection and monitoring daemon. Mar 13 03:44:21 cloudron systemd[1]: collectd.service: Job collectd.service/start failed with result 'dependency'. Mar 13 03:45:23 cloudron systemd[1]: Dependency failed for Statistics collection and monitoring daemon. Mar 13 03:45:23 cloudron systemd[1]: collectd.service: Job collectd.service/start failed with result 'dependency'. Mar 13 03:45:40 cloudron systemd[1]: Dependency failed for Statistics collection and monitoring daemon. Mar 13 03:45:40 cloudron systemd[1]: collectd.service: Job collectd.service/start failed with result 'dependency'.I have done /home/yellowtent/box/setup/start.sh multiple times with no luck and have rebooted a few times with no luck.
I was attempting to setup NFS as a backup and was deploying this on a separate server and left the backup page open over night.
Unsure what's caused this but I'm getting the exact same error to @JOduMonT at almost the exact same time it seems.
Feel free to correct me if I'm wrong.Dumping more logs and info.
-- The unit box.service has entered the 'failed' state with result 'exit-code'. Mar 13 03:59:20 cloudron unbound[5447]: [5447:0] info: generate keytag query _ta-4f66. NULL IN Mar 13 03:59:20 cloudron multipathd[691]: sda: add missing path Mar 13 03:59:20 cloudron multipathd[691]: sda: failed to get udev uid: Invalid argument Mar 13 03:59:20 cloudron multipathd[691]: sda: failed to get sysfs uid: Invalid argument Mar 13 03:59:20 cloudron multipathd[691]: sda: failed to get sgio uid: No such file or directory Mar 13 03:59:20 cloudron systemd[1]: box.service: Scheduled restart job, restart counter is at 50. -- Subject: Automatic restarting of a unit has been scheduledAttempted to restart box
root@cloudron:~# systemctl status box ● box.service - Cloudron Admin Loaded: loaded (/etc/systemd/system/box.service; enabled; vendor preset: enabled) Active: activating (auto-restart) (Result: exit-code) since Sun 2022-03-13 04:01:24 UTC; 94ms ago Process: 7362 ExecStart=/home/yellowtent/box/box.js (code=exited, status=1/FAILURE) Main PID: 7362 (code=exited, status=1/FAILURE)It did come up
But my.WEBSITENAME.com.au is still offine/reconnecting
My apps are running fine and as expected
Going through tshoot steps off cloudron pageroot@cloudron:~# systemctl status unbound ● unbound.service - Unbound DNS Resolver Loaded: loaded (/etc/systemd/system/unbound.service; enabled; vendor preset: enabled) Active: active (running) since Sun 2022-03-13 03:59:03 UTC; 4min 16s ago Main PID: 5447 (unbound) Tasks: 1 (limit: 19104) Memory: 6.3M CGroup: /system.slice/unbound.service └─5447 /usr/sbin/unbound -d Mar 13 03:59:02 cloudron systemd[1]: Starting Unbound DNS Resolver... Mar 13 03:59:02 cloudron unbound[5447]: [5447:0] notice: init module 0: subnet Mar 13 03:59:02 cloudron unbound[5447]: [5447:0] notice: init module 1: validator Mar 13 03:59:02 cloudron unbound[5447]: [5447:0] notice: init module 2: iterator Mar 13 03:59:03 cloudron unbound[5447]: [5447:0] info: start of service (unbound 1.9.4). Mar 13 03:59:03 cloudron systemd[1]: Started Unbound DNS Resolver. Mar 13 03:59:20 cloudron unbound[5447]: [5447:0] info: generate keytag query _ta-4f66. NULL IN root@cloudron:~# systemctl status nginx ● nginx.service - nginx - high performance web server Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/nginx.service.d └─cloudron.conf Active: active (running) since Sun 2022-03-13 03:58:10 UTC; 5min ago Docs: http://nginx.org/en/docs/ Main PID: 1342 (nginx) Tasks: 9 (limit: 19104) Memory: 23.2M CGroup: /system.slice/nginx.service ├─1342 nginx: master process /usr/sbin/nginx -c /etc/nginx/nginx.conf ├─1343 nginx: worker process ├─1344 nginx: worker process ├─1345 nginx: worker process ├─1346 nginx: worker process ├─1347 nginx: worker process ├─1348 nginx: worker process ├─1349 nginx: worker process └─1350 nginx: worker process Mar 13 03:58:08 cloudron systemd[1]: Starting nginx - high performance web server... Mar 13 03:58:10 cloudron systemd[1]: Started nginx - high performance web server. root@cloudron:~# systemctl status mysql ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Sun 2022-03-13 03:58:09 UTC; 5min ago Main PID: 992 (mysqld) Status: "Server is operational" Tasks: 38 (limit: 19104) Memory: 206.6M CGroup: /system.slice/mysql.service └─992 /usr/sbin/mysqld Mar 13 03:58:08 cloudron systemd[1]: Starting MySQL Community Server... Mar 13 03:58:09 cloudron systemd[1]: Started MySQL Community Server.- May show updates?? I'm not 100% sure
root@cloudron:~# root@cloudron:~# ls /var/log/apt/history.log /var/log/apt/history.log root@cloudron:~# cat /var/log/apt/history.log Start-Date: 2022-03-02 06:08:51 Commandline: /usr/bin/unattended-upgrade Upgrade: libpolkit-gobject-1-0:amd64 (0.105-26ubuntu1.2, 0.105-26ubuntu1.3), libpolkit-agent-1-0:amd64 (0.105-26ubuntu1.2, 0.105-26ubuntu1.3), policykit-1:amd64 (0.105-26ubuntu1.2, 0.105-26ubuntu1.3) End-Date: 2022-03-02 06:08:53 Start-Date: 2022-03-03 06:08:00 Commandline: /usr/bin/unattended-upgrade Upgrade: libc6-dev:amd64 (2.31-0ubuntu9.2, 2.31-0ubuntu9.7), libc6:amd64 (2.31-0ubuntu9.2, 2.31-0ubuntu9.7), libc-dev-bin:amd64 (2.31-0ubuntu9.2, 2.31-0ubuntu9.7) End-Date: 2022-03-03 06:08:02 Start-Date: 2022-03-03 06:08:08 Commandline: /usr/bin/unattended-upgrade Upgrade: libc-bin:amd64 (2.31-0ubuntu9.2, 2.31-0ubuntu9.7) End-Date: 2022-03-03 06:08:09 Start-Date: 2022-03-03 06:08:15 Commandline: /usr/bin/unattended-upgrade Upgrade: locales:amd64 (2.31-0ubuntu9.2, 2.31-0ubuntu9.7) End-Date: 2022-03-03 06:08:20 Start-Date: 2022-03-09 06:40:47 Commandline: /usr/bin/unattended-upgrade Upgrade: gcc-9-base:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), cpp-9:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), libasan5:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), libstdc++-9-dev:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), g++-9:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), gcc-9:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04), libgcc-9-dev:amd64 (9.3.0-17ubuntu1~20.04, 9.4.0-1ubuntu1~20.04) End-Date: 2022-03-09 06:40:53 Start-Date: 2022-03-10 06:22:00 Commandline: /usr/bin/unattended-upgrade Install: linux-headers-5.4.0-104-generic:amd64 (5.4.0-104.118, automatic), linux-modules-extra-5.4.0-104-generic:amd64 (5.4.0-104.118, automatic), linux-headers-5.4.0-104:amd64 (5.4.0-104.118, automatic), linux-modules-5.4.0-104-generic:amd64 (5.4.0-104.118, automatic), linux-image-5.4.0-104-generic:amd64 (5.4.0-104.118, automatic) Upgrade: linux-headers-generic:amd64 (5.4.0.100.104, 5.4.0.104.108), linux-image-generic:amd64 (5.4.0.100.104, 5.4.0.104.108), linux-generic:amd64 (5.4.0.100.104, 5.4.0.104.108) End-Date: 2022-03-10 06:22:57 Start-Date: 2022-03-10 06:23:03 Commandline: /usr/bin/unattended-upgrade Upgrade: linux-libc-dev:amd64 (5.4.0-100.113, 5.4.0-104.118) End-Date: 2022-03-10 06:23:03 Start-Date: 2022-03-11 06:04:58 Commandline: /usr/bin/unattended-upgrade Remove: linux-headers-5.4.0-99:amd64 (5.4.0-99.112), linux-headers-5.4.0-99-generic:amd64 (5.4.0-99.112) End-Date: 2022-03-11 06:05:00 Start-Date: 2022-03-11 06:05:07 Commandline: /usr/bin/unattended-upgrade Remove: linux-image-5.4.0-99-generic:amd64 (5.4.0-99.112), linux-modules-extra-5.4.0-99-generic:amd64 (5.4.0-99.112) End-Date: 2022-03-11 06:05:13 Start-Date: 2022-03-11 06:05:19 Commandline: /usr/bin/unattended-upgrade Remove: linux-modules-5.4.0-99-generic:amd64 (5.4.0-99.112) End-Date: 2022-03-11 06:05:20 Start-Date: 2022-03-11 06:05:27 Commandline: /usr/bin/unattended-upgrade Upgrade: libdrm2:amd64 (2.4.105-3~20.04.2, 2.4.107-8ubuntu1~20.04.2), libdrm-common:amd64 (2.4.105-3~20.04.2, 2.4.107-8ubuntu1~20.04.2) End-Date: 2022-03-11 06:05:28 Start-Date: 2022-03-11 06:05:35 Commandline: /usr/bin/unattended-upgrade Upgrade: libexpat1:amd64 (2.2.9-1ubuntu0.2, 2.2.9-1ubuntu0.4) End-Date: 2022-03-11 06:05:35 Start-Date: 2022-03-12 19:01:24 Commandline: apt install -y /tmp/containerd.deb /tmp/docker-ce-cli.deb /tmp/docker.deb Upgrade: containerd.io:amd64 (1.4.6-1, 1.4.9-1), docker-ce:amd64 (5:20.10.7~3-0~ubuntu-focal, 5:20.10.12~3-0~ubuntu-focal), docker-ce-cli:amd64 (5:20.10.7~3-0~ubuntu-focal, 5:20.10.12~3-0~ubuntu-focal) End-Date: 2022-03-12 19:02:11Pulled the log and had a read.
This looks to be when the error started for me.2022-03-12T18:59:50.058Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:00.006Z box:cron Starting box autoupdate to {"version":"7.1.3","changelog":["Add mail manager role","mailbox: app can be set as owner when recvmail addon enabled","domains: add well known config UI (for jitsi configuration)","Prefix email addon variables with CLOUDRON_EMAIL instead of CLOUDRON_MAIL","remove support for manifest version 1","Add option to enable/disable mailbox sharing","base image 3.2.0","Update node to 16.13.1","mongodb: update to 4.4","Add `upstreamVersion` to manifest","Add `logPaths` to manifest","Add cifs seal support for backup and volume mounts","add a way for admins to set username when profiles are locked","Add support for secondary domains","postgresql: enable postgis","remove nginx config of stopped apps","mail: use port25check.cloudron.io to check outbound port 25 connectivity","Add import/export of mailboxes and users","LDAP server can now be exposed","Update monaco-editor to 0.32.1","Update xterm.js to 4.17.0","Update docker to 20.10.12","IPv6 support"],"sourceTarballUrl":"https://prod-cloudron-releases.s3.amazonaws.com/box-193dff8c30-be40cea600-7.1.3.tar.gz","sourceTarballSigUrl":"https://prod-cloudron-releases.s3.amazonaws.com/box-193dff8c30-be40cea600-7.1.3.tar.gz.sig","boxVersionsUrl":"https://s3.amazonaws.com/prod-cloudron-releases/versions.json","boxVersionsSigUrl":"https://s3.amazonaws.com/prod-cloudron-releases/versions.json.sig","unstable":false} 2022-03-12T19:00:00.011Z box:janitor Cleaning up expired tokens 2022-03-12T19:00:00.015Z box:janitor Cleaned up 0 expired tokens 2022-03-12T19:00:00.018Z box:locker Acquired : box_update 2022-03-12T19:00:00.038Z box:tasks startTask - starting task 664 with options {"timeout":72000000,"nice":15,"memoryLimit":400}. logs at /home/yellowtent/platformdata/logs/tasks/664.log 2022-03-12T19:00:00.038Z box:shell startTask spawn: /usr/bin/sudo -S -E /home/yellowtent/box/src/scripts/starttask.sh 664 /home/yellowtent/platformdata/logs/tasks/664.log 15 400 2022-03-12T19:00:00.074Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:00.127Z box:shell startTask (stdout): Running as unit: box-task-664.service 2022-03-12T19:00:10.058Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:20.076Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:30.056Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:40.063Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:00:50.065Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:01:00.059Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:01:10.057Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:01:20.061Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:01:30.056Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:06.915Z box:apphealthmonitor setHealth: 119a7c1a-f70a-4933-bd82-4fec92fe981a (support.joesitsolutions.com.au) waiting for 1163.085 to update health 2022-03-12T19:02:06.925Z box:apphealthmonitor setHealth: 119a7c1a-f70a-4933-bd82-4fec92fe981a (support.joesitsolutions.com.au) waiting for 1163.075 to update health 2022-03-12T19:02:06.926Z box:apphealthmonitor setHealth: 119a7c1a-f70a-4933-bd82-4fec92fe981a (support.joesitsolutions.com.au) waiting for 1163.074 to update health 2022-03-12T19:02:06.991Z box:apphealthmonitor setHealth: 0708633b-f7ec-4a01-9d38-20690f924ade (grafana.joesitsolutions.com.au) waiting for 1163.009 to update health 2022-03-12T19:02:06.992Z box:apphealthmonitor setHealth: 0708633b-f7ec-4a01-9d38-20690f924ade (grafana.joesitsolutions.com.au) waiting for 1163.008 to update health 2022-03-12T19:02:06.992Z box:apphealthmonitor setHealth: 0708633b-f7ec-4a01-9d38-20690f924ade (grafana.joesitsolutions.com.au) waiting for 1163.008 to update health 2022-03-12T19:02:09.085Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:09.086Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:09.086Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:10.018Z box:apphealthmonitor setHealth: 119a7c1a-f70a-4933-bd82-4fec92fe981a (support.joesitsolutions.com.au) waiting for 1159.982 to update health 2022-03-12T19:02:10.161Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:20.270Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:30.065Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:40.062Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:02:50.100Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:00.059Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:10.077Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:20.241Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:30.057Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:40.070Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:03:50.069Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:00.164Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:10.055Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:20.182Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:30.055Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:40.062Z box:apphealthmonitor app health: 4 alive / 0 dead. 2022-03-12T19:04:41.098Z box:box Received SIGTERM. Shutting down. 2022-03-12T19:04:41.100Z box:tasks stopAllTasks: stopping all tasks 2022-03-12T19:04:41.100Z box:shell stopTask spawn: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all 2022-03-12T19:04:41.106Z box:shell startTask code: null, signal: SIGTERM 2022-03-13T03:36:48.328Z box:server ========================================== 2022-03-13T03:36:48.329Z box:server Cloudron 7.1.3 2022-03-13T03:36:48.329Z box:server ========================================== 2022-03-13T03:36:48.447Z box:settings initCache: pre-load settings 2022-03-13T03:36:48.479Z box:tasks stopAllTasks: stopping all tasks 2022-03-13T03:36:48.480Z box:shell stopTask spawn: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_BAD_FIELD_ERROR: Unknown column 'sourceJson' in 'field list'","nestedError":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlMessage":"Unknown column 'sourceJson' in 'field list'","sqlState":"42S22","index":0,"sql":"INSERT INTO eventlog (id, action, sourceJson, dataJson) VALUES ('9344e8c2-c479-42c9-ab49-de7dc4989423', 'cloudron.update.finish', '{\\\"username\\\":\\\"cron\\\",\\\"userId\\\":null,\\\"ip\\\":null}', '{\\\"errorMessage\\\":\\\"\\\",\\\"oldVersion\\\":\\\"7.0.4\\\",\\\"newVersion\\\":\\\"7.1.3\\\"}')"},"code":"ER_BAD_FIELD_ERROR","sqlMessage":"Unknown column 'sourceJson' in 'field list'"} at main (/home/yellowtent/box/box.js:47:41) at processTicksAndRejections (node:internal/process/task_queues:96:5) 2022-03-13T03:36:49.583Z box:server ========================================== 2022-03-13T03:36:49.584Z box:server Cloudron 7.1.3 2022-03-13T03:36:49.584Z box:server ========================================== 2022-03-13T03:36:49.683Z box:settings initCache: pre-load settings 2022-03-13T03:36:49.717Z box:tasks stopAllTasks: stopping all tasks 2022-03-13T03:36:49.717Z box:shell stopTask spawn: /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all Error: Error starting server: {"name":"BoxError","reason":"Database Error","details":{},"message":"ER_BAD_FIELD_ERROR: Unknown column 'sourceJson' in 'field list'","nestedError":{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlMessage":"Unknown column 'sourceJson' in 'field list'","sqlState":"42S22","index":0,"sql":"INSERT INTO eventlog (id, action, sourceJson, dataJson) VALUES ('e3aad5b3-eb7d-4d13-95d8-c4b9c3aa1216', 'cloudron.update.finish', '{\\\"username\\\":\\\"cron\\\",\\\"userId\\\":null,\\\"ip\\\":null}', '{\\\"errorMessage\\\":\\\"\\\",\\\"oldVersion\\\":\\\"7.0.4\\\",\\\"newVersion\\\":\\\"7.1.3\\\"}')"},"code":"ER_BAD_FIELD_ERROR","sqlMessage":"Unknown column 'sourceJson' in 'field list'"}Attempted to do this
root@cloudron:~# /home/yellowtent/box/src/scripts/restartservice.sh all /home/yellowtent/box/src/scripts/restartservice.sh: line 20: BOX_ENV: unbound variable root@cloudron:~# -
Restoring app from backup?posted in Support
I cannot for the life of me figure out how to do this.
See Image:
I had a grav site and am attempting to move it from a backup.
I have the .zip file. Cannot figure out why I keep getting "backupFolder path is protected"
Anyone have any tips?