CECS 5450Internet Services
Due Date: August 4, 2003
Value: 20 points total
Part 1 (15 pts)
Part 2 (5 pts)
Stage 1 - MySQL InstallI will be reviewing the following two sections at the first of the course to make sure nothing has changed from the Spring Semester. Be warned, these section might change by the time we get to them. - Dr. Jones.
Read pages 161-162
Refer to this section instead of page 163, Steps 1, 2, and 3.
Installing and getting MySQL Operational without RPM
Place in /usr/local/src
tar -xvf mysql-standard-4.0.12-pc-linux-i686.tar
create a directory link between /usr/local/mysql and the new mysql directory
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.
Change into the intended installation directory:
Continue with the install
Begin the mysql deamon
When you are ready to automate the start of the process:
Note: Any new data goes into /usr/local/mysql/data
Ways to test
continue with Step 4 on page 163
RedHat 165 - 168
ERROR 1136: Column count doesn't match value count at row 1
Stage 2 - Interacting with the SQL Server using ScriptsNote This stage requires that we compile some code on the system. Since we did not install the development tools at the first of the course, we need to add those. This is normally done by simply inserting RedHat Disk 2 into the CD drive and selecting the new package to install. For some reason, it is not allowing us to install it. Karl has found a thread that indicates that when RedHat 8 has a power failure (which we have had this semester on the systems) that a problem can be introduced into the RPM database. We are looking into this and I'll let you know about Stage 2 as soon as possible. I am making the notes here for the process, in case some of you want to work on this problem as well. Could be you find someone before I do. If you do, please post to the class list.
The purpose of this section is to get the interface between the PERL scripts and MySQL in palce.
RedHat pages 169-186
Installing Perl DBD and DBI Use the following steps to download and install DBD and DBI on page 170
Scroll down to the latest MySQL DBD driver file (currently DBD-mysql-2.1026.tar.gz 03-Mar-2003 12:46 96K) and click to download it to /usr/local/src
After this is complete, scroll down to download the latest Database Interface driver file (currently DBI-1.35.tar.gz 07-Mar-2003 14:02 281K) to /usr/local/src
gunzip and tar extract both files after downloading.
Move or Copy both folders into the Perl Library directory: /usr/lib/perl5/5.8.0
NOTE: The 5.8.0 directory name will depend on which version of PERL you are running. It was 5.0.8 on my RedHat 8 box, but always check on your system.
Now you need to complie the modules.
Install the Perl MySQL DBI module
Install the Perl MySQL DBD module:
Continue with the RedHat book Step 3, page 170
You should now be able to have web pages that access the mysql database.