Nginx, Php-fpm and MySQL/PostgreSQL stack with Certbot from docker-compose.yml

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.

Installation

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

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

Stack

• 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

Exclude MySQL or PostgreSQL

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

MySQL

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 }

PostgreSQL

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 }