IT 3100: Systems Design and Administration I
Database Management (RDBMS)
Due according to the class schedule.
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
Configure the database management system for appropriate security
mysql account with an appropriately
Remove any unnecessary accounts and databases from the
mysql installation. This includes unnamed accounts and
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.
DO NOT even bother checking the output on the autograder until you complete the reverse DNS assignment!!!!
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
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: 220.127.116.11 mysql: database.dsutux.us ns1_ip: 18.104.22.168 ns1: ns1.dsutux.us http_ip: 22.214.171.124 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
- Use the Submisions link at the
top of the page to submit your text file to the
Last Updated 10/12/2020