Cloudron Forum

Hi

In my non-humble opinion, this is the best wiki out there. It produces beautiful documents.
It is a pure joy to use and combines the best experience from all other libre open source wiki's I have used.
Mind you, I also like Mediawiki and Dokuwiki - but they do not come close to BookStack.

It is light on resources and requires minimal configuration, an SQLITE db is supported. It would not be difficult to "port" to Cloudron.

Therefore I would like to propose the inclusion of BookStack. Please consider it!
Screenshots:

Overview

Example documentation pack

Page editor - yummy

Powerful search

Here is my SOLUTION:

It does not solve the root cause why you are running out of space, but with this methodology you will buy yourself time.

Generate 3 files of 2 gigabytes each.
This is one way of generating these files:
fallocate -l 2G /storage-padding-buffer-2-gb-file1.img
fallocate -l 2G /storage-padding-buffer-2-gb-file2.img
fallocate -l 2G /storage-padding-buffer-2-gb-file3.img

When your server is out of storage, you may delete one or all of these padding files, so that regain the space you need to rescue the server.

I have had the same issue with cloudron, because over time, storage will run out.
For now I chose not to update the storage of my VPS server because it will double my hosting cost for this node, from USD400 to USD800 per year. That's digital ocean pricing for you, but I digress.

This is a systems engineering issue and isn't caused by Cloudron. However I would not have anything against an elegant solution from the team if it were possible :).

I want to say I am working on a post to describe I work with a massive cleanup, and exactly which steps I took to regain loads of space. TLDR; use ncdu, analyze all containers and identify where apps are storing logs and rotating these, clear NPM package cache in each container. More to cone

Confirmed. I just tested @nebulon 's suggested method here, and it worked flawlessly.

I did the following steps to

Upgrade my LAMP application from PHP 7.2 to PHP 7.3

• Backed up my LAMP with php7.2.
• Downloaded the "Backup Configuration" JSON file for the backup of the old container
• Created a new LAMP container.
• Went to Backups -> Restore
• Uploaded the "backup configuration file" downloaded from the old container
• Entered the secret for my storage block storage space
• Clicked restore

After that everything worked, and I was on PHP 7.3
The LAMP application I migrated was a regular forum; Vanillaforums php/mysql stack.

Thanks @nebulon

Great! Somebody is taking action. Fantastic.

But please note @girish @samir - The current work focuses on packaging an old version of Odoo!
For some reason it is being packaged for Odoo version 10.
In that case release a package for all the latest 4 major versions 10, 11, 12 and 13
Latest version (2020) is version 13.
Issue: https://git.cloudron.io/altsyst/odoo-ce-app/issues/1
https://git.cloudron.io/altsyst/odoo-ce-app/issues/1

CiviCRM is very good.

Latest major version of Odoo Open Source is now v14

"One click" install script by a community contributor: https://github.com/Yenthe666/InstallScript

Edit: Release notes:

@msbt Odoo Community edition hosted on Cloudron would be a massive value add to the Cloudron portfolio. I totally recommend using Cloudron in a business to structure and improve processes. Unless your company has the budget to run Salesforce, or Service Now to do the same.

I was getting this. The default memory setting was not enough. Increased to 6gb, and it runs like a BMW.

Hi

I have now switched all my trivial sites and business critical systems over to container hosting provisioned by Cloudron. It's great!

Last step on this journey is to verify and test; perform a complete restore of the backup of the platform.
I currently take backups of cloudron every 6 hours and all containers every 6 hours. It seems to work pretty great, no errors.

However I am not sure how to proceed when doing a full restore of the entire Cloudron instance.
Here is my backup config:

I don't see any restore backups functionality in the web frontend of Cloudron.
Okay. Do I download the backup archive, uncompress the file and upload the contents to my server manually?
Where should I place those files?

I can download backup json configuration file, what's it for?

My end goal is to set up a daily sync between the backup location and a failover server on a different private cloud provider, maybe even to an on-prem machine in the office, just to be sure. These restored systems will contain the entire Cloudron instance restored from backups and it will be performed daily. But first I need to understand the various moving parts here.
I found some documentation here, but this was not enough for me to help myself with this topic.

@samir Any progress update on this?

Do you need help?

Did you see my issue mentioned above?

What will it take to roll this out with a newer version?

Would it work to replace the shell script in your Cloudron package with one that points towards Odoo v14?
Here is the script: https://github.com/Yenthe666/InstallScript/blob/14.0/odoo_install.sh

@girish Would you know the answer?

The installation script for Cloudron is too simple and I dear to say not well written.
If it fails ie. is stopped, at any step, the installation is rendered incomplete and it requires the user to provide it a "fresh ubuntu installation" upon next run.
For my last Cloudron installs I have had to rip out functions, ie comment out or delete the lines in order for the installation to complete.
It should not be this way.

The script should be idempotent. It should be able to run many times over without failing. It should just state that such and such step is complete or incomplete.

My suggestion:
All installation steps should be composed in an ansible playbook.
The shell script should download the latest ansible playbook and ensure that ansible is installed on the host machine. From here it should simply launch ansible with this playbook. The rest is magic.
The playbook itself is idempotent and can be run infinite amounts of time, without causing state issues.

Hi

I can't understand how I as an operator shall use the backup system Cloudron offers.

Yesterday I made a mistake and deleted an app I shouldn't have deleted (root cause).

Question time:
Given that I only remember the name of the container, how can I restore the backup of the container?
I don't have the UUID, I don't have the BackupID. I have full access to the object storage, api keys, secrets and encryption key.

My object storage is teeming with backups, Cloudron is set to do it every 6 hours. And this succeeds day in and day out. Great!

However It is not clear to me how to restore these backups.

In my Object storage I have backup archives like this

They seem to follow the naming convention of the uuid for the contiainer, OK that makes sense.

When I am going to restore my backups I have to provide these fields:

As far as I can tell, as an operator I need to keep track of what was the UUID of the container I deleted, in order to restore it. In addition I must also know what is the BackupID. More on that.

When I upload one of my backup config files, there seems to be reference to a BackupID ?
For one of my backups, this is the BackupID
2020-06-13-064435-141/box_2020-06-13-065422-378_v5.2.4 <--- If I don't have the Backup Config File how can I generate this ID? Or how to I find the ID of the container I accidentally deleted?

---

The only surefire way I can think of is to download the backup configuration file for every container and keep them in a folder on my onedrive for whenever disaster strikes such as now. Is this the way every one else are doing it?

Is there a place I can get an overview and piece together the variables and be able to do a restore of the container?

in order not to get stuck in the future, I now will need to do the following when I put an application in production (business critical):

• Create a spreadsheet containing a list of all my containers.
• Keep track of the UUID for each container.
• Download the backup configuration file for each container.
• Explicitly store the BackupID in the spreadsheet per application.
• Maybe there are more fields I must keep track of as well (???).
• Randomly test the restore capability of each container monthly.

Unless there are some elegant solutions here?

Guys this was my first brush with disaster recovery for an application I host on Cloudron and it not go down well.
If it wasn't for my random DigitalOcean Droplet snapshot(backups) and DigitalOcean scheduled VM backups, I would have been screwed here. I was not able to find the right backup archive and the right values to enter to correctly restore backup.

If anything this is a defect toward the documentation, because I cannot figure it out by reading this: https://cloudron.io/documentation/backups/ document. All of the great backup functionality in Cloudron didn't help me.

In Risk Management we use the Bowtie risk causal model and focus on our Barrier Management. The backups of Cloudron was supposed to be a recovery barrier.

This is not uncommon in IT, disaster recovery is a key think to test out. Unfortunately for me I hadn't done all the testing necessary as I didn't see myself ending up in this scenario (making a mistake and deleting a container I actually needed).

@jdaviescoates Odoo is not primarily a website builder for ecommerce to run a webshop. It is a fully fledged ERP with loads of functionality to operate a business. It would be a major value add if Cloudron team would package it and get it onto the Cloudron appstore. It would definitely attract paying Cloudron customers.

@gustavomarcante
Pretty sweet license too. LGPL.
The team has 40 developers
They have consistently produced releases.

Caution. There are dragons.

Although this approach worked perfectly.

I just totally screwed up.
To do a little cleanup, I deleted the "old" container with my 7.2 LAMP application.
Little did I know that my migrated 7.3 app was still persisting data to the 7.2 database instance!
It was all my fault, but this was not obvious to me. Make sure to check which Mysql database your 7.3 version is actually connecting to!

This has now led me down the disaster recovery path to try and fish out a backup package of the 7.2 version.
About to write another post about this situation. (link to disaster recovery thread)

@mastadamus Confirmed. This happened to me today, when I tried to install Crowdsec with Nginx bouncer onto my Cloudron VM.

Thank heavens for a good backup strategy. Digital Ocean snapshots to the rescue.

To have Crowdsec working with my Cloudron install would be a massive value add.

I am not even sure why Nginx failed to start afterwards. I did however note that the install modified or wiped a lot of the Nginx configs which were already in place and perhaps modified by Cloudron. But I haven't tried to dive any deeper.

@jdaviescoates said in Odoo - distributed business apps:

But in my limited experience of playing around with it I found it severely lacking, and with a terribly confusing UX.
Pretty much all the things it does are done MUCH better by other tools that focuses on doing that task rather than hacking together an Odoo module that kinda sorta does it.

This is wrong.

It is not confusing and provides a clean UX.

The functionality that it offers out of the standard modules are great, and provides plenty of value as they come.

I have used them for business scenarios on and off for 10 years.

If one wants to customize a system, one needs to learn this which is in itself a tradecraft. In Odoo's case it is similar to customizing Salesforce. This requires a developer attitude.

Please if you want to continue down this rabbit hole discussion, please list tools which are much better suited that replace Odoo.

Hi

Any plans to create a LAMP stack with Postgres?

It would make hosting all my favorite Postgres enabled applications possible.

I guess it would make it LAPP or something.

Thanks!

Hi

I have a scholar and a friend who used the SIGN UP link at the bottom of the login page of BASEROW.

Okay so far so good, but how do I delete his user? He is still my friend, but I need to know how to do it.

I do not know which users are on my system and I cannot delete and manage them

The user itself can delete himself, so that's something.

It is such a great value add when I can provide business support systems for my company. Anything such as a CRM, timesheets with Kimai, n8n workflows and integration, baserow and so on.
I think Cloudron should have a decent CRM application available.
Dolibarr and EspoCRM which indeed are packaged and published Cloudron apps, are not good enough in my view.
I am hoping for more business support systems on here, it would increase Cloudron's value for my businesses and I am very sure others would agree.

Some suggestions for CRMs: https://www.forbes.com/advisor/business/software/best-open-source-crm/

Sadly - I understand that ErpNext (discussion: https://forum.cloudron.io/topic/1228/erpnext-cost-effective-erp-solution/105 ) and Odoo (discussion: https://forum.cloudron.io/post/81451 ) are considered too large apps to be hosted for Cloudron. Both fit the bill perfectly.