Redmine + SQLSERVER installation in Windows

We have been using Redmine for project management and system defect tracking. recently, the center developed a platform and introduced the telephone system, all of which are from SQLSERVER. To integrate with the two systems, the Redmine was changed to SQLSERVER. previously, Bitnami was used for one-click installation. I did not expect the process of changing a database to be tortuous. the installation process is listed below.

We have been using Redmine for project management and system defect tracking. recently, the center developed a platform and introduced the telephone system, which is SQL server. To integrate with the two systems, we changed Redmine to SQL SERVER. previously, Bitnami was used for one-click installation. I did not expect the process of changing a database to be tortuous. the installation process is listed below.

We have been using Redmine for project management and system defect tracking. recently, the center developed a platform and introduced the telephone system, which is SQL server. To integrate with the two systems, we changed Redmine to SQL SERVER. previously, Bitnami was used for one-click installation. I did not expect the process of changing a database to be tortuous. the installation process is listed below, and we hope to help Redmine users.

Redmine version: 2.4.3

Operating System: Windows 64-bit, Windows 64-bit.

SQL servers: 2008 R2

Preface: do not try to modify it based on the installation of Bitnami.

1. Download the source code file from the official website. [] and decompress it to a directory, such as D: Redmine. The directory should not contain spaces,

2. download ruby1.9.3. []. Be sure not to download version 2.0. Version 1.87 is meaningless if it is no longer updated. install it. Do not install it in the directory with spaces when installing CRUBY. During installation, check the setting environment variables.

3. download DevKIt. You must pay attention to the downloaded version on the previous page. install it to a directory, such as C: DEVKIT. note that the directory should not contain spaces. then use CMD to locate the folder and execute the following statement:

Ruby dk. rb init

Ruby dk. rb install

4. download ImageMagick [# windows] and install it in a folder without spaces, such as C: ImageMagic. add the environment variable CPATH; Value: C: ImageMagickinclude; then add the environment variable LIBRARY_PATH; Value: C: ImageMagicklib

5. download mysql-connector-c-noinstall, which can be downloaded from Baidu. decompress it to a folder, such as D: mysql. set libmysql In the lib directory. copy the dll to C: rubybin and C: rubylib. both directories are covered with insurance.

6. Create a Redmine database. Empty database.

7. configure the database file. in D: Redmine configdatabase. yml. If this file is not available, directly import the database. yml. rename the example file. open this file and comment out or delete each line with #, leaving only the last line in # SQLServer configuration example. delete the comment (delete #). Do not delete one space. configure the database address at the host, username and password for the database. note that there must be a space after the colon (strange design)

8. Open the gemfile file and add a line.

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

9. locate CMD to the directory where Redmine is located, for example, D: Redmine (all the operations below are performed in this directory). Then install mongrel, if you don't install it, using webrick will be too slow for you to endure.

Gem install mongrel -- pre

10. Execute the following statement:

Gem install bundler

11. run the following statement to install the bundle environment. It will install all necessary components according to the configuration file. this is the most important step. note that if you add or delete the content of the database configuration file (database. yml) execute the following statement again.

Bundle install -- without development test rmagick

If an error such as mysql2 is reported

Gem install mysql -- '-- with-mysql-dir = "D: mysql "'

If a component installation error such as json or rails is reported, install it manually. (how to install it? Right-click and mark the component. Copy the component name indicating installation failure and execute the gem install Component name)

Repeat Step 1 until the installation is successful. This step is the most painful and troublesome step.

12. After the above is successful, the basic environment of redmine has been installed, and 90% has been successful. Next, execute

Rake generate_secret_token

13. Execute the following two statements to generate the database structure:

Set RAILS_ENV = production

Rake db: migrate

14. Load the default data.

Set RAILS_ENV = production

Rake redmine: load_default_data

You will be prompted to select a language. Enter ZH to select Chinese.

15. Start the service.

Ruby script/rails server mongrel-e production-d-p 80

Use port 80 here. If you want to change port 80 to another port, do not close this window after the service is started. Then you can access it through a browser.

It took me almost a week to install the device intermittently. many of the guidelines on the Internet are too old. After following the guidance of the old version for a long time, we found that they did not work at all. In fact, redmine has packed up many things needed. in addition, some exceptions are not indicated in the official documentation. I tried Bitnami for two days and ended in failure. I tried mysql for two days in step 1. other methods include installing ruby without devkit, version installation error, or directory with spaces (Why cannot I identify the spaces in the directory ?)

Installing a little thing is so cumbersome that I really don't know how linux users can handle it. Many linuxer may be proud to be able to make such complicated things, "Ha! I used N commands to handle XX !"

The ease of use of Linux programs is really poor-not in its command line interface-in the mess of its package dependency. in the open-source context, the complex dependencies are completely unavailable as long as one of them is slightly faulty. how many times worse than windows dll hell. I believe that a common user will commit suicide.

,