Learn how to – How To Install Odoo 15 on Ubuntu 22.04/20.04/18.04.
Odoo is an open source suite of web based business applications managed from a single console. There is a range of business applications available on Odoo which includes Open Source CRM, Website Builder, eCommerce, Warehouse Management, Project Management, Billing & Accounting, Point of Sale, Human Resources, Marketing, Manufacturing, Purchase Management, among others. In this article we will dive into the installation and configuration of Odoo 15 on Ubuntu Linux with Let’s Encrypt SSL Certificates.
Odoo business applications can be installed and used as stand-alone applications, but they also integrate seamlessly so you get a full-featured Open Source ERP when you install several Apps. This guide will also cover how you configure Nginx Proxy with Let’s Encrypt SSL certificate but any other custom SSL certificate, self-signed or signed by a known CA can be used.
Step 1: Update Ubuntu system
We always begin our installations with system update and upgrade of all installed packages.
sudo apt update
sudo apt upgrade -yWait for all packages to be updated then reboot the system. This is necessary when there are kernel updates.
[ -f /var/run/reboot-required ] && sudo reboot -fStep 2: Install PostgreSQL Database Server
Odoo requires a database server where data is stored. We will install the default version of PostgreSQL server available on Ubuntu upstream repositories.
To install the default version available in Ubuntu repositories. run:
sudo apt install postgresql postgresql-client -yAfter installation the database service is started.
$ systemctl status postgresql*
● postgresql@12-main.service - PostgreSQL Cluster 12-main
Loaded: loaded (/lib/systemd/system/postgresql@.service; enabled-runtime; vendor preset: enabled)
Active: active (running) since Fri 2020-11-06 10:34:45 CET; 1min 6s ago
Main PID: 2177 (postgres)
Tasks: 7 (limit: 2286)
Memory: 18.0M
CGroup: /system.slice/system-postgresql.slice/postgresql@12-main.service
├─2177 /usr/lib/postgresql/12/bin/postgres -D /var/lib/postgresql/12/main -c config_file=/etc/postgresql/12/main/postgresql.conf
├─2179 postgres: 12/main: checkpointer
├─2180 postgres: 12/main: background writer
├─2181 postgres: 12/main: walwriter
├─2182 postgres: 12/main: autovacuum launcher
├─2183 postgres: 12/main: stats collector
└─2184 postgres: 12/main: logical replication launcher
Nov 06 10:34:43 ubuntu systemd[1]: Starting PostgreSQL Cluster 12-main...
Nov 06 10:34:45 ubuntu systemd[1]: Started PostgreSQL Cluster 12-main.
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2020-11-06 10:34:40 CET; 1min 11s ago
Main PID: 1911 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 2286)
Memory: 0B
CGroup: /system.slice/postgresql.service
Nov 06 10:34:40 ubuntu systemd[1]: Starting PostgreSQL RDBMS...
Nov 06 10:34:40 ubuntu systemd[1]: Finished PostgreSQL RDBMS.
Step 3: Install wkhtmltopdf on Ubuntu
wkhtmltopdf is required for printing reports as it does the conversion of html to pdf. The version of wkhtmltopdf available in Ubuntu repositories does not support headers and footers so it is not used as a direct dependency.
Step 4: Install Odoo 15 on Ubuntu 22.04/20.04/18.04
Import APT repo GPG key
curl -fsSL https://nightly.odoo.com/odoo.key|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/odoo.gpgAdd Odoo deb repository so that you can install Odoo 15 on Ubuntu Linux system.
echo "deb http://nightly.odoo.com/15.0/nightly/deb/ ./" | sudo tee /etc/apt/sources.list.d/odoo.list
Update Apt cache and install Odoo 15 on Ubuntu system.
sudo apt update
sudo apt install odooAgree to start installation:
The following NEW packages will be installed:
docutils-common fonts-font-awesome fonts-inconsolata fonts-roboto-unhinted graphviz libann0 libcairo2 libcdt5 libcgraph6 libdatrie1 libgd3 libgraphite2-3
libgts-0.7-5 libgvc6 libgvpr2 libharfbuzz0b libice6 libimagequant0 libjbig0 libjpeg8 libjs-jquery libjs-underscore liblab-gamut1 liblcms2-2 libpango-1.0-0
libpangocairo-1.0-0 libpangoft2-1.0-0 libpathplan4 libpixman-1-0 libsass1 libsm6 libthai-data libthai0 libtiff5 libwebp6 libwebpdemux2 libwebpmux3 libxaw7
libxcb-render0 libxcb-shm0 libxmu6 libxpm4 libxt6 odoo python-babel-localedata python3-aiohttp python3-appdirs python3-async-timeout python3-babel python3-bs4
python3-cached-property python3-dateutil python3-decorator python3-defusedxml python3-docutils python3-feedparser python3-freezegun python3-gevent
python3-greenlet python3-html2text python3-isodate python3-libsass python3-lxml python3-mako python3-mock python3-multidict python3-ofxparse python3-passlib
python3-pbr python3-pil python3-polib python3-psutil python3-psycopg2 python3-pydot python3-pyparsing python3-pypdf2 python3-qrcode python3-reportlab
python3-reportlab-accel python3-requests-toolbelt python3-roman python3-soupsieve python3-stdnum python3-suds python3-tz python3-usb python3-vobject
python3-werkzeug python3-xlrd python3-xlsxwriter python3-xlwt python3-yarl python3-zeep sgml-base xml-core
0 upgraded, 95 newly installed, 0 to remove and 0 not upgraded.
Need to get 87.3 MB of archives.
After this operation, 665 MB of additional disk space will be used.
Do you want to continue? [Y/n] yThe service is started automatically after the installation of Odoo on Ubuntu:
$ systemctl status odoo
● odoo.service - Odoo Open Source ERP and CRM
Loaded: loaded (/lib/systemd/system/odoo.service; enabled; vendor preset: enabled)
Active: active (running) since Fri 2020-11-06 10:50:50 CET; 11min ago
Main PID: 9090 (odoo)
Tasks: 4 (limit: 2286)
Memory: 68.9M
CGroup: /system.slice/odoo.service
└─9090 /usr/bin/python3 /usr/bin/odoo --config /etc/odoo/odoo.conf --logfile /var/log/odoo/odoo-server.log
Nov 06 10:50:50 ubuntu systemd[1]: Started Odoo Open Source ERP and CRM.Set the service to start on every system reboot.
$ sudo systemctl enable --now odoo
enabledThe service is started on port 8069. This can be confirmed using the command below.
$ ss -tunelp | grep 8069
tcp LISTEN 0 128 0.0.0.0:8069 0.0.0.0:* uid:113 ino:1906251 sk:d <-> Step 5: Configure Nginx Proxy for Odoo system
Install Nginx web server on your Ubuntu system:
sudo apt -y install vim nginxThere are two scenarios for Nginx proxy configuration – With HTTPS and when traffic is not served over secure connection. In this section, we’ll consider both setups.
Setup Nginx HTTP proxy for Odoo
Create a new configuration file for odoo.
sudo vim /etc/nginx/conf.d/odoo.confModify this configuration snippet to fit your setup.
# Odoo Upstreams
upstream odooserver {
server 127.0.0.1:8069;
}
server {
listen 80;
server_name erp.ownyourlife.com.ng;
access_log /var/log/nginx/odoo_access.log;
error_log /var/log/nginx/odoo_error.log;
# Proxy settings
proxy_read_timeout 720s;
proxy_connect_timeout 720s;
proxy_send_timeout 720s;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_set_header X-Real-IP $remote_addr;
# Request for root domain
location / {
proxy_redirect off;
proxy_pass http://odooserver;
}
# Cache static files
location ~* /web/static/ {
proxy_cache_valid 200 90m;
proxy_buffering on;
expires 864000;
proxy_pass http://odooserver;
}
# Gzip
gzip_types text/css text/less text/plain text/xml application/xml application/json application/javascript;
gzip on;
}My service domain in this example is erp.ownyourlife.com.ng, replace it with your correct domain to be used with Odoo. A valid DNS record is required for external access as well.
Check your configuration syntax:
$ sudo nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successfulIf the settings are deemed ok, restart nginx service.
sudo systemctl restart nginxNo error should be encountered on restart.
$ systemctl status nginx
● nginx.service - A high performance web server and a reverse proxy server
Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
Active: active (running) since Sat 2019-10-19 17:34:39 UTC; 5s ago
Docs: man:nginx(8)
Process: 626 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
Process: 615 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
Main PID: 631 (nginx)
Tasks: 2 (limit: 2362)
CGroup: /system.slice/nginx.service
├─631 nginx: master process /usr/sbin/nginx -g daemon on; master_process on;
└─632 nginx: worker process
....Using Let’s Encrypt SSL Certificate for Odoo on Nginx
It is always recommended to use SSL encryption for production deployments. Let’s Encrypt is a free SSL offering that you can use in your Setup.
Install certbot tool:
sudo apt-get update
sudo apt-get install certbotGet Let’s Encrypt SSL certificates for your domain.
# Stop nginx service
sudo systemctl stop nginx
# Save domain and email address as variables
export DOMAIN="erp.ownyourlife.com.ng"
export EMAIL="myemail@ownyourlife.com.ng"
# Request Let's Encrypt SSL Certificate
sudo /usr/bin/certbot certonly --standalone -d ${DOMAIN} --preferred-challenges http --agree-tos -n -m ${EMAIL} --keep-until-expiringIf the execution went through, paths to the certificate and chain files will be printed out.
IMPORTANT NOTES:
- Congratulations! Your certificate and chain have been saved at:
/etc/letsencrypt/live/erp.ownyourlife.com.ng/fullchain.pem
Your key file has been saved at:
/etc/letsencrypt/live/erp.ownyourlife.com.ng/privkey.pem
Your cert will expire on 2020-01-17. To obtain a new or tweaked
version of this certificate in the future, simply run certbot-auto
again. To non-interactively renew *all* of your certificates, run
"certbot-auto renew"
- Your account credentials have been saved in your Certbot
configuration directory at /etc/letsencrypt. You should make a
secure backup of this folder now. This configuration directory will
also contain certificates and private keys obtained by Certbot so
making regular backups of this folder is ideal.
- If you like Certbot, please consider supporting our work by:
Donating to ISRG / Let's Encrypt: https://letsencrypt.org/donate
Donating to EFF: https://eff.org/donate-leCreate cron to renew certificate.
$ sudo crontab -e
15 3 * * * /usr/bin/certbot renew --pre-hook "systemctl stop nginx" --post-hook "systemctl start nginx"Create Nginx configuration file.
sudo vim /etc/nginx/conf.d/odoo.confModify below and add to file.
# Odoo Upstreams
upstream odooserver {
server 127.0.0.1:8069;
}
# http to https redirection
server {
listen 80;
server_name erp.ownyourlife.com.ng;
return 301 https://erp.ownyourlife.com.ng$request_uri;
}
server {
listen 443 ssl;
server_name erp.ownyourlife.com.ng;
access_log /var/log/nginx/odoo_access.log;
error_log /var/log/nginx/odoo_error.log;
# SSL
ssl_certificate /etc/letsencrypt/live/erp.ownyourlife.com.ng/fullchain.pem;
ssl_certificate_key /etc/letsencrypt/live/erp.ownyourlife.com.ng/privkey.pem;
ssl_trusted_certificate /etc/letsencrypt/live/erp.ownyourlife.com.ng/chain.pem;
# Proxy settings
proxy_read_timeout 720s;
proxy_connect_timeout 720s;
proxy_send_timeout 720s;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_set_header X-Real-IP $remote_addr;
# Request for root domain
location / {
proxy_redirect off;
proxy_pass http://odooserver;
}
# Cache static files
location ~* /web/static/ {
proxy_cache_valid 200 90m;
proxy_buffering on;
expires 864000;
proxy_pass http://odooserver;
}
# Gzip Compression
gzip_types text/css text/less text/plain text/xml application/xml application/json application/javascript;
gzip on;
}Don’t forget to substitute erp.ownyourlife.com.ng with your domain name.
Restart Nginx.
sudo systemctl restart nginxStep 6: Access Odoo Web interface
Access Odoo Web page on your domain name from a web browser.
Input required details to create Database. After you click “Create Database”, you’ll be redirected to Administration page from where you can install Odoo business applications.
If you did configure https, the page should be loaded over a secure tunnel.
Visit Odoo documentation page for more reading.
Similar guides:
Leave a Reply
You must be logged in to post a comment.