WordPress - Déploiement Docker

/opt/wordpress-clemence/
├── docker-compose.yml
└── nginx/
    └── default.conf

/opt/wordpress-solidarlink/
├── docker-compose.yml
└── nginx/
    └── default.conf

version: '3.8'

services:
  mysql:
    image: mysql:8.0
    container_name: mysql-clemence
    restart: unless-stopped
    environment:
      - MYSQL_ROOT_PASSWORD=<root_password>
      - MYSQL_DATABASE=clemence_db
      - MYSQL_USER=clemence_user
      - MYSQL_PASSWORD=<user_password>
    volumes:
      - mysql-data:/var/lib/mysql
    networks:
      - wordpress-net

  wordpress:
    image: wordpress:latest
    container_name: wordpress-clemence
    restart: unless-stopped
    depends_on:
      - mysql
    environment:
      - WORDPRESS_DB_HOST=mysql-clemence:3306
      - WORDPRESS_DB_NAME=clemence_db
      - WORDPRESS_DB_USER=clemence_user
      - WORDPRESS_DB_PASSWORD=<user_password>
    volumes:
      - wordpress-data:/var/www/html
    ports:
      - "8080:80"
    networks:
      - wordpress-net

volumes:
  mysql-data:
  wordpress-data:

networks:
  wordpress-net:
    driver: bridge

mkdir -p /opt/wordpress-clemence
cd /opt/wordpress-clemence

nano docker-compose.yml
# Coller la configuration ci-dessus

docker-compose up -d

docker-compose logs -f

certbot certonly --nginx \
  -d clemence.srv759970.hstgr.cloud \
  --non-interactive \
  --agree-tos \
  -m julien@julienfernandez.xyz

server {
    listen 443 ssl http2;
    listen [::]:443 ssl http2;
    server_name clemence.srv759970.hstgr.cloud;

    ssl_certificate /etc/letsencrypt/live/clemence.srv759970.hstgr.cloud/fullchain.pem;
    ssl_certificate_key /etc/letsencrypt/live/clemence.srv759970.hstgr.cloud/privkey.pem;
    include /etc/letsencrypt/options-ssl-nginx.conf;
    ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem;

    access_log /var/log/nginx/clemence-access.log;
    error_log /var/log/nginx/clemence-error.log;

    location / {
        proxy_pass http://127.0.0.1:8080;
        proxy_http_version 1.1;
        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;

        # WordPress specific
        proxy_set_header X-Forwarded-Host $host;
        proxy_redirect off;
    }
}

server {
    listen 80;
    listen [::]:80;
    server_name clemence.srv759970.hstgr.cloud;
    return 301 https://$host$request_uri;
}

ln -sf /etc/nginx/sites-available/clemence /etc/nginx/sites-enabled/
nginx -t
systemctl reload nginx

define('FORCE_SSL_ADMIN', true);
if (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] === 'https') {
    $_SERVER['HTTPS'] = 'on';
}

# Backup volumes
docker run --rm \
  -v wordpress-clemence_wordpress-data:/data \
  -v $(pwd):/backup \
  alpine tar czf /backup/wordpress-$(date +%Y%m%d).tar.gz -C /data .

docker run --rm \
  -v wordpress-clemence_mysql-data:/data \
  -v $(pwd):/backup \
  alpine tar czf /backup/mysql-$(date +%Y%m%d).tar.gz -C /data .

docker exec wordpress-clemence wp core update --allow-root
docker exec wordpress-clemence wp plugin update --all --allow-root
docker exec wordpress-clemence wp theme update --all --allow-root

# WordPress
docker logs wordpress-clemence -f

# MySQL
docker logs mysql-clemence -f

# Nginx
tail -f /var/log/nginx/clemence-access.log

# Vérifier que MySQL est démarré
docker ps | grep mysql

# Voir les logs MySQL
docker logs mysql-clemence --tail 50

# Tester la connexion
docker exec -it mysql-clemence mysql -u clemence_user -p

# Réparer les permissions
docker exec wordpress-clemence chown -R www-data:www-data /var/www/html

# Activer le debug dans wp-config.php
docker exec -it wordpress-clemence bash
nano /var/www/html/wp-config.php

# Ajouter:
define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);
define('WP_DEBUG_DISPLAY', false);

# Voir les logs
tail -f /var/www/html/wp-content/debug.log

docker exec -it mysql-clemence mysql -u root -p

OPTIMIZE TABLE wp_posts;
OPTIMIZE TABLE wp_postmeta;