1,576
edits
Changes
m
{{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>
== Introduction and Purpose =='''NOTE: Do this assignment inside the centos3 virtual machine. '''
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 ==
== Configuring MySQL ==
== Installing and Configuring Wordpress ==
== Write-up ==
Open one or more terminals in All screenshots must be full c7host, SSH to centos3 from those terminalsdesktop captures, and have the following ready:* contain no errors. The correct RPMs are installed* Status of fewer total images, the mysql service* Status of the httpd service* MySQL output of: show databases; use mysql; select Userbetter. Submit through Blackboard,Password from user; use myblog; show tables;* Output of ls -la /var/www/html/wordpress/* Output of head -30 /var/www/html/wordpress/wp-configunless told otherwise by your professor.php* Open a Firefox window with http://centos3/wordpress/
=Open one or more terminals in c7host, SSH to centos3 from those terminals, and screenshot the following:* List of additional RPMs installed for the assignment* Status of the ''mysql'' service* Status of the ''httpd'' service* MySQL output of the chained command: '''<code>show databases; use mysql; select User,Password from user; use myblog; show tables;</code>'''* Output of command: '''<code>ls -la /var/www/html/wordpress/</code>'''* Output of command: '''<code>head -30 /var/www/html/wordpress/wp-config.php</code>'''* Output of command: '''<code>iptables -L -vn --line-numbers</code>'''* Open a Firefox window to: '''http://centos3/wordpress/''' == Rubric ===
→Rubric
= OPS235 Assignment 2 Introduction and Purpose =
'''Weight:''' 5% of the overall grade
'''Due Date:''' Week 13 <br />Refer to your instructor for submission instructions12
'''Submission:''' You will be submitting your completed work through a series of screenshots on Blackboard. (See below.)
<u>Install these packages using ''yum''</u>
:*Download a "zipped tar-ball" from a website (google-search), decompress, and compile
# Start the httpd service using '''systemctl'''.
# Ensure that the httpd service starts automatically during boot.
# 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.
# If you can't connect to it from outside the machine - perhaps your firewall is blocking access to the web server.
# Start the MySQL service (mysqld or mariadb) using '''systemctl'''.
#* If you do not see any messages, research how you can secure the MySQL installation and set the MySQL-root password.
#* Read those messages carefully, you are setting up a production MySQL server and there shouldn't be any "test" databases or anonymous users or users without a password.
# Set your MySQL root password to your learn ID Seneca e-mail username (without the ''@senecac.onmyseneca.ca '' part).
# This following part is challenging so take your time and read the instructions to make sure you do it properly, we have to set up a dedicated user and database for wordpress:
## '''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.
## You will need to run those commands in a centos3 terminal.
## Your adminusername is root
## Your databasename is myblog
## Your wordpressusername is your learn IDSeneca username## The password should also be your learn IDSeneca username
## Your hostname is localhost
Wordpress (like most web applications) is not available in the Fedora repositories, it must be downloaded and installed manually.
# '''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'''
# Extract it into '''/var/www/html'''
# 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".
# Check your work so far by pointing your web browser to http://centos3/wordpress/ where you will get an error starting with "There doesn't seem to be a wp-config.php file"
# Copy the wp-config-sample.php file to wp-config.php and edit the new file:
#* 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.)'''
# Now go back to http://centos3/wordpress/ - you should see a Wordpress Welcome/Setup page.
#* Set the title to Your Name's Blog. For example for us me it would be "OPS235 Professor's Blog"
#* Set the password to your learn ID.
#* Set the email to your Seneca email address.
#* Click "Install Wordpress", you should see a "Success!" message.
Write a blog post on your new blog explaining:
''' Make your posts look professional. That means use good english, headings, bullet or numbered lists, etc.
=Configuring iptables =Now that you've set up your blog, you must secure your firewall. The purpose of this section is to lock down your rules as much as possible.# You must be using iptables (firewalld should be uninstalled).# Your INPUT chain's default policy must be set to DROP.# Create INPUT chain exceptions (rules) to allow connections to your blog.# Other than the specific ports needed to access your blog, the only other allowed exception is for SSH.# '''Tip''': Your OUTPUT chain should allow ''all'' traffic. (You can leave it at its default) = Submitting Your Assignment ==
'''Due date:''' Your name will be called in Check with your professor for the lab due dates on the due date for the this assignment. If you are not there when your name is called - you will lose 20% of your and how they choose to mark. In that case you may show me your submission in the second lab that week insteadit. Assignments submitted after that the due date will receive a grade of 0, but must still be completed satisfactorily in order to pass the course.
=== Ready to show =Online Submission Requirements ==
{| class="wikitable" border="1"
| Wordpress showing in Firefox || 1 ||
|-
| Everything ready to show iptables rules configured correctly || 2 |||-| Blog accessed using local hostname resolution || 2 ||
|-
| First blog post || 3 ||
| Second blog post || 3 ||
|-
| '''Total''' || 18 '''20''' ||
|}
[[Category:OPS235]]
[[Category:Summer 2020]]
[[Category:Digital Classroom]]
