How to install ERPNext on Ubuntu 18.04 LTS

ERPNext is a free, open-source, modern and easy-to-use business management software used by thousands of companies across the world. It is a very simple ERP platform that supports retail, trading, services, manufacturing, human resources, nonprofit and other sectors. It is powerful and fully-featured ERP system written in Python on top of the Frappe framework. It uses Node.js for the front end and MariaDB to store its data. ERPNext provides a web-based interface to perform day to day tasks. ERPNext provides an embedded reporting system with office suite integration.

In this tutorial, we will learn how to install and configure ERPNext on Ubuntu 18.04 LTS server.

Requirements

  • A server running Ubuntu 18.04.
  • A non-root user with sudo privileges set up to your server.

Getting Started

First, you will need to update your system with the latest version. You can do it by running the following command:

sudo apt-get update -y
sudo apt-get upgrade -y

Once your system is updated, you will need to create a user for ERPNext.

You can do it with the following command:

sudo useradd -m -s /bin/bash erpnext
sudo passwd erpnext

Next, give sudo privileges to ERPNext user with the following command:

sudo usermod -aG sudo erpnext

Next, log in to ERPNext user and setup environment variable with the following command:

su - erpnext
nano .bashrc

Add the following line:

PATH=$PATH:~/.local/bin/

Save and close the file, when you are finished. Then, restart your system to apply all the changes.

Install Required Packages

First, log in your system with the erpnext user and install some dependencies required by ERPNext to your system.

sudo apt-get install libffi-dev python-pip python-dev libssl-dev wkhtmltopdf -y

Next, install Nginx and MariaDB server with the following command:

sudo apt-get install nginx mariadb-server -y

Once the installation has been completed, you will need to make some changes in 50-server.cnf file. You can do it with the following command:

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Make the following changes:

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

Save and close the file. Then, restart MariaDB service to apply all the changes:

sudo systemctl restart mariadb

You can now check the status of MariaDB server with the following command:

sudo systemctl status mariadb

You should see the following output:

? mariadb.service - MariaDB 10.1.38 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Sat 2019-02-16 06:26:48 UTC; 2h 38min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 4640 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 4636 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 4505 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-
  Process: 4503 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 4482 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 4607 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 31 (limit: 1111)
   CGroup: /system.slice/mariadb.service
           ??4607 /usr/sbin/mysqld

Aug 16 06:26:47 ubuntu1804 systemd[1]: Starting MariaDB 10.1.38 database server...
Aug 16 06:26:48 ubuntu1804 mysqld[4607]: 2019-02-16  6:26:48 140715015396480 [Note] /usr/sbin/mysqld (mysqld 10.1.38-MariaDB-0ubuntu0.18.04.1) starting
Aug 16 06:26:48 ubuntu1804 systemd[1]: Started MariaDB 10.1.38 database server.
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4642]: Upgrading MySQL tables if necessary.
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4659]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4659]: Looking for 'mysql' as: /usr/bin/mysql
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4659]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4659]: This installation of MySQL is already upgraded to 10.1.38-MariaDB, use --force if you still n
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4677]: Checking for insecure root accounts.
Aug 16 06:26:48 ubuntu1804 /etc/mysql/debian-start[4681]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables

Install Redis and Node.js

Next, you will need to install Redis and Node.js to your system. You can install them by running the following command:

sudo curl --silent --location https://deb.nodesource.com/setup_8.x | sudo bash -
sudo apt-get install gcc g++ make -y
sudo apt-get install nodejs redis-server -y
sudo npm install -g yarn

Configure MariaDB

By default, MariaDB installation is not secured, so you will need to secure it first. You can secure it with the following command:

sudo mysql_secure_installation

Answer all the questions as shown below:

    Enter current password for root (enter for none):
    Set root password? [Y/n]: N
    Remove anonymous users? [Y/n]: Y
    Disallow root login remotely? [Y/n]: Y
    Remove test database and access to it? [Y/n]:  Y
    Reload privilege tables now? [Y/n]:  Y

Once MariaDB is secured, log in to MariaDB shell with the following command:

sudo mysql -u root -p

Enter your root password when prompt. Then, create a database and user for ERPNext with the following command:

MariaDB [(none)]> create database erpnextdb;
MariaDB [(none)]> create user [email protected] identified by 'password';

Next, grant all the privileges to the ERPNext with the following command:

MariaDB [(none)]> GRANT ALL ON erpnextdb.* TO 'erpnextuser'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
MariaDB [(none)]> GRANT all privileges on *.* to 'root'@'localhost' IDENTIFIED BY '[email protected]' WITH GRANT OPTION;

Next, flush the privileges and exit from the MariaDB shell with the following command:

MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> EXIT;

Install ERPNext

First, create a directory for ERPNext and give proper permissions with the following command:

sudo mkdir -p /opt/erpnext
sudo chown -R erpnext /opt/erpnext/

Next, change the directory to erpnext and install erpnext with the following command:

cd /opt/erpnext
git clone https://github.com/frappe/bench bench-repo

Output:

Cloning into 'bench-repo'...
remote: Enumerating objects: 19, done.
remote: Counting objects: 100% (19/19), done.
remote: Compressing objects: 100% (14/14), done.
remote: Total 6144 (delta 10), reused 13 (delta 5), pack-reused 6125
Receiving objects: 100% (6144/6144), 29.70 MiB | 231.00 KiB/s, done.
Resolving deltas: 100% (3924/3924), done.

Next, install bench using pip command:

sudo pip install -e bench-repo

Next, initialize the bench directory with frappe framework:

bench init erpnext

Output:

Building frappe assets...

? Built js/print_format_v3.min.js
? Built js/dialog.min.js
? Built js/web_form.min.js
? Built js/social.min.js
? Built js/modules.min.js
? Built js/form.min.js
? Built js/list.min.js
? Built js/frappe-vue.min.js
? Built js/chat.js
? Built js/desk.min.js
? Built js/control.min.js
? Built css/frappe-rtl.css
? Built css/module.min.css
? Built css/report.min.css
? Built css/form.min.css
? Built css/list.min.css
? Built frappe/css/email.css
? Built css/web_form.css
? Built css/frappe-web.css
? Built css/desk.min.css
? Built js/frappe-web.min.js
? Built js/report.min.js
?  Done in 31.313s
Done in 34.43s.
INFO:bench.utils:setting up backups
no crontab for erpnext
INFO:bench.utils:setting up auto update
no crontab for erpnext
Bench erpnext initialized

Next, change the directory to erpnext and create a new site for node1.example.com domain with the following command:

bench new-site node1.example.com

You will be asked to provide your MySQL root password as shown below:

MySQL root password:

Provide your root password and press Enter. You should see the following output:

Installing frappe...
Updating DocTypes for frappe        : [========================================]
Updating country info               : [========================================]
Set Administrator password: 
Re-enter Administrator password: 
*** Scheduler is disabled ***

Next, provide proper permissions to the erpnext with the following command:

sudo chown -R erpnext:erpnext /opt/erpnext/erpnext

Finally, start the server with the following command:

bench start

You should see the following output:

06:34:02 web.1            |  * Running on http://0.0.0.0:8000/ (Press CTRL+C to quit)
06:34:02 web.1            |  * Restarting with inotify reloader
06:34:03 watch.1          | yarn run v1.13.0
06:34:03 watch.1          | $ node rollup/watch.js
06:34:03 web.1            |  * Debugger is active!
06:34:04 web.1            |  * Debugger PIN: 159-307-235
06:34:13 watch.1          | 
06:34:13 watch.1          | Rollup Watcher Started
06:34:13 watch.1          | 
06:34:13 watch.1          | Watching...
06:34:15 watch.1          | Rebuilding frappe-web.css

Access ERPNext

ERPNext is now installed and listening on port 8000. Open your web browser and type the URL http://node1.example.come:8000. You will be redirected to the following page:

ERPNext Login

Now, provide username as Administrator and the password you provided during setup. Then, click on the Sign in button. You should see the following page:

Select Language

Next, choose your language and click on the Next button. You should see the following page:

Set company name

Next, choose your country and click on the Next button. You should see the following page:

Add a first user

Next, provide your full name and email address. Then, click on the Complete Setup button. You should see the following page:

ERPNext Dashboard

Congratulations! you have successfully installed and configured ERPNext in Ubuntu 18.04 server. You can now easily setup ERPNext in a production environment.

Share this page:

Suggested articles

2 Comment(s)

Add comment

Comments

By: Bibaschko at: 2019-09-04 10:39:07

thanks for the guide - unfortunately I have an issue with sudo mysql -u root -p

=> mysql: unknown variable 'pid-file=/var/run/mysqld/mysqld.pid'

What's worng?

thx

By: yaoming.shm at: 2019-09-23 03:41:26

error when running bench init erpnext

 

[email protected]:/opt/erpnext$ bench init erpnext

Traceback (most recent call last):

  File "/usr/local/bin/bench", line 9, in <module>

    load_entry_point('bench', 'console_scripts', 'bench')()

  File "/opt/erpnext/bench-repo/bench/cli.py", line 40, in cli

    bench_command()

  File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 764, in __call__

    return self.main(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 717, in main

    rv = self.invoke(ctx)

  File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 1137, in invoke

    return _process_result(sub_ctx.command.invoke(sub_ctx))

  File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 956, in invoke

    return ctx.invoke(self.callback, **ctx.params)

  File "/usr/local/lib/python2.7/dist-packages/click/core.py", line 555, in invoke

    return callback(*args, **kwargs)

  File "/opt/erpnext/bench-repo/bench/commands/make.py", line 31, in init

    python               = python)

  File "/opt/erpnext/bench-repo/bench/utils.py", line 52, in init

    raise ValueError('Bench Instance {path} already exists.'.format(path = path))

ValueError: Bench Instance erpnext already exists.