# sqlite3....Ugghhh\` **URL:** \ **Category:** Rails\ **Created:** [June 19, 2009, 2:40am UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565 "2009-06-19T02:40:29Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![bloodniece](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/47e85d/32.png) [@bloodniece](https://www.ruby-forum.com/u/bloodniece)\ **Post date:** [June 19, 2009, 2:40am UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565/1 "2009-06-19T02:40:29Z")
Hi all, I have been reading and trying all the google links/forums for 2 nights now on how to fix my issue with getting sqlite3 installed so I can use rails. Im running SLED 11. plese help! thank you! $ uname -a Linux linux-7lbv 2.6.27.19-5-pae #1 SMP 2009-02-28 04:40:21 +0100 i686 i686 i386 GNU/Linux $ gem install sqlite3-ruby 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 checking for fdatasync() in -lrt… yes 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 /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4 for inspection. Results logged to /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.4/ext/sqlite3\_api/gem\_make.out linux-7lbv:/home/derek/Desktop # gem list --local \*\*\* LOCAL GEMS \*\*\* actionmailer (2.3.2) actionpack (2.3.2) activerecord (2.3.2) activeresource (2.3.2) activesupport (2.3.2) acts\_as\_ferret (0.4.4) cgi\_multipart\_eof\_fix (2.5.0) daemons (1.0.10) gem\_plugin (0.2.3) rack (1.0.0) rails (2.3.2) rake (0.8.7) rubygems-update (1.3.4) wirble (0.1.3) $ rpm -qa |egrep ‘^libsql|^ruby’ ruby-1.8.7.p72-5.21 libsqlite3-0-3.6.4-2.8 ruby-devel-1.8.7.p72-3.1 ---
**Author:** ![bloodniece](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/47e85d/32.png) [@bloodniece](https://www.ruby-forum.com/u/bloodniece)\ **Post date:** [June 19, 2009, 2:54am UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565/2 "2009-06-19T02:54:32Z")
Derek S. wrote: > Hi all, > > I have been reading and trying all the google links/forums for 2 nights > now on how to fix my issue with getting sqlite3 installed so I can use > rails. > […] Why not use a real DB? I recommend PostgreSQL. ## Best, Marnen Laibow-Koser [http://www.marnen.org](http://www.marnen.org) removed\_email\_address@domain.invalid ---
**Author:** ![bloodniece](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/47e85d/32.png) [@bloodniece](https://www.ruby-forum.com/u/bloodniece)\ **Post date:** [June 19, 2009, 3:55am UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565/3 "2009-06-19T03:55:18Z")
Derek S. wrote: > $ gem install sqlite3-ruby > 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 > checking for fdatasync() in -lrt… yes > checking for sqlite3.h… no You need to install the development set for SQLite3 since the gem has a native build. From: > **[Install SQLite3 in Ubuntu](https://theplana.wordpress.com/2007/05/11/install-sqlite3-on-ubuntu/)** > > Install Sqlite3 sudo apt-get install sqlite3 libsqlite3-dev sudo gem install sqlite3-ruby To create a data base, we only need to create a empty file. touch database\_name\_dev.db touch database\_name\_… you need to do the equivalent of the below step: - Install Sqlite3 sudo apt-get install sqlite3 libsqlite3-dev sudo gem install sqlite3-ruby I’m sorry I’m a limited Linux user (and mostly use Ubuntu there). Cheers Mohit. ---
**Author:** ![bloodniece](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/47e85d/32.png) [@bloodniece](https://www.ruby-forum.com/u/bloodniece)\ **Post date:** [June 22, 2009, 5:26pm UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565/4 "2009-06-22T17:26:31Z")
Derek S. wrote: > The solution was on SLED 11. Thank you for pointing me in the right > direction! Glad to. Cheers, Mohit. 6/22/2009 | 11:25 PM. ---
**Author:** ![bloodniece](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/47e85d/32.png) [@bloodniece](https://www.ruby-forum.com/u/bloodniece)\ **Post date:** [June 19, 2009, 11:28pm UTC](https://www.ruby-forum.com/t/sqlite3-ugghhh/170565/5 "2009-06-19T23:28:30Z")
Mohit S. wrote: > Derek S. wrote: > > > $ gem install sqlite3-ruby > > 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 > > checking for fdatasync() in -lrt… yes > > checking for sqlite3.h… no > > You need to install the development set for SQLite3 since the gem has a > native build. From: > [Install SQLite3 in Ubuntu | The Plan A](http://theplana.wordpress.com/2007/05/11/install-sqlite3-on-ubuntu/) > > you need to do the equivalent of the below step: > > - Install Sqlite3 > sudo apt-get install sqlite3 libsqlite3-dev > sudo gem install sqlite3-ruby > > I’m sorry I’m a limited Linux user (and mostly use Ubuntu there). > > Cheers > Mohit. The solution was on SLED 11. Thank you for pointing me in the right direction! linux-7lbv:/home/derek/Desktop # rpm -i sqlite3-devel-3.6.4-1.8.i586.rpm linux-7lbv:/home/derek/Desktop # gem install sqlite3-ruby Building native extensions. This could take a while… Successfully installed sqlite3-ruby-1.2.4 1 gem installed Installing ri documentation for sqlite3-ruby-1.2.4… Installing RDoc documentation for sqlite3-ruby-1.2.4…