h1. HOWTO: Install Subversion, Ruby on Rails and Redmine on CentOS5 (& RHEL5)

NOTES
* This HOWTO is written for CentOS 5.2
* Replace [FQDN] with either your IP address or the hostname (or FQDN) which you’ll be using to access the interface.
* Replace [user] with the username under whom's home directory the Subversion repository database will be located. e.g. /home/[user]/svn-repos

* This HOWTO will be using the following variables:
>* You will be running apache as the user ‘apache’
>* The subversion repository root folder will be under /home/[user]/subversion/
>* The vhost's folder locationg will be /var/www/svn
>* The subversion repository to be created will be called ‘example-repo’

Install and set up Subversion
<pre>
yum install mod_dav_svn subversion
</pre>

Add the group [user] to the user apache and make the subversion base URL readable and writable...
<pre>
usermod -aG [user] apache
chmod g+x /home/[user]
mkdir /home/[user]/subversion
chmod g+rwx /home/[user]/subversion
</pre>

Make the web directory:
<pre>
mkdir /var/www/svn
chown apache.apache /var/www/svn
</pre>

Put the following into /etc/httpd/conf.d/svn.conf (this is for a sub-repo called 'example-repo')
<pre>
NameVirtualHost *:80
<VirtualHost *:80>
        DocumentRoot "/var/www/svn"
        ServerName [FQDN]
        <Location /example-repo>
                DAV svn
                SVNPath /home/[user]/subversion/example-repo
                AuthType Basic
                AuthName "Subversion repo"
                AuthUserFile /var/www/passwd
                Require valid-user
        </Location>

        <Directory "/var/www/svn">
        allow from all
        Options +Indexes
        </Directory>
</VirtualHost>
</pre>

Add an HTTP auth user...
<pre>
htpasswd -cm /var/www/passwd [user]
</pre>
Create a proper SVN repository 
<pre>
cd /home/[user]/subversion
su [user] -c "svnadmin create example-repo"
</pre>
Import any SVN repos by doing:
<pre>
su [user] -c "svnadmin load example-repo < /path/to/repo/dump/file"
</pre>

Make sure the permissions are correct
<pre>
chmod g+rwx /home/[user]/subversion
chown -R [user].[user] /home/[user]
</pre>

*+Install Ruby on Rails+*

*NOTE: Ruby on Rails installation requires the EPEL yum repository (at time of writing).
<pre>
su -c 'rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm'
</pre>

Let's get Ruby up and running first... [NOTE: not on an SElinux environment cba with that]
<pre>
yum install httpd httpd-devel apr make gcc-c++ mysql-server mysql ruby ruby-devel ruby-docs ruby-ri \
ruby-libs ruby-mode ruby-tcltk ruby-irb ruby-rdoc fcgi fcgi-devel mod_fcgid rubygems subversion-ruby
</pre>

Now we'll install passenger (aka mod_rails)
<pre>
gem install passenger
passenger-install-apache2-module
</pre>

Create and insert this text into /etc/httpd/conf.d/rails.conf (or alternatively edit the existing svn.conf created when we set up subversion)
NOTE:
* The below configuration is specific to the installation of redmine (hence the DocumentRoot)

<pre>
   LoadModule passenger_module /usr/lib/ruby/gems/1.8/gems/passenger-2.0.6/ext/apache2/mod_passenger.so
   PassengerRoot /usr/lib/ruby/gems/1.8/gems/passenger-2.0.6
   PassengerRuby /usr/bin/ruby

   
NameVirtualHost *:80

   <VirtualHost *:80>
     ServerName 192.168.10.17
     DocumentRoot /var/www/rails/redmine/public
   </VirtualHost>
</pre>

*+Now on to Redmine itself+*
 
Get Redmine 0.8 from http://www.redmine.org/wiki/redmine/Download
<pre>
cd /usr/src
svn co http://redmine.rubyforge.org/svn/branches/0.8-stable redmine-0.8
mkdir /var/www/rails/
cd /var/www/rails/
cp -r /usr/src/redmine-0.8/ redmine/
chown -R apache.apache redmine
cd redmine
</pre>

Create a clean backup of source files
<pre>
tar czf Redmine0.8-clean.tar.gz .
</pre>

Initialise mySQL:
<pre>
service mysqld start
</pre>

To secure mysql:
<pre>
mysql_secure_installation
</pre>

Create a mysql database for redmine...
<pre>
mysql -u<username> -p
</pre>

At the prompt enter:
<pre>
create database redmine character set utf8;
</pre>

Quit with:
<pre>
quit
</pre>

Copy the example database file to the "live" location
<pre>
cd /var/www/rails/redmine
cp config/database.yml.example config/database.yml
</pre>

Enter the appropriate settings for the [production] section ensuring that host is set to 127.0.0.1
<pre>
vim /var/www/rails/redmine/config/database.yml
</pre>

Set up email
<pre>
cd /var/www/rails/redmine
cp config/email.yml.example config/email.yml
</pre>

Enter the appropriate settings for the [production] section ensuring that "address" is set to the *IP address* of the SMTP host
<pre>
vim /var/www/rails/redmine/config/email.yml
</pre>

Install rails for redmine using gem...
<pre>
cd /var/www/rails/redmine/app/
gem install -v=2.1.2 rails
</pre>

Import the redmine database into the live database specified in the above config file
<pre>
cd /var/www/rails/redmine/app/
rake db:migrate RAILS_ENV="production"
</pre>

Install default configuration data in database (this is entirely optional, but recommended).
<pre>
cd /var/www/rails/redmine/app/
rake redmine:load_default_data RAILS_ENV="production"
</pre>

Bring up the testing webserver, once loaded check your config by browsing to http://[FQDN]:3000
<pre>
cd /var/www/rails/redmine/
ruby script/server -e production
</pre>

Make sure your apache config file edits are ok and that the services will start at boot by doing:
<pre>
service httpd configtest
service httpd restart
chkconfig httpd on
chkconfig mysqld on
</pre>

Add the following to your crontab which will create a database backup in the /home/[user] directory
<pre>
/usr/bin/mysqldump -u <user> -p <password> <database> | gzip > /home/[user]/redmine_`date +%y_%m_%d`.gz
</pre>