10
edits
Changes
→Ready to show
= OPS235 Assignment 2 =
'''Weight: ''' 5% of the overall grade
'''Due Date: 8th of August at ''' Week 13 <br />Refer to your instructor for submission instructions {{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. Your instructor will NOT accept the start fact that your hard disk crashed and lost all of classyour work. If you properly backed up your VM images and xml configuration files to a USB, then you can purchase a new hard-disk or wipe and recreate your hard disk and restore your VMs.}}<br>
== Introduction and Purpose ==
In this assignment, you will demonstrate the skills you have learned to this point by configuring two services: a '''database server''' and a '''web server'''. You will install 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 your computer system.
'''NOTE: Do this assignment inside the fedora3 centos3 virtual machine. '''
== Installing Packages using Yum ==
<u>Install these packages using ''yum'':</u>
* '''httpd''' - this is the Apache web server software.
* '''php''' - this is the PHP server software, which allows Apache to run more complex websites.
* '''php-mysql''' - this is a PHP extension that allows PHP to use a MySQL server.
<u>Install the '''mysql-server''' (MySQL database server) package</u>
'''NOTE:''' This package may not be in the main repository. There a couple of options:
:*'''Preferred method:''' Use an alternative package (for example: '''mariadb''' and '''mariadb-server''')
:*Download a "zipped tar-ball" from a website (google-search), decompress, and compile
== Configuring Apache ==
# Start the httpd service using the '''systemctl''' command.
# Ensure that the httpd service starts automatically during boot.
# Confirm that you can connect to your web server using a web browser -- both from fedora3 centos3 (you can test using '''links''') as well as from the host. You should see the Fedora Apache Test Page.# If you can't connect to it from outside the machine - perhaps your firewall is blocking access to the web server.
== Configuring MySQL ==
# Start the MySQL service (mysqldor mariadb) using the '''systemctl''' command.# Ensure that the mysqld /mariadb service starts automatically during boot.# When started You may get messages after starting the MySQL service for the first time. Do not ignore these messages, this service it will print a message telling tell you how to set a password and take other basic steps to secure the the MySQL server. Follow those instructions to set a password, recording the detail of what you do for later use. Look for these #* If you do not see any messages in '''<code>/var/log/messages</code>''', 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 (without the @senecac.on.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:
## Start by looking at http://codex.wordpress.org/Installing_WordPress#Using_the_MySQL_Client where you will find instructions for the setup.
## You will need to run those commands in a fedora3 centos3 terminal.
## Your adminusername is root
## Your databasename is myblog
Wordpress (like most web applications) is not available in the Fedora repositories, it must be downloaded and installed manually.
# Download the latest .tar.gz version from wodpress.org into your fedora3 centos3 (use wget).
# Extract it into '''/var/www/html'''
# Now we need to allow Apache to modify the wordpress installation. To do this use chown -R 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://fedora3centos3/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.
# Now go back to http://fedora3centos3/wordpress/ - you should see a Wordpress Welcome/Setup page.
#* Set the title to Your Name's Blog. For example for me it would be "Andrew Smith's Blog"
#* Set the password to your learn ID.
=== Ready to show ===
Open one or more terminals in f16hostc7host, SSH to fedora3 centos3 from those terminals, and have the following ready:
* The correct RPMs are installed
* Output of systemctl ischkconfig -enabled httpd.service-list mysqld* Output of systemctl ischkconfig -enabled mysqld.service-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-config.php
* Open a firefox with http://fedora3centos3/wordpress/ Save the page (Firefox File menu / Save Page As / HTML only) as yourusername.html and email the professor that page.
=== Rubric ===
| Correct packages installed || 1 ||
|-
| Apache set up and running || 1 2 ||
|-
| MySQL set up correctly || 3 ||
| Wordpress extracted correctly || 1 ||
|-
| Wordpress set up correctly || 1 2 ||
|-
| Wordpress showing in Firefox || 1 ||
|-
|-
| First blog post || 1 3 ||
|-
| Second blog post || 1 3 ||
|-
| '''Total''' || 25 18 ||
|}
[[Category:OPS235]]
