Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Installing a Ruby Development Environment Installing a Ruby Development Environment Installing Ruby on Windows

Rohit Verma
Rohit Verma
4,198 Points

gem install sqlite3 not working

i get the following out put in cmd (Windows):

Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\ABC>gem install sqlite3 Temporarily enhancing PATH to include DevKit... Building native extensions. This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native extension.

C:/Ruby21-x64/bin/ruby.exe extconf.rb

checking for sqlite3.h... no sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first. *** 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=C:/Ruby21-x64/bin/ruby --with-sqlite3-dir --without-sqlite3-dir --with-sqlite3-include --without-sqlite3-include=${sqlite3-dir}/include --with-sqlite3-lib --without-sqlite3-lib=${sqlite3-dir}/lib

extconf failed, exit code 1

Gem files will remain installed in C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/sqlite 3-1.3.10 for inspection. Results logged to C:/Ruby21-x64/lib/ruby/gems/2.1.0/extensions/x64-mingw32/2.1.0 /sqlite3-1.3.10/gem_make.out

C:\Users\ABC>

2 Answers

Jason Goebel
Jason Goebel
4,351 Points

That is how I fixed the stipulation.

1: Go to: www.sqlite.org/download.html

2: Download <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-shell-win32-x86-3080701.zip </a> and the <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-dll-win32-x86-3080701.zip </a> files under Precompiled Binaries for Windows. (versions may differ)

3: Extract both the files into the Ruby[ver]/bin directory. Ex. c:\Ruby21-x64\bin\

4: Now try again: gem install sqlite3

That should work.

OS: Windows 8.1

Jason Goebel
Jason Goebel
4,351 Points

UPDATE: Changing this template will fix it for all servers you make...

OPEN (versions may vary)

\Ruby21-x64\lib\ruby\gems\2.1.0\gems\railties-4.1.6\lib\rails\generators\rails\‌​app\templates\Gemfile file.

EDIT

platforms: [:mingw, :mswin]

to read

platforms: [:mingw, :mswin, :x64_mingw]

SAVE

this should fix

checking for sqlite3.h... no sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first.

Did you try what the error suggested and install SQLite before attempting to build the gem?

Rohit Verma
Rohit Verma
4,198 Points

I followed instructions on this page. http://mislav.uniqpath.com/rails/install-sqlite3/#windows

Now when i enter "gem install sqlite3" i get --> Done installing documentation after 0 seconds