Sqlite3 on Ruby

Hello I’m trying to install gem sqlite 3 and I’m getting this error:

root@kundera-laptop:/usr/local/lib/ruby/gems# gem install sqlite3-ruby
–version 1.2.2
Building native extensions. This could take a while…
ERROR: Error installing sqlite3-ruby:
ERROR: Failed to build gem native extension.

/usr/local/bin/ruby extconf.rb
checking for fdatasync() in -lrt… yes
checking for sqlite3.h… no
*** 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/local/bin/ruby
–with-sqlite3-dir
–without-sqlite3-dir
–with-sqlite3-include
–without-sqlite3-include=${sqlite3-dir}/include
–with-sqlite3-lib
–without-sqlite3-lib=${sqlite3-dir}/lib
–with-rtlib
–without-rtlib

Gem files will remain installed in
/usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.2 for inspection.
Results logged to
/usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.2/ext/sqlite3_api/gem_make.out

The make out file was not helpful at all so if anyone knows what is the
problem , what do I need to install I will highly appreciate it.
Regards

Which O/S are you using?

For Windows XP, sqlite3-ruby 1.2.3 apparently was the last version which
had
a precompiled gem file available (hence the attempt by gem to compile a
fresh one for version 1.2.4 or newer installations). The work-around is
to
install an older version which seems to work although it has its
foibles. So
to install the older version just type:

C:> gem install sqlite3-ruby -v=1.2.3

Satish T.

On Wed, Jun 10, 2009 at 10:17 AM, Francisco Colina
<[email protected]

Francisco Colina wrote:

Hello I’m trying to install gem sqlite 3 and I’m getting this error:

root@kundera-laptop:/usr/local/lib/ruby/gems# gem install sqlite3-ruby
–version 1.2.2
Building native extensions. This could take a while…

You need to install the sqlite development headers also. You could find
some information if you search the net for something like “ubuntu
install sqlite3” - you’ll need to set up sqlite with the development
headers and then when you run the sqlite3 gem install, it will be able
to build native extensions.

Cheers,
Mohit.
6/10/2009 | 2:35 PM.

Hi:

I had a similar error. The error went away when I installed
libsqlite3-dev on Linux (Ubuntu).via Synaptic.

Hope this helps.

Good day.

Mohit & Satish

Thank you guys for the reply , I successfully install sqlite3 in my
computer.

Regards