/wp-cloud-sql-db

Docker environment with nginx wordpress and remote google cloud sql DB

Primary LanguageDockerfile

Docker Nginx + WordPress + Remote Google Cloud SQL Database development environment

Custom build docker image for wordpress and google cloud sql proxy, running in the same container

Getting Started

Create .env file with APP_NAME and DOMAIN, then in project root create SSL cert for local domain

mkdir certs
cd cli
chmod +x create-cert.sh
./create-cert.sh
cd ../

Update Nginx config file with APP_NAME and DOMAIN

cd nginx
chomod +x .update-nginx.sh
./update-nginx.sh
cd ../

Add variables to env and created credentials.json file from a service account that has the appropriate role to gcs

Refer to info on GCP Doc Page.

docker-compose build
docker-compose up -d
docker-compose down

In wp-config.php add

define('WP_CACHE', true); 
$currenthost = $_SERVER['HTTP_HOST']; 
$mypos = strpos($currenthost, 'localhost'); 
if ($mypos === false) { 
    define('WP_HOME','https://livedomain.com'); 
    define('WP_SITEURL','https://livedomain.com'); } 
else { 
    define('WP_HOME','http://localdomain.localhost'); 
    define('WP_SITEURL','http://localdomain.localhost'); 
}

Change wp-content ownership to www-data

sudo chown -R www-data:www-data wp-content/

Modify wp extra host IP address by inspect the nginx container then run docker-compose up -d again

docker container inspect nginx_container
...
extra_hosts:
      - "www.${DOMAIN}:172.18.0.4"
      - "${DOMAIN}:172.18.0.4"