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 }