安装gem sqlite3错误 - centos5.6

Question

我想安装在rails上的ruby的sqlite3 gem，并且得到这个错误...我已经成功地通过yum安装了sqlite3。

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

     /usr/local/rvm/rubies/ruby-1.9.3-p125/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 
compiling 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:81: warning: implicit declaration of function ‘sqlite3_open_v2’ 
database.c: In function ‘set_sqlite3_func_result’: 
database.c:285: error: ‘sqlite3_int64’ undeclared (first use in this function) 
database.c:285: error: expected expression before ‘long’ 
database.c: In function ‘collation’: 
database.c:628: warning: implicit declaration of function ‘sqlite3_create_collation_v2’ 
database.c: In function ‘load_extension’: 
database.c:657: warning: implicit declaration of function ‘sqlite3_load_extension’ 
database.c: In function ‘enable_load_extension’: 
database.c:678: warning: implicit declaration of function ‘sqlite3_enable_load_extension’ 
make: *** [database.o] Error 1 


Gem files will remain installed in /usr/local/rvm/gems/[email protected]/gems/sqlite3-1.3.5 for inspection. 
Results logged to /usr/local/rvm/gems/[email protected]/gems/sqlite3-1.3.5/ext/sqlite3/gem_make.out 

Answer 1

An older guide演示了如何安装SQLite和所有devel包过，加上一些其他技巧。看起来你只是在搞教程，但如果你打算开发，我会建议安装一个'真正'的数据库。一个具有更多功能，而不是什么。 MySQL或PostgreSQL。

此外，请确保您正在通过64位操作系统安装它，因为它看起来需要它从错误堆栈或正在寻找它。