Odoo SSL Certificate & Custom Domain Setup

# Update package list
sudo apt update

# Install Certbot and Nginx plugin
sudo apt install certbot python3-certbot-nginx -y

# Verify installation
certbot --version

# Enable EPEL repository
sudo dnf install epel-release -y

# Install Certbot
sudo dnf install certbot python3-certbot-nginx -y

# Verify installation
certbot --version

# Stop any service using port 80
sudo systemctl stop nginx

# Obtain certificate using standalone mode
sudo certbot certonly --standalone \
  -d erp.yourdomain.com \
  --email [email protected] \
  --agree-tos \
  --non-interactive

# Certificate files are saved to:
# /etc/letsencrypt/live/erp.yourdomain.com/fullchain.pem
# /etc/letsencrypt/live/erp.yourdomain.com/privkey.pem

# Create webroot directory for ACME challenge
sudo mkdir -p /var/www/certbot

# Ensure Nginx serves the challenge directory
# (Add this to your nginx config first - see next section)

# Obtain certificate using webroot mode
sudo certbot certonly --webroot \
  -w /var/www/certbot \
  -d erp.yourdomain.com \
  --email [email protected] \
  --agree-tos \
  --non-interactive

# Wildcard certificates require DNS-01 validation
sudo certbot certonly --manual \
  --preferred-challenges dns \
  -d "*.yourdomain.com" \
  -d yourdomain.com \
  --email [email protected] \
  --agree-tos

# Certbot will prompt you to create a TXT record:
# _acme-challenge.yourdomain.com  ->  <random-string>

# Wait for DNS propagation, then press Enter to continue

# Test renewal process
sudo certbot renew --dry-run

# Add cron job for automatic renewal
sudo crontab -e

# Add this line (runs twice daily):
0 0,12 * * * certbot renew --quiet --post-hook "systemctl reload nginx"

# Or use systemd timer (already installed on most systems)
sudo systemctl enable certbot.timer
sudo systemctl start certbot.timer

# Verify timer is active
sudo systemctl status certbot.timer

# Odoo upstream servers
upstream odoo {
    server 127.0.0.1:8069;
}

upstream odoo-longpolling {
    server 127.0.0.1:8072;
}

# HTTP - Redirect all traffic to HTTPS
server {
    listen 80;
    listen [::]:80;
    server_name erp.yourdomain.com;

    # Let's Encrypt ACME challenge
    location /.well-known/acme-challenge/ {
        root /var/www/certbot;
    }

    # Redirect all other requests to HTTPS
    location / {
        return 301 https://$server_name$request_uri;
    }
}

# HTTPS - Main server block
server {
    listen 443 ssl http2;
    listen [::]:443 ssl http2;
    server_name erp.yourdomain.com;

    # SSL Certificate
    ssl_certificate /etc/letsencrypt/live/erp.yourdomain.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/erp.yourdomain.com/privkey.pem;

    # SSL Session settings
    ssl_session_timeout 1d;
    ssl_session_cache shared:SSL:50m;
    ssl_session_tickets off;

    # Modern SSL configuration (TLS 1.2 and 1.3 only)
    ssl_protocols TLSv1.2 TLSv1.3;
    ssl_ciphers ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384;
    ssl_prefer_server_ciphers off;

    # OCSP Stapling
    ssl_stapling on;
    ssl_stapling_verify on;
    ssl_trusted_certificate /etc/letsencrypt/live/erp.yourdomain.com/chain.pem;
    resolver 8.8.8.8 8.8.4.4 valid=300s;
    resolver_timeout 5s;

    # Security Headers
    add_header X-Frame-Options "SAMEORIGIN" always;
    add_header X-Content-Type-Options "nosniff" always;
    add_header X-XSS-Protection "1; mode=block" always;
    add_header Strict-Transport-Security "max-age=31536000; includeSubDomains" always;
    add_header Referrer-Policy "strict-origin-when-cross-origin" always;

    # Logging
    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 headers for Odoo
    proxy_set_header Host $http_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;
    proxy_set_header X-Forwarded-Host $host;

    # Gzip compression
    gzip on;
    gzip_types text/css text/plain text/xml application/xml application/javascript application/json image/svg+xml;
    gzip_min_length 1000;

    # File upload size (adjust as needed)
    client_max_body_size 100M;

    # Longpolling (real-time features like chat, notifications)
    location /longpolling {
        proxy_pass http://odoo-longpolling;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
    }

    # WebSocket support (Odoo 16+)
    location /websocket {
        proxy_pass http://odoo-longpolling;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
    }

    # Static file caching
    location ~* /web/static/ {
        proxy_pass http://odoo;
        proxy_cache_valid 200 60m;
        expires 24h;
        add_header Cache-Control "public, immutable";
    }

    # Main Odoo application
    location / {
        proxy_pass http://odoo;
        proxy_redirect off;
    }
}

# Create symbolic link to enable site
sudo ln -s /etc/nginx/sites-available/odoo /etc/nginx/sites-enabled/

# Test Nginx configuration
sudo nginx -t

# If test passes, reload Nginx
sudo systemctl reload nginx

# Check Nginx status
sudo systemctl status nginx

[options]
# Enable proxy mode (required when behind reverse proxy)
proxy_mode = True

# Other settings...
db_host = localhost
db_port = 5432
db_user = odoo
db_password = your_password
addons_path = /opt/odoo/addons

# Restart Odoo to apply changes
sudo systemctl restart odoo

# Update web.base.url in Odoo
# Go to Settings > System Parameters
# Set web.base.url to: https://erp.yourdomain.com

# Check A record
dig erp.yourdomain.com A +short

# Check AAAA record (IPv6)
dig erp.yourdomain.com AAAA +short

# Alternative: use nslookup
nslookup erp.yourdomain.com

# Check from multiple locations
# Visit: https://dnschecker.org

server {
    listen 443 ssl http2;
    server_name erp.yourdomain.com
                erp.company.com
                odoo.company.com;

    # SSL certificates must cover all domains
    # Use a wildcard cert or separate certs with SNI
    ssl_certificate /etc/letsencrypt/live/erp.yourdomain.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/erp.yourdomain.com/privkey.pem;

    # ... rest of configuration
}

# Redirect www to non-www
server {
    listen 443 ssl http2;
    server_name www.erp.yourdomain.com;

    ssl_certificate /etc/letsencrypt/live/erp.yourdomain.com/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/erp.yourdomain.com/privkey.pem;

    return 301 https://erp.yourdomain.com$request_uri;
}

# Test SSL certificate
openssl s_client -connect erp.yourdomain.com:443 -servername erp.yourdomain.com

# Check certificate details
echo | openssl s_client -connect erp.yourdomain.com:443 2>/dev/null | openssl x509 -noout -dates

# Use SSL Labs for comprehensive testing
# Visit: https://www.ssllabs.com/ssltest/analyze.html?d=erp.yourdomain.com