# Problem with installing sqlite3-ruby

**URL:** <https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486>\
**Category:** Rails\
**Created:** [January 12, 2009, 8:20am UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486 "2009-01-12T08:20:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![A\_Z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/8e7dd6/32.png) [@A\_Z](https://www.ruby-forum.com/u/A_Z)\
**Post date:** [January 12, 2009, 8:20am UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486/1 "2009-01-12T08:20:22Z")

</div>

Hi friends  
I am new to get on the rails & I have allready a problem in installing  
sqlite3-ruby.  
I just made my first programme :Hello world.When I execute  
[http://localhost:3000/hello\_world](http://localhost:3000/hello_world) on my browser,then the following  
error  
comes with it.  
[

no such file to load – sqlite3

RAILS\_ROOT: /home/whatsup3/HelloProject  
Application Trace [http://localhost:3000/hello\_world#](http://localhost:3000/hello_world#) | Framework  
Trace[http://localhost:3000/hello\_world#](http://localhost:3000/hello_world#)| Full  
Trace [http://localhost:3000/hello\_world#](http://localhost:3000/hello_world#)

/usr/lib/ruby/site\_ruby/1.8/rubygems/custom\_require.rb:31:in  
`gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require’

…  
]  
After that I tried:gem install sqlite3-ruby then the folloing error  
comes:

[  
WARNING: Installing to ~/.gem since /usr/lib/ruby/gems/1.8 and  
/usr/bin aren’t both writable.  
WARNING: You don’t have /home/whatsup3/.gem/ruby/1.8/bin in your PATH,  
gem executables will not run.  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.

/usr/bin/ruby extconf.rb install sqlite3-ruby  
checking for fdatasync() in -lrt… no  
checking for sqlite3.h… no

make  
make: \*\*\* No rule to make target `ruby.h', needed by `sqlite3\_api\_wrap.o’.  
Stop.

Gem files will remain installed in  
/home/whatsup3/.gem/ruby/1.8/gems/sqlite3-ruby-1.2.4 for inspection.  
Results logged to  
/home/whatsup3/.gem/ruby/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3\_api/gem\_make.out  
]

What should I do?  
The OS is :Fedora Core 7

---

<div class="post-metadata">

**Author:** ![A\_Z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/8e7dd6/32.png) [@A\_Z](https://www.ruby-forum.com/u/A_Z)\
**Post date:** [January 12, 2009, 8:52am UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486/2 "2009-01-12T08:52:01Z")

</div>

A Z wrote:

> /usr/bin/ruby extconf.rb install sqlite3-ruby  
> checking for fdatasync() in -lrt… no  
> checking for sqlite3.h… no
> 
> make  
> make: \*\*\* No rule to make target `ruby.h', needed by`sqlite3\_api\_wrap.o’.  
> Stop.

Looks like you are missing the development headers for ruby. These are  
often in a separate package from your linux distribution, often called  
something like ruby-dev or something along those lines.

Fred

---

<div class="post-metadata">

**Author:** ![A\_Z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/8e7dd6/32.png) [@A\_Z](https://www.ruby-forum.com/u/A_Z)\
**Post date:** [January 13, 2009, 10:28am UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486/3 "2009-01-13T10:28:25Z")

</div>

Hello,

I have this problem before. I found answer on line. Just install  
sqlite3-ruby-1.2.3 instead of 1.2.4.

command is:

gem install sqlite3-ruby --version 1.2.3

hope it is helpful for you.

2009/1/12 Frederick C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![A\_Z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/8e7dd6/32.png) [@A\_Z](https://www.ruby-forum.com/u/A_Z)\
**Post date:** [January 13, 2009, 2:02pm UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486/4 "2009-01-13T14:02:00Z")

</div>

Thanks a lot.  
I tried with gem install sqlite3-ruby --version 1.2.3 but got following  
error.

[  
gem install sqlite3-ruby --version 1.2.3  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.  
/usr/bin/ruby extconf.rb install sqlite3-ruby --version 1.2.3  
checking for fdatasync() in -lrt… no  
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/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/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.3 for inspection.  
Results logged to  
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.3/ext/sqlite3\_api/gem\_make.out

]

---

<div class="post-metadata">

**Author:** ![A\_Z](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/8e7dd6/32.png) [@A\_Z](https://www.ruby-forum.com/u/A_Z)\
**Post date:** [March 3, 2009, 3:09am UTC](https://www.ruby-forum.com/t/problem-with-installing-sqlite3-ruby/157486/5 "2009-03-03T03:09:31Z")

</div>

This way help me to fix the problem!

SQLite3:  
Without the -d option, rails will default to sqlite.  
To install SQLite3:  
~$ sudo apt-get install libsqlite3-0 libsqlite3-dev  
~$ sudo gem install sqlite3-ruby
