Database/WebApp

Due : December 3, 2007

Assignment: 
Install and configure a DBMS server and an application that uses it.

Requirements: 

• Install the DBMS and configure it for security.
• Configure the DBMS for use by local users and limited network users.
• Install and configure a web appliation to use the DBMS.

Install the DBMS and configure it for security: 

• Install the mysql-server and mysql-client packages.
• Configure the root mysql account with an appropriate password.
• Remove any unnecessary default accounts and databases from the configuration. This includes accounts with no name, and the databases with test in their names.

Configure the DBMS for use by local users and limited network users: 

• For each group in the accounts assignment, create a database. Name the database after the group.
• For each group, create a DBMS account. Name the mysql user after the group. Use an appropriate password.
• Give the mysql users all normal privileges to their databases.

Install and configure a web appliation to use the DBMS: 

• Download and install phpBB so that the URL http://www.group.yourdomain/forum/ will find phpBB configured for the group users.
• Customize the setup for the group.
• Repeat the above steps for each of the groups.

Pass-off Procedure: 

• Using the CIT submission system, submit a file to IT3100, DBMS.
• The file should be named dbms_info.txt. This file must be a plain text file, with the following format:

  mysql: ip_address_of_the machine with mysql server installed.
  http:  ip_address_of_the machine with phpBB installations.