new rails project error

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:

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

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.

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

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

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,

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

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.