{"id":13820,"date":"2019-04-06T09:50:38","date_gmt":"2019-04-06T09:50:38","guid":{"rendered":"http:\/\/www.appservgrid.com\/paw92\/?p=13820"},"modified":"2019-04-06T09:50:38","modified_gmt":"2019-04-06T09:50:38","slug":"setting-up-openerp-odoo-9-with-nginx-on-rhel-centos-and-debian-ubuntu","status":"publish","type":"post","link":"https:\/\/www.appservgrid.com\/paw92\/index.php\/2019\/04\/06\/setting-up-openerp-odoo-9-with-nginx-on-rhel-centos-and-debian-ubuntu\/","title":{"rendered":"Setting Up OpenERP (Odoo) 9 with Nginx on RHEL\/CentOS and Debian\/Ubuntu"},"content":{"rendered":"

Odoo<\/strong>, formerly known as\u00a0OpenERP<\/strong>, is an\u00a0Open Source Enterprise Resource Planning<\/strong>\u00a0ERP web based business software written in Python which comes with a suite of web apps designed for every business, such as Website Builders, eCommerce modules, Billing and Accounting, Human Resources, Point of Sale, Customer Relationship Management, Inventory module, Live Chat and many other apps and features.<\/p>\n

This tutorial will guide you on you how to install the latest stable version of\u00a0Odoo<\/strong>\u00a0(version\u00a09<\/strong>) on a\u00a0RHEL\/CentOS\/Fedora<\/strong>\u00a0or\u00a0Debian\/Ubuntu<\/strong>\u00a0based systems with\u00a0Nginx<\/strong>\u00a0server to act as a reverse proxy in frontend in order to access the web interface faster, securely and from standard web browsing ports, without the need to burden the users to use browser redirect ports.<\/p>\n

Step 1: Install and Secure PostgreSQL Database<\/h3>\n

1.<\/strong>\u00a0Before you start proceeding with\u00a0Odoo<\/strong>\u00a0installation first assure that your system ships with packages provided by\u00a0Epel repositories<\/a>\u00a0in order to install the backend\u00a0PostgreSQL<\/strong>\u00a0database.<\/p>\n

Also make sure the server is up-to-date with the latest security packages and patches by issuing the below commands:<\/p>\n

----------- On RedHat\/CentOS based systems<\/strong> ----------- \r\n# yum update\r\n# yum install -y epel-release\r\n\r\n----------- On Debian\/Ubuntu based systems<\/strong> ----------- \r\n# apt-get update && sudo apt-get upgrade # On Debian \r\n<\/pre>\n
2.<\/strong>\u00a0Next, go ahead and install\u00a0PostgreSQL<\/strong>\u00a0database server, which is the default database used by\u00a0Odoo<\/strong>\u00a0to store information.<\/p>\n
----------- On RedHat\/CentOS based systems<\/strong> -----------\r\n# yum install postgresql-server\r\n\r\n----------- On Debian\/Ubuntu based systems<\/strong> -----------\r\n# apt-get install postgresql postgresql-client\r\n<\/pre>\n
Initialize\u00a0PostgreSQL<\/strong>\u00a0database.<\/p>\n
# postgresql-setup initdb\t\r\n<\/pre>\n
Now finally start the\u00a0PostgreSQL<\/strong>\u00a0database by issuing the below command:<\/p>\n
----------- On SystemD systems<\/strong> -----------\r\n# systemctl start postgresql\r\n\r\n----------- On SysVinit systems<\/strong> -----------\r\n# service postgresql start\r\n<\/pre>\n
As an additional step to secure\u00a0PostgreSQL<\/strong>\u00a0default user, which has a blank password, issue the below command with root privileges in order to change the password:<\/p>\n
sudo -u postgres psql\r\npostgres=# \\password postgres\r\n<\/pre>\n
Step 2: Install Odoo 9 \u2013 OpenERP<\/h3>\n
3.<\/strong>\u00a0In order to install\u00a0Odoo 9<\/strong>\u00a0from official repository, first\u00a0create new yum repository<\/a>\u00a0file for Odoo with the following content:<\/p>\n
On CentOS\/RHEL Systems<\/h4>\n
# vi \/etc\/yum.repos.d\/odoo.repo\r\n<\/pre>\n
Add the following excerpt to file\u00a0odoo.repo<\/code>.<\/p>\n
[odoo-nightly]\r\nname=Odoo Nightly repository\r\nbaseurl=http:\/\/nightly.odoo.com\/9.0\/nightly\/rpm\/\r\nenabled=1\r\ngpgcheck=1\r\ngpgkey=https:\/\/nightly.odoo.com\/odoo.key\r\n<\/pre>\n
On Debian\/Ubuntu Systems<\/h4>\n
On\u00a0Debian\/Ubuntu<\/strong>\u00a0issue the following command to add the\u00a0Odoo<\/strong>\u00a0repositories:<\/p>\n
# wget -O - https:\/\/nightly.odoo.com\/odoo.key | apt-key add -\r\n# echo \"deb http:\/\/nightly.odoo.com\/9.0\/nightly\/deb\/ .\/\" >> \/etc\/apt\/sources.list\r\n<\/pre>\n
4.<\/strong>\u00a0Next install\u00a0Odoo 9<\/strong>\u00a0software from binaries.<\/p>\n
----------- On RedHat\/CentOS based systems<\/strong> -----------\r\n# yum install odoo\r\n\r\n----------- On Debian\/Ubuntu based systems<\/strong> -----------\r\n# apt-get update && sudo apt-get install odoo\r\n<\/pre>\n
Next, start it and check daemon status by issuing the below commands:<\/p>\n
----------- On SystemD systems<\/strong> -----------\r\n# systemctl start odoo\r\n# systemctl status odoo\r\n\r\n----------- On SysVinit systems<\/strong> -----------\r\n# service odoo start\r\n# service odoo status\r\n<\/pre>\n
As an additional step you can verify\u00a0Odoo<\/strong>\u00a0service listening port by running the\u00a0ss<\/strong>\u00a0or\u00a0netstat<\/a>\u00a0command:<\/p>\n
# ss -tulpn\r\nOR\r\n# netstat -tulpn\r\n<\/pre>\n
By default, Odoo listens for network connections on port\u00a08069\/TCP<\/strong>.<\/p>\n
Step 3: Configure Odoo from Web Interface<\/h3>\n
5.<\/strong>\u00a0In order to configure Odoo further fire-up a browser and access Odoo web interface at the following URI:<\/p>\n
http:\/\/host-or-IP-address:8069\/\r\n<\/pre>\n
6.<\/strong>\u00a0Next you will be prompted to create a new database for Odoo and set a strong password for admin account.<\/p>\n
\n
\"Create<\/a><\/p>\n
Create Odoo Database<\/p>\n<\/div>\n
7.<\/strong>\u00a0Once the database has been created you will be redirected to the administration web panel where you can further install applications and configure your ERP. For the moment leave the application as default and log out.<\/p>\n
\n
\"Odoo<\/a><\/p>\n
Odoo Administrative Web Panel<\/p>\n<\/div>\n
8.<\/strong>\u00a0Once returned at the login screen, hit on\u00a0Manage Databases<\/strong>\u00a0link and Set a master password in order to secure Odoo database manager.<\/p>\n
\n
\"Odoo<\/a><\/p>\n
Odoo Manage Databases<\/p>\n<\/div>\n
\n
\"Set<\/a><\/p>\n
Set Odoo Database Manager Password<\/p>\n<\/div>\n
\n
\"Set<\/a><\/p>\n
Set New Odoo Manager Password<\/p>\n<\/div>\n
9.<\/strong>\u00a0Once you have secured Odoo database manager you can login on your application and start to configure it further with your required apps and settings.<\/p>\n
\n
\"Install<\/a><\/p>\n
Install Configure Odoo Applications<\/p>\n<\/div>\n
Step 4: Access Odoo from Nginx Frontend<\/h3>\n
You can configure the system so that users can access Odoo web panel via Nginx reverse proxy. This can facilitate the users to navigate Odoo web interface faster, due to some Nginx frontend caching, on standard HTTP ports without the need to manually enter the\u00a0http<\/strong>\u00a0port\u00a08069<\/strong>\u00a0on their browsers.<\/p>\n
In order to configure this setting first you need to install and configure\u00a0Nginx<\/strong>\u00a0on your system by issuing the following steps.<\/p>\n
10.<\/strong>\u00a0First install\u00a0Nginx<\/strong>\u00a0web server with the following command:<\/p>\n
----------- On RedHat\/CentOS based systems<\/strong> -----------\r\n# yum install nginx\r\n\r\n----------- On Debian\/Ubuntu based systems<\/strong> -----------\r\n# apt-get install nginx\r\n<\/pre>\n
11.<\/strong>\u00a0Next, open Nginx main configuration file with a text editor and insert the following block after the line which specifies Nginx document root location.<\/p>\n
----------- On RedHat\/CentOS based systems<\/strong> -----------\r\n# vi \/etc\/nginx\/nginx.conf \r\n\r\n----------- On Debian\/Ubuntu based systems<\/strong> -----------\r\n# nano \/etc\/nginx\/sites-enabled\/default\r\n<\/pre>\n
Add the following configuration excerpt to\u00a0nginx.conf<\/code>\u00a0file:<\/p>\n
 location \/ {\r\n        proxy_pass http:\/\/127.0.0.1:8069;\r\n        proxy_redirect off;\r\n        proxy_set_header Host $host;\r\n        proxy_set_header X-Real-IP $remote_addr;\r\n        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;\r\n        proxy_set_header X-Forwarded-Proto $scheme;\r\n<\/pre>\n
Also, comment Nginx\u00a0location<\/code>\u00a0statement by placing a\u00a0#<\/strong>\u00a0in front of the following lines. Use the below screenshot as a guide.<\/p>\n
#location \/ {\r\n                # First attempt to serve request as file, then\r\n                # as directory, then fall back to displaying a 404.\r\n        #       try_files $uri $uri\/ =404;\r\n        #}\r\n<\/pre>\n
\n
\"Configure<\/a><\/p>\n
Configure Nginx for Odoo Reverse Proxy<\/p>\n<\/div>\n
12.<\/strong>\u00a0After you\u2019ve made all the above changes, restart\u00a0Nginx<\/strong>\u00a0daemon but not before you run\u00a0getenforce<\/code>command to check if Selinux in enabled on your machine.<\/p>\n
On CentOS\/RHEL Systems<\/h4>\n
In case the policy is set to\u00a0Enforced<\/code>\u00a0disable it by issuing the below commands:<\/p>\n
# setenforce 0\r\n# getenforce\r\n<\/pre>\n
To completely disable Selinux, open\u00a0\/etc\/selinux\/config<\/code>\u00a0file with a text editor and set the line SELINUX to disabled.<\/p>\n
\n
\"Disable<\/a><\/p>\n
Disable SELinux in CentOS and RHEL<\/p>\n<\/div>\n
If you don\u2019t want to completely disable Seliux policy and just want to relax the rules in order to grant Nginx proxy with permissive access to network socket run the following command:<\/p>\n
# setsebool httpd_can_network_connect on -P\r\n# getsebool -a | grep httpd \r\n<\/pre>\n
Then, restart Nginx daemon to reflect the changes made above:<\/p>\n
# systemctl restart nginx\r\nOR\r\n# service nginx restart\r\n<\/pre>\n
13.<\/strong>\u00a0This next step is a security optional feature and implies the change of the network socket that\u00a0Odoo<\/strong>application is listening, changing the binding address from all interfaces (or address) to localhost only.<\/p>\n
This change must be done only in conjunction with Nginx reverse proxy due to the fact that binding the application on localhost only implies that Odoo will not be accessible from users inside the LAN or other networks.<\/p>\n
In order to active this change, open\u00a0\/etc\/odoo\/openerp-server.conf<\/code>\u00a0file and edit\u00a0xmlrpc_interface<\/code>line to bind on localhost only as suggested on the below screenshot.<\/p>\n
xmlrpc_interface = 127.0.0.1\r\n<\/pre>\n
\n
\"Configure<\/a><\/p>\n
Configure Odoo Interface<\/p>\n<\/div>\n
In order to reflect changes restart Odoo service by running the below command:<\/p>\n
# systemctl restart odoo.service\r\nOR\r\n# service odoo restart\r\n<\/pre>\n
14.<\/strong>\u00a0In case your machine has a network defense line provided by the firewall, issue the following commands in order to open firewall ports to outside world for Nginx proxy:<\/p>\n
----------- On FirewallD based systems<\/strong> -----------\r\n# firewall-cmd --add-service=http --permanent\r\n# firewall-cmd --reload\r\n<\/pre>\n
----------- On IPTables based systems<\/strong> -----------\r\n# iptables -A INPUT -p tcp -m tcp --sport 80 -j ACCEPT\r\n# iptables -A OUTPUT -p tcp -m tcp --dport 80 -j ACCEPT\r\n# \/etc\/init.d\/iptables save\r\n<\/pre>\n
----------- On UFW Firewall systems<\/strong> -----------\r\n# ufw allow http\r\n<\/pre>\n
15.<\/strong>\u00a0That\u2019s it! Now you can successfully access your ERP Odoo application by visiting your server IP Address or domain name.<\/p>\n
http:\/\/192.168.1.40\r\nhttp:\/\/domain.tld\r\n<\/pre>\n
\n
\"Odoo<\/a><\/p>\n
Odoo Web Interface<\/p>\n<\/div>\n
16.<\/strong>\u00a0In order to automatically run the services after a system reboot issue the following command to enable all the daemons system-wide with one-shot.<\/p>\n
------------ On SystemD Systems<\/strong> ------------  \r\n# systemctl enable postgresql.service \r\n# systemctl enable odoo.service\r\n# systemctl enable nginx.service\r\n<\/pre>\n
------------ On SysVinit Systems<\/strong> ------------ \r\n\r\n# chkconfig postgresql on\r\n# chkconfig odoo on\r\n# chkconfig nginx on\r\n<\/pre>\n
NOTE<\/strong>: For PDF reports, you must manually download and install wkhtmltopdf binary packages for your own distribution by visiting the following link\u00a0Install wkhtmltopdf to Convert HTML Page to PDF<\/a>.<\/p>\n
Source<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Odoo, formerly known as\u00a0OpenERP, is an\u00a0Open Source Enterprise Resource Planning\u00a0ERP web based business software written in Python which comes with a suite of web apps designed for every business, such as Website Builders, eCommerce modules, Billing and Accounting, Human Resources, Point of Sale, Customer Relationship Management, Inventory module, Live Chat and many other apps and … <\/p>\n
Continue reading “Setting Up OpenERP (Odoo) 9 with Nginx on RHEL\/CentOS and Debian\/Ubuntu”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-13820","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/comments?post=13820"}],"version-history":[{"count":1,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13820\/revisions"}],"predecessor-version":[{"id":13821,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/posts\/13820\/revisions\/13821"}],"wp:attachment":[{"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/media?parent=13820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/categories?post=13820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.appservgrid.com\/paw92\/index.php\/wp-json\/wp\/v2\/tags?post=13820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}