Not able to create ne app

I am getting error while creating new app. Here are the details :

create
      create README.rdoc
      create Rakefile
      create config.ru
      create .gitignore
      create Gemfile
      create app
      create app/assets/images/rails.png
      create app/assets/javascripts/application.js
      create app/assets/stylesheets/application.css
      create app/controllers/application_controller.rb
      create app/helpers/application_helper.rb
      create app/mailers
      create app/models
      create app/views/layouts/application.html.erb
      create app/mailers/.gitkeep
      create app/models/.gitkeep
      create config
      create config/routes.rb
      create config/application.rb
      create config/environment.rb
      create config/environments
      create config/environments/development.rb
      create config/environments/production.rb
      create config/environments/test.rb
      create config/initializers
      create config/initializers/backtrace_silencers.rb
      create config/initializers/inflections.rb
      create config/initializers/mime_types.rb
      create config/initializers/secret_token.rb
      create config/initializers/session_store.rb
      create config/initializers/wrap_parameters.rb
      create config/locales
      create config/locales/en.yml
      create config/boot.rb
      create config/database.yml
      create db
      create db/seeds.rb
      create doc
      create doc/README_FOR_APP
      create lib
      create lib/tasks
      create lib/tasks/.gitkeep
      create lib/assets
      create lib/assets/.gitkeep
      create log
      create log/.gitkeep
      create public
      create public/404.html
      create public/422.html
      create public/500.html
      create public/favicon.ico
      create public/index.html
      create public/robots.txt
      create script
      create script/rails
      create test/fixtures
      create test/fixtures/.gitkeep
      create test/functional
      create test/functional/.gitkeep
      create test/integration
      create test/integration/.gitkeep
      create test/unit
      create test/unit/.gitkeep
      create test/performance/browsing_test.rb
      create test/test_helper.rb
      create tmp/cache
      create tmp/cache/assets
      create vendor/assets/javascripts
      create vendor/assets/javascripts/.gitkeep
      create vendor/assets/stylesheets
      create vendor/assets/stylesheets/.gitkeep
      create vendor/plugins
      create vendor/plugins/.gitkeep
         run bundle install
Gem::Installer::ExtensionBuildError: ERROR: Failed to build gem native
extension.

        /usr/bin/ruby1.8 extconf.rb
checking for sqlite3.h... no
sqlite3.h is missing. Try 'port install sqlite3 +universal'
or 'yum install sqlite-devel' and check your shared library search path
(the
location where your sqlite3 shared library is located).
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
  --with-opt-dir
  --without-opt-dir
  --with-opt-include
  --without-opt-include=${opt-dir}/include
  --with-opt-lib
  --without-opt-lib=${opt-dir}/lib
  --with-make-prog
  --without-make-prog
  --srcdir=.
  --curdir
  --ruby=/usr/bin/ruby1.8
  --with-sqlite3-dir
  --without-sqlite3-dir
  --with-sqlite3-include
  --without-sqlite3-include=${sqlite3-dir}/include
  --with-sqlite3-lib
  --without-sqlite3-lib=${sqlite3-dir}/lib
  --enable-local
  --disable-local

Gem files will remain installed in
/home/subhransu/.bundler/tmp/29704/gems/sqlite3-1.3.6 for inspection.
Results logged to
/home/subhransu/.bundler/tmp/29704/gems/sqlite3-1.3.6/ext/sqlite3/gem_make.out
An error occurred while installing sqlite3 (1.3.6), and Bundler cannot
continue.
Make sure that `gem install sqlite3 -v '1.3.6'` succeeds before
bundling.

and I am not able to create new app. How to fix this problem ?

Attachments:
http://www.ruby-forum.com/attachment/7754/Screenshot_from_2012-09-24_01_09_52.png

Have you followed the suggestion *in the error message* ?

Hassan Schroeder wrote in post #1077209:

Well, the bottom line is the development libraries on whatever distro
you're using aren't there for sqlite3 -- you need to figure out how to
install them (or use a different DB for which you do have those libs).

GIYF :slight_smile:

hi,
I use mysql . is it possible to exclude sqlite , then how to ?

Of course. Rails lets you use the database of your choice.

Change your Gemfile (and your config/database.yml) appropriately.

hi,

I use mysql . is it possible to exclude sqlite , then how to ?

you can use the -d option to pass the database you want to use. additionally, you can use

rails new -h to show all options available to you. That lists all database that you can use

in rails.