How to Run WordPress in a Cloud Sandbox With an HTTPS URL

# wp/compose.yaml
x-wp-env: &wp-env
  WORDPRESS_DB_HOST: db
  WORDPRESS_DB_NAME: wordpress
  WORDPRESS_DB_USER: wp
  WORDPRESS_DB_PASSWORD: ${DB_PASSWORD}

services:
  db:
    image: mariadb:11.8
    restart: unless-stopped
    environment:
      MARIADB_DATABASE: wordpress
      MARIADB_USER: wp
      MARIADB_PASSWORD: ${DB_PASSWORD}
      MARIADB_RANDOM_ROOT_PASSWORD: "1"
    volumes:
      - db:/var/lib/mysql
    healthcheck:
      test: ["CMD", "healthcheck.sh", "--connect", "--innodb_initialized"]
      interval: 5s
      retries: 30

  wordpress:
    image: wordpress:7.1-php8.3-apache
    restart: unless-stopped
    depends_on:
      db:
        condition: service_healthy
    ports:
      - "127.0.0.1:8080:80"
    environment: *wp-env
    volumes:
      - wp:/var/www/html

  cli:
    image: wordpress:cli-2-php8.3
    profiles: ["cli"]
    user: "33:33"
    depends_on:
      - wordpress
    environment:
      <<: *wp-env
      HOME: /tmp
    volumes:
      - wp:/var/www/html

volumes:
  db:
  wp:

sbx new --name wordpress --type small
id=sb_p4esgbgh3g    # the id that sbx new printed

sbx scp -r ./wp $id:/home/user/
sbx exec $id --timeout 600 "cd wp && umask 077 \
  && echo DB_PASSWORD=\$(openssl rand -hex 16) > .env \
  && openssl rand -hex 12 | tr -d '\n' > admin-pass \
  && docker compose up -d --quiet-pull \
  && docker compose ps --format 'table {{.Service}}\t{{.Image}}\t{{.Status}}\t{{.Ports}}'"

 Container wp-db-1 Healthy
 Container wp-wordpress-1 Starting
 Container wp-wordpress-1 Started
SERVICE     IMAGE                         STATUS                   PORTS
db          mariadb:11.8                  Up 5 seconds (healthy)   3306/tcp
wordpress   wordpress:7.1-php8.3-apache   Up Less than a second    127.0.0.1:8080->80/tcp

sbx host $id 8080 --localhost --title wordpress

{"ok":true,"type":"port.hosted","sandboxId":"sb_p4esgbgh3g","port":8080,"url":"https://crisp-copper-lime-8080.box.sandboxer.com?_token=<token>","access":"private","isProtected":true,"localhost":true}

#!/bin/bash
# usage: bash install.sh https://<subdomain>-8080.box.sandboxer.com
set -e
cd ~/wp
docker compose run -T --rm cli wp core install --url="$1" --title="Sandbox blog" \
  --admin_user=admin --admin_email=admin@example.com --skip-email \
  --admin_password="$(cat admin-pass)"

sbx scp wp/install.sh $id:/home/user/wp/install.sh
sbx exec $id --timeout 300 "bash wp/install.sh https://crisp-copper-lime-8080.box.sandboxer.com"
sbx exec $id "cd wp && docker compose run -T --rm cli wp option get siteurl"

Success: WordPress installed successfully.
https://crisp-copper-lime-8080.box.sandboxer.com

/            301 -> https://crisp-copper-lime-8080.box.sandboxer.com:8080/
/wp-admin/   302 -> https://localhost:8080/wp-login.php?redirect_to=…&reauth=1

sbx exec $id "cd wp && docker compose run -T --rm cli wp search-replace \
  http://localhost:8080 https://crisp-copper-lime-8080.box.sandboxer.com --all-tables --report-changed-only"

Table	Column	Replacements	Type
wp_options	option_value	2	PHP
Success: Made 2 replacements.

sbx exec $id "docker compose -f wp/compose.yaml exec -T wordpress grep -n -A2 HTTP_X_FORWARDED_PROTO /var/www/html/wp-config.php"

122:if (isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && strpos($_SERVER['HTTP_X_FORWARDED_PROTO'], 'https') !== false) {
123-	$_SERVER['HTTPS'] = 'on';
124-}

src="http://crisp-copper-lime-8080.box.sandboxer.com/wp-includes/js/hoverintent-js.min.js?ver=2.2.1"
/wp-admin/        302 -> https://crisp-copper-lime-8080.box.sandboxer.com/wp-admin/
login POST        302 -> https://crisp-copper-lime-8080.box.sandboxer.com/wp-login.php