Installation issue with ruby on rails/sqlite3..

410 views
Skip to first unread message

Hemant Bhargava

unread,
Mar 5, 2015, 9:18:06 AM3/5/15
to rubyonra...@googlegroups.com
Folks,

I just used rails installer to install ruby on rails on my windows 8
machine. I was happy to see that my installation went through without
any issue.
As most of you know, it creates a dummy rails app on installation, todo
app. I thought of running this before jumping into something else.

So, I did "bundle install" and then "rails s" to run server, it went
well until I typed "localhost:3000" in my browser. Message I got in
console was :

ERROR LoadError: Please install the sqlite3 adapter: 'gem install
ativerecord-dqlite-adapter' <sqlite3 is not part of the bundle. Add it
to Gemfile.>

I needed to update the certificates(.pem file) to install sqlite3(Thanks
to ruby-forum for helping me on this as well). Now,
I can see that even sqlite3 is also installed on my machine.

Doing "bundle show sqlite3" gives :
C:/Rails
Installer/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sqlite3-1.3.8-x86-mingw32

Fair enough. So, I should be able to run server now. Right?

Surprisingly, "rails s" is giving me another error message now. Message
is :
C:/Rails
Installer/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sqlite3-1.3.8-x86-mingw32/lib/sqlite3.rb:
in 'require' : cannot load such file --
sqlite3/sqlite3_native<LoadError>
from ...
....


I would appreciate if someone can help me to fix this quickly. Cheers!

--
Posted via http://www.ruby-forum.com/.

Sushruth Sivaramakrishnan

unread,
Mar 5, 2015, 9:19:51 AM3/5/15
to rubyonra...@googlegroups.com

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/50c084fcb6bcb1d374d7e8a157cab5aa%40ruby-forum.com.
For more options, visit https://groups.google.com/d/optout.

Hemant Bhargava

unread,
Mar 5, 2015, 9:45:34 AM3/5/15
to rubyonra...@googlegroups.com
>
http://stackoverflow.com/questions/17643897/cannot-load-such-file-sqlite3-sqlite3-native-loaderror-on-ruby-on-rails
>

Hi Sushruth,

That's nice. I can see that problem going away now. But again, I find
myself hitting another error now. I do not understand why installation
is such a pain. Should't it be pretty straightforward?

Anyway, message I get is:

ERROR LoadError : Please install the sqlite3 adapter: `gem install
activerecord-sqlite3-adapter` <cannot load such file -- sqlite>


Doing "gem install activerecord-sqlite3-adapter" gives

ERROR: Could not find a valid gem 'activerecord-sqlite3-adapter'.

Any idea?

Sushruth Sivaramakrishnan

unread,
Mar 5, 2015, 9:48:50 AM3/5/15
to rubyonra...@googlegroups.com
Hemant, 

All your questions should be covered. 
If you have more doubts, may i suggest the #rubyonrails IRC where it might be easier for people to help you out.

Regards,
Sushruth

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.

Colin Law

unread,
Mar 5, 2015, 9:55:15 AM3/5/15
to rubyonra...@googlegroups.com
On 5 March 2015 at 14:44, Hemant Bhargava <li...@ruby-forum.com> wrote:
>>
> http://stackoverflow.com/questions/17643897/cannot-load-such-file-sqlite3-sqlite3-native-loaderror-on-ruby-on-rails
>>
>
> Hi Sushruth,
>
> That's nice. I can see that problem going away now. But again, I find
> myself hitting another error now. I do not understand why installation
> is such a pain. Should't it be pretty straightforward?

It is often problematic on Windows. Better in my opinion to use a
linux variety such as ubuntu or use a Mac. You can run Ubuntu in a
virtual machine on windows or dual boot your pc windows/ubuntu. Then
you will find Rails much more straightforward I believe.

Colin

Hemant Bhargava

unread,
Mar 5, 2015, 12:23:35 PM3/5/15
to rubyonra...@googlegroups.com
Sushruth, Naah it did not help. Thanks for your prompt reply though.

I am still with the same problem of

ERROR LoadError : Please install the sqlite3 adapter: `gem install
activerecord-sqlite3-adapter` <cannot load such file -- sqlite>

As I said earlier, I have the sqlite3 gem installed in my machine. Doing
"bundle show sqlite3" gives :
C:/Rails
Installer/Ruby2.1.0/lib/ruby/gems/2.1.0/gems/sqlite3-1.3.8-x86-mingw32

I wonder which adapter is it talking about..
Reply all
Reply to author
Forward
0 new messages