Redmine

h1. Installing Redmine using an existing redmine DB + MySQL on CentOS 5

{{>toc}}

h2. Requirements:

    * Ruby 1.8.7

    * MySQL 4.1 or higher (recommended)

    * openssl + openssl-devel

    * zlib + zlib-devel

    * Lighttpd

    * fastcgi

    * RubyGems

> # actionmailer (2.3.5)

> # actionpack (2.3.5)

> # activerecord (2.3.5)

> # activeresource (2.3.5)

> # activesupport (2.3.5)

> # cgi_multipart_eof_fix (2.5.0)

> # daemons (1.0.10)

> # fastthread (1.0.7)

> # fcgi (0.8.8)

> # gem_plugin (0.2.3)

> # mongrel (1.1.5)

> # mysql (2.8.1)

> # rack (1.0.1)

> # rails (2.3.5)

> # rake (0.8.7)

> # rmagick (2.0.0)

Lets install all required packages before compiling ruby.

h2. Add rpmforge to depots

<pre>

    yum install wget

    rpm –import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt

    wget http://dag.wieers.com/rpm/packages/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.i386.rpm

    rpm -ihv rpmforge-release-0.3.6-1.el5.rf.i386.rpm

</pre>

Now we will have the latest software that is not updated on official repos.

h2. Installing all required software from repos:

<pre>

    yum install gcc-c++ mysql-server mysql-devel openssl openssl-devel zlib zlib-devel subversion make

</pre>

h2. Start mysql server and change the pasword for user root in mysql (by default its empty):

<pre>

    service mysqld start

    mysqladmin -u root password newpassword

    chkconfig mysqld on

</pre>

Now we should be ready for ruby installation.

h2. Installing Ruby:

<pre>

    wget ftp://ftp.ruby-lang.org/pub/ruby/1.8/ruby-1.8.7.tar.gz

    tar zxvf ruby-1.8.7.tar.gz

    cd ruby-1.8.7

    ./configure

    make && make install

</pre>

h2. Installing RubyGems:

<pre>

    wget http://rubyforge.org/frs/download.php/60718/rubygems-1.3.5.tgz

    tar zxvf rubygems-1.3.5.tgz

    cd rubygems-1.3.5

    ruby setup.rb

</pre>

h2. Installing Rails:

<pre>

    gem install rails -v=2.3.5

</pre>

h2. Installing  Redmine:

<pre>

    useradd -M redmine  # doesn't create home directory

    cd /opt

    svn co http://redmine.rubyforge.org/svn/trunk redmine

    mkdir /opt/redmine/public/plugin_assets

    chown -R redmine:redmine /opt/redmine/public/plugin_assets

    cd redmine

    chown -R redmine:redmine files log tmp

    chmod -R 755 files log tmp

</pre>

h2. Create Database and give access rights

<pre>

mysql -u root -p

create database redmine character set utf8;

create user 'redmine'@'localhost' identified by 'my_password';

grant all privileges on redmine.* to 'redmine'@'localhost';

</pre>

h2. Migrate configuration files:

<pre>

    cp /opt/redmine/config/database.yml.example /opt/redmine/config/database.yml

    # /opt/redmine/config/database.yml

    production:

	  adapter: mysql

	  database: redmine

	  host: localhost

	  username: redmine

	  password: mysql_password

	  encoding: utf8

    cp /opt/redmine/config/email.yml.example /opt/redmine/config/email.yml

    # /opt/redmine/config/email.yml

    production:

	  delivery_method: :smtp

	  smtp_settings:

	    address: 127.0.0.1

	    port: 25

	    domain: mail_server_domain

	    authentication: :none

</pre>

h2. Generate a session store secret:

<pre>

    cd /opt/redmine

    rake config/initializers/session_store.rb

</pre>

h2. Migrate or Install Database :

<pre>

	gem install mysql

	On projects : mysqldump --single-transaction --add-drop-table -u root -p redmine | gzip -9 > redmine.sql.gz

	On new redmine : 

		gunzip redmine.sql.gz

		mysql -u root -p redmine < redmine.sql

	# upgrade the migrated database for the new version	

	RAILS_ENV=production rake db:migrate

	# you will now see the upgrades appear on the screen

        # IF INSTALLING FOR FIRST TIME USE

        RAILS_ENV=production rake redmine:load_default_data

</pre>

h2. Migrate Files if there are any :

<pre>

	On projects : cd /opt/redmine/files

	tar -czf /root/files.tar.gz /opt/redmine/files/*

	On new redmine :

		cp /root/migration/files.tar.gz /opt/redmine/files/		

		tar -zxvf files.tar.gz

</pre>

h2. Test Server :

h3. On new redmine :

<pre>

	cd /opt/redmine

	ruby script/server webrick -p 8000 -e production

</pre>

h3. on a local machine

<pre>

	http://redmine_server_ip_address:8000/

	Login with your current redmine identification, the ldap is already installed

        # Configure ldap authentication

        Administration 

        LDAP Authentication

        New authentication mode

        Name ldap_ServerName

        Host ldap_server_ip_address

        Port 389

        Account cn=ldapuser,o=ldapOrganization

        Password xxxxxxxxxxxx

        Base DN o=ldapOrganization

        On-the-fly user creation  # check this if you want users to be added to redmine when the user logs in, check this

	On new redmine :

	Stop webrick with CTRL-C

</pre>

h2. Install lighttpd

h3. Install packages from Centos

<pre>	

yum install lighttpd lighttpd-fastcgi php-cli

vi /etc/php.ini

	[...]

	cgi.fix_pathinfo = 1

</pre>

h3. Install FastCGI Gem

<pre>

cd /tmp

wget http://www.fastcgi.com/dist/fcgi-2.4.0.tar.gz

tar -zxvf fcgi-2.4.0.tar.gz

cd fcgi-2.4.0

./configure --prefix=/usr/local/fcgi --exec-prefix=/usr/local/fcgi

make

make install

gem install fcgi -r -- --with-fcgi-lib=/usr/local/fcgi/lib --with-fcgi-include=/usr/local/fcgi/include

</pre>

h3. Set Permissions & Create Log Directories

<pre>

chown redmine:redmine -R /var/log/lighttpd

mkdir /var/log/redmine

chown redmine:redmine -R /var/log/redmine

</pre>

h3. Enable dispatch.fgci

<pre>

cd /opt/redmine

cp dispatch.fcgi.example dispatch.fcgi

chown redmine:redmine -R /opt/redmine/public/plugin_assets

</pre>

h2. Lighttpd vhost

<pre>

$HTTP["host"] =~ "redmine\.somecompany\.(eu|fr|net|com)$" {

        server.document-root = "/opt/redmine/public/"

        server.use-ipv6 = "disable"

        fastcgi.debug = 1

        alias.url = ()

        server.indexfiles = ( "dispatch.fcgi" )

        server.error-handler-404 = "/dispatch.fcgi"

        server.errorlog          = "/var/log/redmine/redmine-error.log"

        accesslog.filename       = "/var/log/redmine/redmine-access.log"

        server.follow-symlink    = "enable"

        url.rewrite-once = (

                "^/(.*\..+(?!html))$" => "$0",

                "^/(.*)\.(.*)"        => "$0",

        )

        fastcgi.server = ( 

                ".fcgi" => ( "redmine" => (     

                        "socket"                => "/opt/redmine/tmp/sockets/redmine.socket",

                        "bin-path"              => "/usr/local/bin/ruby /opt/redmine/public/dispatch.fcgi",

                        "min-procs" => 1,

                        "max-procs" => 4, 

                        "idle-timeout" => 120,

                        "check-local" => "disable",

                        "bin-environment" => ( "RAILS_ENV" => "production" ),

                ))

        )

}

</pre>

h2. Test the lighttpd configuration

<pre>

[root@projects ~]# lighttpd -t -f /etc/lighttpd/lighttpd.conf

Syntax OK

</pre>

h2. Install the init script 

<pre>

cp /etc/init.d/lighttpd /etc/init.d/redmine

chkconfig redmine on

</pre>

h2. Start the redmine server

	/etc/init.d/redmine start

h2. Install ImageMagick

<pre>

	yum install tcl-devel libpng-devel libjpeg-devel ghostscript-devel bzip2-devel freetype-devel libtiff-devel

	cd /root/source

	wget http://image_magick.veidrodis.com/image_magick/ImageMagick-6.3.2-9.tar.gz

	tar -zxvf ImageMagick-6.3.2-9.tar.gz 

	cd ImageMagick-6.3.2

	./configure  --prefix=/usr/local --with-bzlib=yes --with-fontconfig=yes --with-freetype=yes --with-gslib=yes 

           --with-gvc=yes --with-jpeg=yes --with-jp2=yes --with-png=yes --with-tiff=yes

	make clean

	make 

	make install

	gem install rmagick -v=2.0 --no-rdoc --no-ri

</pre>

h2. Install the redmine basecamp theme

<pre>

    mkdir /opt/redmine.old/public/themes/basecamp

    mv basecamp.tar.gz basecamp

    cd /opt/redmine.old/public/themes/basecamp/

    tar -zxvf basecamp.tar.gz 

    mkdir -p /opt/redmine/public/themes/basecamp

    cp -Rp stylesheets /opt/redmine/public/themes/basecamp/

</pre>

h2. Install postfix

<pre>

	yum install postfix

	/etc/postfix/main.cf

	relayhost = smtp_server_address:smtp port

	chkconfig postfix on

	/etc/init.d/postfix start

	Add the public address as a host in the networks table on proxmox

</pre>