in , ,

Install Odoo 15 The OpenERP On Ubuntu 20.04LTS… Quick Start Guide

Install Odoo 15 On Ubuntu 20.04LTS

In this lab we'll try to install Odoo 15 the OpenERP on Ubuntu 20.04 LTS, Odoo is a Python-based ERP application, so we will go to use Virtualenv, and we will

  1. Update Ubuntu
  2. Install Python, PIP
  3. Install PostgreSQL Database
  4. Install And Configure Odoo 15
  5. Use Nginx As A Reverse Proxy

Step1: Update Ubuntu

# apt update
# apt upgrade

Step2: Install Python PIP And Prerequests

Installing Python and PIP

# apt install python3 python-is-python3 python3-dev pip

Installing Requirement Packages

# apt install net-tools git wget build-essential python3-wheel python3-suds python3-all-dev python3-venv \
python3-setuptools python3-tk libxml2-dev node-less libzip-dev libpq-dev libxslt1-dev libevent-dev \
libsasl2-dev libldap2-dev pkg-config libtiff5-dev libjpeg8-dev libjpeg-dev \
zlib1g-dev libfreetype6-dev liblcms2-dev liblcms2-utils libwebp-dev tcl8.6-dev \
tk8.6-dev libyaml-dev fontconfig xfonts-75dpi xfonts-base xfonts-encodings xfonts-utils libopenjp2-7-dev libharfbuzz-dev libfribidi-dev libxcb1-dev

Installing wk-html-to-pdf Tool

Wkhtmltopdf tool is a command-line utility to convert HTML to PDF or image using WebKit

# apt install wkhtmltopdf

Step3: Install And Configure PostgreSQL Database

Install and Enable Database

# apt install postgresql
# systemctl enable postgresql

Create The Database User

We need to create the database user  odoo , so we will use the sudo command to create a database user and password but run the command as the postgres

# sudo -u postgres createuser odoo -U postgres -dP

Step4: Add Odoo System User

Adding the new system user  odoo  and set its password, as the following

# adduser --system --home=/opt/odoo --group odoo

Step5: Install Odoo 15

Cloning Odoo 15 from Github

# git clone https://www.github.com/odoo/odoo --depth 1 --branch 15.0 /opt/odoo

Go to the odoo system user home directory, and create our odoovenv virtual environment, as it's highly recommended to isolate Odoo to avoid any conflicts that may occur.

# cd /opt/odoo
# python -m venv odoovenv

Active odoovenv Odoo Virtualenv and install Python wheel

# source odoovenv/bin/activate
# pip install wheel

Install Odoo dependencies and requirements

# pip install -r requirements.txt

Deactivate the odoovenv

# deactivate

Create a custom Odoo addons directory

# mkdir odoo-extras-addons

Create an Odoo configuration template file with the following options, and set the database user and password we created in Step3 as the following

# vim /etc/odoo.conf

[options]
admin_passwd = set_odoo_admin_gui_password
db_host = False
db_port = False
db_user = odoo
db_password = odoo_db_password
addons_path = /opt/odoo/addons,/opt/odoo/odoo-extras-addons

Create Odoo Systemd Unit

# vim /etc/systemd/system/odoo.service

[Unit]
Description=Odoo 15 Server
Requires=postgresql.service
After=network.target postgresql.service

[Service]
Type=simple
SyslogIdentifier=odoo-server
PermissionsStartOnly=true
User=odoo
Group=odoo
ExecStart=/opt/odoo/odoovenv/bin/python3 /opt/odoo/odoo-bin -c /etc/odoo.conf
StandardOutput=journal+console

[Install]
WantedBy=multi-user.target

Adjustment files permissions

We need to change the ownership and files permissions of the  odoo  home directory

# chown -R odoo.odoo /opt/odoo
# chmod -R 2755 /opt/odoo

If you are not a root while creating the systemd unit file, you will need to change the odoo.service file owner and permission.

Remember: You need to use sudo if you are not currently the root.

# chown root: /etc/systemd/system/odoo.service
# chmod 755 /etc/systemd/system/odoo.service

Start The Odoo server and check the status

# systemctl daemon-reload
# systemctl enable --now odoo
# systemctl status odoo
# netstat -puntl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 0.0.0.0:8069            0.0.0.0:*               LISTEN      59377/python3
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      499/systemd-resolve
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      685/sshd: /usr/sbin
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      56638/postgres
tcp        0      0 127.0.0.1:6010          0.0.0.0:*               LISTEN      791/sshd: root@pts/
tcp6       0      0 :::22                   :::*                    LISTEN      685/sshd: /usr/sbin
tcp6       0      0 ::1:5432                :::*                    LISTEN      56638/postgres

You can see the Odoo server running and listening to port 8069, and PostgreSQL running and listening to port 5432 at localhost.

Now you can browse and access your Odoo using http://[Server_IP_Address]:8069, and continue the setup process by filling up the required information, and clicking the Demo data box if you want to test the system

accessig odoo server

 

Step6: Install And Configure Nginx As A Reverse Proxy

Install And Enable Nginx

# apt install nginx
# systemctl enable nginx

Configure Nginx As A Reverse Proxy

Create the file odoo.conf at the path vim /etc/nginx/sites-available/odoo.conf, then append the following configuration into it.

PS: Do not forget to replace the domain name, and the IP-Address below with your server public IP-Address

# vim /etc/nginx/sites-available/odoo.conf

# Define Your Server To Listen To Your Plubic IP ADDRESS && HTTP Port 80
# Do not forget to replace Server Public IP-Address and domain name with yours.
# If you want to redirect www to non-www domain, uncomment the next server block.
#server {
#  listen      212.71.255.25:80;
#  server_name www.odoo-lab.com;
#  access_log off;
#  return 301 http://odoo-lab.com$request_uri;
#}
server {
  listen      212.71.255.25:80;
  server_name odoo-lab.com;

  # We capture the logs
  access_log /var/log/nginx/odoo-lab.com.log;

  # Adjustment Headers
  # Uncomment the next header if  you are using Validation Certification To Force using it and setting up ssl cache age.
  #add_header Strict-Transport-Security "max-age=63072000; includeSubDomains; preload";
  add_header X-Frame-Options SAMEORIGIN;
  add_header X-Content-Type-Options nosniff;
  add_header Access-Control-Allow-Origin *;
  add_header Access-Control-Allow-Credentials true;


  #Enable and configure GZIP
  gzip on;
  gzip_static on;
  gzip_comp_level    9;
  gzip_min_length    256;
  gzip_proxied       any;
  gzip_vary          on;
  gzip_buffers           16 8k;
  gzip_http_version  1.1;
  proxy_http_version 1.1;
  gzip_types
    application/atom+xml
    application/javascript
    application/x-javascript
    application/json
    application/ld+json
    application/manifest+json
    application/rss+xml
    application/vnd.geo+json
    application/vnd.ms-fontobject
    application/x-font-ttf
    application/ttf
    application/x-ttf
    application/font-woff
    application/x-font-opentype
    application/x-web-app-manifest+json
    application/xhtml+xml
    application/xml
    font/opentype
    font/ttf
    font/x-woff
    image/bmp
    image/svg+xml
    image/x-icon
    text/cache-manifest
    text/css
    text/javascript
    text/plain
    text/vcard
    text/vnd.rim.location.xloc
    text/vtt
    text/x-component
    text/x-cross-domain-policy;
    # text/html is always compressed by gzip module

  # To allow POST on static pages
  error_page 405 =200 $uri$is_args$args;
  location / {
    # Pass Every request to Odoo at the Port 8069
    proxy_pass                         http://212.71.255.25:869;
    # Adjustement reverse proxy headers.
    proxy_read_timeout                 640;
    proxy_connect_timeout              640;
    proxy_redirect                     off;
    proxy_set_header Host              $host;
    proxy_set_header X-Real-IP         $remote_addr;
    proxy_set_header X-Forwarded-For   $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Proto http;
    proxy_set_header X-Forwarded-Port  80;
    proxy_buffers                      16 32k;
    proxy_buffer_size                  64k;
    proxy_request_buffering off;
    proxy_buffering off;
  }
# Enable Caching Static files...
  location ~*  \.(jpg|jpeg|png|gif|ico|css|js|pdf|ttf|woff|eot|bz2|gz|woff2|svg|bmp)$ {

                proxy_pass                         http://212.71.255.25:8069;
                proxy_read_timeout                 640;
                proxy_connect_timeout              640;
                proxy_redirect                     off;

                proxy_set_header Host              $host;
                proxy_set_header X-Real-IP         $remote_addr;
                proxy_set_header X-Forwarded-For   $proxy_add_x_forwarded_for;
                proxy_set_header X-Forwarded-Proto http;
                proxy_set_header X-Forwarded-Port  80;
                proxy_buffers                      32 64k;
                proxy_buffer_size                  128k;
                proxy_request_buffering off;
                proxy_buffering off;
                access_log off;
                log_not_found on;
                # Extend Browsers Caching Time for static file
                expires 60d;
    }


}

Create a symbolic link for the nginx odoo.conf file into the site-enabled directory as the following

# cd /etc/nginx/sites-enabled/
# ln -s /etc/nginx/sites-available/odoo.conf ./

Check the Nginx configuration file, then restart if OK.

# nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
# systemctl restart nginx

You can access your Odoo using http://odoo-lab.com or your server public IP-Address.

To enable SSL access to your Odoo server, you will need to modify the Nginx config file as the one here: https://github.com/linuxlabz/wordpress-debian/blob/main/yourdomain_https.conf its enable SSL, and the file is similar lab and example we created in this article.

And you can create your self signed SSL in simple steps as described here: How to generate your self-signed SSL certificate in 3 Steps for Linux, Or you can create your validate SSL Certificate using Let's Encrypt

What do you think?

Leave a Reply

Your email address will not be published.

Arch Linux logo

Install WordPress On Arch Linux VPS… Quick Start Guide

Install TensorFlow 2.8.0 on ubuntu 20.04 LTS

How To Install Python TensorFlow 2.8.0 GPU On Ubuntu 20.04 LTS