3:29 PM 6/29/2009

1. Password protected folder and post code from it
2. Install MySQL, PHP
3. Discuss Homework One

Mohamed, Nathan, Madhuvanthi, Vikas, Logan, YoonMo, 
Daniel, Nick, Sushmitha, Neethu, Rajeswari, Dean, Talgat, 
Francis, Echo, Joe, Jordan, Alex, Hongliu were in attendance. 

1. Install MySQL

Page 47 in the text, start with step 2.

cd /nobackup/username

Step 3: 

cp /l/www/classes/a348/sum2006/software/mysql* .

This creates mysql-5.0.22.tar.gz in that folder. 

Step 4: uncompress and unarchive

  gunzip mysql-5.0.22.tar.gz 
  tar xvf mysql-5.0.22.tar 

Step 5: 

  -bash-3.2$ cd mysql-5.0.22
  -bash-3.2$ pwd
  /nobackup/dgerman/mysql-5.0.22
  -bash-3.2$ 

Step 6: Create a file called step006 and place this in it:

  ./configure --prefix=/nobackup/dgerman/mysql
  make
  make install

Save the file and make it executable: chmod +x step006

Run the file: ./step006

Step 7: Create a file called step007 and place this in it:

  /nobackup/username/mysql/bin/mysql_install_db \
    --user=username \
    --datadir=/nobackup/username/mysql

Run this file: ./step007

Step 8: Now create a file called step008 (to start the server): 

  /nobackup/[username]/mysql/bin/mysqld_safe \
    --user=[username] \
    --pid-file=/nobackup/[username]/mysql/mysqld.pid \
    --log=/nobackup/[username]/mysql/mysqld.log \
    --socket=/nobackup/[username]/mysql/mysql.sock \
    --basedir=/nobackup/[username]/mysql \
    --log-error=/nobackup/[username]/mysqld-error.log \
    --datadir=/nobackup/[username]/mysql \
    --port=[your assigned mysql port] &

But don't do anything with it. Just save it and leave it there. 

Next let's install PHP: 

1. Go to to /nobackup/username 

2. Get the php compressed archive: 

 cp /l/www/classes/a348/sum2006/software/php-5.1.4.tar.gz .

3. Uncompress and unarchive the archive: 

  gunzip php-5.1.4.tar.gz 
  tar xvf php-5.1.4.tar

4. Go into the folder that was created

5. Create a file step005 with this contents:

  ./configure \
    --with-mysql=/nobackup/[username]/mysql \
    --with-apxs2=/u/[username]/apache/bin/apxs \
    --with-config-file-path=/u/[username]/apache/conf \
    --with-xml --enable-track-vars \
    --prefix=/u/[username]/apache

Change the [username] into your own username. 

Make the file executable: chmod +x step005 

Then run it: ./step005

(To be continued tomorrow)