Best way to install ERPNext on Ubuntu Desktop PC?

YogiYang · June 29, 2022, 4:58am

Hello,

I have an old Core i5 Desktop PC with 8 GB RAM.

I have installed Ubuntu (with X11) on it. This to avoid command line as much as possible.

Now I am planning to install ERPNext.

I would like to know what is the best way to install ERPNext?

Should I install servers like MySQL/MaraiDB and Redis using Ubuntu’s App store or should I install everything from command line as all the installation tutorials here are stating?

The reason why I am asking is because I later want to access MySQL/MaraiDB database using a GUI client like DB Weaver.

TIA

Yogi Yang

clbreshears · June 29, 2022, 6:06am

I know you want to avoid command line, but I don’t know of any way to do so.

What worked for me was installing on Ubuntu server 20.04 using Docker. I could not get the easy install script to work, and I also could not get the manual instal to work either.

Docker worked with no issues. If you want, I could copy and paste the exact steps that I used. (I saved each and every step, after much trial and error.)

Hope it helps even though it’s not what you wanted.

YogiYang · June 29, 2022, 6:12am

Hello,

Thanks for your reply. It is very informative.

Instead of sending days in getting ERPNext to install if we can do something using Dockers faster it would be very good.

But will the installation via docker slow down ERPNext compared to native install?

I am asking because I have never used Dockers till date.

But as you are using Dockers they may be worth using.

Please share installation steps for installing Dockers and ERPNext.

TIA

Yogi Yang

yogeshvachhani · June 29, 2022, 12:51pm

If you are installing Ubuntu 22.04 LTS then follow this guide to install ERPNext in Developer Mode only. I just installed Ubuntu 20.04 LTS in a VM and it is working wonderfully!!

If you want to install in Production Mode then you will have to search this forum for the exact steps.

revant_one · June 29, 2022, 1:56pm

not really. I only use containers for my self hosting stuff. they’re easy to use and don’t mess up with the host system.

I’ve no benchmarks to prove anything. I’m not benchmarking anything.

YogiYang · July 2, 2022, 6:46am

Hello,

Is there any official step by step guide for setting up Dockers on Ubuntu?

I want to setup ERPNext for production in Docker if possible.

BTW I found this article: ERPNext Docker Installation

But if there is official documentations it would be better and more assuring.

Finally would it be possible to use Dockers on Contabo because we are planning to purchase a VPS on Contabo.

TIA

Yogi Yang

revant_one · July 2, 2022, 10:31pm

production setup

github.com

frappe/frappe_docker/blob/main/docs/single-server-example.md

### Single Server Example

In this use case we have a single server with a static IP attached to it. It can be used in scenarios where one powerful VM has multiple benches and applications or one entry level VM with single site. For single bench, single site setup follow only up to the point where first bench and first site is added. If you choose this setup you can only scale vertically. If you need to scale horizontally you'll need to backup the sites and restore them on to cluster setup.

We will setup the following:

- Install docker and docker compose v2 on linux server.
- Install traefik service for internal load balancer and letsencrypt.
- Install MariaDB with containers.
- Setup project called `erpnext-one` and create sites `one.example.com` and `two.example.com` in the project.
- Setup project called `erpnext-two` and create sites `three.example.com` and `four.example.com` in the project.

Explanation:

Single instance of **Traefik** will be installed and act as internal loadbalancer for multiple benches and sites hosted on the server. It can also load balance other applications along with frappe benches, e.g. wordpress, metabase, etc. We only expose the ports `80` and `443` once with this instance of traefik. Traefik will also take care of letsencrypt automation for all sites installed on the server. _Why choose Traefik over Nginx Proxy Manager?_ Traefik doesn't need additional DB service and can store certificates in a json file in a volume.

Single instance of **MariaDB** will be installed and act as database service for all the benches/projects installed on the server.

Each instance of ERPNext project (bench) will have its own redis, socketio, gunicorn, nginx, workers and scheduler. It will connect to internal MariaDB by connecting to MariaDB network. It will expose sites to public through Traefik by connecting to Traefik network.

This file has been truncated. show original

development setup

YogiYang · July 7, 2022, 12:16pm

Hello @revant_one

Thanks for the detailed documentation but unfortunately I am not able to get Dockers to work.

There seems to be Port conflict with already running Ngnix daemon.

I am going to try it out a fresh tomorrow. Will post here the problems that I am facing as they occure.

Once more thanks for your invaluable help.

TIA

Yogi Yang

Leo_Sarmiento · July 7, 2022, 5:35pm

You want to install in Ubuntu…I give you the only guide that worked 100% and that I tried almost all that I found in the forum and search on the Internet … different OS Centos, Debian, AlmaLinux, Rocky Linux and Ubuntu.

I hope it helps you.

yogeshvachhani · July 16, 2022, 7:56am

@revant_one,

I just tried this on a VPS which is liked to a domain but after completing all the steps I am not able to get to the login screen.

Do we have to specify any ports to access ERPNext hosted in Docker on a VPS?

Regards,

revant_one · July 16, 2022, 1:10pm

traefik is publishing ports 443 and 80 and that is enough.

I’m not able to reproduce your issue. I am able to host sites using frappe_docker images.