Project

General

Profile

RedmineInstall » History » Version 268

Go MAEDA, 2017-05-07 15:43
Removed Non ASCII URL issue (https://github.com/rails/rails/pull/19689). It has been fixed in Rails 4.2.3 (Redmine 3.0.4) and current versions of Redmine are not affected by this issue.

1 1 Jean-Philippe Lang
h1. Installing Redmine
2
3
{{>TOC}}
4 73 Liraz Siri
5 147 Jean-Philippe Lang
This is the installation documentation for Redmine 1.4.0 and higher. You can still read the document for 1.3.x "here":/projects/redmine/wiki/RedmineInstall?version=146.
6
7 1 Jean-Philippe Lang
h2. Requirements
8
9 25 Jean-Philippe Lang
h3. Operating system
10 1 Jean-Philippe Lang
11 266 Go MAEDA
Redmine should run on most Unix, Linux, [[RedmineInstallOSX|macOS]], [[RedmineInstallOSXServer|macOS Server]] and [[RedmineInstall#Notes-on-Windows-installation|Windows]] systems as long as Ruby is available on this platform.  See specific installation HowTos [[HowTos|here]].
12 25 Jean-Philippe Lang
13 163 Etienne Massip
h3. Ruby interpreter
14 25 Jean-Philippe Lang
15 163 Etienne Massip
The required Ruby versions for a given Redmine version is:
16 1 Jean-Philippe Lang
17 241 Toshi MARUYAMA
|_. Redmine version|_. Supported Ruby versions                                |_. Rails version used|
18 268 Go MAEDA
|current trunk     |ruby 1.9.3[4], 2.0.0[3], 2.1, 2.2[2], 2.3, 2.4[1]         |Rails 4.2            |
19
|3.3               |ruby 1.9.3[4], 2.0.0[3], 2.1, 2.2[2], 2.3                 |Rails 4.2            |
20
|3.2               |ruby 1.9.3[4], 2.0.0[3], 2.1, 2.2[2]                      |Rails 4.2            |
21 1 Jean-Philippe Lang
22 267 Go MAEDA
%{color: red}Support for Ruby 1.9.3, 2.0 and 2.1 has ended by Ruby community.%
23 260 Toshi MARUYAMA
https://www.ruby-lang.org/en/news/2015/02/23/support-for-ruby-1-9-3-has-ended/
24 1 Jean-Philippe Lang
https://www.ruby-lang.org/en/news/2016/02/24/support-plan-of-ruby-2-0-0-and-2-1/
25 267 Go MAEDA
https://www.ruby-lang.org/en/news/2017/04/01/support-of-ruby-2-1-has-ended/
26 260 Toshi MARUYAMA
27 256 Toshi MARUYAMA
*Redmine 3.2 or lower does not support Ruby 2.3*. Redmine 3.3 supports Ruby 2.3.
28 255 Toshi MARUYAMA
29 247 Toshi MARUYAMA
*Redmine does not support JRuby* because some gems do not support Rails 4.2.
30 1 Jean-Philippe Lang
** "activerecord-jdbc-adapter":https://github.com/jruby/activerecord-jdbc-adapter/issues/599
31
** "loofah":https://github.com/flavorjones/loofah/issues/88
32
33 265 Go MAEDA
fn1. Ruby 2.4 is supported by r16355 and later.
34 1 Jean-Philippe Lang
35 265 Go MAEDA
fn2. MinGW Ruby 2.2 had Nokogiri issue (#19419) and it was fixed by "Nokogiri 1.6.7":https://github.com/sparklemotion/nokogiri/issues/1256#issuecomment-160514102 (2015-11-30).
36 237 Toshi MARUYAMA
37 265 Go MAEDA
fn3. At time of writing (3/19/2013), SQL Server support is reported broken with *ruby 2.0.0 under Windows* because of a "database adapter gem incompatibility":https://github.com/rails-sqlserver/tiny_tds/issues/110
38
39
fn4. MRI 1.9.3p327 contains "a bug":http://bugs.ruby-lang.org/issues/7374 breaking plugin loading under Windows which 1.9.3p194 or 1.9.3p392 haven't.
40 212 Etienne Massip
41 164 Etienne Massip
h3. Supported database back-ends
42 92 Knight Samar
43 262 Toshi MARUYAMA
* MySQL 5.0 - 5.5
44 35 Jean-Philippe Lang
45 195 Mischa The Evil
 * make sure to install the C bindings for Ruby that dramatically improve performance. You can get them by running @gem install mysql2@.
46 263 Go MAEDA
 * *MySQL >= 5.6* and *MariaDB* have known issues (#19344, #19395, #17460, #25416).
47 1 Jean-Philippe Lang
48 191 Etienne Massip
* PostgreSQL 8.2 or higher
49 117 Etienne Massip
50 1 Jean-Philippe Lang
 * 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";@
51 146 Etienne Massip
 * some bugs in PostgreSQL 8.4.0 and 8.4.1 affect Redmine behavior (#4259, #4314), they are fixed in PostgreSQL 8.4.2
52 1 Jean-Philippe Lang
53 233 Toshi MARUYAMA
* Microsoft SQL Server
54
55
 * Redmine 2.x: 2008 or higher (since Redmine 2.3.0)
56
 * Redmine 3.x: "2012 or higher":https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/v4.2.3/README.md#activerecord-sql-server-adapter-for-sql-server-2012-and-higher
57 192 Etienne Massip
58
* SQLite 3 (not for multi-user production use!)
59 190 Etienne Massip
60 1 Jean-Philippe Lang
h3. Optional components
61
62
      * SCM binaries (eg. @svn@), for repository browsing (must be available in your PATH). See [[RedmineRepositories]] for SCM compatibility and requirements.
63 215 Etienne Massip
      * "ImageMagick":http://www.imagemagick.org/ (to enable Gantt export to PNG image and thumbnails generation).
64 193 Mischa The Evil
      * "Ruby OpenID Library":http://openidenabled.com/ruby-openid/ (to enable OpenID support). Version 2 or greater is required.
65 1 Jean-Philippe Lang
66
h2. Redmine Version
67
68
It is recommended that the majority of users install the proper point releases of redmine. Redmine currently releases a new version every 6 months, and these releases are considered very usable and stable. It is *not* recommended to install redmine from trunk, unless you are deeply familiar with Ruby on Rails and keep up with the changes - Trunk _does_ break from time-to-time.
69
70 114 Etienne Massip
h2. Installation procedure
71 35 Jean-Philippe Lang
72 165 Etienne Massip
h3. Step 1 - Redmine application
73 26 Jean-Philippe Lang
74 165 Etienne Massip
Get the Redmine source code by either downloading a packaged release or checking out the code repository.
75 1 Jean-Philippe Lang
76 174 Etienne Massip
See the [[Download|download page]] for details.
77 165 Etienne Massip
78 202 Jean-Philippe Lang
h3. Step 2 - Create an empty database and accompanying user
79 165 Etienne Massip
80 1 Jean-Philippe Lang
Redmine database user will be named @redmine@ hereafter but it can be changed to anything else.
81 165 Etienne Massip
82 1 Jean-Philippe Lang
h4. MySQL
83 166 Etienne Massip
84 208 Etienne Massip
<pre><code class="sql">
85
CREATE DATABASE redmine CHARACTER SET utf8;
86
CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'my_password';
87
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
88
</code></pre>
89 1 Jean-Philippe Lang
90 88 Sean Farrell
For versions of MySQL prior to 5.0.2 - skip the 'create user' step and instead:
91 208 Etienne Massip
<pre><code class="sql">
92
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost' IDENTIFIED BY 'my_password';
93
</code></pre>
94
95 1 Jean-Philippe Lang
96
h4. PostgreSQL
97 166 Etienne Massip
98 205 Etienne Massip
<pre><code class="sql">
99 1 Jean-Philippe Lang
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
100
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
101 205 Etienne Massip
</code></pre>
102
103
h4. SQL Server
104
105
The database, login and user can be created within ??SQL Server Management Studio?? with a few clicks.
106
107
If you prefer the command line option with @SQLCMD@, here's some basic example:
108 206 Etienne Massip
109
{{collapse(Show SQL,Hide SQL)
110 205 Etienne Massip
<pre><code class="sql">
111
USE [master]
112
GO
113
114
-- Very basic DB creation
115
CREATE DATABASE [REDMINE]
116 1 Jean-Philippe Lang
GO
117
118 206 Etienne Massip
-- Creation of a login with SQL Server login/password authentication and no password expiration policy
119
CREATE LOGIN [REDMINE] WITH PASSWORD=N'redminepassword', DEFAULT_DATABASE=[REDMINE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
120 205 Etienne Massip
GO
121
122
-- User creation using previously created login authentication
123
USE [REDMINE]
124
GO
125
CREATE USER [REDMINE] FOR LOGIN [REDMINE]
126
GO
127
-- User permissions set via roles
128 207 Etienne Massip
EXEC sp_addrolemember N'db_datareader', N'REDMINE'
129 205 Etienne Massip
GO
130 207 Etienne Massip
EXEC sp_addrolemember N'db_datawriter', N'REDMINE'
131 1 Jean-Philippe Lang
GO
132 205 Etienne Massip
</code></pre>
133 206 Etienne Massip
}}
134 166 Etienne Massip
135 202 Jean-Philippe Lang
h3. Step 3 - Database connection configuration
136 1 Jean-Philippe Lang
137 165 Etienne Massip
Copy @config/database.yml.example@ to @config/database.yml@ and edit this file in order to configure your database settings for "production" environment.
138
139 264 Go MAEDA
Example for a MySQL database (default port):
140 88 Sean Farrell
141 209 Etienne Massip
<pre><code class="yml">
142 1 Jean-Philippe Lang
production:
143
  adapter: mysql2
144
  database: redmine
145
  host: localhost
146
  username: redmine
147
  password: my_password
148
</code></pre>
149 209 Etienne Massip
150 1 Jean-Philippe Lang
If your server is not running on the standard port (3306), use this configuration instead:
151
152
<pre><code class="yml">
153
production:
154 264 Go MAEDA
  adapter: mysql2
155 1 Jean-Philippe Lang
  database: redmine
156
  host: localhost
157
  port: 3307
158
  username: redmine
159
  password: my_password
160 209 Etienne Massip
</code></pre>
161 1 Jean-Philippe Lang
162
Example for a PostgreSQL database (default port):
163
164 209 Etienne Massip
<pre><code class="yml">
165 1 Jean-Philippe Lang
production:
166
  adapter: postgresql
167
  database: <your_database_name>
168
  host: <postgres_host>
169
  username: <postgres_user>
170
  password: <postgres_user_password>
171
  encoding: utf8
172
  schema_search_path: <database_schema> (default - public)
173 209 Etienne Massip
</code></pre>
174 1 Jean-Philippe Lang
175 209 Etienne Massip
Example for a SQL Server database (default host @localhost@, default port @1433@):
176
<pre><code class="yml">
177
production:
178
  adapter: sqlserver
179
  database: redmine
180
  username: redmine # should match the database user name
181
  password: redminepassword # should match the login password
182
</code></pre>
183 202 Jean-Philippe Lang
184
h3. Step 4 - Dependencies installation
185
186
Redmine uses "Bundler":http://gembundler.com/ to manage gems dependencies.
187
188
You need to install Bundler first:
189
190
  gem install bundler
191
192
Then you can install all the gems required by Redmine using the following command:
193
194
  bundle install --without development test
195
196
h4. Optional dependencies
197
198
h5. RMagick (allows the use of ImageMagick to manipulate images for PDF and PNG export)
199
200
If ImageMagick is not installed on your system, you should skip the installation of the rmagick gem using:
201
202
 @bundle install --without development test rmagick@
203
204
205
If you have trouble installing @rmagick@ on Windows, refer to [[HowTo_install_rmagick_gem_on_Windows|this HowTo]].
206
207
h5. Database adapters
208
209 214 Etienne Massip
Redmine automatically installs the adapter gems required by your database configuration by reading it from the @config/database.yml@ file (eg. if you configured only a connection using the @mysql2@ adapter, then only the @mysql2@ gem will be installed).
210
211
Don't forget to re-run @bundle install --without development test ...@ after adding or removing adapters in the @config/database.yml@ file!
212 202 Jean-Philippe Lang
213
h4. Additional dependencies (@Gemfile.local@)
214
215
If you need to load gems that are not required by Redmine core (eg. Puma, fcgi), create a file named @Gemfile.local@ at the root of your redmine directory. It will be loaded automatically when running @bundle install@.
216
217
Example:
218
<pre>
219
# Gemfile.local
220
gem 'puma'
221 1 Jean-Philippe Lang
</pre>
222
223 165 Etienne Massip
h3. Step 5 - Session store secret generation
224 1 Jean-Philippe Lang
225 165 Etienne Massip
This step generates a random key used by Rails to encode cookies storing session data thus preventing their tampering.
226
Generating a new secret token invalidates all existing sessions after restart.
227
228 151 Jean-Philippe Lang
* with Redmine 1.4.x:
229
230
<pre>
231 234 Go MAEDA
bundle exec rake generate_session_store
232 1 Jean-Philippe Lang
</pre>
233 151 Jean-Philippe Lang
234 1 Jean-Philippe Lang
* with Redmine 2.x:
235
236 151 Jean-Philippe Lang
<pre>
237 234 Go MAEDA
bundle exec rake generate_secret_token
238 1 Jean-Philippe Lang
</pre>
239 90 Jiongliang Zhang
240 243 Toshi MARUYAMA
Alternatively, you can store this secret in config/secrets.yml:
241
http://guides.rubyonrails.org/upgrading_ruby_on_rails.html#config-secrets-yml
242
243 165 Etienne Massip
h3. Step 6 - Database schema objects creation
244 90 Jiongliang Zhang
245 165 Etienne Massip
Create the database structure, by running the following command under the application root directory:
246
247 234 Go MAEDA
  RAILS_ENV=production bundle exec rake db:migrate
248 1 Jean-Philippe Lang
249 184 Etienne Massip
Windows syntax:
250 1 Jean-Philippe Lang
251 184 Etienne Massip
 set RAILS_ENV=production
252 234 Go MAEDA
bundle exec rake db:migrate
253 184 Etienne Massip
254
It will create tables by running all migrations one by one then create the set of the permissions and the application administrator account, named @admin@.
255
256
+Ubuntu troubleshooting:+
257 1 Jean-Philippe Lang
258 165 Etienne Massip
If you get this error with Ubuntu:
259 90 Jiongliang Zhang
<pre>
260 114 Etienne Massip
Rake aborted!
261 1 Jean-Philippe Lang
no such file to load -- net/https
262
</pre>
263
264 165 Etienne Massip
Then you need to install @libopenssl-ruby1.8@ just like this: @apt-get install libopenssl-ruby1.8@.
265 1 Jean-Philippe Lang
266 165 Etienne Massip
h3. Step 7 - Database default data set
267 1 Jean-Philippe Lang
268 165 Etienne Massip
Insert default configuration data in database, by running the following command:
269
270 234 Go MAEDA
  RAILS_ENV=production bundle exec rake redmine:load_default_data
271 62 Vladimir L
272 171 Etienne Massip
Redmine will prompt you for the data set language that should be loaded; you can also define the @REDMINE_LANG@ environment variable before running the command to a value which will be automatically and silently picked up by the task.
273
274
E.g.:
275
276
Unices:
277
278 234 Go MAEDA
  RAILS_ENV=production REDMINE_LANG=fr bundle exec rake redmine:load_default_data
279 171 Etienne Massip
280
Windows:
281
<pre>
282
set RAILS_ENV=production
283
set REDMINE_LANG=fr
284 234 Go MAEDA
bundle exec rake redmine:load_default_data
285 171 Etienne Massip
</pre>
286 32 Jean-Philippe Lang
287 167 Etienne Massip
h3. Step 8 - File system permissions
288 32 Jean-Philippe Lang
289 165 Etienne Massip
NB: _Windows users can skip this section._
290 14 Jean-Philippe Lang
291 165 Etienne Massip
The user account running the application must have write permission on the following subdirectories:
292 1 Jean-Philippe Lang
293 165 Etienne Massip
# @files@ (storage of attachments)
294
# @log@ (application log file @production.log@)
295 167 Etienne Massip
# @tmp@ and @tmp/pdf@ (create these ones if not present, used to generate PDF documents among other things)
296 220 Jean-Baptiste Barth
# @public/plugin_assets@ (assets of plugins)
297 221 Jean-Baptiste Barth
298 167 Etienne Massip
E.g., assuming you run the application with a redmine user account:
299 165 Etienne Massip
300 1 Jean-Philippe Lang
<pre>
301 219 Jean-Baptiste Barth
mkdir -p tmp tmp/pdf public/plugin_assets
302 1 Jean-Philippe Lang
sudo chown -R redmine:redmine files log tmp public/plugin_assets
303
sudo chmod -R 755 files log tmp public/plugin_assets
304
</pre>
305
306 165 Etienne Massip
h3. Step 9 - Test the installation
307 1 Jean-Philippe Lang
308 165 Etienne Massip
Test the installation by running WEBrick web server:
309
310 1 Jean-Philippe Lang
* with Redmine 1.4.x:
311
312 151 Jean-Philippe Lang
<pre>
313 234 Go MAEDA
bundle exec ruby script/server webrick -e production
314 1 Jean-Philippe Lang
</pre>
315
316 151 Jean-Philippe Lang
* with Redmine 2.x:
317
318
<pre>
319 234 Go MAEDA
bundle exec ruby script/rails server webrick -e production
320 151 Jean-Philippe Lang
</pre>
321
322 244 Jan Niggemann (redmine.org team member)
* with Redmine 3.x:
323
324
<pre>
325
bundle exec rails server webrick -e production
326
</pre>
327
328 151 Jean-Philippe Lang
Once WEBrick has started, point your browser to http://localhost:3000/. You should now see the application welcome page.
329
330 165 Etienne Massip
> Note: Webrick is *not* suitable for production use, please only use webrick for testing that the installation up to this point is functional. Use one of the many other guides in this wiki to setup redmine to use either Passenger (aka @mod_rails@), FCGI or a Rack server (Unicorn, Thin, Puma, hellip;) to serve up your redmine.
331 14 Jean-Philippe Lang
332 165 Etienne Massip
h3. Step 10 - Logging into the application
333 158 Etienne Massip
334 165 Etienne Massip
Use default administrator account to log in:
335
336 1 Jean-Philippe Lang
    * login: admin
337
    * password: admin
338 14 Jean-Philippe Lang
339 165 Etienne Massip
You can go to ??Administration?? menu and choose ??Settings?? to modify most of the application settings.
340
341 130 Etienne Massip
h2. Configuration
342 1 Jean-Philippe Lang
343 185 Etienne Massip
Redmine settings are defined in a file named @config/configuration.yml@.
344 1 Jean-Philippe Lang
345 185 Etienne Massip
If you need to override default application settings, simply copy @config/configuration.yml.example@ to @config/configuration.yml@ and edit the new file; the file is well commented by itself, so you should have a look at it.
346 1 Jean-Philippe Lang
347 185 Etienne Massip
These settings may be defined per Rails environment (@production@/@development@/@test@).
348 131 Etienne Massip
349
+Important+ : don't forget to restart the application after any change.
350
351 130 Etienne Massip
h3. Email / SMTP server settings
352
353 132 Etienne Massip
Email configuration is described in a [[EmailConfiguration|dedicated page]].
354 1 Jean-Philippe Lang
355
h3. SCM settings
356
357 133 Etienne Massip
This configuration section allows you to:
358 131 Etienne Massip
* override default commands names if the SCM binaries present in the @PATH@ variable doesn't use the standard name (Windows .bat/.cmd names won't work)
359
* specify the full path to the binary
360
361 133 Etienne Massip
Examples (with Subversion):
362 131 Etienne Massip
363 133 Etienne Massip
Command name override:
364 131 Etienne Massip
365
 scm_subversion_command: "svn_replacement.exe"
366
367 133 Etienne Massip
Absolute path:
368 1 Jean-Philippe Lang
369
 scm_subversion_command: "C:\Program Files\Subversion\bin\svn.exe"
370
371
h3. Attachment storage settings
372
373 133 Etienne Massip
You can set a path where Redmine attachments will be stored which is different from the default 'files' directory of your Redmine instance using the @attachments_storage_path@ setting.
374
375
Examples:
376
377
 attachments_storage_path: /var/redmine/files
378
379
 attachments_storage_path: D:/redmine/files
380 130 Etienne Massip
381
h2. Logging configuration
382
383 101 T. Hauptman
Redmine defaults to a log level of :info, writing to the @log@ subdirectory. Depending on site usage, this can be a lot of data so to avoid the contents of the logfile growing without bound, consider rotating them, either through a system utility like @logrotate@ or via the @config/additional_environment.rb@ file.
384 21 Jean-Philippe Lang
385
To use the latter, copy @config/additional_environment.rb.example@ to @config/additional_environment.rb@ and add the following lines. Note that the new logger defaults to a high log level and hence has to be explicitly set to @info@.
386 123 Jean-Philippe Lang
<pre><code class="ruby">
387 21 Jean-Philippe Lang
#Logger.new(PATH,NUM_FILES_TO_ROTATE,FILE_SIZE)
388 162 Jean-Philippe Lang
config.logger = Logger.new('/path/to/logfile.log', 2, 1000000)
389 11 Jean-Philippe Lang
config.logger.level = Logger::INFO
390
</code></pre>
391
392
h2. Backups
393
394
Redmine backups should include:
395
* data (stored in your redmine database)
396
* attachments (stored in the @files@ directory of your Redmine install)
397
398
Here is a simple shell script that can be used for daily backups (assuming you're using a mysql database):
399
400
<pre>
401
# Database
402 55 Lukasz Slonina
/usr/bin/mysqldump -u <username> -p<password> <redmine_database> | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz
403 11 Jean-Philippe Lang
404
# Attachments
405 1 Jean-Philippe Lang
rsync -a /path/to/redmine/files /path/to/backup/files
406
</pre>
407 69 Giuliano Simoncelli
408 216 Jean-Baptiste Barth
h2. Notes on Linux/Unix installation
409
410
Be sure to disable security hardenning tools during the installation process if you run into bizarre permission problems. These problems are mostly silent and can be caused by tools like extended ACLs, SELinux, or AppArmor. There tools are mostly used in big companies with a strict security policy, default Linux/Unix distributions settings shouldn't be a problem.
411
412 69 Giuliano Simoncelli
h2. Notes on Windows installation
413
414 156 Etienne Massip
There is an prebuilt installer of Ruby MRI available from http://rubyinstaller.org.
415
After installing it, select _Start Command Prompt with Ruby_ in the start menu.
416 1 Jean-Philippe Lang
417 156 Etienne Massip
+Specifying the @RAILS_ENV@ environment variable:+
418 69 Giuliano Simoncelli
419 156 Etienne Massip
When running command as described in this guide, you have to set the @RAILS_ENV@ environment variable using a separate command.
420 1 Jean-Philippe Lang
421 156 Etienne Massip
I.e. commands with the following syntaxes:
422 69 Giuliano Simoncelli
423 156 Etienne Massip
<pre>RAILS_ENV=production <any commmand></pre>
424 69 Giuliano Simoncelli
425 156 Etienne Massip
<pre><any commmand> RAILS_ENV=production</pre>
426 1 Jean-Philippe Lang
427 156 Etienne Massip
have to be turned into 2 subsequent commands:
428 69 Giuliano Simoncelli
429 156 Etienne Massip
<pre>set RAILS_ENV=production
430
<any commmand></pre>
431
432
+MySQL gem installation issue:+
433
434
You may need to manually install the mysql gem using the following command:
435
436 69 Giuliano Simoncelli
<pre>
437
gem install mysql
438
</pre>
439 1 Jean-Philippe Lang
440 156 Etienne Massip
And in some case it is required to copy the _libmysql.dll_ file in your ruby/bin directory.
441
Not all libmysql.dll are ok this seem to works http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll.
442
443 186 Jan Niggemann (redmine.org team member)
*Important note for Win7 and later*
444
On Win7 and later, @localhost@ is commented out in the hosts file[1] and IPV6 is the default[2]. As the mysql2 gem does no support IPV6 addresses[3], a connection can't be established and you get the error "@Can't connect to MySQL server on 'localhost' (10061)@".
445
You can confirm this by pinging @localhost@, if ping targets "::1:" IPV6 is being used.
446
447
+Workaround:+
448
Replace @localhost@ with @127.0.0.1@ in database.yml.
449
450
fn1. http://serverfault.com/questions/4689/windows-7-localhost-name-resolution-is-handled-within-dns-itself-why
451
452
fn2. http://www.victor-ratajczyk.com/post/2012/02/25/mysql-fails-to-resolve-localhost-disable-ipv6-on-windows.aspx
453
454
fn3. https://github.com/brianmario/mysql2/issues/279
455
456 80 Jean-Philippe Lang
457
h2. Alternative to manual installation
458
459
Some users may prefer to skip manual installation by using one of the [[Download#Third-party-Redmine-bundles|third-party Redmine bundles]] on the download page.