Redmine

A free and open source, web-based project management and issue tracking tool. It allows users to manage multiple projects and associated subprojects. It features per project wikis and forums, time tracking, and flexible role based access control. It includes a calendar and Gantt charts to aid visual representation of projects and their deadlines. Redmine integrates with various version control systems and includes a repository browser and diff viewer.

1. install required packages:

    apt-get install redmine-mysql

2. do not setup database connection during setup
3. create new database

   CREATE DATABASE redmine;
   GRANT ALL privileges ON redmine.* TO redmine@localhost IDENTIFIED BY 'redmine';

4. setup database manually in /etc/redmine/database.yaml:

   production:
     adapter: mysql2
     database: redmine
     host: localhost
     port: 
     username: redmine
     password: redmine
     encoding: utf8

5. create database structure:

   bundle exec rake db:migrate RAILS_ENV=production

6. create a symlink to working directory:

   ln -s /usr/share/redmine /var/lib/redmine/default/passenger

7. create apache configuration /etc/apache2/sites-available/redmine.conf:

   Listen 3000
   <VirtualHost *:3000>
           # ServerName my.domain.name
           # this is the passenger config
           RailsEnv production
           # create a link in /var/lib/redmine/default/passenger to /usr/share/redmine
           PassengerAppRoot /var/lib/redmine/default/passenger
           SetEnv X_DEBIAN_SITEID "default"
           Alias "/plugin_assets/" /var/cache/redmine/default/plugin_assets/
           DocumentRoot /usr/share/redmine/public
           <Directory "/usr/share/redmine/public">
                   Order allow,deny
                   Allow from all
           </Directory>
   </VirtualHost>

8. reload apache

   apache2ctl graceful

9. access the redmine on port 3000

https://www.redmine.org/projects/redmine/wiki/HowTo_Migrate_Redmine_to_a_new_server_to_a_new_Redmine_version

1. setup new server following the previous steps
2. copy files from old server to new (files are in /var/lib/redmine/default/files)
3. put db dump from old server to new database