I recently was upgrading a Ruby on Rails installation from 3.2 to 5.2 and as is normal lots of stuff had changed. This particular project involves the use of ruby-odbc and tiny-tds along with activerecord-sqlserver-adapter to provide connectivity to Microsoft SQL server.
The ruby ODBC & TDS gems took quite a version jump after upgrading and required a newer version of FreeTDS than was available via the apt repositories (debian backports was no help either). As a result the only option is to fetch, compile and install freetds yourself. It's always nice to have things configured in an easily reproducible way and so this little script performs the necessary. Simply adjust the version variables (V) and execute the script as root. You should of course ensure you've removed the native freetds-common and freetds-dev packages before you do this. I hope you find it useful.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Note as indicated in the script above, if you're receiving a client library returned TDS_INT_CANCEL error during connect then this is probably related to the openssl ciphers you're using. You should adjust the ciphers used on either your server or client library so they're compatible.