Bash script to automatically provision LAMP sites

sitesetup.sh

#!/bin/bash

# Bash script to set up local site using LAMP on Ubuntu
# Requires Apache2, MySQL, mkcert (https://github.com/FiloSottile/mkcert)
# See also sitedrop.sh https://gist.github.com/jonathanbossenger/4950e107b0004a8ee82aae8b123cce58

HOME_USER=jonathan
SSL_CERTS_DIRECTORY=/home/jonathan/ssl-certs
SITES_DIRECTORY=/home/jonathan/development/websites

SITE_NAME=$1

MYSQL_DATABASE=$(echo $SITE_NAME | sed 's/[^a-zA-Z0-9]//g')
SITE_CONFIG_PATH=/etc/apache2/sites-available/$SITE_NAME.conf
SSL_SITE_CONFIG_PATH=/etc/apache2/sites-available/$SITE_NAME-ssl.conf

MKCERT_EXECUTABLE=/home/linuxbrew/.linuxbrew/bin/mkcert

echo "Creating websites directory"

mkdir $SITES_DIRECTORY/"$SITE_NAME"
chown -R $HOME_USER:$HOME_USER $SITES_DIRECTORY/"$SITE_NAME"

echo "Setting up virtual hosts..."

VIRTUAL_HOST="<VirtualHost *:80>
    ServerName $SITE_NAME.test
    Redirect / https://$SITE_NAME.test
</VirtualHost>"

echo "$VIRTUAL_HOST" | sudo tee -a "$SITE_CONFIG_PATH"

SSL_VIRTUAL_HOST="<IfModule mod_ssl.c>
    <VirtualHost _default_:443>
        ServerName $SITE_NAME.test
        ServerAdmin webmaster@$SITE_NAME.test
        DocumentRoot $SITES_DIRECTORY/$SITE_NAME
        <Directory \"$SITES_DIRECTORY/$SITE_NAME\">
            #Require local
            Order allow,deny
            Allow from all
            AllowOverride all
            # New directive needed in Apache 2.4.3:
            Require all granted
        </Directory>
        ErrorLog \${APACHE_LOG_DIR}/$SITE_NAME-error.log
        CustomLog \${APACHE_LOG_DIR}/$SITE_NAME-access.log combined
        SSLEngine on
        SSLCertificateFile  $SSL_CERTS_DIRECTORY/$SITE_NAME.test.pem
        SSLCertificateKeyFile $SSL_CERTS_DIRECTORY/$SITE_NAME.test-key.pem
        <FilesMatch \"\.(cgi|shtml|phtml|php)\$\">
                SSLOptions +StdEnvVars
        </FilesMatch>
        <Directory /usr/lib/cgi-bin>
                SSLOptions +StdEnvVars
        </Directory>

    </VirtualHost>
</IfModule>"

echo "$SSL_VIRTUAL_HOST" | sudo tee -a "$SSL_SITE_CONFIG_PATH"

echo "Enabling virtual hosts..."

a2ensite "$SITE_NAME".conf
a2ensite "$SITE_NAME"-ssl.conf

echo "Add hosts record.."

echo "127.0.0.1    $SITE_NAME.test" >> /etc/hosts

echo "Creating database.."

mysql -uroot -ppassword --execute="CREATE DATABASE $MYSQL_DATABASE;"

echo "Add certs.."

runuser -l jonathan -c "cd $SSL_CERTS_DIRECTORY && $MKCERT_EXECUTABLE $SITE_NAME.test"

echo "Restarting Apache..."

service apache2 restart

echo "Done."

Discovered runuser command solves mkcert problem.
Added site directory creation.

mkdir -p should be instead of mkdir on line 19 because mkdir creates only a directory. You need a few subdirectory.

Also, I had some changes for everybody to use. Maybe you could interest : My Version

Changed Port 80 virtual host file to only have a config that directs all traffic to HTTPS

<VirtualHost *:80>
   ServerName www.yourdomain.com
   Redirect / https://www.yourdomain.com
</VirtualHost>

Update mkcert call to point to physical path /home/linuxbrew/.linuxbrew/bin/mkcert as from Ubuntu 20.10 onwards this seems required.

Todo, add a switch/option for altering public webroot (eg for Laravel projects)

Updated to use MYSQL_DATABASE variable, in case site name has a hyphen