Redmine 2.1.0 on Ubuntu 12.04, Canaima or Debian 6 with Apache2 and PostgreSQL

Redmine is a project management tool that includes an incident tracking system with bug tracking. Other tools included are activity calendar, Gantt charts for visual representation of project timeline, wiki, forum, version control repository viewer, RSS, role-based workflow control, integration with email.

http://en.wikipedia.org/wiki/WEBrick

Redmine By default it uses http, webrick and MySQL as database. It is quite easy to assemble it like this, later we will see why No. mount it this way.

First of all we install the necessary packages:

apt-get install ruby rubygems libruby libapache2-mod-passenger

We download RedMine 2.1.0

wget http://rubyforge.org/frs/download.php/76448/redmine-2.1.0.tar.gz

We install other dependencies

apt-get install libmagickcore-dev libmagickwand-d

Now, we are going to install the first gem, called bundler, this is responsible for installing all the gems that our project needs.

gem install bundler

We move to the directory where Redmine is located

cd /directorio/redmine/

Now, inside the Redmine directory, we execute the bundler gem, so that it downloads and installs all the gems that Redmine needs.

En Debian: /var/lib/gems/1.8/bin/bundle install –without development test postgresql sqlite

En Ubuntu: bundle install –without development test postgresql sqlite

Now, from the development test, we are omitting the installation of the adapters for the database, as we are interested in installing Redmine in Postgresql, we remove it from the line and add another that we want to omit, such as MySQL. Our code looks like this:

bundle install --without development test mysql sqlite

Now we enter the config folder:

cd config
cp database.yml.example database.yml
nano database.yml

We configure the connection data

echo “production:
adapter: postgresql
database: redmine
host: localhost
username: redmine
password: password
encoding: utf8

We run on the console

rake generate_secret_token

We create the structure of the database.

RAILS_ENV=production rake db:migrate

We insert the content into our database.

RAILS_ENV=production rake redmine:load_default_data

We raise the server.

ruby script/rails server webrick -e production

Let http://localhost:3000/

Administration account
login: admin
password: admin

These instructions are valid for Debian and Canaima, they should only be adapted.

Redmine Apache2

First of all, all the steps that were done above. they should not be discarded, we are simply going to adapt Redmine to Apache.

passenger-install-apache2-module

We assign some permissions to Redmine, as you already know Apache works with the user and group www-data

chown -R www-data:www-data files log tmp public/plugin_assets
chmod -R 755 files log tmp public/plugin_assets

We create a symbolic link

ln -s /directorio donde este redmine/redmine-2.1.0/public/ /var/www/redmine

We edit: /etc/apache2/httpd.conf and add the following lines:

RailsEnv production
RailsBaseURI /redmine

So far it may be fine, in my case I had a problem with routing and it was solved like this:

We move to the address:

cd /etc/apache2/sites-enabled

We edit the file 000default

nano 000-default

We add:

Alias ​​/ redmine "/var/www/redmine-2.1.0/public/"

Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order deny, allow
allow from all

I explain the lines

Alias ​​/ redmine = name of our alias has to be the same as the one we assigned RailsBaseURI in /etc/apache2/httpd.conf
"/Var/www/redmine2.1.0/
public / ”= Address of the redmine on your server
So when asking for localhost / redmine it will be executed from apache and not from Webrick, notice the redmine does not go out through port 3000

All a success the pages load in micro seconds.

As a complement. to view the pages that we are using with passenger

passenger-memory-stats

————– Passenger processes ————–
PID VMSize Private Name
------------------
30091 47.8 MB 9.3 MB Passenger spawn server
30158 283.6 MB 115.1 MB Rails: / var / www / gitorious
30613 315.6 MB 133.6 MB Rails: / home / xxxx / org
### Processes: 3
### Total private dirty RSS: 258.02 MB

In my case I unzipped redmine and renamed it with "org"

Ready redmine, running apache2

SMTP service configuration

The great advantage that redmine has is its email notification tool. To activate this quality we must follow the following steps that will allow us to use our gmail account as a notification email for the redmine

We are located in the redmine directory.

cd config


Now we compile the file configuration.yml.example in this way

cp configuration.yml.example configuration.yml


We edit the file

nano configuration.yml

Now we configure said file. Here is a valid configuration that works.

production: email_delivery: delivery_method:: smtp smtp_settings: enable_starttls_auto: true address: "smtp.gmail.com" port: '587' domain: "smtp.gmail.com" authentication:: plain user_name: "xxxx@gmail.com" password : "xxxx"

Installing Plugins example with "Plugin People"

People plugin

• Avatars for local users
• Global user list with flexible ACL
• Implements for users
• Export VCF Person
• Birthday list Next
• New people list

Unzip the plugin in plugins / folder

Run:

bundle install --without sqlite mysql

rake redmine:plugins NAME=redmine_people RAILS_ENV=production

http://redminecrm.com/projects/people/pages/1

Ruby commands

Remove all gems

gem list | cut -d" " -f1 | xargs sudo gem uninstall -aIx

Delete a gem

gem uninstall

gem uninstall -v

Install a gem

gem install

gem install -v

See all installed gems

gem list

Fonts

•  http://www.redmine.org/projects/redmine/wiki/HowTo_Install_Redmine_210_on_Debian_Squeeze_with_Apache_Passenger
• http://www.redmine.org/projects/redmine/wiki/RedmineInstall
• http://www.redmine.org/projects/redmine/wiki/HowTo_Install_Redmine_on_Debian_Squeeze_with_Postgresql_Ruby-on-Rails_and_Apache2-Passenger