Rails - Jan 2012 - gem install sqlite3-ruby still not working

Dear all,
        I am trying to install ruby on rails...but the sqlite3-ruby part 
has been the trouble giver. I read almost every trouble shoot given in 
various forums in internet but nothing worked? 

I am attaching the output of the command here too. Please help me. 

sudo gem install sqlite-ruby-2.2.3.gem 
Building native extensions.  This could take a while...
ERROR:  Error installing sqlite-ruby-2.2.3.gem:
        ERROR: Failed to build gem native extension.

        /usr/local/bin/ruby extconf.rb
checking for main() in -lsqlite... no
checking for sqlite.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-sqlite-dir
        --without-sqlite-dir
        --with-sqlite-include
        --without-sqlite-include=${sqlite-dir}/include
        --with-sqlite-lib
        --without-sqlite-lib=${sqlite-dir}/lib
        --with-sqlitelib
        --without-sqlitelib


Gem files will remain installed in 
/usr/local/lib/ruby/gems/1.8/gems/sqlite-ruby-2.2.3 for inspection.
Results logged to 
/usr/local/lib/ruby/gems/1.8/gems/sqlite-ruby-2.2.3/ext/gem_make.out

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/XS_paYfsrIUJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Tue, Jan 03, 2012 at 01:52:10AM -0800, Libber wrote:
> I am trying to install ruby on rails...but the sqlite3-ruby part 
> has been the trouble giver. I read almost every trouble shoot given in 
> various forums in internet but nothing worked?
What did you try?  Have you also tried installing the sqlite3 header files?


Peter

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 3 January 2012 09:52, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Dear all,
>         I am trying to install ruby on rails...but the sqlite3-ruby part
has
> been the trouble giver. I read almost every trouble shoot given in various
> forums in internet but nothing worked?
Which operating system are you using and which version of rails?

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I am using ubuntu 10.04. 
$ ruby -v
ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-linux]

$rails -v
Rails 2.2.3

These are the additional header files I installed already 
$ sudo apt-get install libsqlite3-0 libsqlite3-dev

I am behind a bad proxy, so i downloaded all gem files and installed 
locally. This sqlite-ruby-2.2.3.gem also, I downloaded and am trying to 
install locally.

Thanks,



-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/UEQb1AZg29QJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 3 January 2012 10:16, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> I am using ubuntu 10.04.
> $ ruby -v
> ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-linux]
>
> $rails -v
> Rails 2.2.3
>
> These are the additional header files I installed already
> $ sudo apt-get install libsqlite3-0 libsqlite3-dev
>
> I am behind a bad proxy, so i downloaded all gem files and installed
> locally. This sqlite-ruby-2.2.3.gem also, I downloaded and am trying to
> install locally.
>
I don''t know whether it may be the problem but have you also installed
sqlite3?
sudo apt-get install sqlite3

Otherwise you could use apt-file search to find which package should
supply sqlite.h

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I already have it. 
$ sudo apt-get install sqlite3 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
sqlite3 is already the newest version.
>>Otherwise you could use apt-file search to find which package should
supply sqlite.h

How do I do this? ( I am newbie to ubuntu...please bare with me)

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/HZoDA542IlQJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Tue, Jan 3, 2012 at 11:49 AM, Colin Law
<clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:
> On 3 January 2012 10:16, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> > I am using ubuntu 10.04.
> > $ ruby -v
> > ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-linux]
> >
> > $rails -v
> > Rails 2.2.3
> >
> > These are the additional header files I installed already
> > $ sudo apt-get install libsqlite3-0 libsqlite3-dev
> >
> > I am behind a bad proxy, so i downloaded all gem files and installed
> > locally. This sqlite-ruby-2.2.3.gem also, I downloaded and am trying
to
> > install locally.
> >
>
> I don''t know whether it may be the problem but have you also
installed
> sqlite3?
> sudo apt-get install sqlite3
>
> Otherwise you could use apt-file search to find which package should
> supply sqlite.h
>
Strange ...

On my system (Ubuntu 11.10 here), everything points to sqlite3 (THREE that
is) .

So, I get  sqlite3.h  (THREE) from here:

~/b$ dpkg -L libsqlite3-dev
/.
/usr
/usr/include
/usr/include/sqlite3.h
/usr/include/sqlite3ext.h

But, the OP seems to require sqlite.h  (without 3)
> checking for sqlite.h... no
and that is indeed found in a different package:


$ apt-file search sqlite.h
...
libsqlite0-dev: /usr/include/sqlite.

that was not mentioned in the apt-get install list of the OP.

So, why is the OP trying to install a version of sqlite that
seems to be older than sqlite3 ??

@Libber could you please post the Gemfile and Gemfile.lock (if available)
from the root directory of your Rails project.

Why are you caring for the ''sqlite-ruby'' gem ? Why not simply

  gem ''sqlite3''

in your Gemfile that seems to bring little trouble to users on Ubuntu 10.04
(I have used it there for many cases and never had trouble with it).

Hope This Helps (not entirely sure, actually ...)

Peter

-- 
Peter Vandenabeele
http://twitter.com/peter_v
http://rails.vandenabeele.com

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

@ Peter,
       In my rails project directory, where should I search for gemfile, 
gemfile.lock? can you explain ?

while Installing RoR,  I have to sqlite3, and then link this to RoR using 
sqlite3-ruby. So, The first step is fine...second gives me this error!. 

Is there any way I can use some other database software other than sqlite3 
and get rid of the error( and hope to get no more errors)

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/cDVuk_kv1dMJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 3 January 2012 09:52, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Dear all,
>         I am trying to install ruby on rails...but the sqlite3-ruby part
has
> been the trouble giver. I read almost every trouble shoot given in various
> forums in internet but nothing worked?
>
> I am attaching the output of the command here too. Please help me.
>
> sudo gem install sqlite-ruby-2.2.3.gem
I think the problem may be that you are trying to install sqlite-ruby
instead of sqlite3-ruby

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Tue, Jan 3, 2012 at 12:29 PM, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> @ Peter,
>        In my rails project directory, where should I search for gemfile,
> gemfile.lock? can you explain ?
>
Sorry, I had not seen you are using the older Rails version 2.2.3  ....
There is no Gemfile and Gemfile.lock
there by default.

> while Installing RoR,  I have to sqlite3, and then link this to RoR using
> sqlite3-ruby. So, The first step is fine...second gives me this error!.
>
> Is there any way I can use some other database software other than sqlite3
> and get rid of the error( and hope to get no more errors)
>
You could use

  gem ''mysql2'', ''~>0.3.10'' # Ubuntu :
libmysql-ruby1.9.1 libmysqlclient-dev
  gem ''pg'' # Ubuntu : libpq-dev

but those will have other set-up issue that you need to handle.

Peter

-- 
Peter Vandenabeele
http://twitter.com/peter_v
http://rails.vandenabeele.com

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

@collin:
           Wonderful, I was literally crying for the past 20 days in trying 
to install this sqlite3-ruby. The whole mistake is I should have used 
"sqlite3-ruby" instead of "sqlite-ruby".  Thank you very
much.

Thanks a lot once again....

It is working ...yureka...:)

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/fsLvnnZq5M8J.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 3 January 2012 12:08, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> @collin:
>            Wonderful, I was literally crying for the past 20 days in trying
> to install this sqlite3-ruby. The whole mistake is I should have used
> "sqlite3-ruby" instead of "sqlite-ruby".  Thank you
very much.
Thanks should go to Peter Vandenabeele also, it was his pointing out
that sqlite.h should not be used by sqlite3 that made me notice your
error.

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Sorry for that....

A special thanks to Peter Vandenabeele also.

"Long live open source communities "

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/4VcOr91JLNIJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Tue, Jan 3, 2012 at 1:26 PM, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> Sorry for that....

No prob, you''re welcome :-)

Still, is this a new application you are starting (since you are
now setting up the first database connection)?

Why not use the easy default Rails 3 set-up. Setting it up on
Ubuntu 10.xy, 11.xy is a breeze [0].

You will have more trouble getting support on this list for
a 2.2.x application than a 3.x application. Also, I a doubt
if security updates are still supported for 2.2.x Rails apps ...

HTH,

Peter

[0] one of the many tutorials for Ruby on Linux (I wrote it)
http://rails.vandenabeele.com/blog/2011/11/26/installing-ruby-and-rails-with-rvm-on-ubuntu-11-dot-10/

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

For some reason, curl does not work when we are behind a proxy. I actually 
started my project with the same link you gave. After two days without 
result, I switched to the present way...

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/qoWxVfvkKbMJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Tue, Jan 3, 2012 at 2:13 PM, Libber
<amarnath.alapati-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> For some reason, curl does not work when we are behind a proxy.

Do you mean the curl to download rvm ?

I assume you know that there are ways on Linux to set proxy settings system
wide
(I don''t know much detail, but that problem should be possible to
resolve).

Specifically for rvm, this page could be relevant:

http://beginrescueend.com/workflow/proxy/
"Installing RVM behind a proxy"

> I actually started my project with the same link you gave. After two days
> without result, I switched to the present way...

Maybe I misunderstood your problem. Could you explain a little more detail
please.
If needed, I can improve the text to discuss this problem and the solution.

And ... even without rvm, why not use Rails 3.1 ? Why is the proxy not a
problem
for Rails 2.2.x and it is a problem for Rails 3.1?

Sorry for all the questions, but I am curious what is the real problem.

Peter

-- 
Peter Vandenabeele
http://twitter.com/peter_v
http://rails.vandenabeele.com

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

@Peter,
           Thanks for those links. The whole problem with proxy was that my 
password contains special characters(it is must to have atleast one special 
character), Now I figured out a way to change the password and without a 
special character. This worked and in the next computer I am running rvm 
with ease...... and rails >3.x.... 

Thanks 

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/NK-135E3Ib4J.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.