HowTo Install Redmine 212 in Ubuntu 1210 and Apache Passenger » History » Version 11

Boaz Rymland, 2013-06-21 17:54
If i'm not mistaken: why grant redmine user all on ALL DBs? instead - grant it all on the redmine DB only.

1 1 Julian Perelli
h1. HowTo Install Redmine 212 in Ubuntu 1210 and Apache Passenger
2 1 Julian Perelli
3 1 Julian Perelli
Inspired in "HowTo Install Redmine 210 on Debian Squeeze with Apache Passenger", from this same wiki, so meta-kudos, to the original authors.
4 1 Julian Perelli
5 1 Julian Perelli
h2. Assumptions
6 1 Julian Perelli
7 1 Julian Perelli
* We will be using redmine.example.com; so every time you see this below, replace it by your own domain
8 3 Julian Perelli
* For this to work maybe you shold edit /etc/hosts file adding a line "127.0.0.1 redmine.example.com"
9 1 Julian Perelli
* If you are behind a proxy, you could do export http_proxy="http://proxy.domain.tld:port" and the installation should work ok.
10 1 Julian Perelli
11 1 Julian Perelli
h2. Warming up
12 1 Julian Perelli
13 1 Julian Perelli
We will first need to install basic packages:
14 1 Julian Perelli
<pre>
15 5 ian stoddart
apt-get install ruby rubygems libruby libapache2-mod-passenger ruby-dev
16 1 Julian Perelli
</pre>
17 1 Julian Perelli
Download the latest version of Redmine (2.1.2 in our case) and untar it, then move it to /usr/local/share
18 1 Julian Perelli
<pre>
19 4 Julian Perelli
cd /usr/local/share/
20 2 Julian Perelli
wget http://rubyforge.org/frs/download.php/76495/redmine-2.1.2.tar.gz
21 1 Julian Perelli
tar -xzvf redmine-2.1.2.tar.gz
22 7 ian stoddart
ln -s /usr/local/share/redmine-2.1.2 /usr/local/share/redmine
23 1 Julian Perelli
chown -R root:root /usr/local/share/redmine-2.1.2
24 1 Julian Perelli
</pre>
25 1 Julian Perelli
26 2 Julian Perelli
Install development libraries for MySQL and Imagick:
27 1 Julian Perelli
<pre>
28 2 Julian Perelli
apt-get install libmysqlclient-dev libmagickcore-dev libmagickwand-dev (install shitload of packages)
29 1 Julian Perelli
</pre>
30 1 Julian Perelli
31 1 Julian Perelli
h2. Running the Gem stuff
32 1 Julian Perelli
33 1 Julian Perelli
Install Bundler (removing useless module, which would otherwise create dependencies):
34 1 Julian Perelli
<pre>
35 1 Julian Perelli
gem install bundler
36 1 Julian Perelli
cd /usr/local/share/redmine/
37 3 Julian Perelli
bundle install --without development test postgresql sqlite
38 1 Julian Perelli
</pre>
39 1 Julian Perelli
40 6 ian stoddart
h2. Creating the database
41 6 ian stoddart
42 6 ian stoddart
On a new installation you need to create the database and a user for redmine.
43 6 ian stoddart
Open a mysql command prompt:
44 6 ian stoddart
<pre>
45 6 ian stoddart
mysql -u root -p
46 6 ian stoddart
</pre>
47 6 ian stoddart
48 6 ian stoddart
At the mysql prompt enter the mysql commands:
49 6 ian stoddart
<pre>
50 6 ian stoddart
create user 'redmine' identified by 'redmine';
51 6 ian stoddart
set password for 'redmine'@'localhost' = password('my_password');
52 11 Boaz Rymland
grant all on redmine.* to 'redmine'@'localhost';
53 6 ian stoddart
create database redmine;
54 6 ian stoddart
quit;
55 6 ian stoddart
</pre>
56 6 ian stoddart
57 1 Julian Perelli
h2. Configuration
58 1 Julian Perelli
59 1 Julian Perelli
Copy config/database.yml.example to config/database.yml and edit this file in order to configure your database settings for "production" environment.
60 1 Julian Perelli
Example for a MySQL database using ruby1.8 or jruby:
61 1 Julian Perelli
<pre>
62 1 Julian Perelli
production:
63 10 Roland Giesler
  adapter: mysql2      (note: For Rails < 3.1 use mysql instead of mysql2)
64 1 Julian Perelli
  database: redmine
65 1 Julian Perelli
  host: localhost
66 1 Julian Perelli
  username: redmine
67 1 Julian Perelli
  password: my_password
68 1 Julian Perelli
</pre>
69 1 Julian Perelli
70 1 Julian Perelli
Generate a session store secret:
71 1 Julian Perelli
<pre>
72 3 Julian Perelli
rake generate_secret_token
73 1 Julian Perelli
</pre>
74 1 Julian Perelli
75 1 Julian Perelli
Generate the database structure:
76 1 Julian Perelli
<pre>
77 3 Julian Perelli
RAILS_ENV=production rake db:migrate
78 1 Julian Perelli
</pre>
79 1 Julian Perelli
80 1 Julian Perelli
Generate default configuration data:
81 1 Julian Perelli
<pre>
82 3 Julian Perelli
RAILS_ENV=production rake redmine:load_default_data
83 1 Julian Perelli
</pre>
84 1 Julian Perelli
(using “es” for Spanish language in terminal prompt)
85 1 Julian Perelli
86 1 Julian Perelli
Setup config file in config/configuration.yml
87 1 Julian Perelli
88 1 Julian Perelli
Change database_ciphr_key: *******
89 1 Julian Perelli
<pre>
90 3 Julian Perelli
rake db:encrypt RAILS_ENV=production
91 1 Julian Perelli
</pre>
92 1 Julian Perelli
93 1 Julian Perelli
h2. Apache
94 1 Julian Perelli
95 1 Julian Perelli
Setup Apache’s VirtualHost config
96 1 Julian Perelli
97 1 Julian Perelli
<pre>
98 1 Julian Perelli
# 8080 in this case is because we use a reverse proxy before Apache. Otherwise simply use "*:80"
99 1 Julian Perelli
100 1 Julian Perelli
<VirtualHost *:8080>
101 1 Julian Perelli
 ServerName redmine.example.com
102 1 Julian Perelli
 DocumentRoot /usr/local/share/redmine/public
103 1 Julian Perelli
 <Directory /usr/local/share/redmine/public>
104 1 Julian Perelli
   AllowOverride all
105 1 Julian Perelli
   Options -MultiViews
106 1 Julian Perelli
 </Directory>
107 1 Julian Perelli
</VirtualHost>
108 1 Julian Perelli
</pre>
109 1 Julian Perelli
110 3 Julian Perelli
Once you enable this virtual host (a2ensite redmine.example.com) and reload Apache (apache2ctl graceful), you should see your site running on http://redmine.example.com.
111 1 Julian Perelli
112 1 Julian Perelli
The default login/password is admin/admin (don't forget to change this).
113 1 Julian Perelli
114 1 Julian Perelli
h2. Sources of inspiration
115 1 Julian Perelli
116 1 Julian Perelli
We used the following resources as a starting point. Thanks to their respective authors.
117 1 Julian Perelli
118 1 Julian Perelli
* http://madpropellerhead.com/random/20100820-installing-redmine-on-debian-with-apache (outdated, for Lenny)
119 1 Julian Perelli
* http://www.redmine.org/projects/redmine/wiki/RedmineInstall
120 1 Julian Perelli
* http://hodza.net/2012/03/15/howto-install-redmine-on-debian-6-squeeze-ruby-on-rails-apache2-passenger/
121 1 Julian Perelli
* http://www.redmine.org/projects/redmine/wiki/HowTo_Install_Redmine_on_Debian_with_Ruby-on-Rails_and_Apache2-Passenger