From: Luis Lavena <luislavena@...>
Date: 2010-03-02T18:45:08+09:00
Subject: Re: Can't install sqlite3 on Windows XP: Please Help!

On Mar 2, 12:14 am, John Vajda <keroa...@hotmail.com> wrote:
> I am trying to install ruby on windows with gem sqlite3 version 1.2.3 I
> have followed all the instructions here:http://wiki.devchix.com/index.php?title=Server_2003and get stuck on the
> sqlite install: here is the error I get. Please help! I've looked
> everywhere for a solution, but can't resolve it.
>

Sure you looked everywhere?

http://blog.mmediasys.com/2009/07/06/getting-started-with-rails-and-sqlite3/

The DevChix wiki recommend some changes that I would personally not
apply.


> C:\Ruby\lib\ruby\gems\1.8\cache> gem install sqlite3-ruby
> Building native extensions.  This could take a while...
> ERROR:  Error installing sqlite3-ruby:
>         ERROR: Failed to build gem native extension.
>
> C:/Ruby/bin/ruby.exe extconf.rb
> checking for fdatasync() in rt.lib... no
> checking for sqlite3.h... no

As far as the gem installation error you're receiving, is weird:

* There is a native gem for "i386-mswin32" platform (your ruby
installation) in RubyGems:
http://rubygems.org/gems/sqlite3-ruby/versions/1.2.5-x86-mswin32

Which could be, since you're installing from inside the cache folder,
taking an old version of sqlite3-ruby gem.

Can you try installation OUTSIDE that folder? or remove any sqlite3-
ruby gem that is there.

Somehow in your stripping of info removed the path to the ".out" file
which could have helped to determine the version you're trying to
install.

> my environment information:
>
> C:\Ruby\lib\ruby\gems\1.8\cache>gem env
> RubyGems Environment:
>   - RUBYGEMS VERSION: 1.3.6
>   - RUBY VERSION: 1.8.6 (2008-08-11 patchlevel 287) [i386-mswin32]
>   - INSTALLATION DIRECTORY: C:/Ruby/lib/ruby/gems/1.8
>   - RUBY EXECUTABLE: C:/Ruby/bin/ruby.exe
>   - EXECUTABLE DIRECTORY: C:/Ruby/bin
>   - RUBYGEMS PLATFORMS:
>     - ruby
>     - x86-mswin32-60
>   - GEM PATHS:
>      - C:/Ruby/lib/ruby/gems/1.8
>      - C:/Documents and Settings/jvajda/.gem/ruby/1.8
>   - GEM CONFIGURATION:
>      - :update_sources => true
>      - :verbose => true
>      - :benchmark => false
>      - :backtrace => false
>      - :bulk_threshold => 1000
>   - REMOTE SOURCES:
>      -http://rubygems.org/

I would recommend upgrading to RC2 of RubyInstaller, and moving
forward, move to 1.8.7 as it became the stable and supoorted version
of 1.8 line, while 1.8.6 remains only for legacy support.

--
Luis Lavena