ERPNext - cost-effective ERP solution

[nj]

I spent several days to make ErpNext work with Cloudron MySQL or Postgres. Unfortunately, postgres support is still a work in progress in ErpNext upstream and the project uses some features like CREATE SEQUENCE that are only available in MySQL, not in MariaDB. That's why the current version of this package is the most stable one.

My suggestion to @staff if you can, please add the MariaDB addon alongside the MySQL addon. It should be extremely easy to add because of the similarity with MySQL. There are so many open source software that use MariaDB, and will sooner or later be incompatible with MySQL.

[JLX89]

@staff anything further thoughts on this?

[girish]

@JLX89 doesn't seem like it's easy to host this on Cloudron yet. TBH, I don't think we will be able to support this sort of selfhosting complexity.

[LoudLemur]

@girish said in ERPNext - cost-effective ERP solution:

TBH, I don't think we will be able to support this sort of selfhosting complexity.

Cloudron does brilliantly at hosting Nextcloud, which I think is a somewhat similar, complex application. What is it about Nextcloud which makes it possible where ERPnext is too tricky?

[girish]

@LoudLemur you can see this post by @nj who already spent 100+ hours on this. The app also (when previously investigated) required database admin credentials and had restrictions on how username/password is created etc. All this makes it basically unviable for selfhosting imo, in general. I am sure it can be made to run with Cloudron with a lot of effort , but it's not worth it (for us).

[timconsidine]

Totally understand @girish
My 2p : "big" systems deserve their own dedicated deployment, e.g. own VPS

[JLX89]

@girish Thank you for following up! Yes, that makes total sense.

[nilesh]

@girish Were these issues ever reported to ERPNext? I couldn't find any mention of cloudron ever in their repository: https://github.com/frappe/erpnext/issues?q=is%3Aissue+is%3Aopen+cloudron

[nilesh]

[zonzonzon]

Is the ERPNext package on Cloudron still operational at this point? It has been a long time since I’ve seen any updates on this topic @nj

[nj]

Yes, the package still works.

New Installation using my image

To directly install ERPNext if you haven't previously, use this command:
Remember to replace <yourdomain.com> with youre actual domain.

cloudron login my.<yourdomain.com>
cloudron install --image njsubedi/cloudron-erpnext -l erp.<yourdomain.com>

Open the file manager to look for the credentials.

If you need to login with LDAP, you can do that by using the terminal of this app, and run /app/pkg/setup-ldap.sh add

Otherwise, that's all you need to do.

Updating

If you previously used ths app and want to continue using version-14, you need to do is run gosu cloudron bench update --reset once in a while to keep things up to date.

Now, I have upgraded the code to use version-15 by default.

If you were previously running on version-14 and now need to update to version-15 that's pretty easy too.

Just run gosu cloudron bench switch-to-branch version-15 frappe erpnext --upgrade

Then run gosu cloudron bench migrate

[zonzonzon]

@nj Hello, what is the most optimal method for backing up data from Cloudron currently, especially for ERPNext on Cloudron? Thank you.

[nj]

Currently, the data is automatically backed up. But I have also setup S3 backup to BackBlaze just to be double sure. Cloudron backup can be used for full restore of the site. It contains the database, files, and everything. ERPNext backup can be used to restore to a fresh installation.

Cloudron Auto Backup

S3 Backup Settings in ERPNext

PS: I would highly recommend utilizing your cloud provider's "Automatic Backup" or "Automatic Snapshot" feature that allows you to automatically backup the whole VPS everyday. This way you have redundant backups. Make sure to use multiple vendors. For eg: if you host your VPS on AWS,

1. Use AWS's automatic VPS backup system
2. Configure Cloudron backups to say, DigitalOcean spaces
3. Configure ERPNext backups to say, Backblaze
   If all three are in a nearby region, latency won't be an issue, and you'd hardly ever deal with data loss, unless all three cloud providers close your account on the same day.

[zonzonzon]

@nj Thank you very much. I will follow your guidance. Have a great day.

[andreasdueren]

What's keeping this from being officially packaged and offered in the App Store?

[jdaviescoates]

@andreasdueren I'm not sure, but I think perhaps most of this still applies:

https://forum.cloudron.io/post/59314

[BetaBreak]

@nj thanks for packaging this application. It is very much needed!

When I try to install, using your instructions, it I get the error:

No CloudronManifest.json found 

Do you know what I could be doing wrong? Do I need to first pull the image from dockerhub?

Thanks!

[plusone-nick]

@BetaBreak is https://github.com/njsubedi/cloudron-erpnext/blob/master/CloudronManifest.json in your root dir?

[BetaBreak]

@plusone-nick I downloaded the zip file from https://github.com/njsubedi/cloudron-erpnext locally on my computer and cd in that folder. Than I used the instruction provided by @nj https://forum.cloudron.io/post/87732 to get it running on cloudron.

[plusone-nick]

Noted, focusing on the error - is the CloudronManifest.json file currently in the system? As the output is suggesting the file is not there, maybe it's gone ‍️