Cloudron Forum

joesitsolutions

I've been trying to setup a Grav contact form on my website.
I cannot seem to get it working.
I keep getting the following when attempting to send from it:

I have the following settings on the Grav site:

Within Cloudron I have the following:

I've also enabled Masquerading with no change.
I can't seem to be able to send from the address.

I can send via SMTP from my UPS however:

This works fine and sends from the address. Are there some settings within Cloudron that I can change to get this working? Or is this a grav issue?

I'm also having issues from my support platform:

It's the same issue. I also cannot connect from the support side of things to emails via IMAP/POP3 for some reason.
I believe I have port forwarding and DNS setup correctly but am unsure as to why this is not working. Any advice is appreciated.

Update: I somewhat fixed sending from my support platform:

Changed the send from to support.app
I can now send to gmail addresses but not outlook ( I don't have a PTR and that's an issue on my end).

Update 2:

I have removed the contact form from my main website and replaced it with a google form. Have had too many issues with Grav's email function and decided to remove it.

I still can't get emails working on my support platform. Getting the following error:

joesitsolutions

@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

joesitsolutions

@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.

joesitsolutions

@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?

joesitsolutions

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.sh is 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 collectd does not start, this may be caused by outdated or broken config files.

For a start, can you check journalctl -u collectd and 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 link

Also 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.

joesitsolutions

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 scheduled

Attempted 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 page

root@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:11

Pulled 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:~#

joesitsolutions

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?

Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.

joesitsolutions

@joesitsolutions

Latest posts made by joesitsolutions