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.

1. Installation of LAMP

• - 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";