install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds

Added by adam baxter almost 3 years ago

During the installation, I get the following message

C:\inetpub\wwwroot\redmine23>bundle exec rake generate_secret_token
C:/Ruby19/lib/ruby/gems/2.2.0/gems/htmlentities-4.3.1/lib/htmlentities/mappings/
expanded.rb:465: warning: duplicated key at line 466 ignored: "inodot"
rake aborted!
LoadError: cannot load such file -- tiny_tds/tiny_tds
C:/inetpub/wwwroot/redmine23/config/application.rb:5:in `<top (required)>'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `require'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `<top (required)>'
LoadError: cannot load such file -- tiny_tds/2.2/tiny_tds
C:/inetpub/wwwroot/redmine23/config/application.rb:5:in `<top (required)>'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `require'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `<top (required)>'
(See full trace by running task with --trace)

C:\inetpub\wwwroot\redmine23>set RAILS_ENV=production

C:\inetpub\wwwroot\redmine23>bundle exec rake db:migrate
C:/Ruby19/lib/ruby/gems/2.2.0/gems/htmlentities-4.3.1/lib/htmlentities/mappings/
expanded.rb:465: warning: duplicated key at line 466 ignored: "inodot"
rake aborted!
LoadError: cannot load such file -- tiny_tds/tiny_tds
C:/inetpub/wwwroot/redmine23/config/application.rb:5:in `<top (required)>'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `require'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `<top (required)>'
LoadError: cannot load such file -- tiny_tds/2.2/tiny_tds
C:/inetpub/wwwroot/redmine23/config/application.rb:5:in `<top (required)>'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `require'
C:/inetpub/wwwroot/redmine23/Rakefile:5:in `<top (required)>'
(See full trace by running task with --trace)

Before that
Installing tiny_tds 0.6.2
no errors

Please tell me what could be the problem?

Replies (16)

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Ronny . almost 3 years ago

Hey Adam,

i had the same problem.
What help for me was using an older version.
Try using rubyinstaller 2.1.x. It seems Ruby 2.2.x has some issues with TinyURL.

Cheers

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by adam baxter almost 3 years ago

I installed version 2.1.8 x64
and I got the following error when installing

bundle install
...
Checksum of /versions does not match the checksum provided by server! Something
is wrong.

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by adam baxter almost 3 years ago

the installation was successful after installation rubyinstaller-2.0.0-p648-x64.exe

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Ronny . almost 3 years ago

Congrats.

I installed version 2.1.8 x64
and I got the following error when installing

For me 2.1.7 worked fine.

Do you plan to run a RailsWebserver or do you want IIS to be your WebServer?

cheers
Ronny

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Sahib Khan over 2 years ago

Checksum of /versions does not match the checksum provided by server! Something
is wrong.

can be solved with
uninstalling bundler by gem uninstall bundler and then reinstall by gem install bundler

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Mark Wintch over 1 year ago

I am attempting to install Redmine 3.3.0 on Windows Server 2012 SQL 2016

I edited the Gemfile to allow the install of tiny_tds 0.7.0 and uninstalled 0.6.2

I still get the same error as the OP. I get the exact same error with both versions of tiny_tds when attempting to run "bundle exec rails server webrick -e production"

This is after setting the RAILS_ENV=production

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by cunhua kang over 1 year ago

i meet this error too. redmine-3.3.3 + SQL Server 2012 + railsinstaller-3.2.0.exe.

just to fix it like this step:
1. open redmine-3.3.3\Gemfile,and find A replace to B,
A:
gem "tiny_tds", "~> 0.6.2", :platforms => [:mri, :mingw, :x64_mingw]
B:
gem "tiny_tds", "~> 0.7.0", :platforms => [:mri, :mingw, :x64_mingw]
2. then
gem install tiny_tds -v 0.7.0
3. all is OK;

reason:
1. Peter Shannon wrote:

tiny_tds 0.6.0 is bugged with Windows. Install 0.7.0 to fix.

2. gemfile define the tiny_tds allowed between (>=0.6.2,<0.7.0)

and from internet,there is another writing like:
gem "tiny_tds"
do not define the tiny_tds version,you also can try it;

just fine!
good luck!

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by John Bliss 4 months ago

I used this thread to get past "Step 5 - Session store secret generation." That involved manually installing tiny_tds-0.7.0.

But then, on "Step 6 - Database schema objects creation," I'm getting the same error as OP:

rake aborted!
LoadError: cannot load such file -- tiny_tds/tiny_tds

Can someone advise?

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by John Bliss 4 months ago

A workaround for this SEEMS to be:

- install tiny_tds-2.1.2
- edit Gemfile
- change RUBY_VERSION >= "2.0" ? "~> 1.0.5" to RUBY_VERSION >= "2.0" ? "~> 2.1.2"

But now, at the end of:

bundle exec rake db:migrate

...I'm getting:

undefined method 'type' for nil:NilClass

Any suggestions?

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Sergey Alikin 4 months ago

Jonh, hello.
I have a same problem.
What interesting: I installed current Redmine version on Win 2008 with tiny_tds 1.1.0 installed manually successfully (problem was on secret generation). But I failed with MSSQL version (I had 2008, but redmine wants at least 2012).
But now I'm trying to install last redmin on Win2016 + MSSQL 2012 and I see similar problem like you.
I tried to use tiny_tds 1.1.0 like with Win2008, and Step 5 was success, but on Step 6 I had problem identical your's.
So if you will solve this issue, please, don't foget to share your solution. I will do same.
Good bye.

RE: install redmine 3.2.0 on windows 2012+IIS+MSSQL LoadError: cannot load such file -- tiny_tds/tiny_tds - Added by Sergey Alikin 4 months ago

John, do not despond.
I did it. Now I stops on database persmissions (all actions are disabled), but redmine connects and try to execute sql statments.

I'm not sure in solution, but I will try help you (and others). I'm lower than zero in Ruby, so my help will very weak, but still...
So, please, show next info:
1. redmine version (my is 3.4.6)
2. windows version (my is Windows Server 2016 Dataserver)
3. gem list command results (especially line with tiny_tds gem, my is tiny_tds (2.1.2 x64-mingw32, 1.1.0 x64-mingw32)).
4. Ruby version (my is 2.4.4-2 with Devkit, it's important, that with Devkit).

In fact, I have used your solution and have installed 2.1.2 tiny_tds version (last chance, without seriously hope).
I did next command:
gem install tiny_tds -v 2.1.2
then I rerun step 5 and 6.

(1-16/16)