LAMP (Linux Apache Mysql PHP) Configuration in Debian

What is LAMP?

The acronym LAMP refers to a set of free software programs commonly used together to run dynamic Web sites or servers

Linux, the operating system;

Apache, the Web server;

MySQL, the database management system (or database server)

Perl, PHP, and/or Python, scripting languages

If you want to install Debian Linux click here to follow the instructions

Installing Apache2 in Debian

By Default apache2 package you will be given the package apache2-mpm-worker, other packages are available:

apache2-mpm-worker

The worker MPM provides a threaded implementation for Apache2. It is considerably faster than the traditional model, and is the recommended MPM.

apache2-mpm-prefork

This Multi-Processing Module (MPM) implements a non-threaded, pre-forking web server that handles requests in a manner similar to Apache 1.3. It is appropriate for sites that need to avoid threading for compatibility with non-thread-safe libraries.

#apt-get  install apache2

#apt-get install apache2-mpm-prefork

That's it basic apache2 installation finished.If you want to test your installation go to your browser and type the following

http://youripaddress/apache2-default/

This should display welcome message then your installation is correct.

Default document root directory for apache2 is /var/www

If you want to change the default document root directory in apache2 you have to modify /etc/apache2/sites-available/default file.Edit this file and change the path to where ever you want to change.

Installing Mysql Server in debian

To Install MySQL server enter the following command

#apt-get install mysql-server4.1 mysql-client4.1 php4-mysql

Make sure you have all the following lines need to uncomment somewhere in your apache2.conf (or in your conf.d/php.ini) file

;extension=php_mysql.so

so this become

extension=php_mysql.so

If you want to install a web interface for your Mysql server enter the following command

#apt-get install phpmyadmin

After installation finished if you want to access the web interface type the following in you web browser and enter. When it prompts for username and password enter the database root as username and enter the password (By default there is no password for database root user)

http://ipaddress/phpmyadmin/

Installing PHP Support For Apache2

If you want to add support of php and cgi scripts install the following packages
libapache2-mod-php4,php4-cli,php44-common,php4-cgi

# apt-get install libapache2-mod-php4 php4-cli php4-common php4-cgi

Make sure you have all the following lines need to uncomment somewhere in your apache2.conf (or in your conf.d/php.ini) file:

LoadModule php4_module modules/libphp4.so

# Cause the PHP interpreter to handle files with a .php extension.
AddType application/x-httpd-php .php

If you want to allow the different index files types check for the following line in /etc/apache2/apache2.conf file

DirectoryIndex index.html index.cgi index.pl index.php index.xhtml index.shtml

Restart the apache server

#/etc/init.d/apache2 restart

Installing ASP Support For Apache in Debian

If you want to install ASP support for your apache server you need to install libapache-asp-perl package in Debian

perl Apache::ASP - Active Server Pages for Apache with mod_perl

This perl module provides an Active Server Pages port to the Apache Web Server with perl as the host scripting language. Active Server Pages is a web application platform that originated with the Microsoft NT/IIS server. Under Apache for Unix and Win32 platforms it allows a developer to create dynamic web applications with session management and embedded perl code.

This is a portable solution, similar to ActiveState's PerlScript for NT/IIS ASP. Work has been done and will continue to make ports to and from this implementation as smooth as possible.

#apt-get install libapache-asp-perl