Sqlite3 install error

Hi all,

I try to install sqlite3 in Ruby1.9.2 and RedHat5
I use ‘gem install sqlite3’ or ‘gem install sqlite3-ruby’ to install

All will show below error message:


Building native extensions. This could take a while…
ERROR: Error installing sqlite3:
ERROR: Failed to build gem native extension.

    /usr/local/ruby/bin/ruby 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()… no
checking for sqlite3_backup_init()… no
checking for sqlite3_column_database_name()… no
checking for sqlite3_enable_load_extension()… no
checking for sqlite3_load_extension()… no
creating Makefile

make
gcc -I. -I/usr/local/ruby/include/ruby-1.9.1/x86_64-linux
-I/usr/local/ruby/include/ruby-1.9.1/ruby/backward
-I/usr/local/ruby/include/ruby-1.9.1 -I. -DHAVE_RB_PROC_ARITY -fPIC
-O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wpointer-arith
-Wwrite-strings -Wno-missing-field-initializers -Wno-long-long -o
database.o -c database.c
database.c: In function ‘initialize’:
database.c:47: error: ‘SQLITE_OPEN_READWRITE’ undeclared (first use in
this function)
database.c:47: error: (Each undeclared identifier is reported only once
database.c:47: error: for each function it appears in.)
database.c:47: error: ‘SQLITE_OPEN_CREATE’ undeclared (first use in this
function)
database.c:79: error: ‘SQLITE_OPEN_READONLY’ undeclared (first use in
this function)
database.c: In function ‘set_sqlite3_func_result’:
database.c:285: error: ‘sqlite3_int64’ undeclared (first use in this
function)
make: *** [database.o] Error 1

Gem files will remain installed in
/usr/local/ruby/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.5 for inspection.
Results logged to
/usr/local/ruby/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.5/ext/sqlite3/gem_make.out


I can install mysql by ‘gem install mysql’, but ‘sqlite3’ can’t install.
Does someone can help me to fix the problem?

Regards,

On Wed, Apr 4, 2012 at 5:51 PM, CC Chen [email protected] wrote:

Hi all,

I try to install sqlite3 in Ruby1.9.2 and RedHat5
I use ‘gem install sqlite3’ or ‘gem install sqlite3-ruby’ to install

Hi,

The latest sqlite3 library version on RedHat (or CentOS) 5 is 3.3.6,
but the gem seems to require at least 3.6.16 (per the gem
description).
You can either try to compile a new version of the library on
you system or find an older version of the gem.