CECS 5450

Internet Services

Spring 2003


Assignment #5

Due Date: April 8, 2003

Value: 15 points total

Submission: MySQL (Stage 1), Web Based Database (Stage 2 - if we can figure out gcc problem)

  1. Send the instructor an e-mail telling when you have completed the first part. Send along the system name, port number of the database, root password for access, and the URL of the web pages to greg@tapr.org.
  2. Post an e-mail to the class list containing the written part of the assignment (part 2). Use the following subject line: Your Name - Assignment 5

Part 1 (10 pts)

      1. Install and Configure MySQL (Stage 1)
      2. Create the web-based database-driven system outlined in the RedHat Book (p 161)

Part 2 (5 pts)

  • Locate and read, from any professional journal, two articles relevant to the area of the methods for delivering audio and video content in a network environment and/or on there advantages and disadvantages of the approaches. Write a two paragraph review for each article. The 1st paragraph should describe the contents of the article. The 2nd paragraph should be your reaction to the article. Do not forget to include the reference cite. Use APA format.

  • Reply to at least two postings in a meaningful manner. Be sure to include your name in the subject line like: Re: There Name - Assignment #5 - Your Name

Stage 1 - MySQL Install

Read pages 161-162

Refer to this section instead of page 163, Steps 1, 2, and 3.

Installing and getting MySQL Operational without RPM
Steps for MySql 4.0.12

Visit http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.0%2Fmysql-standard-4.0.12-pc-linux-i686.tar.gz&pick=mirror

Place in /usr/local/src

gunzip mysql-standard-4.0.12-pc-linux-i686.tar.gz

tar -xvf mysql-standard-4.0.12-pc-linux-i686.tar

create a directory link between /usr/local/mysql and the new mysql directory
shell> ln -s /usr/local/src/mysql-standard-4.0.12-pc-linux-i686 /usr/local/mysql

NOTE: The mysql-standard-4.0.12-pc-linux-i686 will change depending on the version of mysql you downloaded and the entire path will depend on where you downloaded the mysql source to. In this case, I downloaded it into /usr/local/src

Add a user and group for mysql. These commands add the mysql group and the mysql user.
shell> groupadd mysql
shell> useradd -g mysql mysql

Change into the intended installation directory:
shell> cd /usr/local

Continue with the install
shell> cd /usr/local/mysql

shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .

Begin the mysql deamon
shell> bin/mysqld_safe --user=mysql &

When you are ready to automate the start of the process:
Later on add this command to the rc.local
/usr/local/mysql/support-files/mysql.server start

Note: Any new data goes into /usr/local/mysql/data

Ways to test
shell> cd /usr/local/mysql/bin
shell> ./mysqladmin version
This should return the version

continue with Step 4 on page 163

RedHat 165 - 168
Error on Page 168
be sure to add a value for the Owner field. That field is missing from the example and you will get the following error if you leave it out.

ERROR 1136: Column count doesn't match value count at row 1