CNT5605 — 2012 Fall
Assignment 8
Journals Due Tuesday, November 20, at the beginning of class.

Assignment: CMS

Your objective is to set up a Content Management System (CMS). It should be available from your Debian machine's ip number (not your CentOS virtual server.)

For this assignment, you will use Drupal 7.17, which is available at (you might note that the White House adopted Drupal back in 2009: White House Uses Open Source To Open Government (October 26, 2009).)

The first step for this assignment is to install a mysql server; unlike the default assumption of Drupal that the mysql server is on the same machine as the webserver, please instead install mysql-server on your virtual CentOS instance.

Inside of mysql, you should then create a new database called drupal, and a new mysql user drupal associated with the webserver ip mentioned in the first paragraph (this is not an actual username on the system — this user is a mysql user, and you should look at the mysql documentation available at to see how to create this user). Remember, the security exercise is going on and this user will need permission to come in from the network since the CMS is going to be running a machine separate from the database server.

Now on the Debian host operating system, download Drupal 7.17 and install it. (Copious documentation is available on the Drupal website.) For content, you may use anything you like (a simple poll, or you can use wget to grab real data from, say,, or perhaps you might want to create some content around a seasonal theme).

On Tuesday, I will use a portion of class to visit each of your Drupal sites so we can all admire your handiwork, so please make sure that everything is working during the class period.

A journal is due for this assignment. Make sure that you document in your journal all of the steps that you went through, following the guidelines on the class home page.

Please turn in a printed copy of this assignment at the beginning of class on Tuesday, November 20th.