|

Installing ERPNext 14 on Ubuntu 22.04

ERPNext is a promising Open Source ERP solutions that, unlike similar products such as Odoo is completely Open Source and as such does not require paying modules to use all its functionalities. ERPNext is built on the Frappé Framework that can be managed with the cli tool “bench”. Although somewhat cumbersome, installation is not really difficult, but must be done in a specific order to get it working. In this tutorial, we will go through the procedure step by step.

We assume you have a fresh installation of Ubuntu 22.04 available that we still need to update and upgrade to make sure we are using the latest packages.

# apt update && apt upgrade -y

Now we are ready to install all the required packages for ERPNext.

# apt install git python3-dev python3.10-dev python3-setuptools python3-pip python3-distutils python3.10-venv software-properties-common mariadb-server mariadb-client redis-server xvfb libfontconfig wkhtmltopdf libmysqlclient-dev npm -y

Run the MySQL secure installation script.

# mysql_secure_installation
Enter current password for root: (Enter your SSH root user password)
Switch to unix_socket authentication [Y/n]: Y
Change the root password? [Y/n]: Y
It will ask you to set new MySQL root password at this step. This can be different from the SSH root user password.
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n]: N
This is set as N because we might want to access the database from a remote server for using business analytics software like Metabase / PowerBI / Tableau, etc.
Remove test database and access to it? [Y/n]: Y
Reload privilege tables now? [Y/n]: Y

Make the necessary changes to the MariaDB configuration files.

# vi /etc/mysql/mariadb.conf.d/50-server.cnf
[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

And also comment out the following.

#character-set-server = utf8mb4
#collation-server = utf8mb4_general_ci
# vi /etc/mysql/mariadb.conf.d/50-client.cnf
[client]
default-character-set = utf8mb4

Restart MariaDB to apply the modifications.

# systemctl restart mariadb

Create a new directory “/opt/erpnext”.

# mkdir -p /opt/erpnext

Create a new user “erpnext”.

# useradd -m -s /bin/bash erpnext

Add a strong password.

# passwd erpnext

Add new user “erpnext” to the “sudo” group

# usermod -aG sudo erpnext

Now change the owner of the “/opt/erpnext/” directory to “erpnext”.

# chown -R erpnext /opt/erpnext/

Switch to the “erpnext” user.

# su - erpnext

Add path to the “.bashrc” file.

$ tee -a ~/.bashrc<<EOF
PATH=\$PATH:~/.local/bin/
EOF

Switch into the “/opt/erpnext/” directory.

$ cd /opt/erpnext/

Install nvm.

$ curl https://raw.githubusercontent.com/creationix/nvm/master/install.sh | bash

Read the “.profile” file.

$ source ~/.profile

Install Node.js (version 16.15.0).

$ nvm install 16.15.0

Install Yarn package manager.

$ sudo npm install -g yarn

Install Frappé with bench.

$ sudo pip3 install frappe-bench

Install the python package of Redis.

$ sudo pip3 install redis

Use “bench” to set-up for Frappé.

$ bench setup redis

Initialize Frappé Bench

$ bench init --frappe-branch version-14 frappe-bench

Switch into the Frappe Bench directory.

$ cd frappe-bench

Change user directory permissions giving the bench user execution permission to the home directory.

$ chmod -R o+rx /opt/erpnext/

Create a new site.

$ bench new-site erp.mysite.com
MySQL root password:

Installing frappe...
Updating DocTypes for frappe        : [========================================] 100%
Updating country info               : [========================================] 100%
Set Administrator password:
Re-enter Administrator password:
Updating Dashboard for frappe
erp.mysite.com: SystemSettings.enable_scheduler is UNSET
*** Scheduler is disabled ***

Use “bench” to install the “payments” app which is required to set up ERPNext.

$ bench get-app payments

And now install the “ERPNext” app.

$ bench get-app --branch version-14 erpnext

Install the “ERPNext” app to your domain.

$ bench --site erp.mysite.com install-app erpnext

Instruct Frappé to use your domain.

$ bench use erp.mysite.com

And finally start bench.

$ bench start

Now you should be able to login in your brouwser http://your-erpnext-server- ip:8000 using “Administrator” as user and the password you entered during the installation process.

Switching to production environment.

$ sudo bench setup production erpnext

And after this has finish perform a second time

$ sudo bench setup production erpnext

And answer with yes “y” twice to continue.

Setting Up prerequisites...
Setting Up supervisor...
supervisor.conf already exists and this will overwrite it. Do you want to continue? [y/N]: y
Setting Up NGINX...
nginx.conf already exists and this will overwrite it. Do you want to continue? [y/N]: y
Port configuration list:

Site erp.yoursite.com assigned port: 80

Now your site should be available on both ip and domain (fqdn).

Similar Posts