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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
joesitsolutionsJ

joesitsolutions

@joesitsolutions
About
Posts
18
Topics
4
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Apps stopped functioning post failed updates
    joesitsolutionsJ joesitsolutions

    @girish said in Apps stopped functioning post failed updates:

    However this does not resolve the fact that apps seem to not be responding externally/internally.

    Yet again my cloudflare changed its SSL/TLS encryption mode from Full (strict) to some other setting and broke my ssl side of things causing sites not to load. πŸ˜† Tested other domains I have and those worked so the only setting remaining was that. Fixed my issue there.

    @girish said in Apps stopped functioning post failed updates:

    Interesting solution. How did you end up discovering this ? Is this because of some local network related issue ?

    In terms of this the only thing I can think of is maybe getting rate limited so I had to slow down... I was updating multiple apps all at once when the updates all failed.

    Support

  • Apps stopped functioning post failed updates
    joesitsolutionsJ joesitsolutions

    @joesitsolutions said in Apps stopped functioning post failed updates:

    I seen the following: https://forums.docker.com/t/http-408-request-time-out-but-not-a-ratelimit-or-dns-issue/113755

    In short what I posted here is related
    I ran the following command:
    ip link set mtu 1200 ens160
    This seems to have fixed it and now cloudron can pull images as expected.
    However this does not resolve the fact that apps seem to not be responding externally/internally.

    Support

  • Apps stopped functioning post failed updates
    joesitsolutionsJ joesitsolutions

    Follow-up note.
    I seen the following: https://forums.docker.com/t/http-408-request-time-out-but-not-a-ratelimit-or-dns-issue/113755
    Could this be related?

    Support

  • Apps stopped functioning post failed updates
    joesitsolutionsJ joesitsolutions

    I have run this and it produces an error.
    @nebulon said in Apps stopped functioning post failed updates:

    docker pull cloudron/org.getgrav.cloudronapp:20230719-023805-238baa1a3

    I got the following error:
    Error response from daemon: error parsing HTTP 408 response body: invalid character '<' looking for beginning of value: "<html><body><h1>408 Request Time-out</h1>\nYour browser didn't send a complete request in time.\n</body></html>\n"

    To note there was a "security update" that was done right before this issue. Not sure if that was related but it was around the same time.

    Support

  • Apps stopped functioning post failed updates
    joesitsolutionsJ joesitsolutions

    Hi there,

    my apps have randomly stopped working post multiple failed updates and can no longer be visited from the web. I cancelled the updates as they were not going through

    I am getting the following error on grav:
    https://pastebin.com/vBwdaZtN
    This is when I attempt to restore from a backup. It cannot seem to pull the image.
    I have tried the usual troubleshooting: restarted the server, and went through failed upgrade Steps. I also cannot see my FW/ IPS/IDS blocking the app pull.

    Any advice or support on this would be appreciated. Multiple apps look to be broken in my Cloudron instance.

    Support

  • PDF invoices broken
    joesitsolutionsJ joesitsolutions

    @girish Yep works fine in the demo site.
    This is a strange one and very likely a me issue. Even if I put my config back to normal it doesn't work for me... then I clear my pfsense's suricata blocks and it loads.
    Hmm, I wonder if this pulls in external formatting/css/styles from somewhere that is being blocked on my end or something weird like that.
    But then why would the preview load fine. Real head scratcher this one.

    Edit:
    I've tried from my phone and am getting the same issue. Even with IDS/IPS/PFblocker off on my FW.
    The preview itself loads fine with normal Vanilla config but when I go to preview PDF or download I get the gray file.
    Still not sure what is happening tbh. Worth a reinstall perhaps?

    Edit 2:
    Did a reinstall and it works...? Am I the problem rolf..
    Thanks for your help. I'll do some more testing and see if I run into this issue again.

    Invoice Ninja

  • PDF invoices broken
    joesitsolutionsJ joesitsolutions

    @girish Yep, Previews work but actually making a PDF and downloading it or Viewing a PDF within the platform produces a grey file. I'm not sure if it is just a "me" issue so if you'd like to test it'd be interesting to see if it is more widespread perhaps.

    Invoice Ninja

  • PDF invoices broken
    joesitsolutionsJ joesitsolutions

    Hi All,
    Thanks for the reply around this.
    Here is the browser console
    There are some errors/warnings there
    23a4fae7-ba5e-43aa-82e4-eb45c5f159c8-image.png
    Not entirely sure what this means...
    Ain't too familiar with Chrome errors.
    Here is a log from when I load this page. https://pastebin.com/JhNaA1v2
    Trying some more fixes suggested.
    @girish said in PDF invoices broken:

    PDF_GENERATOR=snappdf

    Tried this and PDFs do not generate. Not even in the preview.
    Should this be on a new line or is it fine right bellow something?
    I did save the env file and restart the app upon each change.

    I also gave this a shot with no change.

    @humptydumpty said in PDF invoices broken:

    NINJA_ENVIRONMENT=selfhost

    PHANTOMJS_PDF_GENERATION=false

    COMPOSER_AUTH='{"github-oauth": {"github.com": "${{ secrets.GITHUB_TOKEN }}"}}'
    DISABLE_AUTO_UPDATE=true

    Invoice Ninja

  • PDF invoices broken
    joesitsolutionsJ joesitsolutions

    @girish @nebulon Hi, sorry about replying to solved issue but I am getting this weirdly. The PDF does generate but when I go to download/print/view it I get this:
    314eab3f-ec82-4e85-afc1-7f9eadd8eba1-image.png
    Same issue it seems.
    Tried adding these to the env file. Even tried different combos of these.
    Not proxied through cloudflare this time.

    PHANTOMJS_PDF_GENERATION=false
    PDF_GENERATOR=hosted_ninja
    

    No change after at all. It is a fresh install from today as I'm messing with it for testing purposes.

    Have tried edge,chrome,firefox and no change at all in either. Even tried their windows app with no avail.
    The fixes and main issues aren't really descriptive enough for a fix.

    Any advice or tips on this?

    Invoice Ninja

  • EspoCRM Stopped working randomly.
    joesitsolutionsJ joesitsolutions

    @girish You are 100% correct.
    Turned off proxied mode and it works fine now.
    Real Doh moment.
    Thanks for the help!

    EspoCRM

  • EspoCRM Stopped working randomly.
    joesitsolutionsJ joesitsolutions

    Hi There,

    My EsopCRM randomly stopped working.
    I am unsure why and have tried restoring from backup & restarting the app & web service. When I do restore from a backup I still get this.
    Have also tried generally restarting Cloudron/updating Cloudron.
    I get the following page with no explanation/error/obvious point of fail:
    1e5b05fd-12a5-47f4-b517-96ba95d905eb-image.png
    I have tried different machines, browsers & cleared cookies/cache.
    Have had no luck, and the logs don't seem to provide an obvious error.
    Is there anything I can do aside from reinstalling?

    EspoCRM

  • SMTP/Email issues
    joesitsolutionsJ 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:

    112609df-9aae-45f8-9af0-723543b68d5d-image.png

    I have the following settings on the Grav site:
    25f3977c-70b7-459a-b00a-5f1c7819dba8-image.png

    Within Cloudron I have the following:
    06483aea-25e9-4216-90af-139cd24b7f48-image.png
    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:
    9a154d6d-dd1b-441c-9f7e-23356cc256ca-image.png
    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:
    d4a2e7dc-84e0-41d3-aa9d-23f530933be5-image.png
    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
      1732b8ab-6894-4109-a198-4775957e8d04-image.png
    • 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:
    00008509-4593-4519-b181-8a34841c3383-image.png

    Support

  • my.cloudron.tld is not accessible
    joesitsolutionsJ 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 πŸ‘

    Support error box

  • my.cloudron.tld is not accessible
    joesitsolutionsJ 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.

    Support error box

  • my.cloudron.tld is not accessible
    joesitsolutionsJ 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?

    Support error box

  • my.cloudron.tld is not accessible
    joesitsolutionsJ 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.

    Support error box

  • my.cloudron.tld is not accessible
    joesitsolutionsJ 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:~#
    
    Support error box

  • Restoring app from backup?
    joesitsolutionsJ joesitsolutions

    I cannot for the life of me figure out how to do this.
    See Image:
    bruh.PNG
    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?

    Support backups restore
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search