Installing Frappe ERPNext on CentOS 7

scottalanmiller

@stacksofplates said in Installing Frappe ERPNext on CentOS 7:

Might need to enable verbose logging. I've never done anything with Redis, but if it's like some other services, you have to manually turn on debug logging.

It should log starting up and stuff, at least.

stacksofplates

@scottalanmiller said in Installing Frappe ERPNext on CentOS 7:

@stacksofplates said in Installing Frappe ERPNext on CentOS 7:

Might need to enable verbose logging. I've never done anything with Redis, but if it's like some other services, you have to manually turn on debug logging.

It should log starting up and stuff, at least.

If I remember right, SSSD doesn't log really anything unless you enable it in the config. I mean syslog will spit something out saying it's not running, but the logs in /var/log/sssd don't have any info.

Just a thought.

stacksofplates

As an aside, I never had really any luck running ERPNext with CentOS, only with Ubuntu. The script seemed to always have issues.

One of the main reasons why I stopped using it. It was too much work keeping up to date with it, and reinstalling was always a pain.

scottalanmiller

Yes, very easily this is a new update that has broken ERPNext.

stacksofplates

@scottalanmiller said in Installing Frappe ERPNext on CentOS 7:

Yes, very easily this is a new update that has broken ERPNext.

I was really only using the accounting, so I just switched to Wave. I couldn't handle a part time job making sure their patches worked.

scottalanmiller

@stacksofplates said in Installing Frappe ERPNext on CentOS 7:

@scottalanmiller said in Installing Frappe ERPNext on CentOS 7:

Yes, very easily this is a new update that has broken ERPNext.

I was really only using the accounting, so I just switched to Wave. I couldn't handle a part time job making sure their patches worked.

We trialed it and decided not to use it. So after getting it up and running with the script, we've not run it since.

Emad R

Hi,

I think the guide needs additional steps:

before :
python install.py --develop --user frappe

perhaps add:
systemctl start mariadb
systemctl enable mariadb
mysql_secure_installation

So we can use the root password of mysql when we run the installation script

Also the below needs to be run from the user frappe, so you will need to exit if you are logged in as root, then login as frappe. (you can change the password for this user using passwd frappe)

cd /home/frappe/frappe-bench
bench new-site mysite
bench get-app erpnext https://github.com/frappe/erpnext
bench --site mysite install-app erpnext
bench start &

travisdh1

@msff-amman-Itofficer said in Installing Frappe ERPNext on CentOS 7:

perhaps add:
systemctl start mariadb
systemctl enable mariadb
mysql_secure_installation

So we can use the root password of mysql when we run the installation script

Shouldn't ever use the root password for an app. The app is storing that password in plain text somewhere on the system. Instead, create a database and give a new user permission to that database.

SQL Script to create a new database, user, and assign permissions for the database to the user. Replace the agoodpassword with a good password, and save it as something like ~/erpnextdbcreate.sql

CREATE DATABASE erpnext;
CREATE USER 'erpuser'@'localhost' IDENTIFIED BY 'agoodpassword';
GRANT ALL PRIVILEGES ON 'erpnext' . * TO 'erpuser'@'localhost';

Then after running mysql_secure_installation,

mysql -u root -p >> ~/erpnextdbcreate.sql

scottalanmiller

Only matters a little when you are talking about a system with only one database. Limited access, full access... same thing.

JaredBusch

@travisdh1 making a sql file is a pain in the ass.

Look at my Nextcloud 11 guide for the simpler way to handle that and securing mariadb.