Install Redmine on Windows (XP / 2003) with sqlite ?

Added by Dominik Schmidt almost 13 years ago

Hi !

I´m absolutely new to redmine but maybe we want to use it for a little software project.
We have a windows XP system which hosts our Subversion system. And it would be nice to run Redmine on that system, too.

But I can´t find a tutorial how to install it on a windows based system with SQLite. Could anyone here give me a short description how to do that?

Greetz
Dominik

Replies (4)

RE: Install Redmine on Windows (XP / 2003) with sqlite ? - Added by Brad Rushworth almost 13 years ago

I just did that exact task three weeks ago. Was fairly straight-forward except I couldn't get Apache to talk to Redmine using either mod_fastcgi or mod_fcgid, only using mod_cgi. Since mod_cgi is far too slow, we are making do for the mean time with the built in webserver running in a DOS window.

I'm a unix guy and have setup Redmine before with both mod_fastcgi or mod_fcgid on FreeBSD, Linux, etc... but couldn't figure out why it didn't work on Windows XP. Is this a typical problem?

Anyway, the basic documentation is here:
RedmineInstall

Ruby is easy to install on Windows. Rails is easy too. Assuming you don't have a menacing corporate firewall, gem should download your dependancies painlessly.

RE: Install Redmine on Windows (XP / 2003) with sqlite ? - Added by Barbara Post over 12 years ago

Hello,

Let me add an (I hope) useful note after stumbling upon this thread : specifically thinking of the dll, because the rest of the process is indeed well documented and easy to follow.

Here is the answer : http://www.ruby-forum.com/topic/149431

So in my case, sqlite3.dll and sqlite3.def are to be copied here :

    Répertoire : Microsoft.PowerShell.Core\FileSystem::C:\Ruby-186-27\lib\ruby\gems\1.8\gems\sqlite3-ruby-1.2.3-x86-msw
    in32\lib

Mode                LastWriteTime     Length Name
----                -------------     ------ ----
d----        10/06/2009     14:27            sqlite3
-a---        25/05/2009     08:51       3710 sqlite3.def
-a---        25/05/2009     08:51     505920 sqlite3.dll
-a---        10/06/2009     14:27         27 sqlite3.rb
-a---        10/06/2009     14:27      99840 sqlite3_api.dll

Just my 2 cents. Hoping it works because I'm not done with it right now.

Barbara

RE: Install Redmine on Windows (XP / 2003) with sqlite ? - Added by Barbara Post over 12 years ago

It seems that you really must use the "ruby/bin" directory...

http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/9d5c9ee6167dace4

The config I gave and tried above clearly indicated it didn't find the dll, that's sad :

PS C:\xampp\redmine-0.8.4> C:\Ruby-186-27\bin\rake.bat db:migrate RAILS_ENV="production" --trace
(in C:/xampp/redmine-0.8.4)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
unknown error
C:/Ruby-186-27/lib/ruby/1.8/dl/import.rb:29:in `initialize'
C:/Ruby-186-27/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
C:/Ruby-186-27/lib/ruby/1.8/dl/import.rb:29:in `dlload'
C:/Ruby-186-27/lib/ruby/1.8/dl/import.rb:27:in `each'
C:/Ruby-186-27/lib/ruby/1.8/dl/import.rb:27:in `dlload'
C:/Ruby-186-27/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.3-x86-mswin32/lib/sqlite3/driver/dl/api.rb:31
C:/Ruby-186-27/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'

My 2 cents back.

RE: Install Redmine on Windows (XP / 2003) with sqlite ? - Added by Will Bike over 12 years ago

I'm new as well, but found some tips for this issue.

To use sqlite3 you setup the production instance to point to sqlite3. see the test example later in the database.yml.example file that comes with redmine. You don't need all the login and password type entries. Here is what mine looks like:
  1. MySQL (default setup). Versions 4.1 and 5.0 are recommended. #
  2. Get the fast C bindings:
  3. gem install mysql
  4. (on OS X: gem install mysql -- --include=/usr/local/lib)
  5. And be sure to use new-style password hashing:
  6. http://dev.mysql.com/doc/refman/5.0/en/old-client.html

production:
adapter: sqlite3
dbfile: db/prod.db
host: localhost

test_sqlite3:
adapter: sqlite3
dbfile: db/test.db

demo:
adapter: sqlite3
dbfile: db/demo.db
#-----end of file------

You also need to install the sqlite3 gem. To do this I consulted the gem web site gems.rubyforge.org because it wasn't obvious what the name of the gem was. The gem I needed was sqlite3-ruby-1.2.3-mswin32.gem. Use gem install to install the file (use a browser to download it and then give it the path to the downloaded file if necessary).

After that the steps in the instructions starting with the step 5. rake command worked flawlessly and my redmine server is running.

Good Luck
Will

(1-4/4)