Learn how To Setup Odoo With PostgreSQL On Centos 7 step by step. If you are one of the persons who prefer to use one tool instead of several, or you shop from one big store to prevent walk-in many stores Odoo has been designed for your taste. So, anytime you needed a VPS, remember to visit Eldernode to buy your considered perfect CentOS VPS to help you stop searching for the best packages because we claim to provide you the best!
What is Odoo?
Former OpenERP, Odoo is a business management platform. You can find some different applications, such as accounting, billing, project management, inventory, and much more in it. This free and open-source ERP is a web-based application with so many features that is a necessity of any job which is related to Point of Sales, Billing, and Accounting, Event Management, Email Marketing, Order Tracking, etc
Tutorial Setup Odoo With PostgreSQL On Centos 7
In the following open-source apps tutorials, in this guide, you will learn about Odoo. So, let’s go through the steps of this article to finish it and start using this unique framework.
How To Install Odoo 12 on CentOS
As a community developer, you need to use an app that is top-notch usability that scales across all apps. Before executing the commands of this tutorial, please consider using the root user.
Step 1: Update System
To update the system, run:
You will face the question of updating, so type ”y” and wait for some time to update your system.
Step 2: Configure Repositories
You need to configure the needed Repositories, so use the command below to enable the Epel repository:
yum install epel-release
Then, type the following command to enable the Software Collections (SCL) repository:
yum install centos-release-scl
Step 3: Install Python 3.6 And Dependencies
To install Python 36, run:
yum install rh-python36
And to install needed dependencies, type:
yum install bzip2-devel freetype-devel nodejs-less libxslt-devel openldap-devel libjpeg-devel gcc
Step 4: Create Odoo User
It is time to create your Odoo user, so run:
useradd -m -U -r -d /opt/odoo -s /bin/bash odoousr
Step 5: Install And Configure PostgreSQL
You are recommended to check repositories from the official site and install the Postgres repository for Centos 7 64bit.
rpm -Uvh https://yum.postgresql.org/11/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
Then, you are ready to install the PostgreSQL 11 server:
yum install postgresql11-server
Next, to create a data directory and other configuration files on the system, you can initialize the database by running:
And to check PostgreSQL Service Status, type:
systemctl status postgresql-11.service
In case you faced the system not starting, use the command below to start it:
systemctl start postgresql-11.service
And to enable service on the system boot. run:
systemctl enable postgresql-11.service
Now, you can check and Verify PostgreSQL Installation:
su - postgres -c "psql"
If you prefer, you can create a password:
Then, you should create a PostgreSQL user:
su - postgres -c "createuser -s odoousr"
Step 6: Install Wkhtmltopdf
Odoo needs an open-source tool to use for making HTML in PDF formats so that it can print PDF reports.
Install “wget” if it is not available.
yum install wget -y
Run the following command to install the downloaded package:
yum localinstall wkhtmltox-0.12.5-1.centos7.x86_64.rpm
Step 7: Install And Configure Odoo 12
First, you need to install Git on your system:
yum install git -y
Second, change the user to Odoo user:
su - odoousr
Third, you need to clone Odoo 12 from its repository. So, download it to the “/opt/odoo/odoo12” directory.
git clone https://www.github.com/odoo/odoo --depth 1 --branch 12.0 /opt/odoo/odoo12
Fourth, enable python36:
scl enable rh-python36 bash
Step 8: How To Create A New Virtual Environment
Use the command below to go to Odoo directory:
And Create an environment:
python3 -m venv odoo12-venv
To activate the environment, type:
Then, you should upgrade pip:
pip install --upgrade pip
Next, install the Wheel library, followed by all the required Python modules.
pip3 install wheel
pip3 install -r odoo12/requirements.txt
Once the installation is complete, deactivate the virtual environment and return to the root user.
Step 9: Other Configurations For Odoo12
First, create a directory for custom modules:
chown odoousr: /opt/odoo/odoo12-custom-addons
Second, create a configuration file for the Odoo12:
By any editors you prefer, you can install vim if it is not available:
yum install vim
Add the following lines to the file:
[options] ; This is the password that allows database operations: admin_passwd = [email protected]<?Linux db_host = False db_port = False db_user = odoousr db_password = False addons_path = /opt/odoo/odoo12/addons,/opt/odoo/odoo12-custom-addons logfile = /var/log/odoo12/odoo.log
Now, you can save and exit the file. Then you should create a log folder and grant permission to it:
mkdir -p /var/log/odoo12
chown -R odoousr: /var/log/odoo12
Step 10: How To Start Odoo12 Manually
In this step, you can start the service and check whether it is working correctly. To do this you need to change the user and then start the command:
su - odoousr
/usr/bin/scl enable rh-python36 -- /opt/odoo/odoo12-venv/bin/python3 /opt/odoo/odoo12/odoo-bin -c /etc/odoo12.conf
Then, try to check Odoo12 port is up and running and open another terminal and by typing:
netstat -tunlp | grep 8069
Step 11: How To Configure firewall
Use the following command to check firewall status:
systemctl status firewalld
Run the command below to start the service if you found it is not started yet:
systemctl start firewalld
To add firewall rules and reload firewall type:
firewall-cmd --zone=public --permanent --add-service=http
firewall-cmd --zone=public --permanent --add-port=8069/tcp
systemctl reload firewalld
Step 12: How To Browse Application
http://Ip or domain name:8069
The Start page would display:
Also, you can change the Selinux mode temporarily if you face the “Service Unavailable” message.
Step 13: Configure Odoo12 run As A Service
And in this step, you need to create a systemd file and add the following content to the file:
[Unit] Description=Odoo12 Requires=postgresql-11.service After=network.target postgresql-11.service [Service] Type=simple SyslogIdentifier=odoo12 PermissionsStartOnly=true User=odoousr Group=odoousr ExecStart=/usr/bin/scl enable rh-python36 -- /opt/odoo/odoo12-venv/bin/python3 /opt/odoo/odoo12/odoo-bin -c /etc/odoo12.conf StandardOutput=journal+console [Install] WantedBy=multi-user.target
Now. you can save, and exit.
Use the following command to reload systemctl daemon.
Step 14: How To Stop Previously Started Odoo12
To check the process, run:
ps -aux | grep odoo
Odoo ProcessKill process.
kill -9 28416 28417 28420
Note: Do not forget to replace process IDs with yours.
Step 15: How To Start Odoo12 Service
systemctl start odoo12
To check status, run:
systemctl status odoo12
Use the command below to monitor the log file:
tail -f /var/log/odoo12/odoo.log
And then, check the status and enable Odoo service on system boot:
systemctl enable odoo12
Step 16: How To Browse The Website And Continue
http://Ip Or Domain name:8069
Once you view the below page, you must add a Master password, database name, and other details.
Then to be redirected to the welcome page, you should click the “create database”
Once you sign out from the above page, you will go to the login page.
That’s that! By reaching here, you have completed the installation.
In this article, you learned How To setup Odoo With PostgreSQL On Centos 7. From now on, you can use and enjoy this software for billing, accounting, project management, manufacturing, warehouse, and inventory apps.