new rails project error

[CC Chen]

Hi all,

I install Ruby1.9.2po0 and Rails3.2.3 on RedHat5
When I create a project "rails nwe chapter"

It show below error message:
*************************************************************
Installing sqlite3 (1.3.5) with native extensions
Gem::Installer::ExtensionBuildError: 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
An error occured while installing sqlite3 (1.3.5), and Bundler cannot
continue.
Make sure that `gem install sqlite3 -v '1.3.5'` succeeds before bundling
***********************************************************

I also try to "gem install sqlite3" but it show:
***********************************************************
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

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

How to fixed this problem?

Or do I change database to mysql from sqlite3?

Thanks,

--
Posted via http://www.ruby-forum.com/.

[Juan Pablo Avello]

I never faced this problem myself and I can't assure this will solve it but having seen other similar problems, I'd start by checking that your system has the 'libsqlite3-dev' package installed.

Anyway its probably better to install mysql or other db system, as you will do it eventually anyway. Just make sure you install the '-dev' packages as well.

Regards.

[CC Chen]

Juan Pablo Avello wrote in post #1055004:
> El mircoles 4 de abril de 2012 15:30:15 UTC+2, Ruby-Forum.com User
> escribi:

>> Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native

>> checking for sqlite3_load_extension()... no

>> database.c:47: error: 'SQLITE_OPEN_READWRITE' undeclared (first use in

>> make: *** [database.o] Error 1
>>

>> checking for sqlite3_initialize()... no

>> -O3 -ggdb -Wextra -Wno-unused-parameter -Wno-parentheses -Wpointer-arith

>> this function)

>>
>> Posted via http://www.ruby-forum.com/.
>>
>
> I never faced this problem myself and I can't assure this will solve it
> but
> having seen other similar problems, I'd start by checking that your
> system
> has the 'libsqlite3-dev' package installed.
>
> Anyway its probably better to install mysql or other db system, as you
> will
> do it eventually anyway. Just make sure you install the '-dev' packages
> as
> well.
>
> Regards.

Is the 32bit or 64bit problems?

How to check 'libsqlite3-dev'/'-dev' installed or not?

Thanks & Best Regards

[Juan Pablo Avello]

If you are using ubuntu or other apt- system, you can check: aptitude search sqlite3, which will list packages containing that word; installed packages will look like "i   libsqlite3-dev....". Not installed packages will appear with 'p' instead of 'i'.

[CC Chen]

Juan Pablo Avello wrote in post #1055007:

> If you are using ubuntu or other apt- system, you can check: aptitude
> search sqlite3, which will list packages containing that word; installed
> packages will look like "i libsqlite3-dev....". Not installed packages
> will appear with 'p' instead of 'i'.
>
>

> El mircoles 4 de abril de 2012 16:26:40 UTC+2, Ruby-Forum.com User
> escribi:

I can install mysql by 'gem install mysql'

My system redhat5 can't use apt- to update or download, so can't use
aptitude to search sqlite3

Could I change the sqlite3 to mysql when 'rails new project' created and
how to do?

Thanks,

[Colin Law]

All you have to do is change database.yml and Gemfile, but you will
run into similar problems I expect installing mysql gems and others.
You will need to install various development libraries. You need to
find out how to install stuff on your system, you will have no hope of
getting very far otherwise. Alternatively change to ubuntu where you
will find more help here.

Colin

[Rogerio Medeiros]

http://sachachua.com/blog/p/22184/

2012/4/4 CC Chen <li...@ruby-forum.com>

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

--
att,

Rogerio

A complicação se descomplica na mesma proporção que fazemos os nós se desatarem ao tecer o conhecimento do saber.

[YogiZoli]

Try to use RVM on Debian too
http://beginrescueend.com/os/debian/
http://blog.beyondthecorner.co.uk/2010/04/06/installing-rvm-on-debian-lenny/
it's gonna solve all your Gem dependency issues.

> > Posted viahttp://www.ruby-forum.com/.