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


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    ERPNext - cost-effective ERP solution

    App Wishlist
    32
    97
    6287
    Loading More Posts
    • 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.
    • chrishthompson
      chrishthompson last edited by

      @nebulon @girish ERPNext is looking good...I'd love to see it added officially as a Cloudron app! (I've decided to move our business to ERPNext.) Maybe they'd support adding an "Install with Cloudron" option on their GitHub page? That could bring more business customers to Cloudron I expect.

      Quick notes:

      • Their official docker image seems mature enough. https://github.com/frappe/frappe_docker
      • They also have a 1-click droplet app on Digital Ocean. (But I'd rather manage it through Cloudron...because Cloudron is beautiful and awesome.)
      • There is an ERPNext integration for n8n.
      Aizat 1 Reply Last reply Reply Quote 4
      • Aizat
        Aizat @chrishthompson last edited by

        @chrishthompson Yes, totally agree. I tried several ERPs and this one really made me almost teary. Such a rich-featured ERP and they decided to make it open source.
        It's a high quality made ERP. It has integration with WordPress and n8n.
        Really wish it would be in Cloudron soon.
        At the moment, I'm paying for a separate server just to deploy ERPnext. But it would lovely to have it in my Cloudron along with other apps I have here.
        Cloudron team, please consider bringing it here πŸ™‚

        1 Reply Last reply Reply Quote 4
        • Aizat
          Aizat @girish last edited by

          @girish Any chance you will be able to have a look at their official package? I deployed their docker image for production in DO: https://github.com/frappe/frappe_docker
          β€” and it works like a charm.
          Why I think ERPnext is a very beautiful project: Open-source at heart, with good developers behind it, highly supportive and very community-driven project. The project has been going on for almost a decade now. πŸ™‚

          andreasdueren 2 Replies Last reply Reply Quote 5
          • andreasdueren
            andreasdueren @Aizat last edited by

            @aizat I second this, would lvoe to see it on cloudron!

            andreasdueren 1 Reply Last reply Reply Quote 1
            • andreasdueren
              andreasdueren @andreasdueren last edited by

              Are there plans to bring ERPNext to cloudron soon so I can use those resources or do I have to set up and pay for another virtual machine? Because my Time is kind of running out on this one and I would rather not migrate again.

              J 1 Reply Last reply Reply Quote 2
              • J
                JLX89 @andreasdueren last edited by

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

                Are there plans to bring ERPNext to cloudron soon so I can use those resources or do I have to set up and pay for another virtual machine? Because my Time is kind of running out on this one and I would rather not migrate again.

                We're actually in the same boat, since it's a new year looking to move platforms and this would be a massive win on our side.

                1 Reply Last reply Reply Quote 3
                • andreasdueren
                  andreasdueren @Aizat last edited by

                  @aizat Since the cloudron Teams seems to be unwilling to adopt the official docker image for the app store, do you or anyone else here have experience in installing custom docker images so I can get this thing finally set up?

                  jadudm Aizat 2 Replies Last reply Reply Quote 1
                  • jadudm
                    jadudm @andreasdueren last edited by

                    @andreasdueren I've packaged one or two things for myself on Cloudron, and I took a look at Frappe/ERPnext.

                    First, for the thread: Cloudron does not run Docker images "as-is." Or, if you prefer, simply because a project runs in Docker does not mean that it will immediately be runnable under Cloudron. A Cloudron app needs to be packaged up so that it will "play nicely" with the control architecture that Cloudron provides. Put simply, to get that friendly Cloudron experience, some work is needed when packaging an app.

                    In the case of ERPnext, it has a compose file that specifies many software services. Traefik is used for routing and load balancing (I assume); Nginx fronts the service; it seems like Frappe (the API backend) is written in Python (another service). There's worker processes of several flavors, a scheduling service, a Redis cache, MariaDB (which, for porting to Cloudron, we'd want to integrate with it's built-in DB add-on), the site creator service... and a large number of storage volumes.

                    Cloudron does not, to the best of my understanding, support running docker-compose files. As a result, to package this, we'd have to pull all of these services into a single container image. That would take some thinking, especially since Docker "likes" to have one process per container. Or, if there is another way/it is possible, I don't personally know how to package up a multi-container Cloudron application.

                    The Cloudron team may have something else to say, but I thought I'd drop a note in the thread that helps explain why this app is a more complex proposition than others (perhaps) when it comes to packaging. Yes, it is open, and yes, it installs easily on a VM when you do a docker-compose up. Unfortunately, that is not the same as packaging things up to run under the Cloudron framework.

                    I use Cloudron on a Dell 7040 I bought on eBay.

                    andreasdueren 1 Reply Last reply Reply Quote 5
                    • andreasdueren
                      andreasdueren @jadudm last edited by

                      @jadudm Fair and not a problem. I'm just a little bit disappointed by the lack of communication. If it won't get packaged for a while then a short note would have been sufficient instead of letting people like me guessing whats planned next.

                      girish 1 Reply Last reply Reply Quote 3
                      • girish
                        girish Staff @andreasdueren last edited by

                        @andreasdueren We are not working on packaging this. We try to leave a note when we start packaging an app. Currently, we are working on 7.1 - https://forum.cloudron.io/topic/5982/what-s-coming-in-cloudron-7-1 and there's also many existing apps that need to be updated.

                        andreasdueren 1 Reply Last reply Reply Quote 2
                        • girish
                          girish Staff last edited by

                          For future reference, I found https://github.com/frappe/frappe/wiki/The-Hitchhiker's-Guide-to-Installing-Frappe-on-Linux . Fairly complicated!

                          1 Reply Last reply Reply Quote 1
                          • andreasdueren
                            andreasdueren @girish last edited by

                            @girish Thank you, that makes it easier forme to decide on my next steps with ERPNext. I'll check out that guide.

                            1 Reply Last reply Reply Quote 1
                            • Aizat
                              Aizat @andreasdueren last edited by Aizat

                              @andreasdueren Hey, sorry for the late reply. I have followed this protocol closely and it works like a charm: Youtube Video

                              It's fairly straightforward if you apply the same method as the video above, it uses the GitHub method that was posted here.
                              ERPnext is a solid system, worth the hassle. Good luck πŸ™‚
                              Kind regards.

                              1 Reply Last reply Reply Quote 4
                              • infogulch
                                infogulch last edited by infogulch

                                From what I've seen looking at the frappe/erpnext system design, it looks like a lot of the service complexity comes from their "bench" system tool that provides multitenancy / "environment duplication" capabilities via their backup and restore system. From my experience being able to branch environments is vital for these kinds of tools, but... that's basically cloudron's core competency. With a bit of work cloudron could probably match any missing features that "bench" has over it.

                                With bench factored out and its features provided by cloudron directly, I think you'd be left with a single python service that needs redis, mariadb/mysql, and postgresql, which cloudron provides as services already.

                                Notes:

                                • "frappe" is the company and also the name of the development/deployment framework for erpnext and other applications developed by the same team
                                • The frappe/frappe-worker docker image referred to in the frappe_docker/compose.yaml file is built from the source in frappe dir in the frappe/frappe repo
                                • The bench worker --queue short command (and similar) runs scheduler.py:start_worker()
                                • The queue workers are a Python RQ-based job scheduling/background task system. RQ uses redis queues
                                1 Reply Last reply Reply Quote 4
                                • nj
                                  nj last edited by

                                  Teaser πŸ˜‰

                                  12156ee2-dc50-446f-9c5b-b400d770289f-image.png

                                  Founder & OpenSource Lover. My Cloudron Apps

                                  nj 1 Reply Last reply Reply Quote 8
                                  • nj
                                    nj @nj last edited by nj

                                    Two major issues that I ran into while testing on cloudron.

                                    • frappe framework requires the database name and database username to be the same (its hardcoded and all over the place). When testing locally it worked but in cloudron, db name is appended with β€œdb” and username with β€œuser”

                                    • frappe framework needs root access to the database, eg. password of the user named β€œpostgres” (its hardcoded, even if β€”dbroot-username exists, it’s for mariadb only)

                                    That’s why I’m running postgres server on the Docker container itself, and not use any db addons. I’ll map the db storage to /app/data so it gets backed up regularly.

                                    See you guys with good news next time. Most apps made in Python seem to write all over the filesystem so I’m testing it on readonly environment; once done ErpNext should be available soon. Thank you for your patience.

                                    Founder & OpenSource Lover. My Cloudron Apps

                                    girish infogulch 2 Replies Last reply Reply Quote 6
                                    • girish
                                      girish Staff @nj last edited by

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

                                      frappe framework requires the database name and database username to be the same (its hardcoded and all over the place). When testing locally it worked but in cloudron, db name is appended with β€œdb” and username with β€œuser”

                                      That's a pretty rough requirement πŸ˜• but we can fix the platform code I guess to have an option to generate such names.

                                      frappe framework needs root access to the database, eg. password of the user named β€œpostgres” (its hardcoded, even if β€”dbroot-username exists, it’s for mariadb only)

                                      Keeps getting rougher πŸ™‚ There's no chance we will allow an app to have root db access.

                                      Is the situation any better with mariadb instead of postgresql?

                                      nj 1 Reply Last reply Reply Quote 5
                                      • infogulch
                                        infogulch @nj last edited by

                                        frappe framework needs root access to the database

                                        Surely this is not actually necessary to run the app, but is just part of their custom dynamic deployment system (ick). I hope it's possible to extricate the actual app from the framework...

                                        nj 1 Reply Last reply Reply Quote 1
                                        • nj
                                          nj @girish last edited by

                                          @girish for the initial release, I've given up on the idea of using Cloudron addons for now. Postgres is also getting over-complicated so I think I'd stick with MariaDB. Let's see how it goes. The build-run-test cycle is quite tedious when there are all kinds of new errors to resolve. ErpNext turned out to be a lot harder than I expected.

                                          Current status: frappe installed, up and running. ErpNext won't install, and require all its dependencies (apps) to be installed. My target is to publish it by this week.

                                          Founder & OpenSource Lover. My Cloudron Apps

                                          L 1 Reply Last reply Reply Quote 4
                                          • nj
                                            nj @infogulch last edited by

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

                                            frappe framework needs root access to the database

                                            Surely this is not actually necessary to run the app, but is just part of their custom dynamic deployment system (ick). I hope it's possible to extricate the actual app from the framework...

                                            I thought so too. Unfortunately, it keeps asking for "postgres super user password". 🀷

                                            Founder & OpenSource Lover. My Cloudron Apps

                                            1 Reply Last reply Reply Quote 3
                                            • L
                                              LoudLemur @nj last edited by

                                              @nj Thanks for all your hard work. Few have the necessary skills.

                                              1 Reply Last reply Reply Quote 3
                                              • nj
                                                nj last edited by nj

                                                Help Needed. Please check issue on github.

                                                I'm inches away from either successfully running ErpNext or quitting the idea of packaging it. Never had I ever stuck with this kind of stupid errors. 🀦

                                                When everything goes smooth, one of the modules (Payment Module in particular) make the entire table crash in the middle of loading the modules. Fix one error, then another pops up, then another.

                                                I no longer have time nor patience to package this after this week. Here's the progress.. github.com/njsubedi/cloudron-erpnext if anyone has time, skill and patience, please go ahead and continue packaging this piece of sofware.

                                                If anyone knows people from Frappe, please tell them to stop putting spaces and uppercase letters in table names, and at least retry any database operation instead of leaving the entire database in broken state when something fails, then have the user restart the minutes long process from the beginning.

                                                Hours spent: 100+

                                                Please check the issue on Github

                                                Founder & OpenSource Lover. My Cloudron Apps

                                                marcusquinn 1 Reply Last reply Reply Quote 10
                                                • marcusquinn
                                                  marcusquinn @nj last edited by

                                                  @nj You might not want to hear this, but in 100 hours, you could probably reproduce anything you need from ERPNext in EspoCRM using the Entity Manager to build copies of any specific data structures and Reports for anything specific there.

                                                  That's basically a lot of what I've been doing lately, taking Espo from being a CRM to an ERP system.

                                                  We're not here for a long time - but we are here for a good time :)
                                                  Jersey/UK
                                                  Work & Ecommerce Advice: https://brandlight.org
                                                  Personal & Software Tips: https://marcusquinn.com

                                                  nj 1 Reply Last reply Reply Quote 1
                                                  • nj
                                                    nj @marcusquinn last edited by

                                                    @marcusquinn I could do the entire EspoCRM in Directus if I had to. πŸ˜‰

                                                    I wanted to package it because it's one of the most wanted apps, but I think it takes someone else who knows python and databases more than me.

                                                    Founder & OpenSource Lover. My Cloudron Apps

                                                    marcusquinn 1 Reply Last reply Reply Quote 2
                                                    • marcusquinn
                                                      marcusquinn @nj last edited by

                                                      @nj After 18 months working with Espo, I doubt it, and I'm a fan of Directus too.

                                                      I see value in having ERPNext, and Odoo, packaged and available too. Even if only so that people can compare all of these similar apps, and take inspiration from all of them to make the best solution with the one they choose to develop among them.

                                                      I think you're right though, this one needs cooperation from the original author if it's not versatile enough to handle errors in building in Cloudron's tighter security Docker environment.

                                                      We're not here for a long time - but we are here for a good time :)
                                                      Jersey/UK
                                                      Work & Ecommerce Advice: https://brandlight.org
                                                      Personal & Software Tips: https://marcusquinn.com

                                                      1 Reply Last reply Reply Quote 5
                                                      • nj
                                                        nj last edited by nj

                                                        Trailer πŸ˜‰
                                                        You know what's disappointing? I started packaging ERPNext for the HR module. Unfortunately, the HR Module is not available after installation. Now I'm here thinking where the hell it go, and why I spent weeks packaging something that doesn't have the particular module I was looking for. 🀦

                                                        Update: Looks like version-14 of ERPNext does not have HR module. Only version-13 has it. πŸ˜• Now packaging version 13.

                                                        b64d910b-dc2c-4bae-b5d4-e0154a7d05e9-image.png

                                                        Founder & OpenSource Lover. My Cloudron Apps

                                                        subven mdreira 2 Replies Last reply Reply Quote 7
                                                        • subven
                                                          subven @nj last edited by

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

                                                          Looks like version-14 of ERPNext does not have HR module.

                                                          They refactored the HR and Payroll module into a "new" app --> #31467. Maybe this could still be installed within the current V14 docker app --> ERPNext HRMS installation.

                                                          PS: Thank you for your hard work 😹

                                                          nj 1 Reply Last reply Reply Quote 6
                                                          • nj
                                                            nj @subven last edited by

                                                            @subven oh, wow! How did I miss that!

                                                            Founder & OpenSource Lover. My Cloudron Apps

                                                            Aizat 1 Reply Last reply Reply Quote 2
                                                            • Aizat
                                                              Aizat @nj last edited by

                                                              @nj Not sure if this is what you are looking for, but if you wish to put on a donation pot, I would be happy to contribute where I can, as a token of thanks for your hard work and time!
                                                              Thank you again for all the hard work.

                                                              nj 1 Reply Last reply Reply Quote 3
                                                              • nj
                                                                nj @Aizat last edited by

                                                                @Aizat I'm looking for someone who know MariaDB and Python3 for the project. I've successfully packaged ErpNext, but I had to patch the source code of "Payments" and "HRMS" modules that crash the database tables during installation. Instead of cash, I'm looking for few other people who would pull the repo, and see if they see the same kind of crashes.

                                                                Founder & OpenSource Lover. My Cloudron Apps

                                                                1 Reply Last reply Reply Quote 4
                                                                • nj
                                                                  nj last edited by

                                                                  @girish @nebulon would you look into it?

                                                                  Founder & OpenSource Lover. My Cloudron Apps

                                                                  infogulch 1 Reply Last reply Reply Quote 1
                                                                  • infogulch
                                                                    infogulch @nj last edited by infogulch

                                                                    @nj I tried installing it to my cloudron and it built successfully, but I ran into an issue with the cloudron cli during installation saying that I need to specify a subdomain (when I clearly did specify a subdomain), then I ran out of time to mess with it until later this week.

                                                                    1 Reply Last reply Reply Quote 2
                                                                    • nj
                                                                      nj last edited by

                                                                      Okay, the errors have gone. I'd say I'm 99% done packaging. Will post the good news soon.

                                                                      Founder & OpenSource Lover. My Cloudron Apps

                                                                      1 Reply Last reply Reply Quote 5
                                                                      • nj
                                                                        nj last edited by

                                                                        Okay, here is the good news. Please try it out and let me know if it works.

                                                                        If you're not ready to build the image yourself, you can simply install the image that I created. cloudron install --image njsubedi/cloudron-erpnext -l erp.<yourdomain.tld>.

                                                                        ErpNext v14 is now available on Cloudron. See the README file for usage instructions.

                                                                        Features

                                                                        • ErpNext v14 - running on Frappe Framework v14
                                                                        • HRMS Module - Includes HR and Payroll modules
                                                                        • Plug n Play - Automatically configured to use the subdomain you install it on, no setup needed
                                                                        • Independent - Does not depend on Cloudron Addons for redis, mysql or such

                                                                        Gotchas

                                                                        • Installs its own database servers, but data resides inside /app/data, so it gets backed-up, no not a big issue
                                                                        • Hasn't been tested a lot, but it's working pretty fine
                                                                        • Multi-tenancy isn't set up, even though that's pretty trivial to do

                                                                        Good to know

                                                                        • After installation, look into /app/data folder using cloudron's file manager for a file that ends with -credential.txt.
                                                                        • Raise issues on Github if you run into problems, not here.

                                                                        Founder & OpenSource Lover. My Cloudron Apps

                                                                        L marcusquinn B 3 Replies Last reply Reply Quote 8
                                                                        • L
                                                                          LoudLemur @nj last edited by

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

                                                                          Okay, here is the good news. Please try it out and let me know if it works.

                                                                          If you're not ready to build the image yourself, you can simply install the image that I created. cloudron install --image njsubedi/cloudron-erpnext -l erp.<yourdomain.tld>.

                                                                          ErpNext v14 is now available on Cloudron. See the README file for usage instructions.

                                                                          Features

                                                                          • ErpNext v14 - running on Frappe Framework v14
                                                                          • HRMS Module - Includes HR and Payroll modules
                                                                          • Plug n Play - Automatically configured to use the subdomain you install it on, no setup needed
                                                                          • Independent - Does not depend on Cloudron Addons for redis, mysql or such

                                                                          Gotchas

                                                                          • Installs its own database servers, but data resides inside /app/data, so it gets backed-up, no not a big issue
                                                                          • Hasn't been tested a lot, but it's working pretty fine
                                                                          • Multi-tenancy isn't set up, even though that's pretty trivial to do

                                                                          Good to know

                                                                          • After installation, look into /app/data folder using cloudron's file manager for a file that ends with -credential.txt.
                                                                          • Raise issues on Github if you run into problems, not here.

                                                                          You are a Free Software hero right there, @nj !

                                                                          1 Reply Last reply Reply Quote 5
                                                                          • marcusquinn
                                                                            marcusquinn @nj last edited by

                                                                            @nj πŸ’― bonus points to you sir! πŸ‘

                                                                            We're not here for a long time - but we are here for a good time :)
                                                                            Jersey/UK
                                                                            Work & Ecommerce Advice: https://brandlight.org
                                                                            Personal & Software Tips: https://marcusquinn.com

                                                                            1 Reply Last reply Reply Quote 4
                                                                            • Referenced by  infogulch infogulch 
                                                                            • subven
                                                                              subven last edited by subven

                                                                              Can somebody review the code?

                                                                              @girish what else needs to be done so that it can be released as an unstable app in the store?

                                                                              Some concerns:

                                                                              • only dev branch for hrms and payment module and no release (yes I'm aware that only the dev branch exists - this has to be adressed in the future)
                                                                              • does not use Cloudrons Redis
                                                                              • Will some of the database mitigations break the insallation in the future?

                                                                              I will wait until the unstable release at the Cloudron App Store and start testing then πŸ™‚

                                                                              1 Reply Last reply Reply Quote 4
                                                                              • nj
                                                                                nj last edited by

                                                                                I’ve added Cloudron LDAP support. I’ll push the changes this evening.

                                                                                I think I can do Cloudron redis too. Looks doable.

                                                                                I think after the default site is created, I can dump the db and import that to cloudron MySQL, but still ErpNext devs recommend Mariadb support only, and it needs the database name to be the same as the db user name. Unless there’s support from Cloudron devs, it’s a blocker. But I have set db path to be inside /app/data, so backup is not an issue. Also tried migration and backup-restore, which worked fine.

                                                                                Since I’m actively using it at my company I’ll keep supporting this app. Also Keycloak, Outline and Odoo.

                                                                                Founder & OpenSource Lover. My Cloudron Apps

                                                                                H L 2 Replies Last reply Reply Quote 7
                                                                                • H
                                                                                  hakunamatata @nj last edited by

                                                                                  @nj Thanks for your hard work with this! I am looking forward to the day this becomes available in the app store us n00bs. 😊

                                                                                  1 Reply Last reply Reply Quote 3
                                                                                  • L
                                                                                    LoudLemur @nj last edited by

                                                                                    @nj What is the latest on Odoo? Is it still inching its way to beta on Cloudron?

                                                                                    1 Reply Last reply Reply Quote 2
                                                                                    • mdreira
                                                                                      mdreira translator @nj last edited by

                                                                                      @nj ERPNext 14 also have an LMS, right?

                                                                                      https://erpnext.com/open-source-education

                                                                                      micmc 1 Reply Last reply Reply Quote 2
                                                                                      • micmc
                                                                                        micmc @mdreira last edited by

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

                                                                                        @nj ERPNext 14 also have an LMS, right?

                                                                                        https://erpnext.com/open-source-education

                                                                                        Seem like yes, indeed, as it is written on the quoted page. And it seems to be very powerful as well.


                                                                                        https://marketingtechnology.agency
                                                                                        For cutting edge web technologies

                                                                                        mdreira 1 Reply Last reply Reply Quote 2
                                                                                        • mdreira
                                                                                          mdreira translator @micmc last edited by

                                                                                          @micmc @nj Yes.

                                                                                          After reviewing Odoo and Flectra, in their community and enterprise versions, I think that ERPNext is a very good option because it is 100% free software.

                                                                                          And it has a lot of features.

                                                                                          As @nebulon says, it is a cost-effective ERP solution.

                                                                                          marcusquinn 1 Reply Last reply Reply Quote 2
                                                                                          • marcusquinn
                                                                                            marcusquinn @mdreira last edited by

                                                                                            @mdreira The big gotchya with Odoo is that the most useful part of it, the Studio addon, is not in the community edition.

                                                                                            With ERPNext, their equivalent no-code custom data model builder is included.

                                                                                            We're not here for a long time - but we are here for a good time :)
                                                                                            Jersey/UK
                                                                                            Work & Ecommerce Advice: https://brandlight.org
                                                                                            Personal & Software Tips: https://marcusquinn.com

                                                                                            1 Reply Last reply Reply Quote 4
                                                                                            • B
                                                                                              benneic @nj last edited by

                                                                                              This post is deleted!
                                                                                              1 Reply Last reply Reply Quote 0
                                                                                              • mdreira
                                                                                                mdreira translator last edited by mdreira

                                                                                                @girish @nebulon so, could erpnext be a reality in Cloudron in the short term?

                                                                                                (I know you are working in the new update)

                                                                                                1 Reply Last reply Reply Quote 1
                                                                                                • P
                                                                                                  privsec last edited by

                                                                                                  Such a great solution and offering.

                                                                                                  This would solve quite a few problems a client of mine is experiencing trying to solve.

                                                                                                  Looking forward to this!

                                                                                                  1 Reply Last reply Reply Quote 3
                                                                                                  • mdreira
                                                                                                    mdreira translator last edited by

                                                                                                    Wow, this app wishlist post started at 2018…

                                                                                                    P 1 Reply Last reply Reply Quote 0
                                                                                                    • P
                                                                                                      plusone-nick @mdreira last edited by

                                                                                                      @mdreira Yeahhh...all good things take time, plus ERP next at the time was not what it is now lol but that's even more reason to get it onboarded now =]

                                                                                                      βœŒπŸ’™+1

                                                                                                      Aizat 1 Reply Last reply Reply Quote 0
                                                                                                      • Aizat
                                                                                                        Aizat @plusone-nick last edited by

                                                                                                        @plusone-nick I'm hoping the Cloudron team will support to include this formally in Cloudron soon. There might be some hindrances, but I think it should work relatively fine now, right?

                                                                                                        1 Reply Last reply Reply Quote 0
                                                                                                        • S
                                                                                                          spacetime last edited by

                                                                                                          I add my request for ERPNext!

                                                                                                          1 Reply Last reply Reply Quote 1
                                                                                                          • infogulch
                                                                                                            infogulch last edited by

                                                                                                            I was able to successfully build and run the package nj published on github for the last couple of months.

                                                                                                            It seems to work fine, though I have not had a chance to evaluate how the upgrade and backup/restore process goes (I still have concerns about how it would interact with cloudron long-term), and I've only just started setup for a few modules.

                                                                                                            From my (limited) experience, if you want to use ERPNext, be prepared for an extended commissioning phase. The product is both wide and deep, you will be taking considerable time to learn the ERPNext system and configuring it to work with your business process. ERPNext is moderately opinionated on how things should work, an approach I generally appreciate, but I found integration to be a big task as it pushed me to shift my expectation on how things should be organized to the "ERPNext-way". To be fair, this could be as much my ignorance of ERP systems in general as ERPNext's particular obtuseness, but I suspect the truth is that any large integrated bookkeeping system will exhibit similar commissioning/integration difficulties by the very nature of its size and scope.

                                                                                                            I don't mean to push anyone away from the product, just to lay out realistic expectations of how much effort it will take on your part to integrate a product of this scope into your business.

                                                                                                            1 Reply Last reply Reply Quote 3
                                                                                                            • nj
                                                                                                              nj last edited by 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.

                                                                                                              Founder & OpenSource Lover. My Cloudron Apps

                                                                                                              jdaviescoates R 2 Replies Last reply Reply Quote 9
                                                                                                              • jdaviescoates
                                                                                                                jdaviescoates @nj last edited by

                                                                                                                @nj great, thanks!

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

                                                                                                                I use Cloudron with Gandi & Hetzner

                                                                                                                nj 1 Reply Last reply Reply Quote 0
                                                                                                                • nj
                                                                                                                  nj @jdaviescoates last edited by

                                                                                                                  @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 & OpenSource Lover. My Cloudron Apps

                                                                                                                  L MooCloud_Matt timconsidine 3 Replies Last reply Reply Quote 1
                                                                                                                  • L
                                                                                                                    LoudLemur @nj last edited by

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

                                                                                                                    1 Reply Last reply Reply Quote 0
                                                                                                                    • MooCloud_Matt
                                                                                                                      MooCloud_Matt @nj last edited by

                                                                                                                      @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 Reply Quote 1
                                                                                                                      • R
                                                                                                                        rookiee @nj last edited by

                                                                                                                        @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 Reply Quote 1
                                                                                                                        • timconsidine
                                                                                                                          timconsidine @nj last edited by 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.

                                                                                                                          subven 1 Reply Last reply Reply Quote 3
                                                                                                                          • subven
                                                                                                                            subven @timconsidine last edited by

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

                                                                                                                            jdaviescoates 1 Reply Last reply Reply Quote 3
                                                                                                                            • First post
                                                                                                                              Last post
                                                                                                                            Powered by NodeBB