files/do-mysql.sh

   1 #!/bin/bash -xe
   2
   3 DRUPAL_DB_PASSWORD="please change me"
   4
   5 # install the mysql server
   6 apt install -y mariadb-server ||:
   7 # installation "fails" when working in a chroot
   8 # so we just ignore it
   9 # should work on a regular system, but this part can't be tested in a chroot
  10
  11 # set up mysql with defaults
  12 mysql_secure_installation < /sqldefaults
  13
  14 # add the drupal db
  15 mysql -u root -p -e 'CREATE DATABASE drupal CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'
  16 mysql -u root -p -e "GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON drupal.* TO 'drupaluser'@'localhost' IDENTIFIED BY '$DRUPAL_DB_PASSWORD';"
  17
  18 # and have drupal do the site-install
  19 cd /var/www/html
  20 vendor/bin/drush site-install --db-url=mysql://drupaluser:$DRUPAL_DB_PASSWORD@localhost/drupal
  21
  22 # make sure perms are right
  23 chown -R www-data:www-data /var/www/html