Skip to content

DanielNery/odoo-docker-compose-nginx-postgresql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

82 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Odoo ERP, PostgreSQL and Nginx Compose 🔥 🇧🇷

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

Odoo ERP 🖥️

project-image

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 📜

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 🍎

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 📞

About

Composição Docker do Odoo com PostgreSQL e Nginx para subir e desenvolver com facilidade seu ERP

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published