This repository to create Nginx, Php-fpm and MySQL/PostgreSQL stack with Certbot from docker-compose.yml file.

This repository is accompanied by a step-by-step guide on Boilerplate for nginx with Let’s Encrypt on docker-compose.

init-letsencrypt.sh fetches and ensures the renewal of a Let’s Encrypt certificate for one or multiple domains in a docker-compose setup with nginx. This is useful when you need to set up nginx as a reverse proxy for an application.

1. Install docker-compose.

2. Clone this repository: git clone https://github.com/tobing/nginx-certbot-php-mysql-docker.git

3. Modify configuration:

   • Replace domains and email addresses in init-letsencrypt.sh
   • Replace all occurrences of example.org with primary domain in /nginx/app.conf and /nginx.localhost/app.conf
   • Uncomment - ./nginx.localhost:/etc/nginx/conf.d and comment - ./nginx:/etc/nginx/conf.d in docker-compose.yml file. This setting to generate certificate for the first time

4. chmod +x init-letsencrypt.sh then run the init script: ./init-letsencrypt.sh (set staging=1 for testing your setup to avoid Let's Encrypt request limits)

5. Comment - ./nginx.localhost:/etc/nginx/conf.d and uncomment - ./nginx:/etc/nginx/conf.d in docker-compose.yml file.

6. Run the server: docker-compose up -d

PHP image including composer and these addional modules so need some time to compile. You can customize them from /php/Dockerfile

• curl
• gd
• intl
• opcache
• pdo
• pdo_mysql
• pdo_pgsql
• pgsql
• zip

• nginx:1.23-alpine
• certbot/certbot
• php:8-fpm-alpine
• mysql:8
• postgres:15-alpine

You can customize the versions from docker-compose.yml and /php/Dockerfile

Remove these sections from docker-compose.yml before run docker-compose up -d

mysql: image: mysql:8 ports: - "3306:3306" environment: - MYSQL_ROOT_PASSWORD=0123456789 - MYSQL_USER=dbuser - MYSQL_PASSWORD=9876543210 - MYSQL_DATABASE=dbname - TZ=Asia/Jakarta volumes: - "mysql_data:/var/lib/mysql" 

mysql_data: { driver: local } 

pgsql: image: postgres:15-alpine restart: always ports: - "5432:5432" environment: - POSTGRES_USER=postgres - POSTGRES_PASSWORD=example - TZ=Asia/Jakarta volumes: - "pgsql_data:/var/lib/postgresql/data" 

pgsql_data: { driver: local }