Odoo ERP, PostgreSQL and Nginx Compose 🔥 🇧🇷

• Odoo
• PostgreSQL
• Nginx
• Certbot Letsencrypt SSL
• Installations and use simplified ❤

Odoo ERP 🖥️

Clone this repository

git clone --recurse-submodules --remote-submodules https://github.com/DanielNery/odoo-docker-compose-nginx-postgresql.git --branch=master

Steps To Live

# On odoo-docker-compose-nginx-postgresql directory
sudo mkdir ./odoo-web-data && sudo mkdir ./addons && sudo chmod -R 777 ./addons &&  sudo chmod -R 777 ./odoo-web-data && sudo docker-compose up -d

# Check container id from odoo
sudo docker ps

# Copy default addons (Optional)
sudo docker cp <odoo_container_id>:/usr/lib/python3/dist-packages/odoo/addons ./addons  

Commands

# Check services running on ports of interest
sudo lsof -i -P -n | grep 80

# Kill process running on port of interest
sudo service apache2 stop
# Containers Up
sudo docker-compose up -d
# Obs: 'd' is from detached

# Allow permissions to read filestore
sudo chmod 777 ./odoo-web-data

# Down containers (Alert: This deletes all config your containers)
sudo docker-compose down


# See Logs
sudo docker-compose logs --tail=100 -f


# Start, Stop and check containers
sudo docker-compose start
sudo docker-compose stop
sudo docker-compose ps

# Init database with base modules
sudo docker-compose stop odoo && \
sudo docker-compose run --rm odoo odoo -c /etc/odoo/odoo.conf -i base --stop-after-init && \
sudo docker-compose restart


# Up Odoo updating modules
sudo docker-compose stop odoo && \
sudo docker-compose run --rm odoo odoo -c /etc/odoo/odoo.conf -u modules_name --stop-after-init && \
sudo docker-compose restart


# Generate database backup
export DATABASE=your_database && sudo docker-compose run --rm -e PGPASSWORD=odoo -e DATABASE=$DATABASE db pg_dump -h db -U odoo $DATABASE > /tmp/db-${DATABASE}-$(date +%Y%m%d%H%M).dump


# Restore your database
cat your_file_name.dump | docker exec -i postgresql psql -U odoo -d your_database_name


# Security copy 'dumps files' from server to your local machine
scp server_user@link_server:/tmp/db-your_db_name.dump ~/Downloads/db-your_db_name.dump &&
scp -r server_user@link_server:/home/ubuntu/projects/your-erp/odoo-web-data/filestore/your_filestore_name ~/Downloads/your_filestore_name


# List databases on postgres container
docker exec postgresql psql -U odoo -l


# Delete databases on postgres container
docker exec postgresql psql -U odoo drop database your_database_name

Nginx SSL config example

server { listen 443 ssl; server_name domain.com.br;

  ssl_certificate     /etc/letsencrypt/live/domain.com.br/fullchain.pem;
  ssl_certificate_key /etc/letsencrypt/live/domain.com.br/privkey.pem;

  location / {
      proxy_pass http://odoo:8069;
      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 $scheme;

      # Configurações adicionais de proxy, se necessário
  }

  location ~ /.well-known/acme-challenge/ {
          root /var/www/certbot;
  }

  error_page 500 502 503 504 /50x.html;
  location = /50x.html {
      root /usr/share/nginx/html;
  }

}

Documentation 📜

• https://docs.docker.com/
• https://docs.docker.com/compose/
• https://www.odoo.com/documentation/14.0/
• https://nginx.org/en/docs/
• https://www.postgresql.org/docs/

Linux Basic Commands 🐧

sudo apt update && sudo apt upgrade -y
sudo apt install docker docker-compose -y
git clone https://github.com/DanielNery/odoo-docker-compose-nginx-postgresql.git
cd odoo-docker-compose-nginx-postgresql
sudo docker-compose up -d

Windowns or Mac Tutorial 🍎

• Install Docker Desktop https://www.docker.com/products/docker-desktop/

  git clone https://github.com/DanielNery/odoo-docker-compose-nginx-postgresql.git
cd odoo-docker-compose-nginx-postgresql
docker-compose up -d
  

Update or custom modules 🍺

docker-compose stop odoo && sudo docker-compose run --rm odoo odoo -c /etc/odoo/odoo.conf -u your_module --stop-after-init && docker-compose start odoo

Contact 📞

• Linkedin: https://www.linkedin.com/in/danielpontesnery/
• Email: [email protected]