Redmine+sql Server Installation under Windows

We have been using Redmine to manage project and system defect tracking. Recently, the center developed a micro-platform and introduced a telephony system, both SQL Server, in order to integrate with the two systems, calculate the redmine into SQL Server. Before the Bitnami with a key installation, did not expect to change the database process is extremely tortuous. The installation process is listed below, and I hope to help friends who use Redmine.

Redmine version: 2.4.3

Operating system: WIN2003 64-bit, Win7 64-bit as possible.

SQL server:2008 R2

Write in front: Do not attempt to change on the basis of Bitnami installation.

1. Website download source code files. [http://rubyinstaller.org/downloads/], extract to a directory, such as D:redmine, directory do not have spaces,

2. Download ruby1.9.3. [Http://rubyonrails.org/download], be careful not to download 2.0 version, 1.87 version is no longer updated installed it is not fun. Install it, install to Cruby do not install to a directory with spaces, remember to set the environment variable when installing.

3. Download Devkit, also on the previous page, be sure to note the download version. Install it to a directory, such as C:devkit. Note that there are no spaces in the directory. Then use CMD to locate this folder, and execute the following statement:

Ruby DK.RB Init

Ruby dk.rb Install

4. Download Imagemagick[http://www.imagemagick.org/script/binary-releases.php#windows], install to a folder without spaces, such as c:i Magemagic. Add environment variable CPath, value is c:imagemagickinclude, add environment variable Library_path, value is: c:imagemagicklib

5. Download Mysql-connector-c-noinstall, you can download a Baidu. Unzip it to a folder, such as D:mysql. Copy the Libmysql.dll under the Lib directory to C:rubybin and c:rubylib. All two directories are insured.

6. The establishment of Redmine database, empty library can be.

7. Configure the database file. In D:redmine configdatabase.yml, if you don't have this file, simply rename the Database.yml.example file. Open this file, comment out or delete each line with the # number, leaving only the last # SQL Server Configuration Example section of the line. Uncomment this section (delete #) Note that you don't want to delete more than one space. Then configure the database address at the host. Username and password The user name and password for the configuration database. Note that after the colon must have a space (very strange design)

8. Open Gemfile file, add one line

Gem ' mongrel ', ' ~> 1.2.0.pre2 '

9. Position cmd to redmine directory, such as D:redmine (all of the following operations are operating in this directory), then install the mongrel, do not install it if the use of Webrick will be slow so you can not bear

Gem Install mongrel--pre

10. Execute the following statement again:

Gem Install Bundler

11. Then execute the following statement to install the bundle environment, which installs all the necessary components according to the configuration file. This is the most important step. Note that if you add or remove the contents of the database configuration file (DATABASE.YML), you must repeat the following sentence.

Bundle install--without Development test Rmagick

If an error such as MYSQL2 is executed, the execution

Gem install mysql–-'--with-mysql-dir= ' d:mysql '

If you are reporting a component installation error such as JSON or rails, install it manually. (How to install? Right click, mark, select Copy out to prompt installation Failed component name, execute gem install component name)

Then repeat step 10th until the installation succeeds. This step is the most painful, the most troublesome step.

12. After the success of the above has been installed redmine the basic environment, the success of the 90%. Next execution

Rake Generate_secret_token

13. Then execute the following two sentences to build the database structure

Set Rails_env=production

Rake Db:migrate

14. Then load the default data.

Set Rails_env=production

Rake Redmine:load_default_data

You will be prompted to select the language and enter en to select Chinese.

15. Finally, start the service.

Ruby Script/rails Server Mongrel-e production-d-p 80

The 80 port used here, if you want to use a different port to change 80 to another one. Do not turn off the window when the service is started. Then you can access it through the browser.

It took me a week to install this thing on and off. Many of the online guidelines are too old, according to the old version of the guidelines for a long time, the results found that not at all, in fact, Redmine itself has a lot of things need to pack well. In addition, There are no exceptions in the official document. I tried two days in Bitnami and failed. In the 10th step for two days, the main problem is MySQL. The other is to install Ruby without installing Devkit, or a version installation error, or a space in the directory (why can't I identify the spaces in the directory)? ?)

Installing a small thing is so cumbersome that I really don't know how Linux users endure it. Many linuxer may also be proud of the things that can be done with such complexity, "Ha! I used the n command to get XX!"

The

Linux program is so poor in ease of use-not in its command-line interface-but in the chaos of its package dependencies. The complexity of dependencies in the open source context is completely unusable as long as one of them is slightly problematic. than Windows DLL Hell don't know how many times. I believe that If it is an ordinary user to use it, will commit suicide.