Skip to content

Instantly share code, notes, and snippets.

@robconery
Last active August 24, 2020 19:14
Show Gist options
  • Save robconery/b3d1ab3146f777707a6d6fb2e851cc8d to your computer and use it in GitHub Desktop.
Save robconery/b3d1ab3146f777707a6d6fb2e851cc8d to your computer and use it in GitHub Desktop.
Spin up Wordpress on Azure Using Managed Services
RG="[YOUR RESOURCE GROUP]"
APPNAME=$RG-wordpress #Name what you want
LOCATION="Central US" #put where you like
#Recommend to keep these random, but if you need to change go for it
USER=admin_$RANDOM #set this to whatever you like but it's not something that should be easy
PASS=$(uuidgen) #Again - whatever you like but keep it safe! Better to make it random
SERVERNAME=server$RANDOM #this has to be unique across azure
#accepted values for the service plan: B1, B2, B3, D1, F1, FREE, P1, P1V2, P2, P2V2, P3, P3V2, PC2, PC3, PC4, S1, S2, S3, SHARED
#B2 is good for getting started - read up on the different levels and their associated cost.
PLAN=B2
#Kick it off by creating the Resource Group
echo "Creating resource group"
az group create -n $RG -l $LOCATION
#The sku-name parameter value follows the convention {pricing tier}_{compute generation}_{vCores} as in the examples below:
# --sku-name B_Gen5_2 maps to Basic, Gen 5, and 2 vCores.
# --sku-name GP_Gen5_32 maps to General Purpose, Gen 5, and 32 vCores.
# --sku-name MO_Gen5_2 maps to Memory Optimized, Gen 5, and 2 vCores.
#WARNING - this might error out if your region doesn't support the SKU you set here. If it does, execute:
#az group delete -g [resource group] to drop everything and try again
#The SKU below is reasonable for a WP blog, but if you're going to host something more, consider more RAM/Cores
SKU=B_Gen5_1 #this is the cheapest one
echo "Spinning up MySQL $SERVERNAME in group $RG Admin is $USER"
# Create the MySQL service
az mysql server create --resource-group $RG \
--name $SERVERNAME --admin-user $USER \
--admin-password $PASS --sku-name $SKU \
--ssl-enforcement Disabled \
--location $LOCATION
echo "Guessing your external IP address from ipinfo.io"
IP=$(curl -s ipinfo.io/ip)
echo "Your IP is $IP"
# Open up the firewall so we can access
echo "Popping a hole in firewall for IP address $IP (that's you)"
az mysql server firewall-rule create --resource-group $RG \
--server $SERVERNAME --name AllowMyIP \
--start-ip-address $IP --end-ip-address $IP
# Open up the firewall so wordpress can access - this is internal IP only
echo "Popping a hole in firewall for Azure Services"
az mysql server firewall-rule create --resource-group $RG \
--server $SERVERNAME --name AllowAzureIP \
--start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0
echo "Creating Wordpress Database"
mysql --host=$SERVERNAME.mysql.database.azure.com \
--user=$USER@$SERVERNAME --password=$PASS \
-e 'create database wordpress;' mysql
echo "Setting ENV variables locally"
MYSQL_SERVER=$SERVERNAME.mysql.database.azure.com
MYSQL_USER=$USER@$SERVERNAME
MYSQL_PASSWORD=$PASS
MYSQL_PORT=3306
MYSQL_DB=$DATABASE
echo "MYSQL_SERVER=$MYSQL_SERVER\nMYSQL_USER=$USER\nMYSQL_PASSWORD=$PASS\nMYSQL_PORT=3306" >> .env
echo "alias prod=\"mysql --host=$SERVERNAME.mysql.database.azure.com --user=$USER@$SERVERNAME --password=$PASS\" wordpress"
echo "MySQL ENV vars added to .env. You can printenv to see them, or cat .env."
echo "To access your MySQL Instance just run `prod` as an alias. You can rename this in .env."
echo "Creating AppService Plan"
az appservice plan create --name $RG \
--resource-group $RG \
--sku $PLAN \
--is-linux
echo "Creating Web app"
az webapp create --resource-group $RG \
--plan $RG --name $APPNAME \
--deployment-container-image-name wordpress
echo "Adding app settings"
#add the settings for the new MYSQL bits
az webapp config appsettings set --name $APPNAME \
--resource-group $RG \
--settings WORDPRESS_DB_HOST=$MYSQL_SERVER \
WORDPRESS_DB_USER=$MYSQL_USER \
WORDPRESS_DB_PASSWORD=$MYSQL_PASSWORD \
WEBSITES_PORT=80
#turn on logging
echo "Setting up logging"
#setup logging and monitoring
az webapp log config --application-logging true \
--detailed-error-messages true \
--web-server-logging filesystem \
--level information \
--name $APPNAME \
--resource-group $RG
echo "Adding logs alias to .env. Invoking this will allow you to see the application logs realtime-ish."
#set an alias for convenience - add to .env
alias logs="az webapp log tail --name $APPNAME --resource-group $RG"
echo "alias logs='az webapp log tail -n $APPNAME -g $RG'" >> .env
echo "Opening site and viewing logs"
open https://$APPNAME.azurewebsites.net
source .env
logs
@robconery
Copy link
Author

Thanks Matt - fixed :).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment