railsの環境構築での問題

Question

前提・実現したいこと

こんにちは。
質問なのですが、railsの初期の初期の起動ができません。

発生している問題・エラーメッセージ

Could not find gem 'sqlite3 x64-mingw32' in any of the gem sources listed in your Gemfile.
Run `bundle install` to install missing gems.

該当のソースコード

ソースコード

試したこと

まず、sqlite3を環境変数が通っているファイルに移動。
正しく動作することを確認。
ruby,railsも正しく動作することを確認しました。

補足情報（FW/ツールのバージョンなど）

Answer 1

まずは、sqlite3 x64-mingw32がGemfileにあるか確認したのち、存在していなければ記述して、bundle installしなおすとよいとおもいます。

Comments

[Azla_marhyu]

どこをどのように修正すればよいのでしょう？
見た限り、gemfileには存在しているのですが

[Azla_marhyu]

source 'https://rubygems.org'
git_source(:github) { |repo| "https://github.com/#{repo}.git" }

ruby '2.3.3'

# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
gem 'rails', '~> 5.2.3'
# Use sqlite3 as the database for Active Record
gem 'sqlite3'
# Use Puma as the app server
gem 'puma', '~> 3.11'
# Use SCSS for stylesheets
gem 'sass-rails', '~> 5.0'
# Use Uglifier as compressor for JavaScript assets
gem 'uglifier', '>= 1.3.0'
# See https://github.com/rails/execjs#readme for more supported runtimes
gem 'duktape'
# Use CoffeeScript for .coffee assets and views
gem 'coffee-rails', '~> 4.2'
# Turbolinks makes navigating your web application faster. Read more: https://github.com/turbolinks/turbolinks
gem 'turbolinks', '~> 5'
# Build JSON APIs with ease. Read more: https://github.com/rails/jbuilder
gem 'jbuilder', '~> 2.5'
# Use Redis adapter to run Action Cable in production
# gem 'redis', '~> 4.0'
# Use ActiveModel has_secure_password
# gem 'bcrypt', '~> 3.1.7'

# Use ActiveStorage variant
# gem 'mini_magick', '~> 4.8'

# Use Capistrano for deployment
# gem 'capistrano-rails', group: :development

# Reduces boot times through caching; required in config/boot.rb
gem 'bootsnap', '>= 1.1.0', require: false

group :development, :test do
# Call 'byebug' anywhere in the code to stop execution and get a debugger console
gem 'byebug', platforms: [:mri, :mingw, :x64_mingw]
end

group :development do
# Access an interactive console on exception pages or by calling 'console' anywhere in the code.
gem 'web-console', '>= 3.3.0'
end

group :test do
# Adds support for Capybara system testing and selenium driver
gem 'capybara', '>= 2.15'
gem 'selenium-webdriver'
# Easy installation and use of chromedriver to run system tests with Chrome
gem 'chromedriver-helper'
end

# Windows does not include zoneinfo files, so bundle the tzinfo-data gem
gem 'tzinfo-data', platforms: [:mingw, :mswin, :x64_mingw, :jruby]

[hirontan]

確かに存在していそうです。
bundle install の結果をいただいてもよいですか？

[Azla_marhyu]

The latest bundler is 2.0.2, but you are currently running 1.15.3.
To update, run `gem install bundler`
Fetching gem metadata from https://rubygems.org/..............
Fetching version metadata from https://rubygems.org/...
Fetching dependency metadata from https://rubygems.org/..
Resolving dependencies.....
Using rake 12.3.3
Using concurrent-ruby 1.1.5
Using minitest 5.11.3
Using thread_safe 0.3.6
Using builder 3.2.3
Using erubi 1.8.0
Using mini_portile2 2.4.0
Using crass 1.0.4
Using rack 2.0.7
Using nio4r 2.4.0
Using websocket-extensions 0.1.4
Using mini_mime 1.0.2
Using arel 9.0.0
Using mimemagic 0.3.3
Using public_suffix 3.1.1
Using io-like 0.3.0
Using bindex 0.8.1
Using msgpack 1.3.0 (x86-mingw32)
Using bundler 1.15.3
Using byebug 11.0.1
Using regexp_parser 1.6.0
Using coffee-script-source 1.12.2
Using execjs 2.7.0
Using method_source 0.9.2
Using thor 0.20.3
Using duktape 2.3.0.0
Using ffi 1.11.1 (x86-mingw32)
Using puma 3.12.1
Using rb-fsevent 0.10.3
Using rubyzip 1.2.3
Using tilt 2.0.9
Fetching sqlite3 1.4.1
Installing sqlite3 1.4.1 with native extensions
Using turbolinks-source 5.2.0
Using childprocess 1.0.1
Using i18n 1.6.0
Using tzinfo 1.2.5
Using nokogiri 1.10.3 (x86-mingw32)
Using rack-test 1.1.0
Using sprockets 3.7.2
Using websocket-driver 0.7.1
Using mail 2.7.1
Using marcel 0.3.3
Using addressable 2.6.0
Using archive-zip 0.12.0
Fetching bootsnap 1.4.4
Installing bootsnap 1.4.4 with native extensions
Using coffee-script 2.4.1
Using uglifier 4.1.20
Using rb-inotify 0.10.0
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

current directory:
C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/sqlite3-1.4.1/ext/sqlite3
C:/RailsInstaller/Ruby2.3.3/bin/ruby.exe -r ./siteconf20190805-11776-1mu3x1m.rb
extconf.rb
checking for sqlite3.h... no
sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first.
*** 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=C:/RailsInstaller/Ruby2.3.3/bin/$(RUBY_BASE_NAME)
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-config
--without-sqlite3-config
--with-pkg-config
--without-pkg-config
--with-sqlcipher
--without-sqlcipher
--with-sqlite3-dir
--without-sqlite3-dir
--with-sqlite3-include
--without-sqlite3-include=${sqlite3-dir}/include
--with-sqlite3-lib
--without-sqlite3-lib=${sqlite3-dir}/lib

To see why this extension failed to compile, please check the mkmf.log which can
be found here:

C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sqlite3-1.4.1/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in
C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/gems/sqlite3-1.4.1 for
inspection.
Results logged to
C:/RailsInstaller/Ruby2.3.3/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sqlite3-1.4.1/gem_make.out

An error occurred while installing sqlite3 (1.4.1), and Bundler cannot continue.
Make sure that `gem install sqlite3 -v '1.4.1'` succeeds before bundling.

In Gemfile:
sqlite3

[Azla_marhyu]

これですか？bundle installはコマンドの結果ですよね

[hirontan]

ログありがとうございます。
sqliteのインストール失敗していますね。

下記のエラーが出ていますので、
```
sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first.
```
SQLite3をインストールしましょうだと思います。

下記参考になりそうです。
https://www.javadrive.jp/rails/install/index2.html

[hirontan]

> まず、sqlite3を環境変数が通っているファイルに移動。

とのことで、もしかしたら、実施しているのかもしれませんが、、