Q&A
> https://geniusium.hatenablog.com/entry/2021/06/15/133317
こちらの記事は内容的に無関係なようです。
mysql clientのインストールが行われていないように見えますが、これを行いましたか？
前提：rails コマンドを入力しても下記エラーが出てしまうようになった。
rails
1taka@masterMacBook-Air freemarket_sample_67e % rails s 2/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/digest-3.1.0/lib/digest.rb:20: warning: already initialized constant Digest::REQUIRE_MUTEX 3/Users/taka/.rbenv/versions/2.7.3/lib/ruby/2.7.0/digest.rb:6: warning: previous definition of REQUIRE_MUTEX was here 4Traceback (most recent call last): 5 37: from bin/rails:3:in `<main>' 6 36: from bin/rails:3:in `load' 7 35: from /Users/taka/techcamp/freemarket_sample_67e/bin/spring:15:in `<top (required)>' 8 34: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/site_ruby/2.7.0/rubygems/core_ext/kernel_require.rb:85:in `require' 9 33: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/site_ruby/2.7.0/rubygems/core_ext/kernel_require.rb:85:in `require' 10 32: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/binstub.rb:11:in `<top (required)>' 11 31: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/binstub.rb:11:in `load' 12 30: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/bin/spring:49:in `<top (required)>' 13 29: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/client.rb:30:in `run' 14 28: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/client/command.rb:7:in `call' 15 27: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/client/rails.rb:28:in `call' 16 26: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/spring-2.1.1/lib/spring/client/rails.rb:28:in `load' 17 25: from /Users/taka/techcamp/freemarket_sample_67e/bin/rails:9:in `<top (required)>' 18 24: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 19 23: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 20 22: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/commands.rb:18:in `<main>' 21 21: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/command.rb:48:in `invoke' 22 20: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/command/base.rb:87:in `perform' 23 19: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor.rb:392:in `dispatch' 24 18: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/invocation.rb:127:in `invoke_command' 25 17: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/thor-1.2.1/lib/thor/command.rb:27:in `run' 26 16: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/commands/server/server_command.rb:134:in `perform' 27 15: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/commands/server/server_command.rb:134:in `tap' 28 14: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/railties-7.0.3.1/lib/rails/commands/server/server_command.rb:137:in `block in perform' 29 13: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 30 12: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 31 11: from /Users/taka/techcamp/freemarket_sample_67e/config/application.rb:7:in `<main>' 32 10: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler.rb:187:in `require' 33 9: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/runtime.rb:44:in `require' 34 8: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/runtime.rb:44:in `each' 35 7: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/runtime.rb:55:in `block in require' 36 6: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/runtime.rb:55:in `each' 37 5: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bundler-2.3.18/lib/bundler/runtime.rb:60:in `block (2 levels) in require' 38 4: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 39 3: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 40 2: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2.rb:36:in `<main>' 41 1: from /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require' 42/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require': dlopen(/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle, 0x0009): Library not loaded: '/usr/local/opt/mysql/lib/libmysqlclient.21.dylib' (LoadError) 43 Referenced from: '/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle' 44 Reason: tried: '/usr/local/opt/mysql/lib/libmysqlclient.21.dylib' (no such file), '/usr/local/lib/libmysqlclient.21.dylib' (no such file), '/usr/lib/libmysqlclient.21.dylib' (no such file) - /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle
調べたこと
こちらの記事を発見し、対象のgemを削除すれば良さそうなのですがどのgemをunistallすれば良いかわかりません。
https://geniusium.hatenablog.com/entry/2021/06/15/133317
回答1件
0
kaztoさんが説明してくださっていますが、回答まだないようですので、補足させていただきます。
takataka3の貼り付けてくださったエラーログの一番下から3行が原因のように見えます。
/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require': dlopen(/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle, 0x0009): Library not loaded: '/usr/local/opt/mysql/lib/libmysqlclient.21.dylib' (LoadError) Referenced from: '/Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle' Reason: tried: '/usr/local/opt/mysql/lib/libmysqlclient.21.dylib' (no such file), '/usr/local/lib/libmysqlclient.21.dylib' (no such file), '/usr/lib/libmysqlclient.21.dylib' (no such file) - /Users/taka/.rbenv/versions/2.7.3/lib/ruby/gems/2.7.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.bundle
Library not loaded: '/usr/local/opt/mysql/lib/libmysqlclient.21.dylib' (LoadError)というように、ライブラリが見つからないよというのがエラーの原因に見えますね。
以下の記事を参考にすると、解決するかもしれません。
もしよければ試してみてください。
https://qiita.com/k-yasuhiro/items/9674d2e6e0b0fac3e1a8
上の記事ですが、やっていることはmysqlをインストールし直しているだけです。
もしうまくいかなければmysql gem installという形で調べてみるのも手かもしれません。
投稿2022/08/12 12:12
総合スコア51
kaztoさん
shinjia305さん
ご丁寧なコメントありがとうございます。
無事起動まで漕ぎ着けました！！！
kaztoさんご指摘のmysql client のインストールに手間取っており反応遅れました。
ご指摘通りインストールできておりませんでしたのでインストールをして、shinjia305さんご指摘のライブラリエラーがまさにその通りで参考記事と全く同じ状況でした！
記事の通りにmysqlをでgemエラー出ておりましたのでuninstallしてbundle installしたところ無事railsが起動しました！
しかし、起動してlocalhost:3000へのアクセスで再びエラーとなってしまいました。
```
ActiveRecord::DatabaseConnectionError
There is an issue connecting to your database with your username/password, username: root.
Please check your database configuration to ensure the username/password are valid.
Extracted source (around line #49):
47 raise ActiveRecord::NoDatabaseError.db_error(config[:database])
48 elsif error.error_number == ConnectionAdapters::Mysql2Adapter::ER_ACCESS_DENIED_ERROR
49 raise ActiveRecord::DatabaseConnectionError.username_error(config[:username])
50 elsif [ConnectionAdapters::Mysql2Adapter::ER_CONN_HOST_ERROR,ConnectionAdapters::Mysql2Adapter::ER_UNKNOWN_HOST_ERROR].include?(error.error_number)
51 raise ActiveRecord::DatabaseConnectionError.hostname_error(config[:host])
52 else
```
横からで申し訳ないですが、とりあえず落ち着いてエラーメッセージを読んでみればよいかと。
上から順番に読んでみればなぜエラーが出ているかが分かると思います。
There is an issue connecting to your database with your username/password, username: root.
Please check your database configuration to ensure the username/password are valid.
まずは、railsに設定しているユーザー名とパスワードでmysqlに対してアクセスできるか確認したほうが良いように思えます。
あなたの回答
tips
プレビュー
