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.