Rails Installer Sqlite3 Issue

[Darrell Sanderlin]

$ 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.

    current directory: c:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/sqlite3-1.4.0/ext/sqlite3

c:/RailsInstaller/Ruby2.3.3/bin/ruby.exe -r ./siteconf20190224-8252-5q8idu.rb 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:/RailsInstaller/Ruby2.3.3/bin/$(RUBY_BASE_NAME)

        --with-sqlcipher

        --without-sqlcipher

        --with-sqlite3-config

        --without-sqlite3-config

        --with-pkg-config

        --without-pkg-config

        --with-sqlcipher

        --without-sqlcipher

        --with-sqlite3-dir

        --without-sqlite3-dir

        --with-sqlite3-include

        --without-sqlite3-include=${sqlite3-dir}/include

        --with-sqlite3-lib

        --without-sqlite3-lib=${sqlite3-dir}/lib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  c:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sqlite3-1.4.0/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in c:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/sqlite3-1.4.0 for inspection.

Results logged to c:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sqlite3-1.4.0/gem_make.out

*************************************************************

package configuration for sqlite3 is not found

find_header: checking for sqlite3.h... -------------------- no

"gcc -o conftest.exe -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0/i386-mingw32 -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0/ruby/backward -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0 -I. -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0501 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64   -O3 -fno-omit-frame-pointer -fno-fast-math -g -Wall -Wextra -Wno-unused-parameter -Wno-parentheses -Wno-long-long -Wno-missing-field-initializers -Wunused-variable -Wpointer-arith -Wwrite-strings -Wdeclaration-after-statement -Wimplicit-function-declaration -Wdeprecated-declarations -Wno-packed-bitfield-compat conftest.c  -L. -Lc:/RailsInstaller/Ruby2.3.3/lib -L.      -lmsvcrt-ruby230  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "

checked program was:

/* begin */

1: #include "ruby.h"

2: 

3: #include <winsock2.h>

4: #include <windows.h>

5: int main(int argc, char **argv)

6: {

7:   return 0;

8: }

/* end */

"gcc -E -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0/i386-mingw32 -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0/ruby/backward -Ic:/RailsInstaller/Ruby2.3.3/include/ruby-2.3.0 -I. -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0501 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64   -O3 -fno-omit-frame-pointer -fno-fast-math -g -Wall -Wextra -Wno-unused-parameter -Wno-parentheses -Wno-long-long -Wno-missing-field-initializers -Wunused-variable -Wpointer-arith -Wwrite-strings -Wdeclaration-after-statement -Wimplicit-function-declaration -Wdeprecated-declarations -Wno-packed-bitfield-compat  conftest.c -o conftest.i"

conftest.c:5:21: fatal error: sqlite3.h: No such file or directory

compilation terminated.

checked program was:

/* begin */

1: #include "ruby.h"

2: 

3: #include <winsock2.h>

4: #include <windows.h>

5: #include <sqlite3.h>

/* end */

--------------------

Help??

[Darrell Sanderlin]

Gave up and just used Postgresql.

[Itai]

any luck with this error?

i have it too , on Win10 32bit and also Win7 32bit.

[Itai]

how do i use the Postgresql ?

[Darrell Sanderlin]

I was able to get PostgreSQL installed and that fixed that issue but I ran into other issues with Windows 10.  Finally, I installed Ubuntu as a dual boot and have not had any issues since then.

Darrell Sanderlin

919-250-8071

--
You received this message because you are subscribed to the Google Groups "RailsInstaller" group.
To unsubscribe from this group and stop receiving emails from it, send an email to railsinstalle...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Itai]

so , more than 10 years , and still in cant be setup correctly on windows....

so moving to Unix.... /-:

thanks alot Darrel.

btw,

can i ,please ,write you if i would have more issues ?