phpBB

# Connect via SSH
ssh root@your-vps-ip

# Alternative with key file
ssh -i /path/to/key root@your-vps-ip

# Create and navigate to project directory
mkdir -p ~/apps/phpbb
cd ~/apps/phpbb

services:
  phpbb:
    image: php:8.2-apache
    ports:
      - "8080:80"
    environment:
      - PHPBB_DB_HOST=db
      - PHPBB_DB_NAME=phpbb
      - PHPBB_DB_USER=phpbb
      - PHPBB_DB_PASSWORD=<your-db-password>
    volumes:
      - phpbb_data:/var/www/html
    restart: unless-stopped
    depends_on:
      db:
        condition: service_healthy
    command: >
      bash -c "
        docker-php-ext-install mysqli pdo pdo_mysql > /dev/null 2>&1;
        if [ ! -f /var/www/html/index.php ]; then
          curl -sL https://download.phpbb.com/pub/release/3.3/3.3.14/phpBB-3.3.14.zip -o /tmp/phpbb.zip &&
          apt-get update -qq && apt-get install -y -qq unzip > /dev/null 2>&1 &&
          unzip -q /tmp/phpbb.zip -d /tmp/phpbb &&
          cp -r /tmp/phpbb/phpBB3/* /var/www/html/ &&
          chown -R www-data:www-data /var/www/html &&
          chmod -R 755 /var/www/html &&
          rm -rf /tmp/phpbb /tmp/phpbb.zip;
        fi;
        apache2-foreground
      "

  db:
    image: mysql:8.0
    environment:
      - MYSQL_ROOT_PASSWORD=<your-db-root-password>
      - MYSQL_DATABASE=phpbb
      - MYSQL_USER=phpbb
      - MYSQL_PASSWORD=<your-db-password>
    volumes:
      - db_data:/var/lib/mysql
    restart: unless-stopped
    healthcheck:
      test: ["CMD-SHELL", "mysqladmin ping -h localhost -u root -p$$MYSQL_ROOT_PASSWORD || exit 1"]
      interval: 10s
      timeout: 5s
      retries: 5
      start_period: 30s

volumes:
  phpbb_data:
  db_data:

# Start all services
docker compose up -d

# List running containers
docker compose ps

# Watch the logs
docker compose logs -f

# Allow the application port through firewall
sudo ufw allow 8080/tcp
sudo ufw reload

# Access your app at:
# http://your-server-ip:8080