ERP applications<\/a> , ERPNext supports MariaDB in order to store the persistent part of the data. Previously we installed the latest available version of MariaDB for CentOS 8 and now we need to configure it for ERPNext.<\/p>\r\n\r\n\r\n\r\nCreate a config file for ERPNext for MariaDB:<\/p>\r\n\r\n\r\n\r\n
cat <<EOF >\/etc\/my.cnf.d\/erpnext.cnf\r\n<\/pre>\r\n\r\n\r\n[mysqld]<\/p>\n\r\n\r\n\r\n
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<\/p>\r\n\r\n\r\n
[mysql]<\/p>\n\r\n\r\n\r\n
default-character-set = utf8mb4 EOF<\/p>\r\n\r\n\r\n\r\n
Enable and start the MariaDB service:<\/p>\r\n\r\n\r\n\r\n
sudo systemctl enable mariadb\r\nsudo systemctl start mariadb<\/pre>\r\n\r\n\r\n\r\nStart the MariaDB secure installation script (make sure you remember the MariaDB root password). Also, always use a strong passwords if asked:<\/p>\r\n\r\n\r\n\r\n
sudo mysql_secure_installation<\/pre>\r\n\r\n\r\n\r\n<\/span>Install ERPNext<\/span><\/h2>\r\n\r\n\r\n\r\nWe will install ERPNext under the new user that we have created, erp.<\/p>\r\n\r\n\r\n\r\n
Change to the ERPNext user and change the working directory to its home directory:<\/p>\r\n\r\n\r\n\r\n
su - erp<\/pre>\r\n\r\n\r\n\r\nInstall frappe-bench with pip3 and initialize version-12:<\/p>\r\n\r\n\r\n\r\n
pip3 install --user frappe-bench\r\nbench init frappe-bench --frappe-branch version-12<\/pre>\r\n\r\n\r\n\r\nWhen the initialization is done, you will get the following message:<\/p>\r\n\r\n\r\n\r\n
SUCCESS: Bench frappe-bench initialized<\/pre>\r\n\r\n\r\n\r\nWith the initialized frappe-bench we can create new frappe site for our ERPNext instance.<\/p>\r\n\r\n\r\n\r\n
We need to start the frappe development server:<\/p>\r\n\r\n\r\n\r\n
cd frappe-bench\r\nsed -i '\/web:\/ s\/$\/ --noreload\/' Procfile\r\nbench start >\/tmp\/bench_log &<\/pre>\r\n\r\n\r\n\r\nWe need to create a new site with our domain\/subdomain name:<\/p>\r\n\r\n\r\n\r\n
bench new-site erp.rosehosting.com<\/pre>\r\n\r\n\r\n\r\nWe will receive a prompt for the MySQL password that we have entered earlier. Enter the MySQL root password.<\/p>\r\n\r\n\r\n\r\n
Now we are ready to download and install ERPNext via bench.<\/p>\r\n\r\n\r\n\r\n
First download the latest ERPNext version with bench:<\/p>\r\n\r\n\r\n\r\n
bench get-app erpnext --branch version-12<\/pre>\r\n\r\n\r\n\r\nOnce downloaded install it:<\/p>\r\n\r\n\r\n\r\n
bench install-app erpnext<\/pre>\r\n\r\n\r\n\r\nNow we are ready to start and to use ERPNext<\/p>\r\n\r\n\r\n\r\n