Course Home | Syllabus | Assignments | Schedule | Downloads | Submissions | [print]

IT 3100: Systems Design and Administration I

Database Management (RDBMS)

Due according to the class schedule.

Assignment

In this assignment, you will use the virtual machine created earlier to act as a database server.

Throughout the semester this server must be functioning correctly.

Configure a system for use as a database management system

Use the machine created in an earlier assignment.

Be sure that the DNS system is correct for this machine.

Be sure that this system is configured correctly as an email satellite system on your network.

Install the RDBMS

Install the server and client packages for mysql on this system.

Install the client package for mysql on the web server system, and the master DNS system (Don’t forget this).

Install the packages on the web server necessary for the scripting system to access the mysql database.

Configure the database management system for appropriate security

Configure the root mysql account with an appropriately secure password.

Remove any unnecessary accounts and databases from the mysql installation. This includes unnamed accounts and databases with test in their names.

Allow remote connections to the database by configuring the listening address to include more than the loopback address.

Create and configure users

Create at least three mysql users that have access to the database management system.

One should be allowed to access only from the localhost.

One should be allowed to access only from the web server.

One should be allowed to access from any system on your LAN.

Configure appropriate passwords for the accounts.

Create and configure databases

Create at least three databases in the system, one for each of the users in the previous section.

Each user should be given all normal access privileges for their individual database.

Database web application

Create or download a web application that requires the use of a database.

Configure the application to use the database created in the previous step for the user that can only access from the web server.

ERRORS

DO NOT even bother checking the output on the autograder until you complete the reverse DNS assignment!!!!

Verification

Use the command line database client to check that each of the three accounts can access their databases from the machines they should be allowed.

Use the command line database client to check that each of the three accounts can not access their databases from the machines they should not be allowed.

Use the installed web application to insure correct functionality of web access to the database. Be sure to test something that is actually using the database.

Submission File Format

The submission file is a UNIX text file, and must have this format, exactly!

The file must be named dbms_info.txt.

mysql_ip: ip_address_of_the machine with mysql server installed.
mysql:    host name of the machine with mysql server installed.
ns1_ip:   ip address of the master dns server
ns1:      host name of the master dns server
http_ip:  ip_address_of_the machine with web server installed.
http:     host name of the machine with web server installed.
user1:    msyql_username:password:database  # localhost only access
user2:    msyql_username:password:database  # webserver only access
user3:    msyql_username:password:database  # full LAN access
url:      url of the web application.
user:     user_name_created_for_email_passoff
pass:     password_for_user

For example, my file might look like this:

mysql_ip: 144.38.214.9
mysql:    database.dsutux.us
ns1_ip:   144.38.214.2
ns1:      ns1.dsutux.us
http_ip:  144.38.214.6
http:     www.dsutux.us
user1:    recluse:%1rTil4^:hermitage
user2:    tarantula:&HS%#Js1:burrow
user3:    extrovert:1053r():party
url:      http://tarzan.dsctux.net/wp/
user:     bbonzai
pass:     $&^bbi13

Submission and Passoff

Last Updated 10/12/2020