= OPS235 Assignment 2 Introduction and Purpose =

'''Weight:''' 515% of the overall grade

'''Due Date:''' Week 13 <br />Refer to your instructor for submission instructionsSee blackboard

{{Admon/important|It is YOUR responsibility to Backup your centos3 VM for this Assignment!|You are required to frequently backup your VM prior to exiting a work session during In this assignment. Your instructor , you will NOT accept demonstrate the fact that your hard disk crashed skills you have learned to this point by configuring two services: a '''database server''' and lost all of your worka '''web server'''. If you properly backed up your VM images You will install and xml configuration files to use a USBdatabase-backed web application, then you can purchase a new hard-disk or wipe and recreate '''Wordpress''', to show that these services have been installed properly. You will also configure your hard disk and restore '''firewall''' to further enhance the security of your VMscomputer system.}}<br>

In {{Admon/important|It is YOUR responsibility to backup your centos3 VM for this assignment!|You are required to frequently backup your VM prior to exiting a work session during this assignment, you . Your instructor will demonstrate NOT accept the skills fact that your hard disk crashed and lost all of your work. If you have learned properly backed up your VM images and xml configuration files to this point by configuring two services: a '''database server''' USB, then you can purchase a new hard-disk or wipe and a '''web server'''. You will install recreate your hard disk and use a database-backed web application, '''Wordpress''', to show that these services have been installed properly. You will also configure the '''SELinux''' security system to further enhance the security of restore your computer system. '''NOTE: Do this assignment inside the centos3 virtual machineVMs. '''}}

== Installing Packages==

== Configuring Apache ==

# Confirm that you can connect to your web server using a web browser -- both from centos3 (you can test using '''linkslynx''') as well as from the host. You should see the Apache Test Page.

== Configuring MySQL ==

# Set your MySQL root password to your learn ID Seneca e-mail username (without the ''@senecac.onmyseneca.ca '' part).

## '''NOTE: If you decide to download the wordpress package during this section, please use the 5.0.x version here (use wget): https://wordpress.org/wordpress-5.0.7.tar.gz'''## Start by looking at httphttps://codex.wordpress.org/Installing_WordPresssupport/article/creating-database-for-wordpress/#Using_the_MySQL_Client using-the-mysql-client where you will find instructions for the setup.

## Your wordpressusername is your learn IDSeneca username## The password should also be your learn IDSeneca username

== Installing and Configuring Wordpress ==

# '''Download the latest 5.tar0.gz x version from wodpress.org into of wordpress to your centos3 VM here (use wget): https://wordpress.org/wordpress-5.0.7.tar.gz'''

# Now we need to allow Apache to modify the wordpress installation. To do this use <b>chown </b> and <b>chgrp</b> with <b>-R </b> option to make the owner and group of every file and directory inside wordpress "apache".

#* Change the DB_NAME, DB_USER, DB_PASSWORD to the appropriate values.'''(Do not use the root account for your database connection! Marks will be deducted.)'''

#* Set the title to Your Name's Blog. For example for me it would be "Andrew SmithOPS235 Professor's Blog"

== Write-up ==

Write a second post on your blog explainingincluding for example:

== Submitting Your Assignment == '''Due date:''' Check with your professor for the due dates on this assignment and how they choose to mark it. Assignments submitted after the due date will receive a grade of 0, but must still be completed satisfactorily in order to pass the course.

=== Ready Open one or more terminals in c7host, SSH to centos3 from those terminals, and screenshot the following:* '''asg2-01-rpms.png''': List of additional RPMs installed for the assignment* '''asg2-02-apache.png''': Status of the ''httpd'' service* '''asg2-03-mysql1.png''': Status of the ''mysql'' service* '''asg2-04-mysql2.png''': MySQL output of the chained command: '''<code>show ===databases; use mysql; select User,Password from user; use myblog; show tables;</code>'''* '''asg2-05-wordpress.png''': Output of command: '''<code>ls -la /var/www/html/wordpress/</code>'''* '''asg2-06-wpconfig.png''': Output of command: '''<code>head -30 /var/www/html/wordpress/wp-config.php</code>'''* '''asg2-07-firefox.png''': Open a Firefox window to: '''http://centos3/wordpress/'''* '''asg2-08-iptables.png''': Output of command: '''<code>iptables -L -vn --line-numbers</code>'''* '''asg2-09-blogpost1.png''': Your first blog post in Firefox* '''asg2-10-blogpost2.png''': Your second blog post in Firefox

Open one or more terminals in c7host, SSH to centos3 from those terminals, Create a tarball named '''asg2.tar.gz''' containing all the images above and have the following ready:* The correct RPMs are installed* Output of chkconfig --list mysqld* Output of chkconfig --list httpd* MySQL output of: show databases; use mysql; select User,Password from user; use myblog; show tables;* Output of ls -la /var/www/html/wodpress/* Output of head -30 /var/www/html/wodpress/wp-configsubmit it on Blackboard.php* Open a firefox with http://centos3/wordpress/

=== Rubric ===

| Everything ready to show Blog accessed using local hostname resolution || 2 |||-| iptables rules configured correctly || 2 |||-| First blog post || 1 ||

| First Second blog post || 3 1 ||

| Second blog post Submitted correctly || 3 4 ||

| '''Total''' || 18 '''20''' ||