drupal-automake-generic/files/do-mysql.sh

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