ruby on rails - Heroku rejecting my git push due to SQLite3 -


heroku keeps rejecting pushes error:

 make sure `gem install sqlite3 -v '1.3.11'` succeeds before bundling. remote:  ! remote:  !     failed install gems via bundler. remote:  !      remote:  !     detected sqlite3 gem not supported on heroku. remote:  !     https://devcenter.heroku.com/articles/sqlite3 remote:  ! remote:  !     push rejected, failed compile ruby app. 

i realize common problem (i have looked @ other threads) have tried removing sqlite3 gem gemfile, ran bundle install , made sure sqlite3 gem out of gemfile.lock (which was).
got rid of references sqlite3 database.yml , replaced them postgres:

# default: &default   adapter: postgresql   encoding: unicode   database: store_development   pool: 5   timeout: 5000  development:     adapter: postgresql     encoding: unicode     database: store_development  # warning: database defined "test" erased , # re-generated development database when run "rake". # not set db same development or production. test:   adapter: postgresql   encoding: unicode   database: store_test  production:   adapter: postgresql   encoding: unicode   database: store_development 

i'm lost suggestions?

here gemfile:

source 'https://rubygems.org'

# bundle edge rails instead: gem 'rails', github: 'rails/rails' gem 'rails', '4.2.5.1' # use scss stylesheets gem 'sass-rails', '~> 5.0' # use uglifier compressor javascript assets gem 'uglifier', '>= 1.3.0' # use coffeescript .coffee assets , views gem 'coffee-rails', '~> 4.1.0' #bcrypt for encrpytion gem 'bcrypt', '~> 3.1', '>= 3.1.11' #byebug gem 'byebug', '~> 9.0', '>= 9.0.5' # use jquery javascript library gem 'jquery-rails' # turbolinks makes following links in web application faster. read more: https://github.com/rails/turbolinks gem 'turbolinks' # build json apis ease. read more: https://github.com/rails/jbuilder gem 'jbuilder', '~> 2.0' # bundle exec rake doc:rails generates api under doc/api. gem 'sdoc', '~> 0.4.0', group: :doc #paperclip easy upload management gem 'paperclip', '~> 4.3', '>= 4.3.6' #bootstrap-sass gem 'bootstrap-sass', '~> 3.3', '>= 3.3.6' #searchkick gem 'searchkick', '~> 1.2', '>= 1.2.1' #paginate gem 'will_paginate', '~> 3.1' #paginate bootstrap gem 'bootstrap-will_paginate', '~> 0.0.10' #carrierwave #gem 'carrierwave' #cloudinary #gem 'cloudinary' #paperclip forcloudinary gem 'paperclip-cloudinary' #elasticsearch stuff gem 'elasticsearch-rails' gem 'elasticsearch-model' #bonsi gem 'bonsai-elasticsearch-rails', '~> 0.0.4'    group :development, :test   end  group :development   # access irb console on exception pages or using <%= console %> in views   gem 'web-console', '~> 2.0'   # spring speeds development keeping application running in background. read more: https://github.com/rails/spring   gem 'spring'   #db stuff   gem 'sqlite3'    end group :production   gem 'rails_12factor'   gem 'puma', '~> 3.4'   #postgresql   gem 'pg' end 

i'll include whole heroku rejection reference:

    remote: compressing source files... done. remote: building source: remote:  remote: -----> ruby app detected remote: -----> compiling ruby/rails remote: -----> using ruby version: ruby-2.2.4 remote: -----> installing dependencies using bundler 1.11.2 remote:        running: bundle install --without development:test --path vendor/bundle --binstubs vendor/bundle/bin -j4 --deployment remote:        warning: running version of bundler older version created lockfile. suggest upgrade latest version of bundler running `gem install bundler`. remote:        fetching gem metadata https://rubygems.org/......... remote:        fetching version metadata https://rubygems.org/... remote:        fetching dependency metadata https://rubygems.org/.. remote:        using i18n 0.7.0 remote:        using rake 11.1.2 remote:        using json 1.8.3 remote:        using minitest 5.8.4 remote:        using thread_safe 0.3.5 remote:        using builder 3.2.2 remote:        using erubis 2.7.0 remote:        using mini_portile2 2.0.0 remote:        using rack 1.6.4 remote:        using mime-types-data 3.2016.0221 remote:        using arel 6.0.3 remote:        using execjs 2.6.0 remote:        using aws_cf_signer 0.1.3 remote:        using bcrypt 3.1.11 remote:        using bonsai-elasticsearch-rails 0.0.4 remote:        using sass 3.4.22 remote:        using will_paginate 3.1.0 remote:        using coffee-script-source 1.10.0 remote:        using thor 0.19.1 remote:        using concurrent-ruby 1.0.1 remote:        using orm_adapter 0.5.0 remote:        using multi_json 1.11.2 remote:        using multipart-post 2.0.0 remote:        using hashie 3.4.3 remote:        using elasticsearch-rails 0.1.9 remote:        using mimemagic 0.3.0 remote:        using pg 0.18.4 remote:        using bundler 1.11.2 remote:        using rails_serve_static_assets 0.0.5 remote:        using rails_stdout_logging 0.0.5 remote:        using tilt 2.0.2 remote:        using rdoc 4.2.2 remote:        using tzinfo 1.2.2 remote:        using nokogiri 1.6.7.2 remote:        using mime-types 3.0 remote:        using autoprefixer-rails 6.3.6 remote:        using uglifier 3.0.0 remote:        using rack-test 0.6.3 remote:        using warden 1.2.6 remote:        using bootstrap-will_paginate 0.0.10 remote:        using coffee-script 2.4.1 remote:        using sprockets 3.6.0 remote:        using elasticsearch-api 1.0.17 remote:        using faraday 0.9.2 remote:        using rails_12factor 0.0.3 remote:        using sdoc 0.4.1 remote:        using activesupport 4.2.5.1 remote:        using loofah 2.0.3 remote:        using mail 2.6.4 remote:        using rest-client 1.6.7 remote:        using bootstrap-sass 3.3.6 remote:        using elasticsearch-transport 1.0.17 remote:        using rails-deprecated_sanitizer 1.0.3 remote:        using globalid 0.3.6 remote:        using activemodel 4.2.5.1 remote:        using climate_control 0.0.3 remote:        using jbuilder 2.4.1 remote:        using rails-html-sanitizer 1.0.3 remote:        using cloudinary 1.2.0 remote:        using rails-dom-testing 1.0.7 remote:        using elasticsearch 1.0.17 remote:        using activejob 4.2.5.1 remote:        using cocaine 0.5.8 remote:        using paperclip-cloudinary 1.1.0 remote:        using actionview 4.2.5.1 remote:        using elasticsearch-model 0.1.9 remote:        using activerecord 4.2.5.1 remote:        using searchkick 1.2.1 remote:        using paperclip 4.3.6 remote:        using actionpack 4.2.5.1 remote:        using actionmailer 4.2.5.1 remote:        using railties 4.2.5.1 remote:        using sprockets-rails 3.0.4 remote:        using coffee-rails 4.1.1 remote:        using responders 2.1.2 remote:        using jquery-rails 4.1.1 remote:        using rails 4.2.5.1 remote:        using sass-rails 5.0.4 remote:        using turbolinks 2.5.3 remote:        using devise 4.0.0 remote:        installing sqlite3 1.3.11 native extensions remote:        gem::ext::builderror: error: failed build gem native extension. remote:        /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/ruby-2.2.4/bin/ruby -r ./siteconf20160801-197-lz2bsz.rb extconf.rb remote:        checking sqlite3.h... no remote:        sqlite3.h missing. try 'port install sqlite3 +universal', remote:        'yum install sqlite-devel' or 'apt-get install libsqlite3-dev' remote:        , check shared library search path (the remote:        location sqlite3 shared library located). remote:        *** extconf.rb failed *** remote:        not create makefile due reason, lack of necessary remote:        libraries and/or headers.  check mkmf.log file more details.  may remote:        need configuration options. remote:        provided configuration options: remote:        --with-opt-dir remote:        --without-opt-dir remote:        --with-opt-include remote:        --without-opt-include=${opt-dir}/include remote:        --with-opt-lib remote:        --without-opt-lib=${opt-dir}/lib remote:        --with-make-prog remote:        --without-make-prog remote:        --srcdir=. remote:        --curdir remote:        --ruby=/tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/ruby-2.2.4/bin/$(ruby_base_name) remote:        --with-sqlite3-dir remote:        --without-sqlite3-dir remote:        --with-sqlite3-include remote:        --without-sqlite3-include=${sqlite3-dir}/include remote:        --with-sqlite3-lib remote:        --without-sqlite3-lib=${sqlite3-dir}/lib remote:        extconf failed, exit code 1 remote:        gem files remain installed in /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/bundle/ruby/2.2.0/gems/sqlite3-1.3.11 inspection. remote:        results logged /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/bundle/ruby/2.2.0/extensions/x86_64-linux/2.2.0-static/sqlite3-1.3.11/gem_make.out remote:        error occurred while installing sqlite3 (1.3.11), , bundler cannot remote:        continue. remote:        make sure `gem install sqlite3 -v '1.3.11'` succeeds before bundling. remote:        bundler output: warning: running version of bundler older version created lockfile. suggest upgrade latest version of bundler running `gem install bundler`. remote:        fetching gem metadata https://rubygems.org/......... remote:        fetching version metadata https://rubygems.org/... remote:        fetching dependency metadata https://rubygems.org/.. remote:        using i18n 0.7.0 remote:        using rake 11.1.2 remote:        using json 1.8.3 remote:        using minitest 5.8.4 remote:        using thread_safe 0.3.5 remote:        using builder 3.2.2 remote:        using erubis 2.7.0 remote:        using mini_portile2 2.0.0 remote:        using rack 1.6.4 remote:        using mime-types-data 3.2016.0221 remote:        using arel 6.0.3 remote:        using execjs 2.6.0 remote:        using aws_cf_signer 0.1.3 remote:        using bcrypt 3.1.11 remote:        using bonsai-elasticsearch-rails 0.0.4 remote:        using sass 3.4.22 remote:        using will_paginate 3.1.0 remote:        using coffee-script-source 1.10.0 remote:        using thor 0.19.1 remote:        using concurrent-ruby 1.0.1 remote:        using orm_adapter 0.5.0 remote:        using multi_json 1.11.2 remote:        using multipart-post 2.0.0 remote:        using hashie 3.4.3 remote:        using elasticsearch-rails 0.1.9 remote:        using mimemagic 0.3.0 remote:        using pg 0.18.4 remote:        using bundler 1.11.2 remote:        using rails_serve_static_assets 0.0.5 remote:        using rails_stdout_logging 0.0.5 remote:        using tilt 2.0.2 remote:        using rdoc 4.2.2 remote:        using tzinfo 1.2.2 remote:        using nokogiri 1.6.7.2 remote:        using mime-types 3.0 remote:        using autoprefixer-rails 6.3.6 remote:        using uglifier 3.0.0 remote:        using rack-test 0.6.3 remote:        using warden 1.2.6 remote:        using bootstrap-will_paginate 0.0.10 remote:        using coffee-script 2.4.1 remote:        using sprockets 3.6.0 remote:        using elasticsearch-api 1.0.17 remote:        using faraday 0.9.2 remote:        using rails_12factor 0.0.3 remote:        using sdoc 0.4.1 remote:        using activesupport 4.2.5.1 remote:        using loofah 2.0.3 remote:        using mail 2.6.4 remote:        using rest-client 1.6.7 remote:        using bootstrap-sass 3.3.6 remote:        using elasticsearch-transport 1.0.17 remote:        using rails-deprecated_sanitizer 1.0.3 remote:        using globalid 0.3.6 remote:        using activemodel 4.2.5.1 remote:        using climate_control 0.0.3 remote:        using jbuilder 2.4.1 remote:        using rails-html-sanitizer 1.0.3 remote:        using cloudinary 1.2.0 remote:        using rails-dom-testing 1.0.7 remote:        using elasticsearch 1.0.17 remote:        using activejob 4.2.5.1 remote:        using cocaine 0.5.8 remote:        using paperclip-cloudinary 1.1.0 remote:        using actionview 4.2.5.1 remote:        using elasticsearch-model 0.1.9 remote:        using activerecord 4.2.5.1 remote:        using searchkick 1.2.1 remote:        using paperclip 4.3.6 remote:        using actionpack 4.2.5.1 remote:        using actionmailer 4.2.5.1 remote:        using railties 4.2.5.1 remote:        using sprockets-rails 3.0.4 remote:        using coffee-rails 4.1.1 remote:        using responders 2.1.2 remote:        using jquery-rails 4.1.1 remote:        using rails 4.2.5.1 remote:        using sass-rails 5.0.4 remote:        using turbolinks 2.5.3 remote:        using devise 4.0.0 remote:        installing sqlite3 1.3.11 native extensions remote:         remote:        gem::ext::builderror: error: failed build gem native extension. remote:         remote:        /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/ruby-2.2.4/bin/ruby -r ./siteconf20160801-197-lz2bsz.rb extconf.rb remote:        checking sqlite3.h... no remote:        sqlite3.h missing. try 'port install sqlite3 +universal', remote:        'yum install sqlite-devel' or 'apt-get install libsqlite3-dev' remote:        , check shared library search path (the remote:        location sqlite3 shared library located). remote:        *** extconf.rb failed *** remote:        not create makefile due reason, lack of necessary remote:        libraries and/or headers.  check mkmf.log file more details.  may remote:        need configuration options. remote:         remote:        provided configuration options: remote:        --with-opt-dir remote:        --without-opt-dir remote:        --with-opt-include remote:        --without-opt-include=${opt-dir}/include remote:        --with-opt-lib remote:        --without-opt-lib=${opt-dir}/lib remote:        --with-make-prog remote:        --without-make-prog remote:        --srcdir=. remote:        --curdir remote:        --ruby=/tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/ruby-2.2.4/bin/$(ruby_base_name) remote:        --with-sqlite3-dir remote:        --without-sqlite3-dir remote:        --with-sqlite3-include remote:        --without-sqlite3-include=${sqlite3-dir}/include remote:        --with-sqlite3-lib remote:        --without-sqlite3-lib=${sqlite3-dir}/lib remote:         remote:        extconf failed, exit code 1 remote:         remote:        gem files remain installed in /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/bundle/ruby/2.2.0/gems/sqlite3-1.3.11 inspection. remote:        results logged /tmp/build_650c9daea9707f0830f7e2ecbfc558e2/vendor/bundle/ruby/2.2.0/extensions/x86_64-linux/2.2.0-static/sqlite3-1.3.11/gem_make.out remote:        error occurred while installing sqlite3 (1.3.11), , bundler cannot remote:        continue. remote:        make sure `gem install sqlite3 -v '1.3.11'` succeeds before bundling. remote:  ! remote:  !     failed install gems via bundler. remote:  !      remote:  !     detected sqlite3 gem not supported on heroku. remote:  !     https://devcenter.heroku.com/articles/sqlite3 remote:  ! remote:  !     push rejected, failed compile ruby app. remote:  remote:  !     push failed remote: verifying deploy... remote:  remote: !   push rejected professor-ratings. remote:  

could problem build configuration? how can change that?'

using sqlite3 fine in development, heroku needs pg production, gemfile should this:

group :development, :test     gem 'sqlite3' end  group :production     gem 'pg' end 

you may need reset database (rails db:reset / rake db:reset depending on rails version). can run bundle install --without production


Comments