## ----------------------  Extra CONFIGURATIONS  -------------------------- ##

## Update /etc/mysql/mysql.conf.d/mysqld.cnf ... add: lower_case_table_names=1
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com "sudo sed -i 's/\[mysqld\]/\[mysqld\]\nlower_case_table_names=1/' /etc/mysql/mysql.conf.d/mysqld.cnf"
sudo service mysql restart

## USE SCP TO COPY (website configuration files) and move them to /etc/apache2/sites-available/
for CNF in /etc/apache2/sites-available/*;
do
    scp -i ~/.ssh/MyFirstKeyPair.pem /etc/apache2/sites-available/${CNF} ubuntu@our.company.dynamic.dns.name.amazonaws.com:${CNF}
    ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo cp /home/ubuntu/${CNF} /etc/apache2/sites-available/
    ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo chown root:www /etc/apache2/sites-available/${CNF}
    ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo ln -s /etc/apache2/sites-available/${CNF} /etc/apache2/sites-enabled/
done;

## COPY, MOVE AND CHANGE OWNER OF CERTIFICATE FILES
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo mkdir /etc/apache2/ssl
scp -i ~/.ssh/MyFirstKeyPair.pem /etc/apache2/ssl/siteName.crt ubuntu@our.company.dynamic.dns.name.amazonaws.com:~/siteName.crt
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo cp /home/ubuntu/siteName.crt /etc/apache2/ssl/
scp -i ~/.ssh/MyFirstKeyPair.pem /etc/apache2/ssl/siteName.key ubuntu@our.company.dynamic.dns.name.amazonaws.com:~/siteName.key
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo cp /home/ubuntu/siteName.key /etc/apache2/ssl/

## USE SCP TO COPY /var/lib/tomcat7/conf/server.xml (/etc/tomcat7/server.xml)
scp -i ~/.ssh/MyFirstKeyPair.pem /var/lib/tomcat7/conf/server.xml ubuntu@our.company.dynamic.dns.name.amazonaws.com:server.xml
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo cp /home/ubuntu/server.xml /var/lib/tomcat7/conf/server.xml
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo chown root:tomcat7 /var/lib/tomcat7/conf/server.xml

## Create MySQL databases, users and privileges
## Upload the MySQL users script to AWS and import it
scp -i ~/.ssh/MyFirstKeyPair.pem /data/Downloads/AWS/RecreateUsers.sql ubuntu@our.company.dynamic.dns.name.amazonaws.com:~/RecreateUsers.sql
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com "mysql -u root mysql -p********** < RecreateUsers.sql > RecreateUsers.log"

## import all MySQL databases from mail.net-technologies.com
scp admin@companyName.com:~/mysqldump.databases.sql.gz /data/Downloads/AWS/mysqldump.databases.sql.gz

## Upload the MySQL dump to AWS, unzip it and import it
scp -i ~/.ssh/MyFirstKeyPair.pem /data/Downloads/AWS/mysqldump.databases.sql.gz ubuntu@our.company.dynamic.dns.name.amazonaws.com:~/mysqldump.databases.sql.gz
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com "gunzip -k mysqldump.databases.sql.gz"
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com "mysql -u root mysql -p********** < mysqldump.databases.sql > mysqldump.databases.log"

## Change ownership of web files in S3 bucket and soft-link them at /var/www/
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo chown -R root:www /mnt/s3/www
for CNF in /mnt/s3/www/*; 
do
    ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo ln -s /mnt/s3/www/${CNF} /var/www/;
done;

## Upload WAR file for webApplicationName
scp -i ~/.ssh/MyFirstKeyPair.pem /usr/local/tomcat7/webapps/webApplicationName.war ubuntu@our.company.dynamic.dns.name.amazonaws.com:~/webApplicationName.war
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo cp /home/ubuntu/webApplicationName.war /var/lib/tomcat7/webapps/webApplicationName.war
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo chown tomcat7:tomcat7 /var/lib/tomcat7/webapps/webApplicationName.war
## ----------------------  Extra CONFIGURATIONS  -------------------------- ##

## IMPORTANT!
## NOW, CREATE DNS ENTRIES FOR AWS ELASTIC IP (?.?.?.?) at: http://registrarName.com/

## FINALLY RESTART KEY SERVICES
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo service mysql restart
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo service tomcat7 restart
ssh -i ~/.ssh/MyFirstKeyPair.pem ubuntu@our.company.dynamic.dns.name.amazonaws.com sudo service apache2 restart

## END ##