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
  1. Cloudron Forum
  2. App Wishlist
  3. ERPNext - cost-effective ERP solution

ERPNext - cost-effective ERP solution

Scheduled Pinned Locked Moved App Wishlist
118 Posts 35 Posters 57.4k Views 41 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • jdaviescoatesJ jdaviescoates

      @nj great, thanks!

      @staff are you going to take a look at this and get it into the App Store?

      njN Offline
      njN Offline
      nj
      wrote on last edited by
      #81

      @jdaviescoates I doubt that because of a few reasons.

      • ERPNext cannot use the MySQL addon because it needs MariaDB and needs to have exact same name for database username and the database name (eg. db_name and db_username must be same),

      • ERPNext cannot use the Postgrest addon because it needs access to the database root user's password, which seems impossible to grant. There might be a possibility if that particular user had permissions to create new databases and user, which isn't possible right now.

      • A separate MariaDB service is running inside the container. the database files are stored at /app/data so they can be backed up. This might not be a good idea but many apps that use file-based database are already using this so this might not be an issue.

      • The frappe-bench folder is huge (~1GB) and needs to be writable at runtime. Hence the backup size grows fast.

      If there's no problem running an extra background process for mariadb, and storing the data in /app/data folder, I think the team can look into packaging it. Good thing is this app doesn't need regular update as you can run bench update command to automatically update the Frappe framework and apps like Erpnext.

      Founder / Coder • My Apps

      L MooCloud_MattM timconsidineT 3 Replies Last reply
      3
      • njN nj

        @jdaviescoates I doubt that because of a few reasons.

        • ERPNext cannot use the MySQL addon because it needs MariaDB and needs to have exact same name for database username and the database name (eg. db_name and db_username must be same),

        • ERPNext cannot use the Postgrest addon because it needs access to the database root user's password, which seems impossible to grant. There might be a possibility if that particular user had permissions to create new databases and user, which isn't possible right now.

        • A separate MariaDB service is running inside the container. the database files are stored at /app/data so they can be backed up. This might not be a good idea but many apps that use file-based database are already using this so this might not be an issue.

        • The frappe-bench folder is huge (~1GB) and needs to be writable at runtime. Hence the backup size grows fast.

        If there's no problem running an extra background process for mariadb, and storing the data in /app/data folder, I think the team can look into packaging it. Good thing is this app doesn't need regular update as you can run bench update command to automatically update the Frappe framework and apps like Erpnext.

        L Offline
        L Offline
        LoudLemur
        wrote on last edited by
        #82

        @nj You do a lot of hard work for Cloudron. Thank you very much.

        1 Reply Last reply
        0
        • njN nj

          @jdaviescoates I doubt that because of a few reasons.

          • ERPNext cannot use the MySQL addon because it needs MariaDB and needs to have exact same name for database username and the database name (eg. db_name and db_username must be same),

          • ERPNext cannot use the Postgrest addon because it needs access to the database root user's password, which seems impossible to grant. There might be a possibility if that particular user had permissions to create new databases and user, which isn't possible right now.

          • A separate MariaDB service is running inside the container. the database files are stored at /app/data so they can be backed up. This might not be a good idea but many apps that use file-based database are already using this so this might not be an issue.

          • The frappe-bench folder is huge (~1GB) and needs to be writable at runtime. Hence the backup size grows fast.

          If there's no problem running an extra background process for mariadb, and storing the data in /app/data folder, I think the team can look into packaging it. Good thing is this app doesn't need regular update as you can run bench update command to automatically update the Frappe framework and apps like Erpnext.

          MooCloud_MattM Offline
          MooCloud_MattM Offline
          MooCloud_Matt
          wrote on last edited by
          #83

          @nj
          What you suggested is actually really hard to backup.
          And it's not the best to have too many process in the same container.
          Docker container differentiate from other container tecnologie to be single service container, even if they support multi services is not the best, especially for db.
          Due to resources management especially.

          Matteo. R.
          Founder and Tech-Support Manager.
          MooCloud MSP
          Swiss Managed Service Provider

          1 Reply Last reply
          1
          • njN nj

            I have published an update for ERPNext on Github - cloudron-erpnext-v0.20.0 This version is stable, but has breaking changes from the first release, so instead of updating you'll need to export and re-import the documents manually. This won't be necessary from future updates.

            1. Built on the base image version 4.0 (Ubuntu 22.04), so the source code is much lesser and simpler.
            2. Uses Cloudron's redis service, as requested by one of the members.
            3. The webserver and supervisor run as a normal (non-root) user so it's a bit more secure
            4. Existing apps (frappe, erpnext) etc can be updated easily from the terminal. There will be no need to update this app anymore from this point onward.
            5. New apps (like hrms, frappedesk) can also be added or removed easily.
            6. LDAP Settings can be configured if needed using the included script.
            7. There's preliminary support for multi-site setup.

            I request someone to test this package and give some feedback. Thank you.

            If building the app sounds complex, you can simply use the existing package by running cloudron install --image njsubedi/cloudron-erpnext:20230104-200417-70210de70 -l erp.your-domain.tld

            Note: the latest image can be found at https://hub.docker.com/r/njsubedi/cloudron-erpnext/tags . Replace 20230104-200417-70210de70 with the latest tag.

            R Offline
            R Offline
            rookiee
            wrote on last edited by
            #84

            @nj hey thanks for doing god works, i tested it and works really well.
            but i running to some problem when adding another erpnext site using different domain, seeing this message when visiting the url

            You are seeing this page because the DNS record of erp.redacted.com is set to this server's IP but Cloudron has no app configured for this domain.
            

            i'm running this command succesfully in the terminal

            gosu cloudron bench config dns_multitenant on 
            
            gosu cloudron bench new-site erp.redacted.com
            

            i'm sorry if this sound stupid, im new to cloudron

            1 Reply Last reply
            1
            • njN nj

              @jdaviescoates I doubt that because of a few reasons.

              • ERPNext cannot use the MySQL addon because it needs MariaDB and needs to have exact same name for database username and the database name (eg. db_name and db_username must be same),

              • ERPNext cannot use the Postgrest addon because it needs access to the database root user's password, which seems impossible to grant. There might be a possibility if that particular user had permissions to create new databases and user, which isn't possible right now.

              • A separate MariaDB service is running inside the container. the database files are stored at /app/data so they can be backed up. This might not be a good idea but many apps that use file-based database are already using this so this might not be an issue.

              • The frappe-bench folder is huge (~1GB) and needs to be writable at runtime. Hence the backup size grows fast.

              If there's no problem running an extra background process for mariadb, and storing the data in /app/data folder, I think the team can look into packaging it. Good thing is this app doesn't need regular update as you can run bench update command to automatically update the Frappe framework and apps like Erpnext.

              timconsidineT Offline
              timconsidineT Offline
              timconsidine
              App Dev
              wrote on last edited by timconsidine
              #85

              @nj thanks for comments.

              Strikes me that someone needs to be brave and just say 'ERPNext will not be packaged for Cloudron', as much in fairness to those who are really keen on it so they know it won't happen and they can look to self-host on a different VPS.

              I don't have a dog in the fight, just trying to improve clarity and reduce "app anxiety".

              There is no mechanism to "close" an entry in AppWIshlist. Maybe there needs to be one?

              Of course, if I am wrong, that's fine, the exploration can continue.

              subvenS 1 Reply Last reply
              3
              • timconsidineT timconsidine

                @nj thanks for comments.

                Strikes me that someone needs to be brave and just say 'ERPNext will not be packaged for Cloudron', as much in fairness to those who are really keen on it so they know it won't happen and they can look to self-host on a different VPS.

                I don't have a dog in the fight, just trying to improve clarity and reduce "app anxiety".

                There is no mechanism to "close" an entry in AppWIshlist. Maybe there needs to be one?

                Of course, if I am wrong, that's fine, the exploration can continue.

                subvenS Offline
                subvenS Offline
                subven
                wrote on last edited by
                #86

                @timconsidine you can of course install ERPNext at Cloudron with the package provided by @nj 🙂 It just needs some extra care and is not listed at the app store. Cloudron was always very open to custom package development and will push its efforts even further in the future.

                There is no need to close the listing at the App Wishlist since there is still high demand for ERPNext and maybe at some point the app store will open up to list community maintained packages.

                jdaviescoatesJ 1 Reply Last reply
                3
                • njN Offline
                  njN Offline
                  nj
                  wrote on last edited by
                  #87

                  To be honest I started packaging the most voted apps and ERPNext happened to be one of them. Also it saves me from installing 99 other apps now. 🙂

                  The good things about this package are:

                  • I don’t need to update it anymore; I can simply update the entire system without reinstalling this package

                  • I’m still working to bring multi-domain to it. For now dns based multi-tenancy is showing some issues but I will fix it soon

                  • If everything goes south, I can create a backup and move it to another ErpNext installation without an issue

                  • Cloudron totally takes care of backup and restore and I have already tested it

                  The bad things are:

                  • There are two processes running (mariadb and supervisor) and cloudron will only restart the container if supervisor goes out; but maybe I’ll add a mechanism to restart mariadb myself

                  • the backup size will be >1GB but if I’m using incremental backup this isn’t a big issue

                  • this app is not in the app store; but I’m going to keep the package maintained, because managing an instance of Erpnext on another VPS is going to be harder than maintaining it on Cloudron because I don’t have to care about ssl, redis, backups, ldap, etc.

                  So, guys, I’ll leave it here. Will let you know when an update is out.

                  Founder / Coder • My Apps

                  MooCloud_MattM 1 Reply Last reply
                  5
                  • subvenS subven

                    @timconsidine you can of course install ERPNext at Cloudron with the package provided by @nj 🙂 It just needs some extra care and is not listed at the app store. Cloudron was always very open to custom package development and will push its efforts even further in the future.

                    There is no need to close the listing at the App Wishlist since there is still high demand for ERPNext and maybe at some point the app store will open up to list community maintained packages.

                    jdaviescoatesJ Offline
                    jdaviescoatesJ Offline
                    jdaviescoates
                    wrote on last edited by
                    #88

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

                    maybe at some point the app store will open up to list community maintained packages.

                    Sounds like that is in the pipeline:

                    @girish said in What's coming in 7.4:

                    Community repo (appstore)

                    I use Cloudron with Gandi & Hetzner

                    1 Reply Last reply
                    0
                    • njN nj

                      To be honest I started packaging the most voted apps and ERPNext happened to be one of them. Also it saves me from installing 99 other apps now. 🙂

                      The good things about this package are:

                      • I don’t need to update it anymore; I can simply update the entire system without reinstalling this package

                      • I’m still working to bring multi-domain to it. For now dns based multi-tenancy is showing some issues but I will fix it soon

                      • If everything goes south, I can create a backup and move it to another ErpNext installation without an issue

                      • Cloudron totally takes care of backup and restore and I have already tested it

                      The bad things are:

                      • There are two processes running (mariadb and supervisor) and cloudron will only restart the container if supervisor goes out; but maybe I’ll add a mechanism to restart mariadb myself

                      • the backup size will be >1GB but if I’m using incremental backup this isn’t a big issue

                      • this app is not in the app store; but I’m going to keep the package maintained, because managing an instance of Erpnext on another VPS is going to be harder than maintaining it on Cloudron because I don’t have to care about ssl, redis, backups, ldap, etc.

                      So, guys, I’ll leave it here. Will let you know when an update is out.

                      MooCloud_MattM Offline
                      MooCloud_MattM Offline
                      MooCloud_Matt
                      wrote on last edited by
                      #89

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

                      Cloudron totally takes care of backup and restore and I have already tested it

                      Not really, cloudron takes a snapshot of /app/data, and your database I guess don't create a dump before that happened.
                      That's not really stable as a solution.

                      If you could like get a dump every x time, that could be a solution, even if not perfect

                      Matteo. R.
                      Founder and Tech-Support Manager.
                      MooCloud MSP
                      Swiss Managed Service Provider

                      njN 1 Reply Last reply
                      1
                      • MooCloud_MattM MooCloud_Matt

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

                        Cloudron totally takes care of backup and restore and I have already tested it

                        Not really, cloudron takes a snapshot of /app/data, and your database I guess don't create a dump before that happened.
                        That's not really stable as a solution.

                        If you could like get a dump every x time, that could be a solution, even if not perfect

                        njN Offline
                        njN Offline
                        nj
                        wrote on last edited by nj
                        #90

                        @MooCloud_Matt you don’t need to take a database dump because the entire mariadb database lies inside the /app/data folder.

                        Founder / Coder • My Apps

                        MooCloud_MattM L 2 Replies Last reply
                        0
                        • njN nj

                          @MooCloud_Matt you don’t need to take a database dump because the entire mariadb database lies inside the /app/data folder.

                          MooCloud_MattM Offline
                          MooCloud_MattM Offline
                          MooCloud_Matt
                          wrote on last edited by
                          #91

                          @nj
                          that is correct if you have ZFS or BTRFS, that can do a snapshot instantaneity.
                          But cloudron uses a simple compression or rsync, which means that from when it starts and when it stops it takes time and in that time, data could be changed and the relationship could come out corrupted.

                          postgress in their documentation, for example, suggests that if you want to use an fs snapshot you should stop the DB.

                          Matteo. R.
                          Founder and Tech-Support Manager.
                          MooCloud MSP
                          Swiss Managed Service Provider

                          1 Reply Last reply
                          2
                          • njN nj

                            @MooCloud_Matt you don’t need to take a database dump because the entire mariadb database lies inside the /app/data folder.

                            L Offline
                            L Offline
                            LoudLemur
                            wrote on last edited by
                            #92

                            @nj I do not know if it is permissable or even possible but how about trying to use the Cloudron Demo to setup uour ERPNext?
                            We could take a look at it there.

                            @girish ?

                            njN 1 Reply Last reply
                            0
                            • L LoudLemur

                              @nj I do not know if it is permissable or even possible but how about trying to use the Cloudron Demo to setup uour ERPNext?
                              We could take a look at it there.

                              @girish ?

                              njN Offline
                              njN Offline
                              nj
                              wrote on last edited by nj
                              #93

                              @LoudLemur you are right in that case. I didn’t worry because my backup schedule is at 3:00AM when nobody really used the app. If you expect people to write to the database during backup that’s an issue for sure.

                              Fortunately, ErpNext has a solution for that. We can put the app in maintenance mode for a while, and as I have already setup this ErpNext package to allow database read operations during maintenance, only writes will fail, which means websites etc will still be working fine.

                              Unfortunately, Cloudron doesn’t have a scheduler or cron system that can trigger a script before starting to backup and another script after backup success / failure. If @girish added a cron format like @prebackup @postbackup and @onbackupfail or simply added those options to the scheduler manifest, it would be perfect.

                              Either we could put the app in maintenance mode right before backup and put the site back on afterwards . I could even run mariadb inside /run/mariadb instead of /app/data ; I would only create database backup at /app/data/mariadb-dump-datetime.sql right before backup and delete it when backup task completes.

                              Also I’d like to see/know how the database addon handles backups and restoration.

                              Founder / Coder • My Apps

                              robiR 1 Reply Last reply
                              3
                              • njN nj

                                @LoudLemur you are right in that case. I didn’t worry because my backup schedule is at 3:00AM when nobody really used the app. If you expect people to write to the database during backup that’s an issue for sure.

                                Fortunately, ErpNext has a solution for that. We can put the app in maintenance mode for a while, and as I have already setup this ErpNext package to allow database read operations during maintenance, only writes will fail, which means websites etc will still be working fine.

                                Unfortunately, Cloudron doesn’t have a scheduler or cron system that can trigger a script before starting to backup and another script after backup success / failure. If @girish added a cron format like @prebackup @postbackup and @onbackupfail or simply added those options to the scheduler manifest, it would be perfect.

                                Either we could put the app in maintenance mode right before backup and put the site back on afterwards . I could even run mariadb inside /run/mariadb instead of /app/data ; I would only create database backup at /app/data/mariadb-dump-datetime.sql right before backup and delete it when backup task completes.

                                Also I’d like to see/know how the database addon handles backups and restoration.

                                robiR Offline
                                robiR Offline
                                robi
                                wrote on last edited by
                                #94

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

                                Unfortunately, Cloudron doesn’t have a scheduler or cron system that can trigger a script before starting to backup and another script after backup success / failure. If @girish added a cron format like @prebackup @postbackup and @onbackupfail or simply added those options to the scheduler manifest, it would be perfect.

                                File a feature request for this to get it in their queue.

                                Conscious tech

                                1 Reply Last reply
                                2
                                • yusfY Offline
                                  yusfY Offline
                                  yusf
                                  wrote on last edited by yusf
                                  #95

                                  @nj Thanks for packaging ERPNext. Its potential is vast.

                                  Trying out different features of it I notice that there seem to be several modules missing when compared to the ERPNext docs.

                                  For example Automation is missing. (Though I can reach and use event producers by searching for it, or reaching /app/event-producer directly)

                                  Perhaps that's all in order if your app is packing the core app only?

                                  njN 1 Reply Last reply
                                  2
                                  • yusfY yusf

                                    @nj Thanks for packaging ERPNext. Its potential is vast.

                                    Trying out different features of it I notice that there seem to be several modules missing when compared to the ERPNext docs.

                                    For example Automation is missing. (Though I can reach and use event producers by searching for it, or reaching /app/event-producer directly)

                                    Perhaps that's all in order if your app is packing the core app only?

                                    njN Offline
                                    njN Offline
                                    nj
                                    wrote on last edited by nj
                                    #96

                                    @yusf I have setup frappe to install ErpNext only. If Automation is an app, you can add any apps you like. Instructions on Github. I also installed other apps after installing this package on my cloudron. Or maybe Automation module is hidden by default and you can show it from Settings, I don’t know.

                                    Founder / Coder • My Apps

                                    1 Reply Last reply
                                    3
                                    • njN Offline
                                      njN Offline
                                      nj
                                      wrote on last edited by
                                      #97

                                      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.

                                      Founder / Coder • My Apps

                                      1 Reply Last reply
                                      7
                                      • girishG girish referenced this topic on
                                      • L LoudLemur referenced this topic on
                                      • J Offline
                                        J Offline
                                        JLX89
                                        wrote on last edited by
                                        #98

                                        @staff anything further thoughts on this?

                                        girishG 1 Reply Last reply
                                        1
                                        • J JLX89

                                          @staff anything further thoughts on this?

                                          girishG Offline
                                          girishG Offline
                                          girish
                                          Staff
                                          wrote on last edited by
                                          #99

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

                                          L J 2 Replies Last reply
                                          0
                                          • girishG 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.

                                            L Offline
                                            L Offline
                                            LoudLemur
                                            wrote on last edited by
                                            #100

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

                                            girishG 1 Reply Last reply
                                            0
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes


                                              • Login

                                              • Don't have an account? Register

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