Installation issue with ruby on rails/sqlite3

Rails
1

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’

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
from …
…

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

2

Hemant,
Have a look at this,

Regards
ᐧ

On Thu, Mar 5, 2015 at 7:46 PM, Hemant B. [email protected]

3

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?

4

On 5 March 2015 at 14:44, Hemant B. [email protected] wrote:

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

5

Hemant,

Follow this link,

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
ᐧ

On Thu, Mar 5, 2015 at 8:14 PM, Hemant B. [email protected]

6

Follow this link,

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…