Redmine on Windows with MS SQLServer
Added by Joseph M over 14 years ago
Hello,
Is there information, tutorials or feedback on how to install Redmine on Windows (Windows Server 2008 R2 64bits) with an MS SQLServer database?
I found information on how to install Redmine on [Windows + MySQL] or on [Linux + SQLServer] but nothing on [Windows + SQLServer].
Thank you in advance,
Regards,
Joseph
Replies (8)
RE: Redmine on Windows with MS SQLServer
-
Added by Felix Schäfer over 14 years ago
Well, in the end rails is an ORM, so it wraps the DB and abstracts it away from redmine. See if you can find any info on getting rails to work with MS SQL on windows and you should be able to use MS SQL with redmine provided you configure the database.yml
correctly. That being said, redmine is not actively tested on MS SQL, so you could be "more easily" subject to bugs than a classic installation, and would need to provide very detailed error descriptions if this happens for the devs to help you (none will have an MS SQL installation to reproduce problems on).
RE: Redmine on Windows with MS SQLServer
-
Added by Joseph M over 14 years ago
Dear Felix,
Thank you a lot for your clear and prompt answer.
So if follow both tutorials simultaneously :
and
http://www.aspdeveloper.net/tiki-index.php?page=IISRubyOnWindows
obviously, what I am trying to do should work?
Thank you,
Kind regards,
Joseph
RE: Redmine on Windows with MS SQLServer
-
Added by Felix Schäfer over 14 years ago
Well, the first describes connecting an apache to redmine under windows, the other one describe how to connect IIS to it, so it really depends what webserver you use or want to use.
For the database connection to MSSQL, it seems the activerecord-sqlserver-adapter is the way to go, so try it with that.
RE: Redmine on Windows with MS SQLServer
-
Added by Joseph M over 14 years ago
Dear Felix,
Thank you a lot for your help.
I followed several tutorials and managed to have something more or less working.
Following steps seem to have worked :
set RAILS_ENV=production
rake config/initializers/session_store.rb
rake db:migrate
rake redmine:load_default_data
And I saw the Redmine website at some point (before launching "rake redmine:load_default_data").
However, now when I launch the webserver (mongrel) and try to access Redmine's website, I get the following error :
ActiveRecord::SerializationTypeMismatch in WelcomeController#index
permissions was supposed to be a Array, but was a String
RAILS_ROOT: C:/webserver/railsapp/redmine
I attached an image of the error for more details. This issue seem to be related to this one : http://www.redmine.org/issues/3903
I hope someone can help.
Cheers,
Joseph
RE: Redmine on Windows with MS SQLServer
-
Added by Joseph M over 14 years ago
Sorry, here is the image of the error.
RE: Redmine on Windows with MS SQLServer
-
Added by Felix Schäfer over 14 years ago
Do you have all your ruby gems at the correct versions? What collation do you use on the database? Could you provide a dump of the contents of the "roles" table?
RE: Redmine on Windows with MS SQLServer
-
Added by Brian K about 14 years ago
Joseph, do you have a list or a link to the steps you took to get Redmine running with MSSQL? I haven't had any luck yet.
RE: Redmine on Windows with MS SQLServer
-
Added by Vitor Odenor Aquino da Silva about 12 years ago
Joseph,
I'm with same problem, you could solve?