Project

General

Profile

RedmineInstall » History » Version 67

Jean-Philippe Lang, 2009-11-21 11:32
bug in PosgtreSQL 8.4.0

1 1 Jean-Philippe Lang
h1. Installing Redmine
2
3
{{>TOC}}
4
5
h2. Requirements
6
7 25 Jean-Philippe Lang
h3. Operating system
8 1 Jean-Philippe Lang
9 25 Jean-Philippe Lang
Redmine should run on most Unix, Linux, Mac and Windows systems as long as ruby is available on this platform.
10
11
h3. Ruby & Ruby on Rails
12
13 30 Jean-Philippe Lang
The required Ruby and Ruby on Rails versions for a given Redmine version is:
14 25 Jean-Philippe Lang
15 30 Jean-Philippe Lang
|_. Redmine version|_. Supported Ruby versions|_. Required Rails version|
16 58 Eric Davis
|current trunk|ruby 1.8.6, 1.8.7|Rails 2.3.4|
17
|trunk from r2493 to r2886|ruby 1.8.6, 1.8.7|Rails 2.2.2|
18 32 Jean-Philippe Lang
|trunk before r2493|ruby 1.8.6, 1.8.7|Rails 2.1.2|
19 30 Jean-Philippe Lang
|0.8.x|ruby 1.8.6, 1.8.7|Rails 2.1.2|
20
|0.7.x|ruby 1.8.6|Rails 2.0.2|
21 22 Jean-Philippe Lang
22
Official releases include the appropriate Rails version in their @vendor@ directory. So no particular action is needed.
23 1 Jean-Philippe Lang
If you checkout the source from the Redmine repository, you can install a specific Rails version on your machine by running:
24
25 32 Jean-Philippe Lang
  gem install rails -v=2.2.2
26 25 Jean-Philippe Lang
27 28 Jean-Philippe Lang
Notes:
28 27 Jean-Philippe Lang
* RubyGems 1.3.1 is required
29 25 Jean-Philippe Lang
* Rake 0.8.3 is required
30 1 Jean-Philippe Lang
31 25 Jean-Philippe Lang
h3. Database
32
33 50 Mat Tipton
* MySQL 4.1 or higher (recommended) [One exception- the ruby mysql gem does not currently support mysql 5.1]
34 1 Jean-Philippe Lang
35 35 Jean-Philippe Lang
 * make sure to install the C bindings for ruby that dramatically improve performance. You can get them by running @gem install mysql@.
36
37
* PostgreSQL 8
38
39
 * make sure your database datestyle is set to ISO (Postgresql default setting). You can set it using: @ALTER DATABASE "redmine_db" SET datestyle="ISO,MDY";@
40 67 Jean-Philippe Lang
 * a bug in PostgreSQL 8.4.0 affects Redmine behaviour (#4259), this is fixed in PostgreSQL 8.4.1
41 35 Jean-Philippe Lang
42
* SQLite 3
43 26 Jean-Philippe Lang
44 25 Jean-Philippe Lang
h3. Optional components
45 23 Jean-Philippe Lang
46 25 Jean-Philippe Lang
      * SCM binaries (eg. @svn@), for repository browsing (must be available in your PATH). See [[RedmineRepositories]] for SCM compatibility and requirements.
47
      * "RMagick":http://rmagick.rubyforge.org/ (to enable Gantt export to png image)
48 56 Eric Davis
      * "Ruby OpenID Library":http://openidenabled.com/ruby-openid/ (to enable OpenID support) [only on Redmine trunk / 0.9-dev]  Version 2 or greater is required.
49 1 Jean-Philippe Lang
50 8 Thomas Lecavelier
h2. Installation
51 1 Jean-Philippe Lang
52 6 Jean-Philippe Lang
1. [[Download]] and extract the archive or [[CheckingoutRedmine|checkout]] Redmine.
53
54 36 Yclept Nemo
2. Create an empty database and accompanying user named @redmine@ for example.
55 6 Jean-Philippe Lang
56
For MySQL:
57 1 Jean-Philippe Lang
58 38 Yclept Nemo
<pre>
59 39 Yclept Nemo
create database redmine character set utf8;
60
create user 'redmine'@'localhost' identified by 'my_password';
61
grant all privileges on redmine.* to 'redmine'@'localhost';
62 38 Yclept Nemo
</pre>
63 1 Jean-Philippe Lang
64 63 Thanos Kyritsis
For PostgreSQL:
65
66
<pre>
67
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
68 64 Thanos Kyritsis
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
69 63 Thanos Kyritsis
</pre>
70
71 3 Jean-Philippe Lang
3. Copy @config/database.yml.example@ to @config/database.yml@ and edit this file in order to configure your database settings for "production" environment.
72 1 Jean-Philippe Lang
73 14 Jean-Philippe Lang
Example for a MySQL database:
74
75
<pre>
76
production:
77
  adapter: mysql
78
  database: redmine
79
  host: localhost
80 40 Yclept Nemo
  username: redmine
81
  password: my_password
82 3 Jean-Philippe Lang
</pre>
83
84 54 Barbara Post
If your server is not running on the standard port (3306), use this configuration instead:
85
86
<pre>
87
production:
88
  adapter: mysql
89
  database: redmine
90
  host: localhost
91
  port: 3307
92
  username: redmine
93
  password: my_password
94
</pre>
95
96
97
Example for a PostgreSQL database (default port):
98 44 Alexey Lustin
99
<pre>
100
production:
101
  adapter: postgresql
102
  database: <your_database_name>
103
  host: <postgres_host>
104
  username: <postgres_user>
105 46 Istvan DEMETER
  password: <postgres_user_password>
106 44 Alexey Lustin
  encoding: utf8
107
  schema_search_path: <database_schema> (default - public)
108
</pre>
109
110 57 Eric Davis
4. Generate a session store secret.  This is only required on the *trunk* version of Redmine at r2493 or above.  Users installing a released version of 0.8.x can skip this step.
111 1 Jean-Philippe Lang
112 48 Mat Tipton
Redmine stores session data in cookies by default, which requires a secret to be generated. This can be done by running:
113 41 Yclept Nemo
114 61 Ethan Fremen
   rake config/initializers/session_store.rb
115 41 Yclept Nemo
116
5. Create the database structure, by running the following command under the application root directory:
117
118 62 Vladimir L
  RAILS_ENV=production rake db:migrate
119 1 Jean-Philippe Lang
120
It will create tables and an administrator account.
121
122 41 Yclept Nemo
6. Insert default configuration data in database, by running the following command:
123 1 Jean-Philippe Lang
124 62 Vladimir L
  RAILS_ENV=production rake redmine:load_default_data
125 32 Jean-Philippe Lang
126
This step is optional but *highly recommended*, as you can define your own configuration from scratch. It will load default roles, trackers, statuses, workflows and enumerations.
127
128
7. Setting up permissions
129
130 14 Jean-Philippe Lang
NB: _Windows users have to skip this section._
131
132
The user who runs Redmine must have write permission on the following subdirectories: @files@, @log@, @tmp@ (create the last one if not present).
133
134
Assuming you run Redmine with a @redmine@ user:
135
136 31 Eric Davis
<pre>
137 1 Jean-Philippe Lang
mkdir tmp public/plugin_assets
138 31 Eric Davis
sudo chown -R redmine:redmine files log tmp public/plugin_assets
139 14 Jean-Philippe Lang
sudo chmod -R 755 files log tmp public/plugin_assets
140
</pre>
141 1 Jean-Philippe Lang
142 32 Jean-Philippe Lang
8. Test the installation by running WEBrick web server:
143 1 Jean-Philippe Lang
144 33 Jean-Philippe Lang
  ruby script/server webrick -e production
145 1 Jean-Philippe Lang
146 14 Jean-Philippe Lang
Once WEBrick has started, point your browser to http://localhost:3000/. You should now see the application welcome page.
147 1 Jean-Philippe Lang
148 32 Jean-Philippe Lang
9. Use default administrator account to log in:
149 1 Jean-Philippe Lang
150
    * login: admin
151 14 Jean-Philippe Lang
    * password: admin
152 1 Jean-Philippe Lang
153
You can go to @Admin & Settings@ to modify application settings.
154
155 21 Jean-Philippe Lang
h2. SMTP server Configuration
156
157
h3. 0.8.x releases
158
159 66 Henry Bernard
Copy @config/email.yml.example@ to @config/email.yml@ and edit this file to adjust your SMTP settings.
160 21 Jean-Philippe Lang
161 45 Cyber Sprocket
See the [[Email Configuration|email configuration]] examples.
162
163 1 Jean-Philippe Lang
h3. 0.7.x releases
164
165
In config/environment.rb, you can set parameters for your SMTP server:
166
167
    * config.action_mailer.smtp_settings: SMTP server configuration
168 7 Thomas Lecavelier
    * config.action_mailer.perform_deliveries: set to false to disable mail delivering
169 11 Jean-Philippe Lang
170
Don't forget to restart the application after any change.
171
172
h2. Backups
173
174
Redmine backups should include:
175
* data (stored in your redmine database)
176
* attachments (stored in the @files@ directory of your Redmine install)
177
178
Here is a simple shell script that can be used for daily backups (assuming you're using a mysql database):
179
180
<pre>
181
# Database
182 55 Lukasz Slonina
/usr/bin/mysqldump -u <username> -p<password> <redmine_database> | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz
183 11 Jean-Philippe Lang
184
# Attachments
185 1 Jean-Philippe Lang
rsync -a /path/to/redmine/files /path/to/backup/files
186
</pre>