Kubuntu 8.10 with Apache2, PHP 5 and MySQL5

In order to resume testing and developing web based application, I needed PHP, MySQL and Apache to complete the LAMP stack. Default Kubuntu 8.10 did not include those.

Steps taken.
1. Install Apache2 web server
sudo apt-get install apache2

2. Install PHP5 and enable the PHP5 in Apache
sudo apt-get install php5 php-pear
a2enmod php5

3. Install MySQL server
sudo apt-get install php5-mysql libapache2-mod-php5 mysql-server libapache2-mod-auth-mysql

This requires the setup of MySQL root password.

4. Install the Apache and MySQL documentations
sudo apt-get install apache2-doc mysql-doc-5.0

5. Enabled the user public_html directory
cd /etc/apache2/mods-enabled
sudo ln -s ../mods-available/userdir.load
sudo ln -s ../mods-available/userdir.conf

6. Steps to install the training application

1. Create the database "example.db"
   
   
2. Insert into the database with the script.
   mysql -u root -p example.db < mysqldata.sql
   
   
3. Add the mcrypt tools.
   sudo apt-get install libmcrypt4 php5-mcrypt
   
   
4. Add the MySQL pear libraries.
   sudo pear channel-update pear.php.net
   sudo pear install Auth_HTTP
   sudo pear install pear/MDB2#mysql
   
   
5. Test the application.