Wednesday, November 26, 2008

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.

2 comments:

Homer said...

Very nicely done. Thank you.

Harinath Mallepally said...

Useful instructions.