Project

General

Profile

RedmineInstall » History » Version 318

Mischa The Evil, 2021-08-17 18:47
Added Ruby 2.5 EOL notice and minor fixes for English spelling errors.

1 1 Jean-Philippe Lang
h1. Installing Redmine
2
3
{{>TOC}}
4 73 Liraz Siri
5 310 Go MAEDA
This is the installation documentation for Redmine 4.0 and higher. You can still read the document for older versions: "3.x":/projects/redmine/wiki/RedmineInstall/308 , "1.4.x - 2.6.x":/projects/redmine/wiki/RedmineInstall/263, "1.3.x":/projects/redmine/wiki/RedmineInstall?version=146
6 147 Jean-Philippe Lang
7 1 Jean-Philippe Lang
h2. Requirements
8
9 25 Jean-Philippe Lang
h3. Operating system
10 1 Jean-Philippe Lang
11 301 Go MAEDA
Redmine should run on most Unix, Linux, [[RedmineInstallOSX|macOS]] 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 318 Mischa The Evil
The required Ruby versions for a given Redmine version are:
16 1 Jean-Philippe Lang
17 299 Go MAEDA
|_. Redmine version|_. Supported Ruby versions                       |_. Rails version used|
18 316 Go MAEDA
|trunk (>= r20913) |Ruby 2.5, 2.6, 2.7, 3.0                          |Rails 6.1            |
19 315 Marius BĂLTEANU
|4.2               |Ruby 2.4, 2.5, 2.6, 2.7[1]                       |Rails 5.2            |
20 1 Jean-Philippe Lang
|4.1               |Ruby 2.3, 2.4, 2.5, 2.6                          |Rails 5.2            |
21
22 316 Go MAEDA
fn1. Redmine 4.2 does not support Ruby 2.7.0 and 2.7.1. Use Ruby 2.7.2 or higher (see #31500#note-13).
23 313 Go MAEDA
24
fn2. Redmine prior to 4.0.6 supports Ruby >= 2.2.2. Redmine 4.0.6 and later don't support Ruby 2.2 (see #32787).
25 308 Go MAEDA
26 255 Toshi MARUYAMA
Important notices:
27 294 Go MAEDA
28 318 Mischa The Evil
* %{color: red}Support of Ruby 2.5 and earlier has been ended by the Ruby community.% See the official announcements for details: "2.2":https://www.ruby-lang.org/en/news/2018/06/20/support-of-ruby-2-2-has-ended/, "2.3":https://www.ruby-lang.org/en/news/2019/03/31/support-of-ruby-2-3-has-ended/, "2.4":https://www.ruby-lang.org/en/news/2020/04/05/support-of-ruby-2-4-has-ended/, "2.5":https://www.ruby-lang.org/en/news/2021/04/05/ruby-2-5-9-released/.
29 306 Go MAEDA
* *Redmine does not support JRuby* because "activerecord-jdbc-adapter":https://github.com/jruby/activerecord-jdbc-adapter/issues/599 and "loofah":https://github.com/flavorjones/loofah/issues/88 do not support Rails 4.2 or later.
30 212 Etienne Massip
31 164 Etienne Massip
h3. Supported database back-ends
32 92 Knight Samar
33 302 Go MAEDA
* MySQL 5.5 - 5.7
34 287 Toshi MARUYAMA
35 303 Go MAEDA
 * *MySQL 5.6 or higher* and *MariaDB* have known issues (#19344, #19395, #17460).
36 289 Go MAEDA
37 1 Jean-Philippe Lang
* PostgreSQL 9.2 or higher
38
39 146 Etienne Massip
 * 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 302 Go MAEDA
41 270 Go MAEDA
* Microsoft SQL Server "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
42 192 Etienne Massip
43 311 Go MAEDA
 * Redmine 4.0.0 to 4.0.6 and 4.1.0 don't support SQL Server (#30285, #32737).
44 304 Go MAEDA
45 192 Etienne Massip
* SQLite 3 (not for multi-user production use!)
46 190 Etienne Massip
47 1 Jean-Philippe Lang
h3. Optional components
48
49
      * SCM binaries (eg. @svn@), for repository browsing (must be available in your PATH). See [[RedmineRepositories]] for SCM compatibility and requirements.
50 215 Etienne Massip
      * "ImageMagick":http://www.imagemagick.org/ (to enable Gantt export to PNG image and thumbnails generation).
51 309 Go MAEDA
      * "Ghostscript":https://www.ghostscript.com/ (to enable thumbnails generation for PDF attachments in Redmine 4.1 or later).
52 1 Jean-Philippe Lang
53
h2. Redmine Version
54
55
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.
56
57 114 Etienne Massip
h2. Installation procedure
58 35 Jean-Philippe Lang
59 165 Etienne Massip
h3. Step 1 - Redmine application
60 26 Jean-Philippe Lang
61 165 Etienne Massip
Get the Redmine source code by either downloading a packaged release or checking out the code repository.
62 1 Jean-Philippe Lang
63 174 Etienne Massip
See the [[Download|download page]] for details.
64 165 Etienne Massip
65 202 Jean-Philippe Lang
h3. Step 2 - Create an empty database and accompanying user
66 165 Etienne Massip
67 1 Jean-Philippe Lang
Redmine database user will be named @redmine@ hereafter but it can be changed to anything else.
68 165 Etienne Massip
69 1 Jean-Philippe Lang
h4. MySQL
70 166 Etienne Massip
71 1 Jean-Philippe Lang
<pre><code class="sql">
72 287 Toshi MARUYAMA
CREATE DATABASE redmine CHARACTER SET utf8mb4;
73
CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'my_password';
74
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
75
</code></pre>
76
77
For versions of MySQL "5.5.2":https://dev.mysql.com/doc/relnotes/mysql/5.5/en/news-5-5-3.html or lower - use *utf8* instead of "utf8mb4":https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html
78
79
<pre><code class="sql">
80 208 Etienne Massip
CREATE DATABASE redmine CHARACTER SET utf8;
81
CREATE USER 'redmine'@'localhost' IDENTIFIED BY 'my_password';
82 1 Jean-Philippe Lang
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost';
83
</code></pre>
84 281 Go MAEDA
85 287 Toshi MARUYAMA
For versions of MySQL "5.0.2":https://docs.oracle.com/cd/E17952_01/mysql-5.0-en/grant.html or lower - skip the 'CREATE USER' step and instead:
86 208 Etienne Massip
<pre><code class="sql">
87 287 Toshi MARUYAMA
CREATE DATABASE redmine CHARACTER SET utf8;
88 208 Etienne Massip
GRANT ALL PRIVILEGES ON redmine.* TO 'redmine'@'localhost' IDENTIFIED BY 'my_password';
89
</code></pre>
90 1 Jean-Philippe Lang
91
h4. PostgreSQL
92 166 Etienne Massip
93 205 Etienne Massip
<pre><code class="sql">
94 1 Jean-Philippe Lang
CREATE ROLE redmine LOGIN ENCRYPTED PASSWORD 'my_password' NOINHERIT VALID UNTIL 'infinity';
95
CREATE DATABASE redmine WITH ENCODING='UTF8' OWNER=redmine;
96 205 Etienne Massip
</code></pre>
97
98 296 Go MAEDA
h4. SQLite
99
100
Skip this step. A database file will be created during [[RedmineInstall#Step-6-Database-schema-objects-creation|Step 6]].
101
102 205 Etienne Massip
h4. SQL Server
103
104
The database, login and user can be created within ??SQL Server Management Studio?? with a few clicks.
105
106
If you prefer the command line option with @SQLCMD@, here's some basic example:
107 206 Etienne Massip
108
{{collapse(Show SQL,Hide SQL)
109 205 Etienne Massip
<pre><code class="sql">
110
USE [master]
111
GO
112
113
-- Very basic DB creation
114
CREATE DATABASE [REDMINE]
115 1 Jean-Philippe Lang
GO
116
117 206 Etienne Massip
-- Creation of a login with SQL Server login/password authentication and no password expiration policy
118
CREATE LOGIN [REDMINE] WITH PASSWORD=N'redminepassword', DEFAULT_DATABASE=[REDMINE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
119 205 Etienne Massip
GO
120
121
-- User creation using previously created login authentication
122
USE [REDMINE]
123
GO
124
CREATE USER [REDMINE] FOR LOGIN [REDMINE]
125
GO
126
-- User permissions set via roles
127 207 Etienne Massip
EXEC sp_addrolemember N'db_datareader', N'REDMINE'
128 205 Etienne Massip
GO
129 207 Etienne Massip
EXEC sp_addrolemember N'db_datawriter', N'REDMINE'
130 1 Jean-Philippe Lang
GO
131 205 Etienne Massip
</code></pre>
132 206 Etienne Massip
}}
133 166 Etienne Massip
134 202 Jean-Philippe Lang
h3. Step 3 - Database connection configuration
135 1 Jean-Philippe Lang
136 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.
137
138 264 Go MAEDA
Example for a MySQL database (default port):
139 88 Sean Farrell
140 209 Etienne Massip
<pre><code class="yml">
141 1 Jean-Philippe Lang
production:
142
  adapter: mysql2
143
  database: redmine
144
  host: localhost
145
  username: redmine
146 295 Go MAEDA
  password: "my_password"
147 1 Jean-Philippe Lang
</code></pre>
148 209 Etienne Massip
149 1 Jean-Philippe Lang
If your server is not running on the standard port (3306), use this configuration instead:
150
151
<pre><code class="yml">
152
production:
153 264 Go MAEDA
  adapter: mysql2
154 1 Jean-Philippe Lang
  database: redmine
155
  host: localhost
156
  port: 3307
157
  username: redmine
158 295 Go MAEDA
  password: "my_password"
159 209 Etienne Massip
</code></pre>
160 1 Jean-Philippe Lang
161
Example for a PostgreSQL database (default port):
162
163 209 Etienne Massip
<pre><code class="yml">
164 1 Jean-Philippe Lang
production:
165
  adapter: postgresql
166
  database: <your_database_name>
167
  host: <postgres_host>
168
  username: <postgres_user>
169 295 Go MAEDA
  password: "<postgres_user_password>"
170 1 Jean-Philippe Lang
  encoding: utf8
171
  schema_search_path: <database_schema> (default - public)
172 296 Go MAEDA
</code></pre>
173
174
Example for a SQLite database:
175
176
<pre><code class="yml">
177
production:
178
  adapter: sqlite3
179
  database: db/redmine.sqlite3
180 209 Etienne Massip
</code></pre>
181 1 Jean-Philippe Lang
182 209 Etienne Massip
Example for a SQL Server database (default host @localhost@, default port @1433@):
183
<pre><code class="yml">
184
production:
185
  adapter: sqlserver
186
  database: redmine
187 1 Jean-Philippe Lang
  username: redmine # should match the database user name
188 209 Etienne Massip
  password: "redminepassword" # should match the login password
189 295 Go MAEDA
</code></pre>
190 209 Etienne Massip
191 202 Jean-Philippe Lang
h3. Step 4 - Dependencies installation
192
193
Redmine uses "Bundler":http://gembundler.com/ to manage gems dependencies.
194
195 310 Go MAEDA
You need to install Bundler first if you use Ruby 2.5 or earlier:
196 1 Jean-Philippe Lang
197 202 Jean-Philippe Lang
  gem install bundler
198 1 Jean-Philippe Lang
199
Then you can install all the gems required by Redmine using the following command:
200
201 202 Jean-Philippe Lang
  bundle install --without development test
202
203
h4. Optional dependencies
204
205 310 Go MAEDA
h5. RMagick
206 202 Jean-Philippe Lang
207 310 Go MAEDA
RMagick is an interface between the Ruby programming language and the ImageMagick image processing library. The library is necessary for Redmine prior to 4.1.0 to export gantt charts to PNG or PDF.
208
209
If ImageMagick (6.4.9 - 6.9.10) is not installed on your system and you are installing Redmine 4.0 or earlier, you should skip the installation of the rmagick gem using:
210 202 Jean-Philippe Lang
211
 @bundle install --without development test rmagick@
212
213
214
If you have trouble installing @rmagick@ on Windows, refer to [[HowTo_install_rmagick_gem_on_Windows|this HowTo]].
215
216
h5. Database adapters
217
218 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).
219
220
Don't forget to re-run @bundle install --without development test ...@ after adding or removing adapters in the @config/database.yml@ file!
221 202 Jean-Philippe Lang
222
h4. Additional dependencies (@Gemfile.local@)
223
224
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@.
225
226
Example:
227
<pre>
228
# Gemfile.local
229
gem 'puma'
230 1 Jean-Philippe Lang
</pre>
231
232 165 Etienne Massip
h3. Step 5 - Session store secret generation
233 1 Jean-Philippe Lang
234 165 Etienne Massip
This step generates a random key used by Rails to encode cookies storing session data thus preventing their tampering.
235 151 Jean-Philippe Lang
Generating a new secret token invalidates all existing sessions after restart.
236 1 Jean-Philippe Lang
237 151 Jean-Philippe Lang
<pre>
238 234 Go MAEDA
bundle exec rake generate_secret_token
239 1 Jean-Philippe Lang
</pre>
240 90 Jiongliang Zhang
241 243 Toshi MARUYAMA
Alternatively, you can store this secret in config/secrets.yml:
242
http://guides.rubyonrails.org/upgrading_ruby_on_rails.html#config-secrets-yml
243
244 165 Etienne Massip
h3. Step 6 - Database schema objects creation
245 90 Jiongliang Zhang
246 165 Etienne Massip
Create the database structure, by running the following command under the application root directory:
247
248 271 Toshi MARUYAMA
<pre>
249 278 Toshi MARUYAMA
RAILS_ENV=production bundle exec rake db:migrate
250 271 Toshi MARUYAMA
</pre>
251
252
*Windows syntax:*
253
254
<pre>
255
set RAILS_ENV=production
256 184 Etienne Massip
bundle exec rake db:migrate
257 271 Toshi MARUYAMA
</pre>
258 184 Etienne Massip
259
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@.
260
261
+Ubuntu troubleshooting:+
262 1 Jean-Philippe Lang
263 165 Etienne Massip
If you get this error with Ubuntu:
264 90 Jiongliang Zhang
<pre>
265 114 Etienne Massip
Rake aborted!
266 1 Jean-Philippe Lang
no such file to load -- net/https
267
</pre>
268
269 165 Etienne Massip
Then you need to install @libopenssl-ruby1.8@ just like this: @apt-get install libopenssl-ruby1.8@.
270 1 Jean-Philippe Lang
271 165 Etienne Massip
h3. Step 7 - Database default data set
272 1 Jean-Philippe Lang
273 165 Etienne Massip
Insert default configuration data in database, by running the following command:
274
275 234 Go MAEDA
  RAILS_ENV=production bundle exec rake redmine:load_default_data
276 62 Vladimir L
277 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.
278
279
E.g.:
280
281
Unices:
282
283 234 Go MAEDA
  RAILS_ENV=production REDMINE_LANG=fr bundle exec rake redmine:load_default_data
284 171 Etienne Massip
285
Windows:
286
<pre>
287
set RAILS_ENV=production
288
set REDMINE_LANG=fr
289 234 Go MAEDA
bundle exec rake redmine:load_default_data
290 171 Etienne Massip
</pre>
291 32 Jean-Philippe Lang
292 167 Etienne Massip
h3. Step 8 - File system permissions
293 32 Jean-Philippe Lang
294 165 Etienne Massip
NB: _Windows users can skip this section._
295 14 Jean-Philippe Lang
296 165 Etienne Massip
The user account running the application must have write permission on the following subdirectories:
297 1 Jean-Philippe Lang
298 165 Etienne Massip
# @files@ (storage of attachments)
299
# @log@ (application log file @production.log@)
300 167 Etienne Massip
# @tmp@ and @tmp/pdf@ (create these ones if not present, used to generate PDF documents among other things)
301 220 Jean-Baptiste Barth
# @public/plugin_assets@ (assets of plugins)
302 221 Jean-Baptiste Barth
303 167 Etienne Massip
E.g., assuming you run the application with a redmine user account:
304 165 Etienne Massip
305 1 Jean-Philippe Lang
<pre>
306 219 Jean-Baptiste Barth
mkdir -p tmp tmp/pdf public/plugin_assets
307 1 Jean-Philippe Lang
sudo chown -R redmine:redmine files log tmp public/plugin_assets
308
sudo chmod -R 755 files log tmp public/plugin_assets
309
</pre>
310
311 284 Toshi MARUYAMA
Note: If you have files in these directories (e.g. restore files from backup), make sure these files are not executable.
312
313
<pre>
314
sudo find files log tmp public/plugin_assets -type f -exec chmod -x {} +
315
</pre>
316
317 165 Etienne Massip
h3. Step 9 - Test the installation
318 151 Jean-Philippe Lang
319 244 Jan Niggemann (redmine.org team member)
Test the installation by running WEBrick web server:
320
321
<pre>
322
bundle exec rails server webrick -e production
323
</pre>
324
325 151 Jean-Philippe Lang
Once WEBrick has started, point your browser to http://localhost:3000/. You should now see the application welcome page.
326
327 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.
328 14 Jean-Philippe Lang
329 165 Etienne Massip
h3. Step 10 - Logging into the application
330 158 Etienne Massip
331 165 Etienne Massip
Use default administrator account to log in:
332
333 1 Jean-Philippe Lang
    * login: admin
334
    * password: admin
335 14 Jean-Philippe Lang
336 165 Etienne Massip
You can go to ??Administration?? menu and choose ??Settings?? to modify most of the application settings.
337
338 130 Etienne Massip
h2. Configuration
339 1 Jean-Philippe Lang
340 185 Etienne Massip
Redmine settings are defined in a file named @config/configuration.yml@.
341 1 Jean-Philippe Lang
342 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.
343 1 Jean-Philippe Lang
344 185 Etienne Massip
These settings may be defined per Rails environment (@production@/@development@/@test@).
345 131 Etienne Massip
346
+Important+ : don't forget to restart the application after any change.
347
348 130 Etienne Massip
h3. Email / SMTP server settings
349
350 132 Etienne Massip
Email configuration is described in a [[EmailConfiguration|dedicated page]].
351 1 Jean-Philippe Lang
352
h3. SCM settings
353
354 133 Etienne Massip
This configuration section allows you to:
355 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)
356
* specify the full path to the binary
357
358 133 Etienne Massip
Examples (with Subversion):
359 131 Etienne Massip
360 133 Etienne Massip
Command name override:
361 131 Etienne Massip
362
 scm_subversion_command: "svn_replacement.exe"
363
364 133 Etienne Massip
Absolute path:
365 1 Jean-Philippe Lang
366
 scm_subversion_command: "C:\Program Files\Subversion\bin\svn.exe"
367
368
h3. Attachment storage settings
369
370 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.
371
372
Examples:
373
374
 attachments_storage_path: /var/redmine/files
375
376
 attachments_storage_path: D:/redmine/files
377 130 Etienne Massip
378
h2. Logging configuration
379
380 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.
381 21 Jean-Philippe Lang
382
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@.
383 123 Jean-Philippe Lang
<pre><code class="ruby">
384 21 Jean-Philippe Lang
#Logger.new(PATH,NUM_FILES_TO_ROTATE,FILE_SIZE)
385 162 Jean-Philippe Lang
config.logger = Logger.new('/path/to/logfile.log', 2, 1000000)
386 11 Jean-Philippe Lang
config.logger.level = Logger::INFO
387
</code></pre>
388
389
h2. Backups
390
391
Redmine backups should include:
392
* data (stored in your redmine database)
393
* attachments (stored in the @files@ directory of your Redmine install)
394
395 288 Go MAEDA
Please refer to [[RedmineBackupAndRestore|Backing up and restoring Redmine]] for more details.
396 69 Giuliano Simoncelli
397 216 Jean-Baptiste Barth
h2. Notes on Linux/Unix installation
398
399
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.
400
401 69 Giuliano Simoncelli
h2. Notes on Windows installation
402
403 156 Etienne Massip
There is an prebuilt installer of Ruby MRI available from http://rubyinstaller.org.
404
After installing it, select _Start Command Prompt with Ruby_ in the start menu.
405 1 Jean-Philippe Lang
406 156 Etienne Massip
+Specifying the @RAILS_ENV@ environment variable:+
407 69 Giuliano Simoncelli
408 156 Etienne Massip
When running command as described in this guide, you have to set the @RAILS_ENV@ environment variable using a separate command.
409 1 Jean-Philippe Lang
410 156 Etienne Massip
I.e. commands with the following syntaxes:
411 69 Giuliano Simoncelli
412 156 Etienne Massip
<pre>RAILS_ENV=production <any commmand></pre>
413 69 Giuliano Simoncelli
414 156 Etienne Massip
<pre><any commmand> RAILS_ENV=production</pre>
415 1 Jean-Philippe Lang
416 156 Etienne Massip
have to be turned into 2 subsequent commands:
417 69 Giuliano Simoncelli
418 156 Etienne Massip
<pre>set RAILS_ENV=production
419
<any commmand></pre>
420
421
+MySQL gem installation issue:+
422
423
You may need to manually install the mysql gem using the following command:
424
425 69 Giuliano Simoncelli
<pre>
426
gem install mysql
427
</pre>
428 1 Jean-Philippe Lang
429 156 Etienne Massip
And in some case it is required to copy the _libmysql.dll_ file in your ruby/bin directory.
430
Not all libmysql.dll are ok this seem to works http://instantrails.rubyforge.org/svn/trunk/InstantRails-win/InstantRails/mysql/bin/libmySQL.dll.
431
432 186 Jan Niggemann (redmine.org team member)
*Important note for Win7 and later*
433 283 Mischa The Evil
On Win7 and later, @localhost@ is commented out in the hosts file[5] and IPV6 is the default[6]. As the mysql2 gem does no support IPV6 addresses[7], a connection can't be established and you get the error "@Can't connect to MySQL server on 'localhost' (10061)@".
434 186 Jan Niggemann (redmine.org team member)
You can confirm this by pinging @localhost@, if ping targets "::1:" IPV6 is being used.
435
436
+Workaround:+
437
Replace @localhost@ with @127.0.0.1@ in database.yml.
438
439 283 Mischa The Evil
fn5. http://serverfault.com/questions/4689/windows-7-localhost-name-resolution-is-handled-within-dns-itself-why
440 186 Jan Niggemann (redmine.org team member)
441 283 Mischa The Evil
fn6. http://www.victor-ratajczyk.com/post/2012/02/25/mysql-fails-to-resolve-localhost-disable-ipv6-on-windows.aspx
442 186 Jan Niggemann (redmine.org team member)
443 283 Mischa The Evil
fn7. https://github.com/brianmario/mysql2/issues/279
444 80 Jean-Philippe Lang
445
h2. Alternative to manual installation
446
447
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.