CACTI

CACTI is an open source networking monitoring and graphing tool.  With this project the student worked with the three different tasks that Cacti handles: data retrieval, data storage, and data presentation.  CACTI was installed on windows server 2008 R2, Windows XP, and Ubuntu.  The student ran into some problems being able to log in to the system on the Server 2008, however resolved them on his own by choosing different install options.  For the data retrieval portion the student used Poller, Windows Operating System Scheduler, and Unix Crontab.  Next the student create a SQl database, a Flat file database, and a RRDTool that consolidates historical data.  Lastly the data was presented through the use of the RRDTool which is a built-in graphing function.  By using this tool Cacti is able to deploy customized graphing reports based on time series data that is collected from different SNMP-capable devices.  In the end the student learned how to add a device in Cacti and how to build graphs.

Project Student: Kashif Rauf

Installing Oracle

The desired outcome for this project was to install Oracle database and make remote access to the database.  The student started by installing Windows XP SP3 onto a virtual machine within VMware.  Next, the student installed Oracle database without any issues.  When the student tried to connect to the Oracle database remotely, problems rose.  The problem with this was the address that was needed had already been linked to the old IP of the old oracle server.  The student tried to set the static IP address of the old Oracle server on the new oracle server, but Oracle crashed.  The student was unable to complete the project due to these problems.

 Project Student: Aleksandr Sterkin

Moving Interns Folder Data to the SharePoint

This project consisted of moving the data from the old intern’s folder to the Sharepoint.  The backup of this data was located on the SQL server.  The interns folder is a collection of the previous and present university department students projects including reports and documentation. After gaining remote access to the SQL server the student did some research on the best way to accomplish this project.  The student decided to make all of the folders on the SharePoint by hand and then upload the files via a copy from a flash drive.  SharePoint does not support some of the file extensions that were used so the student had to zip the files and upload them in that fashion. The student was able to complete this project.

 Project Student: Aleksandr Sterkin

Server Room Organization

Throughout the duration of the semester the students worked on keeping the server room organized.  The students sent items that were not functioning to surplus.  Next, the computer wiring for the labs was organized using Velcro.  This maximized the space the students had on the desks to work.

 Student Team Members: Aleksandr Sterkin, Mark Mitchell

SNORT

The goal of this project was to build a Snort Intrusion Detection System (IDS) to monitor sections of an university department.  The initial parameters for the project were for the server to be built in a virtual environment, for the server to have MySQL database on the back end which would be populated with alerts, and then easily queried.  The virtual machine was created to run Ubuntu Server 10.04 LTS. A MySQL database was created which Barnyard2 populated when SNORT flagged a packet to trigger an alert.  SnortReport was also installed to provide a GUI interface for interacting with the database as well as provide preset queries.  After the student finished these steps, the parameters of the project were changed to include email and SMS message alters when snort triggers critical alerts. The student came across several solutions for these requirements finding Snort Alert Monitoring and a combination of sendmail and syslog-ng.  Time did not allow the student to fill these last few requirement changes.

 Project Student: Eric Mikeworth

Image Deployment

During this project the students deployed a windows image that was created by an instructor  to all the desktops in three labs.  The students working on this project moved the machines from one lab to another where they deployed the image to these systems.  After that was finished they moved the machines back up to their original location and checked their functionality.  The final step for this project was to deploy the image to the machines located within two of the labs.

Project Student: Kashif Rauf

Not-For-Profit Network Infrastructure

A Not-For-Profit requested a network infrastructure build.  The student on this project first installed 594 feet of Cat6 and Cat5e cables. The also installed and configured a router as well as installed an antenna to broadcast the wireless signals.

 Student Team Members:  Kashif Rauf, Mark Mitchell, and Tom Zender

Root Certificate Authority

A Certificate Authority (CA) certificate is a digital credential that validates the identity of the CA that owns the certificate.  Within the CA there are public keys in which are assigned which is used to verify the authenticity.  The objective of this project was to setup and implement a Root CA, and Stand Alone CA on an university department domain using Windows Server 2008 Active Directory Certificate services. The student first cloned the virtual machine and then installed active directory domain services onto the virtual machine.  Next, DCpromo was installed and the Enterprise Root CA was configured.  The student then configured the certificates and installed an Online Responder.  After that was successfully completed the Stand Alone CA was configured.  Finally the student tested the CA’s through a web request.

 Project Student: Patrick Owens

Database Experience

The main goal in this project was giving the student the opportunity to gain knowledge and experience in a database environment.  This student went to an Indiana company where he worked with their database administrators on various projects.  The student was able to work with SQL Server 2000, 2005, and 2008.  He was able to create an instance of each, install, and uninstall each.  Next, the student worked on how to create a security scheme that would allow certain users only to do certain things.  He was able to create tables, set permissions, and encrypt a column.  The last project was working on queries.

Project Student: Tom Zender

Not-For-Profit Fire Department

The student on this project began by building a very basic database design but then decided that he wanted to create the database that he would create if he it was his database in this situation.  He created two different database designed and then presented them to his instructors.  After picking the best design he created the database.  After meeting with the client representatives, they needed to do a few more changes to the database.  Due to the changes, the student came up with a fourth prototype and began creating the database but was unable to complete it.

 Project Student: Tom Zender