Please prepare tiny_tds gem for Ruby v2.6 on Windows

[TheR2]

Windows 10

ERROR: Error installing tiny_tds:
The last version of tiny_tds (>= 0) to support your Ruby & RubyGems was 2.1.2. Try installing it with gem install tiny_tds -v 2.1.2
tiny_tds requires Ruby version >= 2.0, < 2.6. The current ruby version is 2.6.1.33.

Thank you
TheR

[aharpervc]

Huh, looks like the rake task might need to be updated to match the ruby versions we're testing in CI

https://github.com/rails-sqlserver/tiny_tds/blob/master/tasks/native_gem.rake#L11 lists 2.5.0, 2.4.0, 2.3.0, 2.2.2, 2.1.6, and 2.0.0 whereas https://github.com/rails-sqlserver/tiny_tds/blob/master/appveyor.yml lists 2.3 through 2.6.

I can't think of any reason for those lists to be different, to be honest.

[avinashsa]

folks, what does this mean, "gem install" still complains about this error on windows 10.
Was this fixed ? if no when is it available ?

[will]

Yeah I can confirm that you can't install using ruby 2.6 on windows

[mrambossek]

any updates - is there a workaround? thanks

[aharpervc]

Did you try building the gem after updating the rake task to include 2.6 as I described above?

[mrambossek]

Did you try building the gem after updating the rake task to include 2.6 as I described above?

sorry i dont know how to do that.
i did a git checkout, and then ran "gem build tiny_tds.gemspec", which produced a tiny_tds-2.1.2.gem which i then installed via "gem install". however now i appearently dont have any of those tinytds static libraries? not sure. what are the steps necessary to get or build those tinytds libraries?

[aharpervc]

what are the steps necessary to get or build those tinytds libraries?

Please review the instructions in the readme file. If you're on Windows, the simplest way is to use docker to set up the build environment. https://github.com/rails-sqlserver/tiny_tds#compiling-gems-for-windows

[mrambossek]

Please review the instructions in the readme file. If you're on Windows, the simplest way is to use docker to set up the build environment. https://github.com/rails-sqlserver/tiny_tds#compiling-gems-for-windows

tried this, i think im on the right track, but the build fails somewhere on openssl?

C:\Users\mram.AD\tiny_tds>rake gem:windows
tasks/ports.rake:9: warning: already initialized constant OpenSSL::SSL::VERIFY_PEER
rake-compiler-dock bash -c "bundle && rake ports:compile[i686-w64-mingw32] MAKE='make -j`nproc`' && rake ports:compile[x86_64-w64-mingw32] MAKE='make -j`nproc`'"
Fetching gem metadata from https://rubygems.org/.............
Fetching rake 10.5.0
Installing rake 10.5.0
Using bundler 2.0.1
Fetching connection_pool 2.2.2
Installing connection_pool 2.2.2
Using mini_portile2 2.4.0
Fetching minitest 5.12.2
Installing minitest 5.12.2
Fetching rake-compiler 1.0.8
Installing rake-compiler 1.0.8
Fetching rake-compiler-dock 0.6.3
Installing rake-compiler-dock 0.6.3
Using tiny_tds 2.1.2 from source at `.`
Bundle complete! 7 Gemfile dependencies, 8 gems now installed.
Use `bundle info [gemname]` to see where a bundled gem is installed.
tasks/ports.rake:9: warning: already initialized constant OpenSSL::SSL::VERIFY_PEER
Compiling ports for i686-w64-mingw32...
Extracting openssl-1.1.0j.tar.gz into tmp/i686-w64-mingw32/ports/openssl/1.1.0j... OK
Running 'configure' for openssl 1.1.0j... OK
Running 'compile' for openssl 1.1.0j... OK
Running 'install' for openssl 1.1.0j... ERROR, review '/c/Users/mram.AD/tiny_tds/tmp/i686-w64-mingw32/ports/openssl/1.1.0j/install.log' to see what happened. Last lines are:
========================================================================
created directory `/c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl'
created directory `/c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/certs'
created directory `/c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/private'
created directory `/c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/misc'
install ./apps/CA.pl -> /c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/misc/CA.pl
make[1]: Entering directory '/c/Users/mram.AD/tiny_tds/tmp/i686-w64-mingw32/ports/openssl/1.1.0j/openssl-1.1.0j'
make[1]: Leaving directory '/c/Users/mram.AD/tiny_tds/tmp/i686-w64-mingw32/ports/openssl/1.1.0j/openssl-1.1.0j'
install ./apps/tsget -> /c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/misc/tsget
make[1]: warning: -jN forced in submake: disabling jobserver mode.
install ./apps/openssl.cnf -> /c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/openssl.cnf.dist
install ./apps/openssl.cnf -> /c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/ssl/openssl.cnf
*** Installing runtime files
install libcrypto-1_1.dll -> /c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/bin/libcrypto-1_1.dll
cp: cannot create regular file '/c/Users/mram.AD/tiny_tds/ports/i686-w64-mingw32/openssl/1.1.0j/bin/libcrypto-1_1.dll.new': No such file or directory
Makefile:382: recipe for target 'install_runtime_libs' failed
make: *** [install_runtime_libs] Error 1
make: *** Waiting for unfinished jobs....
make[1]: Entering directory '/c/Users/mram.AD/tiny_tds/tmp/i686-w64-mingw32/ports/openssl/1.1.0j/openssl-1.1.0j'
make[1]: Nothing to be done for '_build_programs'.
make[1]: Leaving directory '/c/Users/mram.AD/tiny_tds/tmp/i686-w64-mingw32/ports/openssl/1.1.0j/openssl-1.1.0j'
========================================================================
rake aborted!
Failed to complete install task
/usr/local/rvm/gems/ruby-2.5.3/gems/mini_portile2-2.4.0/lib/mini_portile2/mini_portile.rb:402:in `block in execute'
/usr/local/rvm/gems/ruby-2.5.3/gems/mini_portile2-2.4.0/lib/mini_portile2/mini_portile.rb:373:in `chdir'
/usr/local/rvm/gems/ruby-2.5.3/gems/mini_portile2-2.4.0/lib/mini_portile2/mini_portile.rb:373:in `execute'
/c/Users/mram.AD/tiny_tds/tasks/ports/openssl.rb:43:in `execute'
/c/Users/mram.AD/tiny_tds/tasks/ports/openssl.rb:24:in `install'
/usr/local/rvm/gems/ruby-2.5.3/gems/mini_portile2-2.4.0/lib/mini_portile2/mini_portile.rb:155:in `cook'
/c/Users/mram.AD/tiny_tds/tasks/ports/recipe.rb:12:in `cook'
tasks/ports.rake:23:in `block (2 levels) in <top (required)>'
tasks/ports.rake:66:in `block (3 levels) in <top (required)>'
tasks/ports.rake:65:in `each'
tasks/ports.rake:65:in `block (2 levels) in <top (required)>'
/usr/local/rvm/gems/ruby-2.5.3/bin/ruby_executable_hooks:24:in `eval'
/usr/local/rvm/gems/ruby-2.5.3/bin/ruby_executable_hooks:24:in `<main>'
Tasks: TOP => ports:openssl
(See full trace by running task with --trace)
rake aborted!
Command failed with status (1): [docker run -v /c/Users/mram.AD/tiny_tds:/c/Users/mram.AD/tiny_tds -e UID\=1000 -e GID\=1000 -e USER\=mram -e GROUP\=dummygroup -e ftp_proxy\= -e http_proxy\= -e https_proxy\= -e RCD_HOST_RUBY_PLATFORM\=x64-mingw32 -e RCD_HOST_RUBY_VERSION\=2.6.4 -e RCD_IMAGE\=larskanis/rake-compiler-dock-mri:0.7.2 -w /c/Users/mram.AD/tiny_tds --rm -i -t larskanis/rake-compiler-dock-mri:0.7.2 runas sigfw bash -c bundle\ \&\&\ rake\ ports:compile\[i686-w64-mingw32\]\ MAKE\=\'make\ -j\`nproc\`\'\ \&\&\ rake\ ports:compile\[x86_64-w64-mingw32\]\ MAKE\=\'make\ -j\`nproc\`\']
tasks/ports.rake:82:in `block (2 levels) in <top (required)>'
Tasks: TOP => gem:windows => ports:cross
(See full trace by running task with --trace)

install.log

[aharpervc]

Ah yes, openssl is a giant headache. Try changing this line to something else, such as 1.1.0e

But also more generally for this issue, it might also be useful to update the travis ci config to enable downloading built gems, so that people can more easily test PR artifacts without building locally themselves.

[crazycajun]

Any chance a Ruby 2.6 version of the pre-compiled Windows gem getting pushed to rubygems soon? I have a client that needs to upgrade to a patched version or Ruby and this is holding them up.

[aharpervc]

I have pushed 2.1.3-pre to rubygems for testing. Interested parties should install it & verify it works in ruby 2.6 with their app