Project

General

Profile

Forums » Open discussion »

Trouble installing redmine 2.6.5 on windows with MSSQL

Added by James Peckham almost 9 years ago

Hi,

Looking for someone who can help out as I am very new to RoR. I am trying to setup redmine 2.6.5 on Ruby 2.1.6 (x64) on windows 2012 and SQL 2012 R2. I ran the steps outlined in the install guide after installing ruby from rubyinstaller.org, however it doesn't seem like files are installing in all of the right places within ruby gems.

here is my database.yml, not sure if i've gotten far enough for this to come into play...

production:
adapter: sqlserver
database: REDMINE
username: REDMINE
password: redminepassword

Below is my command line log to reproduce the issue.

C:\inetpub\wwwroot\rails\redmine>gem install bundler
Fetching: bundler-1.10.3.gem (100%)
Successfully installed bundler-1.10.3
Parsing documentation for bundler-1.10.3
Installing ri documentation for bundler-1.10.3
Done installing documentation for bundler after 6 seconds
1 gem installed

C:\inetpub\wwwroot\rails\redmine>bundle install --without development test
Fetching gem metadata from https://rubygems.org/.........
Fetching version metadata from https://rubygems.org/..
Resolving dependencies..............
Installing rake 10.4.2
Installing i18n 0.6.11
Installing multi_json 1.11.1
Installing activesupport 3.2.21
Installing builder 3.0.4
Installing activemodel 3.2.21
Installing erubis 2.7.0
Installing journey 1.0.4
Installing rack 1.4.5
Installing rack-cache 1.2
Installing rack-test 0.6.3
Installing hike 1.2.3
Installing tilt 1.4.1
Installing sprockets 2.2.3
Installing actionpack 3.2.21
Installing mime-types 1.25.1
Installing polyglot 0.3.5
Installing treetop 1.4.15
Installing mail 2.5.4
Installing actionmailer 3.2.21
Installing arel 3.0.3
Installing tzinfo 0.3.44
Installing activerecord 3.2.21
Installing activeresource 3.2.21
Using bundler 1.10.3
Installing coderay 1.1.0
Installing rack-ssl 1.3.4
with native extensions Installing json 1.8.3
Installing rdoc 3.12.2
Installing thor 0.19.1
Installing railties 3.2.21
Installing jquery-rails 3.1.2
Installing net-ldap 0.3.1
Installing ruby-openid 2.3.0
Installing rack-openid 1.4.2
Installing rails 3.2.21
Installing rbpdf 1.18.5
Installing request_store 1.0.5
Bundle complete! 26 Gemfile dependencies, 38 gems now installed.
Gems in the groups development and test were not installed.
Use `bundle show [gemname]` to see where a bundled gem is installed.
Post-install message from rdoc:
Depending on your version of ruby, you may need to install ruby rdoc/ri data:

<= 1.8.6 : unsupported = 1.8.7 : gem install rdoc-data; rdoc-data --install = 1.9.1 : gem install rdoc-data; rdoc-data --install

= 1.9.2 : nothing to do! Yay!

C:\inetpub\wwwroot\rails\redmine>bundle exec rake generate_secret_token

C:\inetpub\wwwroot\rails\redmine>set RAILS_ENV=production

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate
rake aborted!
LoadError: Please install the sqlserver adapter: `gem install activerecord-sqlserver-adapter` (cannot load such file -- active_record/connection_adapters/sqlserver_adapter)
C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
LoadError: cannot load such file -- active_record/connection_adapters/sqlserver_adapter
C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

C:\inetpub\wwwroot\rails\redmine>gem install activerecord-sqlserver-adapter -v 3.2.13
Fetching: activerecord-sqlserver-adapter-3.2.13.gem (100%)
Successfully installed activerecord-sqlserver-adapter-3.2.13
Parsing documentation for activerecord-sqlserver-adapter-3.2.13
Installing ri documentation for activerecord-sqlserver-adapter-3.2.13
Done installing documentation for activerecord-sqlserver-adapter after 1 seconds
1 gem installed

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate
rake aborted!
LoadError: Please install the sqlserver adapter: `gem install activerecord-sqlserver-adapter` (cannot load such file -- active_record/connection_adapters/sqlserver_adapter)
C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
LoadError: cannot load such file -- active_record/connection_adapters/sqlserver_adapter
C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    LoadError: Please install the sqlserver adapter: `gem install activerecord-sqlserver-adapter` (cannot load such file -- active_record/connection_adapters/sqlserver_adapter)
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:50:in `resolve_hash_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:41:in `resolve_string_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:25:in `spec'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:130:in `establish_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/railtie.rb:88:in `block (2 levels) in <class:Railtie>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:26:in `block in on_load'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:25:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:25:in `on_load'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/railtie.rb:80:in `block in <class:Railtie>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:30:in `instance_exec'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:30:in `run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:55:in `block in run_initializers'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:54:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:54:in `run_initializers'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:136:in `initialize!'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/railtie/configurable.rb:30:in `method_missing'
    C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:103:in `require_environment!'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:305:in `block (2 levels) in initialize_tasks'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:201:in `block in invoke_prerequisites'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:199:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:199:in `invoke_prerequisites'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:178:in `block in invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'
    C:/Ruby21-x64/bin/rake:23:in `load'
    C:/Ruby21-x64/bin/rake:23:in `<main>'
    LoadError: cannot load such file -- active_record/connection_adapters/sqlserver_adapter
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:50:in `resolve_hash_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:41:in `resolve_string_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:25:in `spec'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/abstract/connection_specification.rb:130:in `establish_connection'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/railtie.rb:88:in `block (2 levels) in <class:Railtie>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:36:in `instance_eval'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:36:in `execute_hook'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:26:in `block in on_load'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:25:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/lazy_load_hooks.rb:25:in `on_load'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/railtie.rb:80:in `block in <class:Railtie>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:30:in `instance_exec'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:30:in `run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:55:in `block in run_initializers'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:54:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/initializable.rb:54:in `run_initializers'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:136:in `initialize!'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/railtie/configurable.rb:30:in `method_missing'
    C:/inetpub/wwwroot/rails/redmine/config/environment.rb:14:in `<top (required)>'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `block in require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:236:in `load_dependency'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:103:in `require_environment!'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/railties-3.2.21/lib/rails/application.rb:305:in `block (2 levels) in initialize_tasks'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `call'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:240:in `block in execute'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:235:in `execute'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:179:in `block in invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:201:in `block in invoke_prerequisites'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:199:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:199:in `invoke_prerequisites'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:178:in `block in invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/2.1.0/monitor.rb:211:in `mon_synchronize'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:172:in `invoke_with_call_chain'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/task.rb:165:in `invoke'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:150:in `invoke_task'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block (2 levels) in top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `each'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:106:in `block in top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:115:in `run_with_threads'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:100:in `top_level'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:78:in `block in run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:176:in `standard_exception_handling'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/lib/rake/application.rb:75:in `run'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/rake-10.4.2/bin/rake:33:in `<top (required)>'
    C:/Ruby21-x64/bin/rake:23:in `load'
    C:/Ruby21-x64/bin/rake:23:in `<main>'
    Tasks: TOP => db:migrate => environment

Replies (8)

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

i copied contents of

C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activerecord-sqlserver-adapter-3.2.13\lib\active_record\connection_adapters
to
C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activerecord-3.2.21\lib\active_record\connection_adapters

now i get this error
C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    LoadError: Please install the sqlserver adapter: `gem install activerecord-sqlserver-adapter` (cannot load such file -- arel/visitors/sqlserver)
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

copied

C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activerecord-sqlserver-adapter-3.2.13\lib\arel

to

C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activesupport-3.2.21\lib\arel

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    Errno::ENOENT: No such file or directory @ rb_sysopen - C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/VERSION
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:181:in `read'
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activerecord-3.2.21/lib/active_record/connection_adapters/sqlserver_adapter.rb:181:in `<class:SQLServerAdapter>'

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

copied C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activerecord-sqlserver-adapter-3.2.13\VERSION

to

C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activerecord-3.2.21\VERSION

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    LoadError: cannot load such file -- tiny_tds
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

C:\inetpub\wwwroot\rails\redmine>gem install tiny_tds
Fetching: tiny_tds-0.6.2-x64-mingw32.gem (100%)
Successfully installed tiny_tds-0.6.2-x64-mingw32
Parsing documentation for tiny_tds-0.6.2-x64-mingw32
Installing ri documentation for tiny_tds-0.6.2-x64-mingw32
Done installing documentation for tiny_tds after 0 seconds
1 gem installed

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    LoadError: cannot load such file -- tiny_tds
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/active_support/dependencies.rb:251:in `require'

copied C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\tiny_tds-0.6.2-x64-mingw32\lib\*
to
C:\Ruby21-x64\lib\ruby\gems\2.1.0\gems\activesupport-3.2.21\lib

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
    rake aborted!
    ArgumentError: missing :host option if no :dataserver given
    C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/activesupport-3.2.21/lib/tiny_tds/client.rb:68:in `initialize'

added
host: 127.0.0.1 in database.yml

C:\inetpub\wwwroot\rails\redmine>bundle exec rake db:migrate --trace
  • Invoke db:migrate (first_time)
  • Invoke environment (first_time)
  • Execute environment
  • Invoke db:load_config (first_time)
  • Execute db:load_config
  • Execute db:migrate
    rake aborted!
    ActiveRecord::StatementInvalid: TinyTds::Error: CREATE TABLE permission denied in database 'REDMINE'.: CREATE TABLE [schema_migrations] ([version] nvarchar(255) NOT NULL)

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

in sql management studio

EXEC Sp_droprolemember N'db_datareader', N'REDMINE'
GO
EXEC Sp_droprolemember N'db_datawriter', N'REDMINE'
GO
EXEC sp_addrolemember N'db_owner', N'REDMINE'
GO

Looks like rake is running now!!!

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by James Peckham almost 9 years ago

Now that i'm up and functioning... can anyone explain what I did wrong where I had to make all the copies of gem libs around and they weren't aware of eachother? Do I just need to update my Gemfile.local with some stuff? Is this a bundler issue?

Thanks!

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by Doo - mic about 8 years ago

I know, it's a lot of months ago. But I issued the same. First i tried to install redmine on a x64 system (ruby, devkit, etc..) Got the sqladapter and tinytds error. I have changed the [Gemfile] (root folder of the downloaded 2.6 redmine) like below. Forced the version numbers of this 2 gem installs.

when /sqlserver/
gem "tiny_tds", "= 0.7.0"
gem "activerecord-sqlserver-adapter", "3.2.13"
else

My issue is now: get it running in IIS7... Therefor I currently making a clean install on anther windows system. Used x86 (32bit) installations... Still getting a tinytds error.. but no sqlserveradapter error. Changed the tinytds record in Gemfile to get it worked.

Wondering if the redmine comunity will fix this for the old version (2.6) of redmine. Can't go to 3.x because it doen't support MSSQL2008

RE: Trouble installing redmine 2.6.5 on windows with MSSQL - Added by Doo - mic about 8 years ago

I had to change tiny_tds in gem file also for the installation of redmine 3.2.1. Sidenote, it is a x64 setup.
however, didn't had to change activerecord-sqlserver-adapter

    (1-8/8)