installing tiny_tds gem fails on Ubuntu 12.04 LTS

[bwb]

Hello,

I'm having aproblem getting the bumdle install for a working application to work go to completion on a new linux vm.  It quits when trying to process the tiny_tds line in the Gemfile.  THere is a message that says further info is in a certain gem_make.out file, but that file is empty.  Any suggestions would be appreciated.

[bwb]

Fruther to my original post, here is the stdout from the bundle install run:

Fetching gem metadata from https://rubygems.org/...........
Fetching gem metadata from https://rubygems.org/..
Using rake (0.9.2.2)
Using i18n (0.6.1)
Using multi_json (1.3.6)
Using activesupport (3.2.1)
Using builder (3.0.4)
Using activemodel (3.2.1)
Using erubis (2.7.0)
Using journey (1.0.4)
Using rack (1.4.1)
Using rack-cache (1.2)
Using rack-test (0.6.2)
Using hike (1.2.1)
Using tilt (1.3.3)
Using sprockets (2.1.3)
Using actionpack (3.2.1)
Using mime-types (1.19)
Using polyglot (0.3.3)
Using treetop (1.4.12)
Using mail (2.4.4)
Using actionmailer (3.2.1)
Using arel (3.0.2)
Using tzinfo (0.3.34)
Using activerecord (3.2.1)
Using activerecord-sqlserver-adapter (3.2.9)
Using activeresource (3.2.1)
Using bundler (1.2.1)
Using chunky_png (1.2.6)
Using coffee-script-source (1.4.0)
Using execjs (1.4.0)
Using coffee-script (2.2.0)
Using rack-ssl (1.3.2)
Using json (1.7.5)
Using rdoc (3.12)
Using thor (0.14.6)
Using railties (3.2.1)
Using coffee-rails (3.2.2)
Using columnize (0.3.6)
Using fssm (0.2.9)
Using sass (3.2.1)
Using compass (0.12.2)
Using compass-rails (1.0.3)
Using compass-twitter-bootstrap (0.0.1)
Using debugger-ruby_core_source (1.1.4)
Using debugger-linecache (1.1.2)
Using debugger (1.2.1)
Using formtastic (2.2.1)
Using jquery-rails (2.1.3)
Using rails (3.2.1)
Using sass-rails (3.2.5)
Installing tiny_tds (0.5.1) with native extensions
[33mGem::Installer::ExtensionBuildError: ERROR: Failed to build gem native extension.

        /usr/bin/ruby1.9.1 extconf.rb
checking for iconv_open() in iconv.h... yes
checking for sybfront.h... no
-----
freetds is missing.
-----
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers.  Check the mkmf.log file for more
details.  You may need configuration options.

Provided configuration options:
    --with-opt-dir
    --without-opt-dir
    --with-opt-include
    --without-opt-include=${opt-dir}/include
    --with-opt-lib
    --without-opt-lib=${opt-dir}/lib
    --with-make-prog
    --without-make-prog
    --srcdir=.
    --curdir
    --ruby=/usr/bin/ruby1.9.1
    --enable-lookup
    --disable-lookup
    --with-iconv-dir
    --without-iconv-dir
    --with-iconv-include
    --without-iconv-include=${iconv-dir}/include
    --with-iconv-lib
    --without-iconv-lib=${iconv-dir}/lib
    --with-freetds-dir
    --without-freetds-dir
    --with-freetds-include
    --without-freetds-include=${freetds-dir}/include
    --with-freetds-lib
    --without-freetds-lib=${freetds-dir}/lib


Gem files will remain installed in /home/railsadmin/.bundler/tmp/5501/gems/tiny_tds-0.5.1 for inspection.
Results logged to /home/railsadmin/.bundler/tmp/5501/gems/tiny_tds-0.5.1/ext/tiny_tds/gem_make.out
[0m [31mAn error occurred while installing tiny_tds (0.5.1), and Bundler cannot continue.
Make sure that `gem install tiny_tds -v '0.5.1'` succeeds before bundling. [0m

[k...@metaskills.net]

freetds is missing.

Do you have FreeTDS installed?

https://github.com/rails-sqlserver/tiny_tds#install

[bwb]

Ken.  Thanks for your response--

No.  I was hoping it was that simple.  And fearing that was required, as I'm working in an unfamiliar environment (Linux 12.04 Server, with only terminal window access.)  In my home directory i have established a freetds folder from the freetds tar archive at ubuntu.  how do i point at it?  How does one apply the knowledge from your statement at gihub, to wit:

"Although we search for FreeTDS's libraries and headers, you may have to specify include and lib directories using--with-freetds-include=/some/local/include/freetds and --with-freetds-lib=/some/local/lib"

[k...@metaskills.net]

You can build a native gem that downloads FreeTDS and statically links to it using nothing more than git, bunlder and a few rake commands. See the link below. Might be a good solution for you.

https://github.com/rails-sqlserver/tiny_tds#using-miniportile

[bwb]

Got FreeTDS installed and all is well.  Thanks.

On Thursday, November 1, 2012 4:00:40 PM UTC-4, bwb wrote:

[Adrian Muhrer]

could you post what you did to get it working?

i have the same problem

[Ken Collins]

I would assume they either (a) installed FreeTDS on their system via whatever their platform and package manger options were, out of scope for this list or (b) used TinyTDS's self contained build system to make a gem that has all dependencies self-contained in static libs as described here.

https://github.com/rails-sqlserver/tiny_tds/#using-miniportile

 - Ken