# Enable clean URL
#cp /etc/httpd/conf/httpd.conf.backup /etc/httpd/conf/httpd.conf
#kate /etc/httpd/conf/httpd.conf
#"AllowOverride None" to "AllowOverride All"

yum -y install drupal7 mysql mysql-server phpMyAdmin php

#Backup
cp -r /usr/share/drupal7 /usr/share/drupal7-backup
cp -r /etc/drupal7 /etc/drupal7-backup
cp -r /var/lib/drupal7/files/default /var/lib/drupal7/files/default-backup

# Mysql User & Pass for PHP-Myadmin
cp -r /etc/drupal7/default/default.settings.php /etc/drupal7/default/settings.php
chmod 777 /etc/drupal7/default/settings.php
systemctl stop httpd mariadb
systemctl start httpd mariadb
systemctl enable httpd mariadb
mysqladmin -u root password 123

chmod 644 /etc/drupal7/default/settings.php
#groupadd Drupal
#usermod -G Drupal -a Muhammad
#chgrp -R Drupal /etc/drupal7/default/settings.php

#DataBase
mysql -u root -p123
CREATE DATABASE `DataBase` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'DataBase'@'localhost' IDENTIFIED BY '123';
GRANT USAGE ON * . * TO 'DataBase'@'localhost' IDENTIFIED BY '123' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON `DataBase` . * TO 'DataBase'@'localhost' WITH GRANT OPTION ;
exit

#Reinstall Remove
rm -rf /usr/share/drupal7
cp -r /usr/share/drupal7-backup /usr/share/drupal7
rm -rf /etc/drupal7
cp -r /etc/drupal7-backup /etc/drupal7
rm -rf /var/lib/drupal7/files/default
cp -r /var/lib/drupal7/files/default-backup /var/lib/drupal7/files/default
chgrp -R apache /var/lib/drupal7/
chmod -R 775 /var/lib/drupal7/

cp /usr/share/drupal7/.htaccess /usr/share/drupal7/.htaccess.backup
kate /usr/share/drupal7/.htaccess
#RewriteBase /drupal to  RewriteBase /drupal

# Configure drupale to Work With Apache
cp /etc/httpd/conf.d/drupal7.conf /etc/httpd/conf.d/drupal7.conf.backup
kate /etc/httpd/conf.d/drupal7.conf

#Remove User
mysql -u root -p123
REVOKE ALL PRIVILEGES ON `DataBase` . * FROM 'DataBase'@'localhost';
REVOKE GRANT OPTION ON `DataBase` . * FROM 'DataBase'@'localhost';
exit
