[eostre.git] / drupal-automake-generic / files / do-mysql.sh

#!/bin/bash -xe

# conf/conf contains some variables
. conf/conf

DRUPAL_DB_PASSWORD="${DRUPAL_DB_PASSWORD:-password}"

# install the mysql server
apt install -y mariadb-server ||:
# installation "fails" when working in a chroot
# so we just ignore it
# should work on a regular system, but this part can't be tested in a chroot

# set up mysql with defaults
mysql_secure_installation < /sqldefaults

# add the drupal db
mysql -u root -e "CREATE DATABASE $DRUPAL_DB_NAME CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;"
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';"

## and have drupal do the site-install
#cd /var/www/html
#vendor/bin/drush site-install --db-url=mysql://drupaluser:$DRUPAL_DB_PASSWORD@localhost/drupal

# make sure perms are right
chown -R www-data:www-data /var/www/html
Commit	Line	Data
	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