View source for OPS345 Assignment 2 2022-1

Because AWS Academy has deleted hundreds of students' work without any notice or backups: you may choose to do this assignment instead of the one we had planned earlier.

= Overview =

In this assignment you'll find out whether you've become more efficient at the AWS basics you've done previously in this course. You'll recreate much (but not all) of the virtual network environment and virtual machines you've set up in the labs.

= Part 1: Networking =

* Create a new VPC:
** Named '''vpc-ops345-asg2'''
** With the CIDR block 10.0.0.0/24
* Create a new subnet:
** Named '''subnet-ops345-asg2'''
** With CIDR block to 10.0.0.0/25
** Do not let it auto-assign public IP addresses
* Create a second subnet:
** Named '''subnet-ops345-asg2-db'''
** In an availability zone different from subnet-ops345-asg2
* Add an internet gateway and a route table to give your VPC access to the internet.
** Name them '''ops345-asg2-internet-gateway''' and '''ops345-asg2-route-table'''

= Part 2: Web server =

* Create a new VM
** Named '''www-asg2'''
** With local IP 10.0.0.5
** With an elastic IP
** With a security group '''wwwasg2sg'''
** Add a 6GB EBS volume as an LVM physical volume, with a 6GB logical volume permanently mounted on /var/www
* Install Apache and PHP
* Put a copy of '''[https://sourceforge.net/projects/phpfm/ PHP File Manager]''' under /var/www/htdocs, look around, and ponder how little thought you've given web server security in the past.

= Part 3: Database =

* Create a new MariaDB instance named '''ops345dbasg2'''
* Create a database in your instance named '''asg2'''
* Create a user for your database named '''asg2dbuser''' with any password you like
* Instead of setting up a complex database-backed web application: use the mariadb command-line to log in as asg2dbuser, and run the following SQL commands:<syntaxhighlight lang="mysql">
use asg2;
CREATE TABLE work_log(
    -> id INT NOT NULL AUTO_INCREMENT,
    -> person VARCHAR(100) NOT NULL,
    -> hours INT,
    -> PRIMARY KEY ( id ));
INSERT INTO work_log(person, hours) values('yournamehere', 4);
/* Insert at least two more rows with different values */
SELECT * FROM work_log;
</syntaxhighlight>

= Part 4: DNS and HTTPS =

* Create an A record in Bindistrar to map www-asg2.youruserid.ops345.ca to your machine's public IP.
* Create a CNAME record to map asg2done.youruserid.ops345.ca to www-asg2.youruserid.ops345.ca
* Get a Let's Encrypt certificate for www-asg2.youruserid.ops345.ca
* Configure Apache to serve encrypted connections

= Submission =

Please submit on Blackboard one asg2-alt.tar.gz file containing screenshots of your work (as individial images) with the correct filenames. Skip screenshots of work you didn't do:

* '''asg2-alt-ss01-vpc.png''' a screenshot of your VPC configuration.
* '''asg2-alt-ss02-subnet1.png''' a screenshot of your subnet-ops345-asg2 configuration.
* '''asg2-alt-ss03-subnet2.png''' a screenshot of your subnet-ops345-asg2-db configuration.
* '''asg2-alt-ss04-www.png''' a screenshot of your www-asg2 instance configuration, including its IP addresses.
* '''asg2-alt-ss05-lvm.png''' a screenshot of you running '''mount''' on www-asg2.
* '''asg2-alt-ss06-fm.png''' a screenshot of Firefox showing the PHP file manager.
* '''asg2-alt-ss07-sql.png''' a screenshot of you loggin into ops345dbasg2 as asg2dbuser and running '''SELECT * FROM work_log;'''.
* '''asg2-alt-ss08-dig-a.png''' a screenshot of you running a dig command to get the ip address of www-asg2.youruserid.ops345.ca.
* '''asg2-alt-ss09-dig-cname.png''' a screenshot of you running a dig command to get the value of asg2done.youruserid.ops345.ca.
* '''asg2-alt-ss10-https.png''' a screenshot of Firefox accessing https://www-asg2.youruserid.ops345.ca

(to create asg2-alt.tar.gz select all your screenshots in a file manager in Linux Mint, right click, and pick "Compress")

[[Category:OPS345]]