Erpnext & Frappe 14+ Dev - DEVELOPMENT & PRODUCTION [UBUNTU/SERVER 22.04]

https://www.youtube.com/watch?v=4v4zs8TWleY :boom:

ERPNext 12 Installation Guide

ERPNext 13 Installation Guide

ERPNext 14 Installation Guide

DEBIAN 11 ERPNext 13, 14+DEV

.

:boom: NOTES :boom:

:small_blue_diamond: SHOULD USE SUGGESTED SYSTEM

because of python versions and frappe dependencies other systems might dont work

:small_blue_diamond: SHOULD BE ONLY 2 USERS IN SYSTEM [ root & frappe ]

you can use any other user other then frappe

:small_blue_diamond: ROOT & FRAPPE PASSWORDS SHOULD BE SAME AS MARIADB

you can use any other password other then frappe07

:small_blue_diamond: SERVER SHOULD BE UPGRADED BEFORE START INSTALLATION

.
.

:anger: DEVELOPMENT SETUP

sudo apt-get clean -y
sudo apt-get autoremove -y
sudo apt --fix-broken install -y
sudo dpkg --configure -a
sudo apt-get install -f
sudo apt-get update && sudo apt-get upgrade

root@server22

su - root

:small_blue_diamond: FIREWALL

ufw allow 22,25,143,80,443,3306,3022,8000/tcp
ufw enable

:small_blue_diamond: REQUIRED TOOLS

apt-get install git python3-dev python-setuptools python3-pip python3-distutils redis-server -y
apt install python3-venv -y
sudo apt-get update -y
apt-get install xvfb libfontconfig wkhtmltopdf -y

:small_blue_diamond: MARIADB

SET YOUR ROOT PASSWORD HERE

sudo passwd root
password: frappe07

apt-get install mariadb-server mariadb-client -y

mysql_secure_installation

Switch to unix_socket authentication [Y/n] n
Change the root password? [Y/n] y
password: frappe07
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

set root password. THIS IS MUST

mysql -u root -p
USE mysql;
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password;
SET PASSWORD = PASSWORD(‘frappe07’);
***GIVE THE PASSWORD AS ABOVE IN mysql_secure_installation SETUP
FLUSH PRIVILEGES;
exit

nano /etc/mysql/my.cnf

**add these lines @end of the file

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

service mysql restart
sudo reboot

frappe@server22

SET YOUR USER PASSWORD HERE

sudo passwd frappe
password: frappe07
sudo usermod -aG sudo frappe
sudo su - frappe

:small_blue_diamond: NODE JS & NPM

sudo apt-get install curl
curl -sL https://deb.nodesource.com/setup_16.x | sudo -E bash -
sudo apt-get install -y nodejs

:small_blue_diamond: BENCH REPO

sudo pip3 install frappe-bench
sudo npm install -g yarn

:small_blue_diamond: FRAPPE Dev

bench init frappe --verbose

cd frappe
bench start

- - OPEN NEW SESSION

:small_blue_diamond: SITE CREATION

sudo su - frappe

cd frappe
bench new-site site1.local
bench use site1.local

:small_blue_diamond: ERPNEXT Dev

bench get-app payments

make sure bench is runing in other terminal

bench get-app erpnext

make sure bench is runing in other terminal

bench get-app hrms

make sure bench is runing in other terminal

bench --site site1.local install-app erpnext
make sure bench is runing in other terminal

bench --site site1.local install-app hrms
make sure bench is runing in other terminal

bench use site1.local
bench migrate
STOP THE BENCH ( ctrl +c ) & START AGAIN ( bench start )

.
.
.

:partying_face: GO TO [SERVER IP]:8000 SETUP YOUR DEVELOPMENT SYSTEM :partying_face:

=====================================================

.
.
.

:anger: PRODUCTION SETUP

bench --site site1.local enable-scheduler
bench --site site1.local add-to-hosts
bench --site site1.local set-maintenance-mode off
bench --site site1.local scheduler resume
sudo snap install --classic certbot
sudo bench setup production frappe

bench setup supervisor
sudo ln -s pwd/config/supervisor.conf /etc/supervisor/conf.d/frappe-bench.conf

sudo bench setup sudoers $(whoami)

sudo su - frappe
cd frappe

sudo service supervisor stop
sudo service nginx stop
sudo service supervisor start
sudo service nginx start
sudo bench setup production frappe

.
.
.

:partying_face: GO TO [SERVER IP] YOUR PRODUCTION SYSTEM IS UP :partying_face:

.
.
.

================

:boom: NOTES :boom:

error: <class ‘PermissionError’>, [Errno 13] Permission denied: file: /usr/lib/python3/dist-packages/supervisor/xmlrpc.py line: 560

After productions is up. if you want to add any other app. just go through with below setup to avoid

============================

sudo su - frappe
cd frappe
sudo service supervisor stop
sudo service nginx stop
bench start

OPEN NEW SESSION

sudo su - frappe
cd frappe

bench get-app chat
make sure bench is runing in other terminal

bench get-app https://github.com/libracore/woocommerceconnector.git
make sure bench is runing in other terminal

bench get-app healthcare
make sure bench is runing in other terminal

bench get-app hospitality
make sure bench is runing in other terminal

================================

bench --site site1.local install-app chat
make sure bench is runing in other terminal

bench --site site1.local install-app woocommerceconnector
make sure bench is runing in other terminal

bench --site site1.local install-app healthcare
make sure bench is runing in other terminal

bench --site site1.local install-app hospitality
make sure bench is runing in other terminal

bench use site1.local
bench migrate
sudo service supervisor start
sudo service nginx start
bench --site site1.local clear-website-cache

.
.

================

:boom: BENCH UPDATE :boom:

After productions is up. Update the Bench

===========================================

sudo su - frappe
cd frappe
sudo service supervisor stop
sudo service nginx stop
bench start

OPEN NEW SESSION

sudo su - frappe
cd frappe
bench update --reset
sudo service supervisor start
sudo service nginx start
bench --site site1.local clear-website-cache

9 Likes

I wonder why do you require the same password for different kind of users?

for begginers. so there is no confusion to mariadb connection. if u are used to installations. can be use any passwords.

dont miss any step. and read guide carefully. i do a lot of installations without any error.

delete your replies. they are misleading. Thanks

1 Like

Try this while in production mode

sudo bench disable-production

then

sudo bench setup production <username>
1 Like

Just extending on the Cerbot Section:

sudo ln -s /snap/bin/certbot /usr/bin/certbot
sudo certbot --nginx
sudo certbot renew --dry-run

These can only be run if the site you are wanting to secure ends with a valid public suffix i.e, .com, .eu, etc.

This is quite complicated and I dont kouw what to follow, i have only two users one which was created during the instalation of the ubuntu and the other one frappe-user and the password is the same for maria db and both users.

I ran sudo service supervisor restart and now I get the following error on my localhost address:

Initially I was unable to create a customised app. Please help

DUE TO SYSTEM ISSUES

Go to link and copy command