Debian 9: Install Drupal for CMS

#!/bin/sh

set -e

MYSQL_VERSION=5.5
[ -z "${MYSQL_PASSWD}" ] && \
  MYSQL_PASSWD=mysql
[ -z "${DRUPAL_PASSWD}" ] && \
  DRUPAL_PASSWD=drupal

drupal_install_mysql()
{
  cat <<EOF | sudo debconf-set-selections
mysql-server-${MYSQL_VERSION} mysql-server/root_password password ${MYSQL_PASSWD}
mysql-server-${MYSQL_VERSION} mysql-server/root_password_again password ${MYSQL_PASSWD}
EOF
  sudo apt install -y mysql-server
}

drupal_install_drupal()
{
  cat <<EOF | sudo debconf-set-selections
drupal7 drupal7/dbconfig-install boolean true
drupal7 drupal7/database-type select mysql
drupal7 drupal7/mysql/admin-pass password ${MYSQL_PASSWD}
drupal7 drupal7/password-confirm password ${MYSQL_PASSWD}
drupal7 drupal7/mysql/app-pass password ${DRUPAL_PASSWD}
drupal7 drupal7/app-password-confirm password ${DRUPAL_PASSWD}
EOF
  sudo apt install -y drupal7
}

drupal_install_apache()
{
  sudo apt install -y apache2 libapache2-mod-php php-mbstring

  sudo mv /etc/apache2/conf-available/drupal7.conf \
       /etc/apache2/conf-available/drupal7.conf.orig
  cat <<EOF | sudo tee /etc/apache2/conf-available/drupal7.conf
<VirtualHost _default_:443>
  SSLEngine on
  SSLCertificateFile    /etc/ssl/certs/ssl-cert-snakeoil.pem
  SSLCertificateKeyFile /etc/ssl/private/ssl-cert-snakeoil.key

$(sed -e 's/^/  /g' /etc/apache2/conf-available/drupal7.conf.orig)
</VirtualHost>
EOF

  sudo a2enmod php7.0
  sudo a2enmod ssl
  sudo a2enconf drupal7
  sudo systemctl enable apache2
  sudo systemctl restart apache2
}

drupal_main()
{
  drupal_install_mysql
  drupal_install_drupal
  drupal_install_apache
}

drupal_main