If I install sqlite3-ruby using gem, I get this error.. LoadError: no such file to load -- sqlite3/database I saw this post.. http://www.ruby-forum.com/topic/144703#641008 And it seems that this is most commonly a problem if people don''t have the sqlite3 libraries and headers installed when they build the sqlite3-ruby module. I''ve got those. "gem install sqlite3-ruby" only populates /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2 but if I download the gem from rubyforge, and build and install it by hand, it puts stuff in both... /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2 /usr/lib/ruby/site_ruby/1.8/sqlite3 and creates /usr/lib/ruby/site_ruby/1.8/i686-linux/sqlite3_api.so.. which takes of the "LoadError: no such file to load..." problem. Any ideas why installing sqlite3 via gem doesn''t work, but building it by hand does? -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
What platform are you running this on? On Jun 25, 11:06 am, Liam Hoekenga <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> If I install sqlite3-ruby using gem, I get this error.. > > LoadError: no such file to load -- sqlite3/database > > I saw this post.. > > http://www.ruby-forum.com/topic/144703#641008 > > And it seems that this is most commonly a problem if people don''t have > the sqlite3 libraries and headers installed when they build the > sqlite3-ruby module. I''ve got those. > > "gem install sqlite3-ruby" only populates > > /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2 > > but if I download the gem from rubyforge, and build and install it by > hand, it puts stuff in both... > > /usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.2 > /usr/lib/ruby/site_ruby/1.8/sqlite3 > > and creates /usr/lib/ruby/site_ruby/1.8/i686-linux/sqlite3_api.so.. > which takes of the "LoadError: no such file to load..." problem. > > Any ideas why installing sqlite3 via gem doesn''t work, but building it > by hand does? > -- > Posted viahttp://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---
We''re using a locally developed LFS based linux distribution. No easy access to widely used package management (yum, apt, rpm). I do have ruby 1.8.6 (not p230 - that was causing issues). Linux 2.6.23.1, glibc 2.3.6, sqlite 3.5.9 installed from source. As far as I know, the other gems we''re using are working ok. -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hhmm ... it seems like something is missing to me with the install. I''m not sure if there is something ruby might be missing? On Jun 26, 9:19 am, Liam Hoekenga <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> We''re using a locally developed LFS based linux distribution. No easy > access to widely used package management (yum, apt, rpm). > > I do have ruby 1.8.6 (not p230 - that was causing issues). Linux > 2.6.23.1, glibc 2.3.6, sqlite 3.5.9 installed from source. > > As far as I know, the other gems we''re using are working ok. > -- > Posted viahttp://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---
Oh yeah.. this is Rails 2.1. -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 26 Jun 2008, at 16:12, Liam Hoekenga wrote:> > Oh yeah.. this is Rails 2.1.when you built the gem did you tell it where to find the sqlite headers. Did it print the ''building native extension'' blurb ? Fred> > -- > Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Yup.. # gem install sqlite3-ruby Building native extensions. This could take a while... Successfully installed sqlite3-ruby-1.2.2 1 gem installed Installing ri documentation for sqlite3-ruby-1.2.2... Installing RDoc documentation for sqlite3-ruby-1.2.2... -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Liam Hoekenga wrote:> Yup.. > > # gem install sqlite3-ruby > Building native extensions. This could take a while... > Successfully installed sqlite3-ruby-1.2.2 > 1 gem installed > Installing ri documentation for sqlite3-ruby-1.2.2... > Installing RDoc documentation for sqlite3-ruby-1.2.2...That specific error happened to me on Ubuntu, and I had to install libsqlite3-ruby. I know you don''t have access to packages, but maybe you can look into that package''s content to figure out what you need. -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Thu, Jun 26, 2008 at 9:12 AM, Bobnation <boblmartens-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> LoadError: no such file to load -- sqlite3/databaseI found this evening that I have this same issue on a new Debian install.> dpkg -l|grep sqlite3ii libsqlite3-0 3.3.8-1.1 SQLite 3 shared library ii libsqlite3-dev 3.3.8-1.1 SQLite 3 development files ii libsqlite3-ruby 1.1.0-2 SQLite3 interface for Ruby ii libsqlite3-ruby1.8 1.1.0-2 SQLite3 interface for Ruby 1.8 ii sqlite3 3.3.8-1.1 A command line interface for SQLite 3> gem list --localactionmailer (2.1.0) actionpack (2.1.0) activerecord (2.1.0) activeresource (2.1.0) activesupport (2.1.0) hoe (1.6.0) mysql (2.7) paginator (1.1.1) rails (2.1.0) rake (0.8.1) rcov (0.8.1.2.0) rubyforge (1.0.0) sqlite3-ruby (1.2.2)> ruby -vruby 1.8.7 (2008-06-20 patchlevel 22) [i686-linux]> uname -aLinux mercury 2.6.18-4-686 #1 SMP Wed May 9 23:03:12 UTC 2007 i686 GNU/Linux -- Greg Donald http://destiney.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Thu, Jun 26, 2008 at 10:55 PM, Greg Donald <gdonald-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Thu, Jun 26, 2008 at 9:12 AM, Bobnation <boblmartens-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: >> LoadError: no such file to load -- sqlite3/database > > I found this evening that I have this same issue on a new Debian install. > > sqlite3-ruby (1.2.2)An older version seems to work. gem uninstall sqlite3-ruby gem install sqlite3-ruby -v=1.2.1 -- Greg Donald http://destiney.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I find I get a /more/ complete installation when I install 1.2.1 via gem, but still not functional. The only method that really seems to work for me is to download the gem from rubyforge and to build and install it by hand. :\ -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thanks for the suggestions! On a Mac (10.4.11) I was having this issue with a new Rails 2.1 app. Downgrading to 1.2.1 worked perfectly. On Jun 28, 10:21 pm, "Greg Donald" <gdon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Thu, Jun 26, 2008 at 10:55 PM, Greg Donald <gdon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > On Thu, Jun 26, 2008 at 9:12 AM, Bobnation <boblmart...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > >> LoadError: no such file to load -- sqlite3/database > > > I found this evening that I have this same issue on a new Debian install. > > > sqlite3-ruby (1.2.2) > > An older version seems to work. > > gem uninstall sqlite3-ruby > > gem install sqlite3-ruby -v=1.2.1 > > -- > Greg Donaldhttp://destiney.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-/JYPxA39Uh5TLH3MbocFFw@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 -~----------~----~----~----~------~----~------~--~---