sqlite3 (1.3.4) fails to install in bundle on Heroku with Cedar stack.

[crispybacon]

My first night with RoR. I am having trouble getting the first application (chapter 2) from "Ruby on Rails 3 Tutorial" by Michael Hartl to go into production on Heroku.com. At first the it complained about assets not being pre-compiled and I am on Windows 7 so I tried to re install the app using Celadon Cedar stack and got the below error. It asked for a report so I am putting one in. I am puzzled why Heroku defaults to postgres when I originally declared sqlite3 in the gemfile but that is a separate issue. The application installs fine with Bamboo Stack but the "Users" Scaffold fails to run. Sorry for the N00Bn3SS...
-Jesse

$ git push heroku master
Enter passphrase for key '/c/Users/jbacon/.ssh/id_rsa':
Counting objects: 4984, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (4621/4621), done.
Writing objects: 100% (4984/4984), 16.70 MiB | 204 KiB/s, done.
Total 4984 (delta 790), reused 0 (delta 0)

-----> Heroku receiving push
-----> Ruby/Rails app detected
-----> Installing dependencies using Bundler version 1.1.rc
Running: bundle install --without development:test --path vendor/bundle
Fetching gem metadata from http://rubygems.org/.......
Installing rake (0.9.2)
Installing multi_json (1.0.3)
Installing activesupport (3.1.0)
Installing bcrypt-ruby (3.0.1) with native extensions
Installing builder (3.0.0)
Installing i18n (0.6.0)
Installing activemodel (3.1.0)
Installing erubis (2.7.0)
Installing rack (1.3.5)
Installing rack-cache (1.0.3)
Installing rack-mount (0.8.3)
Installing rack-test (0.6.1)
Installing hike (1.2.1)
Installing tilt (1.3.3)
Installing sprockets (2.0.3)
Installing actionpack (3.1.0)
Installing mime-types (1.16)
Installing polyglot (0.3.2)
Installing treetop (1.4.10)
Installing mail (2.3.0)
Installing actionmailer (3.1.0)
Installing arel (2.2.1)
Installing tzinfo (0.3.30)
Installing activerecord (3.1.0)
Installing activeresource (3.1.0)
Using bundler (1.1.rc)
Installing coffee-script-source (1.1.2)
Installing execjs (1.2.9)
Installing coffee-script (2.2.0)
Installing rack-ssl (1.3.2)
Installing json (1.6.1) with native extensions
Installing rdoc (3.11)
Installing thor (0.14.6)
Installing railties (3.1.0)
Installing coffee-rails (3.1.1)
Installing jquery-rails (1.0.16)
Installing pg (0.11.0) with native extensions
Installing rails (3.1.0)
Installing sass (3.1.10)
Installing sass-rails (3.1.4)
Installing sqlite3 (1.3.4) with native extensions Unfortunately, a fatal
error has occurred. Please report this error to the Bundler issue tracker at d so that we can fix it. Thanks!
/usr/local/lib/ruby/1.9.1/rubygems/installer.rb:483:in rescue in block i n build_extensions': ERROR: Failed to build gem native extension. (Gem::Installe r::ExtensionBuildError) /usr/local/bin/ruby extconf.rb checking for sqlite3.h... no sqlite3.h is missing. Try 'port install sqlite3 +universal' or 'yum install sqlite3-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/local/bin/ruby --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 /tmp/build_2zayi7b0gc1lg/vendor/bundle /ruby/1.9.1/gems/sqlite3-1.3.4 for inspection. Results logged to /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/ sqlite3-1.3.4/ext/sqlite3/gem_make.out from /usr/local/lib/ruby/1.9.1/rubygems/installer.rb:486:inblock in bui
ld_extensions'
from /usr/local/lib/ruby/1.9.1/rubygems/installer.rb:446:in each' from /usr/local/lib/ruby/1.9.1/rubygems/installer.rb:446:inbuild_extens
ions'
from /usr/local/lib/ruby/1.9.1/rubygems/installer.rb:198:in install' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/source.rb:90:inblock in install'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/rubygems_integration.rb:78:in preserve_paths' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/source.rb:89:ininstall'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/installer.rb:73:in block in install_gem_from_spec' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/rubygems_integration.rb:93:inwith_build_args'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/installer.rb:72:in install_gem_from_spec' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/installer.rb:56:inblock in run'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/installer.rb:55:in run' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/installer.rb:12:ininstall'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/cli.rb:219:in install' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/vendor/thor/task.rb:22:inrun'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/vendor/thor/invocation.rb:118:in invoke_task' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/lib/bundler/vendor/thor.rb:263:indispatch'
from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r
c/lib/bundler/vendor/thor/base.rb:386:in start' from /tmp/build_2zayi7b0gc1lg/vendor/bundle/ruby/1.9.1/gems/bundler-1.1.r c/bin/bundle:13:in<top (required)>'
from vendor/bundle/ruby/1.9.1/bin/bundle:19:in load' from vendor/bundle/ruby/1.9.1/bin/bundle:19:in

'
!
! Failed to install gems via Bundler.
!
! Heroku push rejected, failed to compile Ruby/rails app

To git@heroku.com:bacononruby.git
! [remote rejected] master -> master (pre-receive hook declined)
error: failed to push some refs to 'git@heroku.com:bacononruby.git'

[hone]

This is an issue with Heroku and not bundler itself. SQLite3 is not installed on heroku's cedar stack. If you need more assistance, please file a support ticket with heroku: http://support.heroku.com.

[crispybacon]

Terence,

Thank you. I will specify postgres for my production group with this
project and re-deploy. I appreciate your response.

-Jesse

On Wed, Oct 26, 2011 at 2:32 PM, Terence Lee <
reply@reply.github.com>wrote:

This is an issue with Heroku and not bundler itself. SQLite3 is not
installed on heroku's cedar stack. If you need more assistance, please file
a support ticket with heroku: http://support.heroku.com.

Reply to this email directly or view it on GitHub:
#1492 (comment)

Jesse Bacon
(703)625-4076