--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/build/drupal/installDrupal.sh Fri Nov 18 14:48:49 2016 +0100
@@ -0,0 +1,122 @@
+#!/bin/sh
+#
+clear
+TARFILE=sources.tar.gz
+DUMP=corpusdelaparole.sql
+APUSER=apache
+APGROUP=apache
+# Variables de configuration à modifier selon vos besoins
+#########################################################
+ROOT=/var/www/corpusdelaparole/drupal
+DBNAME=corpusdelaparole
+DBUSER=corpus
+DBPASS=aeTh3ohC
+DBSERV=127.0.0.1
+PHP=/opt/remi/php56/root/usr/bin/php
+#########################################################
+splashTitle() {
+cat <<"EOT"
+ __ _ _____ _ _____ _
+ / _(_) | __ \ | | / ____| | |
+ __ _| |_ _ | | | |_ __ _ _ _ __ __ _| | | (___ ___| |_ _ _ _ __
+ / _` | _| | | | | | '__| | | | '_ \ / _` | | \___ \ / _ \ __| | | | '_ \
+ | (_| | | | | | |__| | | | |_| | |_) | (_| | | ____) | __/ |_| |_| | |_) |
+ \__, |_| |_| |_____/|_| \__,_| .__/ \__,_|_| |_____/ \___|\__|\__,_| .__/
+ __/ | | | | |
+ |___/ |_| |_|
+
+EOT
+}
+
+splashTitle
+echo "--------------------------- PARAMETRES D'INSTALLATION -------------------------------------------------------"
+echo "-------------------------------------------------------------------------------------------------------------"
+echo "Dossier d'installation = $ROOT"
+echo "chemin php = $PHP"
+echo "Nom de la base de données = $DBNAME"
+echo "User Mysql = $DBUSER"
+echo "Mot de passe Mysql = $DBPASS"
+echo "Serveur Mysql = $DBSERV"
+echo "-------------------------------------------------------------------------------------------------------------"
+echo "-------------------------------------------------------------------------------------------------------------"
+read -r -p "Etes-vous sur(e) de vouloir installer avec les paramètres ci dessus ? [Oui/n]" response
+ response=${response,,} # tolower
+ if [[ $response =~ ^(oui|o| ) ]]; then
+ #
+ echo ""
+ echo ""
+ echo "-------------------- Installation du site corpus de la parole -----------------------------------------------"
+ echo "-------------------------------------------------------------------------------------------------------------"
+ #
+ # Errors are fatal
+ #
+ set -e
+
+ echo ""
+ echo "Copie des sources et du dump SQL dans $ROOT"
+ echo "-------------------------------------------"
+ echo "cp $TARFILE $ROOT/$TARFILE"
+ cp $TARFILE $ROOT/$TARFILE
+ echo "cp $DUMP $ROOT/$TARFILE"
+ cp $DUMP $ROOT/$DUMP
+ echo ">> Copie effectuée avec succès"
+ echo ""
+
+ cd $ROOT
+ echo "Extraction des sources dans $ROOT"
+ echo "---------------------------------"
+ echo "tar -xf $TARFILE"
+ tar -xf $TARFILE
+ echo ">> Extraction effectuée avec succès"
+ echo ""
+
+ echo "Restauration du dump de bdd dans la base $DBNAME"
+ echo "------------------------------------------------"
+ echo "mysql -u $DBUSER -p$DBPASS $DBNAME < $DUMP"
+ mysql -h $DBSERV -u $DBUSER -p$DBPASS $DBNAME < $DUMP
+ echo ""
+ echo "Vidage des tables accesslog,search_dataset,search_index,search_total,sessions,watchdog"
+ echo "--------------------------------------------------------------------------------------"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE accesslog"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_dataset"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_index"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE search_total"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE sessions"
+ mysql -h $DBSERV -u $DBUSER -D $DBNAME -p$DBPASS -e "TRUNCATE TABLE watchdog"
+ echo ">> Restauration effectuée avec succès"
+ echo ""
+ echo "Suppression de l'archive tar et du dump"
+ echo "-----------------------------------------------------"
+ rm $TARFILE
+ rm $DUMP
+ echo ">> Suppression effectuée avec succès"
+ echo ""
+ echo "Attribution des droits apache (httpd) sur les sources"
+ echo "-----------------------------------------------------"
+ echo "chown –R $APUSER:$APGROUP $ROOT/*"
+ chown $APUSER:$APGROUP -R $ROOT/*
+ echo ">> Droits apache attribués avec succès"
+ echo ""
+ echo "Mise à jour du fichier de configuation de drupal"
+ echo "-----------------------------------------------------"
+ echo "sed -E \"... database => $DBNAME \" sites/default/settings.php"
+ sed -e '' -E "s/^([[:space:]]+[\'\"]database[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBNAME\2\3/" sites/default/settings.php
+ echo "sed -E \"... username => $DBUSER \" sites/default/settings.php"
+ sed -e '' -E "s/^([[:space:]]+[\'\"]username[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBUSER\2\3/" sites/default/settings.php
+ echo "sed -E \"... password => $DBPASS \" sites/default/settings.php"
+ sed -e '' -E "s/^([[:space:]]+[\'\"]password[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBPASS\2\3/" sites/default/settings.php
+ echo "sed -E \"... host => $DBSERV \" sites/default/settings.php"
+ sed -e '' -E "s/^([[:space:]]+[\'\"]host[\'\"][[:space:]]+\=\>[[:space:]]+)([\'\"]).*[\'\"](.*)$/\1\2$DBSERV\2\3/" sites/default/settings.php
+
+ echo "Vidage des caches Drupal"
+ echo "-----------------------------------------------------"
+ export DRUSH_OPTIONS="-q"
+ sudo -u $APUSER DRUSH_PHP="$PHP" /usr/local/bin/drush cc all
+ set -e
+
+ echo ""
+ echo ""
+ echo ">>>>>>>>>>>>>> INSTALLATION EFFECTUEE AVEC SUCCESS"
+ echo ""
+ echo ""
+ fi