Ubuntu - Install Redmine + MySQL in Ubuntu 10.04

Introduciton

Redmine is an open source, web-based project management and bug-tracking tool. It includes calendar and gantt charts to aid visual representation of projects and their deadlines. It supports multiple projects. Redmine is free and open source software which provides integrated project management features, issue tracking, and support for multiple version control options.

The design of Redmine is significantly influenced by Trac, a software package with some similar features.

Redmine is written using the Ruby on Rails framework. It is cross-platform and cross-database.

Installation Steps
The following are my steps to install it on the new Ubuntu 10.04 system:
1) install mysql server & phpmyadmin tool

$ sudo apt-get install mysql-server phpmyadmin

You can just set all initial passwords to 'admin'. When finished, you can use http://localhost/phpmyadmin to manage your databases.
2) change mysql database directory (optional, I just want to store it in the /srv directory)

$ mysqladmin -u root -p shutdown
$ sudo mv /var/lib/mysql /srv/
$ sudo vi /etc/mysql/my.cnf (change datadir value from "/var/lib/mysql" to "/srv/mysql")
$ sudo vi /etc/apparmor.d/usr.sbin.mysqld (replace all "/var/lib/mysql" to "/srv/mysql")
$ sudo /etc/init.d/mysql restart (FIXME: doesn't work, I just reboot the system instead)

3) install redmine & redmine-mysql

$ sudo apt-get install redmine redmine-mysql

4) install rails...

$ sudo apt-get install mongrel ruby1.8-dev

5) change redmine files default directory (optional, I prefer to store them in the /srv directory)

$ sudo mv /var/lib/redmine /srv/
$ sudo vi /usr/share/redmine/config/environment.rb (replace all "/var/lib" to "/srv")

6) test redmine

$ cd /usr/share/redmine
$ sudo mkdir /usr/share/redmine/log
$ sudo ruby /usr/share/redmine/scripts/server -e production

(now in PC web-browser, you can use http://localhost:3000 to do the test)
7) configure apache to run redmine

$ sudo apt-get install libapache2-mod-passenger (seems it has been already installed)
$ sudo ln -s /usr/share/redmine/public /var/www/redmine
$ sudo a2enmod passanger (seems already been enabled too)
$ sudo vi /etc/apache2/site-available/default
+ RailsEnv production
+ RailsBaseURI /redmine
$ sudo chown www-data /usr/share/redmine/config/environment.rb
$ sudo /etc/init.d/apache2 reload

That's all. In your PC, you can use: http://localhost/redmine to access Redmine now.