bundle install won't install sqlite3

Question

Hi,

I've followed these instructions to install sqlite3 gem : http://docs.webfaction.com/software/rails.html#installing-sqlite3-ruby from source.

Everything worked fine. But when in my rails application directory i try to "bundle install" to install all gems I get this error :

Installing sqlite3 (1.3.3) with native extensions
/home/plehoux/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubygems/installer.rb:551:in
`rescue in block in build_extensions': ERROR: Failed to build gem native
extension. (Gem::Installer::ExtensionBuildError)

        /home/plehoux/.rvm/rubies/ruby-1.9.2-p290/bin/ruby extconf.rb 
checking for sqlite3.h... yes
checking for sqlite3_libversion_number() in -lsqlite3... yes
checking for rb_proc_arity()... yes
checking for sqlite3_initialize()... no
sqlite3-ruby only supports sqlite3 versions 3.6.16+, please upgrade!
*** 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.

I've installed rvm in my home directory and run ruby 1.9.2 and Gem from ~/.rvm directory.

Any idea?

Accepted Answer

0

Solved! The problem was that we needed to set the sqlite3-ruby installation options via "bundle config".

Here is what finally worked:

bundle config build.sqlite3 --with-sqlite3-include=$HOME/include --with-sqlite3-lib=$HOME/lib --with-sqlite3-dir=$HOME/bin
bundle install

Hope that helps!

permanent link

answered 23 Aug '11, 16:20

seanf ♦♦
11.8k●2●13●33
accept rate: 37%

Answer 2

0

Hi,

You would need to install Sqlite in your home directory as explained here:
http://docs.webfaction.com/software/sqlite.html#installing-sqlite-from-source

You would then need to install sqlite3-ruby using:
http://docs.webfaction.com/software/rails.html#installing-sqlite3-ruby

Hope that helps!

permanent link

answered 23 Aug '11, 01:11

neeravk
1.5k●3●4●11
accept rate: 41%

I already did those two steps.

(23 Aug '11, 01:17) plehoux

Can you try using the command: "which sqlite3" and see if it references the binary inside your home directory?

(23 Aug '11, 01:27) neeravk

~/bin/sqlite3 (yes)

(23 Aug '11, 10:12) plehoux

Answer 3

0

Please try setting LD_LIBRARY_PATH and LD_INCLUDE_PATH when you run your commands, eg:

LD_INCLUDE_PATH=$HOME/include LD_LIBRARY_PATH=$HOME/lib <your command here>

permanent link

answered 23 Aug '11, 10:39

seanf ♦♦
11.8k●2●13●33
accept rate: 37%

LD_INCLUDE_PATH=$HOME/include LD_LIBRARY_PATH=$HOME/lib bundle install

still give the same error.

(23 Aug '11, 11:22) plehoux

Ok, try this - log out of your current SSH session, log back in, and then run the following commands:

export GEM_HOME=$HOME/.rvm/gems/ruby-1.9.2-p290/gems/
LD_INCLUDE_PATH=$HOME/include LD_LIBRARY_PATH=$HOME/lib bundle install sqlite3

(23 Aug '11, 11:46) seanf ♦♦

Same error. (tks a lot for your time!) Strangely, if I run "gem install sqlit3-ruby" everything is find.

gem install sqlite3-ruby Fetching: sqlite3-ruby-1.3.3.gem (100%)

Hello! The sqlite3-ruby gem has changed it's name to just sqlite3. Rather than installing `sqlite3-ruby`, you should install `sqlite3`. Please update your dependencies accordingly.

Thanks from the Ruby sqlite3 team!

<3 <3 <3 <3

Successfully installed sqlite3-ruby-1.3.3 1 gem installed Installing ri documentation for sqlite3-ruby-1.3.3... Installing RDoc documentation for sqlite3-ruby-1.3.3...

(23 Aug '11, 13:21) plehoux

You're very welcome!

I don't think we're going to be able to resolve this here in the public forum. If you'd like us to investigate this further, please open a support ticket to give us permission to log into your account and run these commands ourselves. In the ticket, be sure to let us know the exact commands you are running, and the directory from which you are running them. We'll then try running them and try to get it working for you.

(23 Aug '11, 13:38) seanf ♦♦

bundle install won't install sqlite3

Hello! The sqlite3-ruby gem has changed it's name to just sqlite3. Rather than installing `sqlite3-ruby`, you should install `sqlite3`. Please update your dependencies accordingly.

Thanks from the Ruby sqlite3 team!

<3 <3 <3 <3

Successfully installed sqlite3-ruby-1.3.3 1 gem installed Installing ri documentation for sqlite3-ruby-1.3.3... Installing RDoc documentation for sqlite3-ruby-1.3.3...

Follow this question

Related questions

bundle install won't install sqlite3

Hello! The sqlite3-ruby gem has changed it's name to just sqlite3. Rather than installing sqlite3-ruby, you should install sqlite3. Please update your dependencies accordingly. Thanks from the Ruby sqlite3 team! <3 <3 <3 <3

Successfully installed sqlite3-ruby-1.3.3 1 gem installed Installing ri documentation for sqlite3-ruby-1.3.3... Installing RDoc documentation for sqlite3-ruby-1.3.3...

Follow this question

Related questions

Hello! The sqlite3-ruby gem has changed it's name to just sqlite3. Rather than installing `sqlite3-ruby`, you should install `sqlite3`. Please update your dependencies accordingly.

Thanks from the Ruby sqlite3 team!

<3 <3 <3 <3