Ubuntu Wiki

I want to create a page for setting up a LAMP server for hobbyists. The current LAMP server page is too confusing for this purpose.

Purpose and scope.

A lot of people are trying out the turn-key LAMP installer from the Dapper server cd. Most people who ask about this on the forums are surprised that there is no GUI. It is also very easy to break the working setup. This guide will help guide the user to install, configure and use the LAMP stack installed on Ubuntu Dapper.

This guide is aimed at the absolute beginner.

1. Installation of LAMP

You can install LAMP on any computer running Ubuntu. You just have to install the packages. There is nothing preventing you from installing the Ubuntu Desktop on a machine and then adding on the Apache2, Mysql and Php packages. You probably will not want to run any desktop applications or even a graphical system (Xorg) on a mission-critical server, since this goes against best security practices. But you are not prohibited from doing this to experiment and learn about LAMP.

The Apache, Mysql and PhP configuration is mostly done via the command line. This is in general because they are not used in a GUI environment. It is actually fairly painless to use the command line to install and configure these applications to work together. That is probably a good reason why there is no GUI tool to configure them presently.

• - stand alone box (headless) - user's current desktop - phpmyadmin and ssh

2. Configuration of database

• - Set up databse

  - set MysqlRoot password - create mysql user with password - Grant priviledges to that user

3. Dynapmic DNS

• - What it does - Stand-alone box - linux router - router appliance

sudo apt-get install apache2 php5 mysql-server ibapache2-mod-auth-mysql php5-mysql phpmyadmin


mysql_install_db --user=mysql

mysql -u root

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');

mysql> GRANT ALL PRIVILEGES ON *.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; 

mysql> \q

Wordpress

sudo apt-get install wordpress php5-gd

sudo ln -s /usr/share/wordpress /var/www/wordpress

sudo sh /usr/share/doc/wordpress/examples/setup-mysql -n (your mysql user) localhost

Browse localhost/wordpress

click on the install.php link

The configuration changes the password of the mysql user. You need to create a different mysql user if you want to set up other web applications.

phpbb2

sudo apt-get install phpbb2-conf-mysql

This will also install phpbb2. The configuration of the phpbb2-conf-mysql will prompt you for the mysql username and password.

read /usr/share/doc/phpbb2/README.Debian

sudo ln -s /usr/share/phpbb2/site /var/www/phpbb

Browse your webserver/phpbb

Moinmoin wiki

sudo apt-get install python-moinmoin libapache2-mod-python2.4 python2.4-twisted miscfiles

read /usr/share/doc/python2.4-moinmoin/README.Debian.gz

Drupal

http://drupal.org/node/260

wge http://ftp.osuosl.org/pub/drupal/files/projects/drupal-4.7.2.tar.gz tar xvzf drupal-4.7.2.tar.gz mv drupal-4.7.2/* drupal-4.7.2/.htaccess /var/www/drupal

mysql -u username -p databasename < /var/www/drupal/database/database.4.1.mysql

edit sites/default/settings.php $db_url = "mysql://joe:mypassword@localhost/mysql";