Error installing 1.3.6 in MacOSX10.14

[hahmed]

Hey, I'm trying to install sqlite 1.3.6 (1.4.0 works just fine) in MacOSX10.14 with ruby 2.6.0 and running into an error, how can I fix this?

~ % gem install sqlite3 -v 1.3.6
Building native extensions. This could take a while...
ERROR:  Error installing sqlite3:
	ERROR: Failed to build gem native extension.

    current directory: /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.6/ext/sqlite3
/Users/haroon/.asdf/installs/ruby/2.6.0/bin/ruby -I /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/site_ruby/2.6.0 -r ./siteconf20190226-1207-1spp42e.rb extconf.rb
checking for sqlite3.h... yes
checking for sqlite3_libversion_number() in -lsqlite3... yes
checking for rb_proc_arity()... yes
checking for sqlite3_initialize()... yes
checking for sqlite3_backup_init()... yes
checking for sqlite3_column_database_name()... yes
checking for sqlite3_enable_load_extension()... no
checking for sqlite3_load_extension()... no
checking for sqlite3_open_v2()... yes
checking for sqlite3_prepare_v2()... yes
checking for sqlite3_int64 in sqlite3.h... yes
checking for sqlite3_uint64 in sqlite3.h... yes
creating Makefile

current directory: /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.6/ext/sqlite3
make "DESTDIR=" clean

current directory: /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.6/ext/sqlite3
make "DESTDIR="
compiling backup.c
compiling database.c
database.c:205:3: warning: 'sqlite3_trace' is deprecated: first deprecated in macOS 10.12 [-Wdeprecated-declarations]
  sqlite3_trace(ctx->db, NIL_P(block) ? NULL : tracefunc, (void *)self);
  ^~~~~~~~~~~~~
  sqlite3_trace_v2
/Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk/usr/include/sqlite3.h:2952:36: note: 'sqlite3_trace' has been explicitly marked deprecated here
SQLITE_API SQLITE_DEPRECATED void *sqlite3_trace(
                                   ^
1 warning generated.
compiling exception.c
compiling sqlite3.c
compiling statement.c
statement.c:262:11: warning: implicit declaration of function 'RBIGNUM' is invalid in C99 [-Wimplicit-function-declaration]
      if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
          ^
./sqlite3_ruby.h:16:24: note: expanded from macro 'RBIGNUM_LEN'
#define RBIGNUM_LEN(x) RBIGNUM(x)->len
                       ^
statement.c:262:11: error: member reference type 'int' is not a pointer
      if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
          ^~~~~~~~~~~~~~~~~~
./sqlite3_ruby.h:16:36: note: expanded from macro 'RBIGNUM_LEN'
#define RBIGNUM_LEN(x) RBIGNUM(x)->len
                       ~~~~~~~~~~  ^
statement.c:262:32: error: use of undeclared identifier 'SIZEOF_BDIGITS'
      if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
                               ^
1 warning and 2 errors generated.
make: *** [statement.o] Error 1

make failed, exit code 2

Gem files will remain installed in /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/gems/2.6.0/gems/sqlite3-1.3.6 for inspection.
Results logged to /Users/haroon/.asdf/installs/ruby/2.6.0/lib/ruby/gems/2.6.0/extensions/x86_64-darwin-18/2.6.0-static/sqlite3-1.3.6/gem_make.out

[jonathanhefner]

I encountered this same issue on Ubuntu 18.04. Installing v1.4.0 succeeds, but installing v1.3.6 yields the above error.

If you're trying to install v1.3.6 to satisfy Rails 5.2.2 (related: rails/rails#35154), you might try v1.3.13 instead. Rails 5.2.2 requires sqlite3 "~> 1.3.6", and I was able to install v1.3.13 without any problems.

[isopen]

I encountered this same issue on Debian 9.8.

gem install sqlite3
Building native extensions.  This could take a while...
ERROR:  Error installing sqlite3:
	ERROR: Failed to build gem native extension.
    current directory: /var/lib/gems/2.3.0/gems/sqlite3-1.4.0/ext/sqlite3
/usr/bin/ruby2.3 -r ./siteconf20190307-8587-z0x7ny.rb extconf.rb
mkmf.rb can't find header files for ruby at /usr/lib/ruby/include/ruby.h
extconf failed, exit code 1
Gem files will remain installed in /var/lib/gems/2.3.0/gems/sqlite3-1.4.0 for inspection.
Results logged to /var/lib/gems/2.3.0/extensions/x86_64-linux/2.3.0/sqlite3-1.4.0/gem_make.out

gem install sqlite3 -v 1.3.6
Building native extensions.  This could take a while...
ERROR:  Error installing sqlite3:
	ERROR: Failed to build gem native extension.
    current directory: /var/lib/gems/2.3.0/gems/sqlite3-1.3.6/ext/sqlite3
/usr/bin/ruby2.3 -r ./siteconf20190307-8745-1hpb01a.rb extconf.rb
mkmf.rb can't find header files for ruby at /usr/lib/ruby/include/ruby.h
extconf failed, exit code 1
Gem files will remain installed in /var/lib/gems/2.3.0/gems/sqlite3-1.3.6 for inspection.
Results logged to /var/lib/gems/2.3.0/extensions/x86_64-linux/2.3.0/sqlite3-1.3.6/gem_make.out

apt install ruby-dev
gem install sqlite3 -v 1.3.6
Building native extensions.  This could take a while...
ERROR:  Error installing sqlite3:
	ERROR: Failed to build gem native extension.
    current directory: /var/lib/gems/2.3.0/gems/sqlite3-1.3.6/ext/sqlite3
/usr/bin/ruby2.3 -r ./siteconf20190307-8854-1xd1pkb.rb extconf.rb
checking for sqlite3.h... yes
checking for sqlite3_libversion_number() in -lsqlite3... yes
checking for rb_proc_arity()... yes
checking for sqlite3_initialize()... yes
checking for sqlite3_backup_init()... yes
checking for sqlite3_column_database_name()... yes
checking for sqlite3_enable_load_extension()... yes
checking for sqlite3_load_extension()... yes
checking for sqlite3_open_v2()... yes
checking for sqlite3_prepare_v2()... yes
checking for sqlite3_int64 in sqlite3.h... yes
checking for sqlite3_uint64 in sqlite3.h... yes
creating Makefile
To see why this extension failed to compile, please check the mkmf.log which can be found here:
  /var/lib/gems/2.3.0/extensions/x86_64-linux/2.3.0/sqlite3-1.3.6/mkmf.log
current directory: /var/lib/gems/2.3.0/gems/sqlite3-1.3.6/ext/sqlite3
make "DESTDIR=" clean
current directory: /var/lib/gems/2.3.0/gems/sqlite3-1.3.6/ext/sqlite3
make "DESTDIR="
compiling backup.c
compiling database.c
compiling exception.c
compiling sqlite3.c
compiling statement.c
In file included from statement.c:1:0:
statement.c: In function ‘bind_param’:
./sqlite3_ruby.h:16:24: warning: implicit declaration of function ‘RBIGNUM’ [-Wimplicit-function-declaration]
 #define RBIGNUM_LEN(x) RBIGNUM(x)->len
                        ^
statement.c:262:11: note: in expansion of macro ‘RBIGNUM_LEN’
       if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
           ^~~~~~~~~~~
./sqlite3_ruby.h:16:34: error: invalid type argument of ‘->’ (have ‘int’)
 #define RBIGNUM_LEN(x) RBIGNUM(x)->len
                                  ^
statement.c:262:11: note: in expansion of macro ‘RBIGNUM_LEN’
       if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
           ^~~~~~~~~~~
statement.c:262:32: error: ‘SIZEOF_BDIGITS’ undeclared (first use in this function)
       if (RBIGNUM_LEN(value) * SIZEOF_BDIGITS <= 8) {
                                ^~~~~~~~~~~~~~
statement.c:262:32: note: each undeclared identifier is reported only once for each function it appears in
Makefile:239:  «statement.o»
make: *** [statement.o] Error 1
make failed, exit code 2
Gem files will remain installed in /var/lib/gems/2.3.0/gems/sqlite3-1.3.6 for inspection.
Results logged to /var/lib/gems/2.3.0/extensions/x86_64-linux/2.3.0/sqlite3-1.3.6/gem_make.out

gem install sqlite3 -v1.3.13
Fetching: sqlite3-1.3.13.gem (100%)
Building native extensions.  This could take a while...
Successfully installed sqlite3-1.3.13
Parsing documentation for sqlite3-1.3.13
Installing ri documentation for sqlite3-1.3.13
Done installing documentation for sqlite3 after 2 seconds
1 gem installed

[failingCode]

Where you able to figure out the problem? I'm dealing with the same thing.

[mmenafra]

Same problem here, any updates?

[gloriaconcepto]

thank @isopen work like magic

[flavorjones]

We're working on shipping precompiled native gems as well as increasing test coverage for people who want to use system libraries. If you're curious please follow #320.