質問編集履歴

「自分で試したこと」の部分の変更

2021/03/29 06:36

投稿

Marchan4

スコア15

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -8,6 +8,7 @@
 ```
 $ ruby -v
 ruby 3.0.0p0 (2020-12-25 revision 95aff21468) [x86_64-darwin17]
 ```
@@ -15,6 +16,7 @@
 ```
 $ mysql --version
 mysql  Ver 14.14 Distrib 5.7.32, for osx10.16 (x86_64) using  EditLine wr
 apper
 ```
@@ -23,6 +25,7 @@
 ```
 $ brew -v
 Homebrew 3.0.5
 Homebrew/homebrew-core (git revision f376c69429; last commit 2021-03-15)
 Homebrew/homebrew-cask (git revision 83abe76d01; last commit 2021-03-15)
@@ -36,246 +39,230 @@
 Fetching gem metadata from https://rubygems.org/.
 Using bundler 2.2.3
 Following files may not be writable, so sudo is needed:
-  /Users/masatosankai/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/build_
+  /Users/ユーザ名/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/build_info/mysql2-0.5
-info/mysql2-0.5.3.info
+.3.info
 Fetching mysql2 0.5.3
 Your user account isn't allowed to install to the system RubyGems.
   You can cancel this installation and run:
       bundle config set --local path 'vendor/bundle'
       bundle install
-  to install the gems into ./vendor/bundle/, or you can enter your pas
+  to install the gems into ./vendor/bundle/, or you can enter your password
-sword
   and install the bundled gems to RubyGems using sudo.
   Password:
 Installing mysql2 0.5.3 with native extensions
+Bundle complete! 1 Gemfile dependency, 2 gems now installed.
-Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
+Use `bundle info [gemname]` to see where a bundled gem is installed.
+```
-current directory:
-/var/folders/dw/kmw_z3yn035_rwps2mh1n5q80000gn/T/bundler20210328-34165
--rzwojsmysql2-0.5.3/gems/mysql2-0.5.3/ext/mysql2
-/Users/masatosankai/.rbenv/versions/3.0.0/bin/ruby -I
-/Users/masatosankai/.rbenv/versions/3.0.0/lib/ruby/3.0.0 -r
-./siteconf20210328-34165-nxc9bm.rb extconf.rb
-checking for rb_absint_size()... yes
-checking for rb_absint_singlebit_p()... yes
-checking for rb_wait_for_single_fd()... yes
------
+```
-Using mysql_config at /usr/local/opt/mysql@5.7/bin/mysql_config
------
-checking for mysql.h... yes
-checking for errmsg.h... yes
-checking for SSL_MODE_DISABLED in mysql.h... yes
-checking for SSL_MODE_PREFERRED in mysql.h... yes
-checking for SSL_MODE_REQUIRED in mysql.h... yes
-checking for SSL_MODE_VERIFY_CA in mysql.h... yes
-checking for SSL_MODE_VERIFY_IDENTITY in mysql.h... yes
-checking for MYSQL.net.vio in mysql.h... yes
-checking for MYSQL.net.pvio in mysql.h... no
-checking for MYSQL_ENABLE_CLEARTEXT_PLUGIN in mysql.h... yes
-checking for SERVER_QUERY_NO_GOOD_INDEX_USED in mysql.h... yes
-checking for SERVER_QUERY_NO_INDEX_USED in mysql.h... yes
-checking for SERVER_QUERY_WAS_SLOW in mysql.h... yes
-checking for MYSQL_OPTION_MULTI_STATEMENTS_ON in mysql.h... yes
-checking for MYSQL_OPTION_MULTI_STATEMENTS_OFF in mysql.h... yes
-checking for my_bool in mysql.h... yes
------
-Don't know how to set rpath on your system, if MySQL libraries are not
-in path mysql2 may not load
+$ brew install openssl@1.1
------
------
-Setting libpath to /usr/local/opt/mysql@5.7/lib
------
-creating Makefile
+Error: openssl@1.1 1.1.1j is already installed.
-current directory:
+To upgrade to 1.1.1k, run:
-/var/folders/dw/kmw_z3yn035_rwps2mh1n5q80000gn/T/bundler20210328-34165
--rzwojsmysql2-0.5.3/gems/mysql2-0.5.3/ext/mysql2
-make "DESTDIR=" clean
+  brew upgrade openssl@1.1
+```
-current directory:
+```
-/var/folders/dw/kmw_z3yn035_rwps2mh1n5q80000gn/T/bundler20210328-34165
--rzwojsmysql2-0.5.3/gems/mysql2-0.5.3/ext/mysql2
-make "DESTDIR="
-compiling client.c
-client.c:787:14: warning: incompatible pointer types passing 'VALUE
-(void *)' (aka 'unsigned long (void *)') to parameter of type 'VALUE
-(*)(VALUE)' (aka 'unsigned long (*)(unsigned long)')
-[-Wincompatible-pointer-types]
-rb_rescue2(do_send_query, (VALUE)&args, disconnect_and_raise, self,
-rb_eException, (VALUE)0);
+$ brew upgrade openssl@1.1
-^~~~~~~~~~~~~
-/Users/masatosankai/.rbenv/versions/3.0.0/include/ruby-3.0.0/ruby/inte
-rnal/iterator.h:51:25:
-note: passing argument to parameter here
-VALUE
-rb_rescue2(VALUE(*)(VALUE),VALUE,VALUE(*)(VALUE,VALUE),VALUE,...);
-                        ^
-client.c:795:16: warning: incompatible pointer types passing 'VALUE
-(void *)' (aka 'unsigned long (void *)') to parameter of type 'VALUE
-(*)(VALUE)' (aka 'unsigned long (*)(unsigned long)')
-[-Wincompatible-pointer-types]
-rb_rescue2(do_query, (VALUE)&async_args, disconnect_and_raise,
-self, rb_eException, (VALUE)0);
-               ^~~~~~~~
-/Users/masatosankai/.rbenv/versions/3.0.0/include/ruby-3.0.0/ruby/inte
-rnal/iterator.h:51:25:
-note: passing argument to parameter here
-VALUE
-rb_rescue2(VALUE(*)(VALUE),VALUE,VALUE(*)(VALUE,VALUE),VALUE,...);
-^
-2 warnings generated.
-compiling infile.c
-compiling mysql2_ext.c
-compiling result.c
-compiling statement.c
-linking shared-object mysql2/mysql2.bundle
-ld: library not found for -lssl
+==> Upgrading 1 outdated package:
+openssl@1.1 1.1.1j -> 1.1.1k
+==> Upgrading openssl@1.1 1.1.1j -> 1.1.1k
+==> Downloading https://homebrew.bintray.com/bottles/openssl%401.1-1.1.1k.big_sur.bot
+==> Downloading from https://d29vzk4ow07wi7.cloudfront.net/17d94c51ddfa8364baed5f3a75
+######################################################################## 100.0%
+==> Pouring openssl@1.1-1.1.1k.big_sur.bottle.tar.gz
+==> Regenerating CA certificate bundle from keychain, this may take a while...
+==> Caveats
-clang: error: linker command failed with exit code 1 (use -v to see
+A CA file has been bootstrapped using certificates from the system
-invocation)
-make: *** [mysql2.bundle] Error 1
+keychain. To add additional certificates, place .pem files in
+  /usr/local/etc/openssl@1.1/certs
-make failed, exit code 2
-Gem files will remain installed in
+and run
-/var/folders/dw/kmw_z3yn035_rwps2mh1n5q80000gn/T/bundler20210328-34165
+  /usr/local/opt/openssl@1.1/bin/c_rehash
--rzwojsmysql2-0.5.3/gems/mysql2-0.5.3
-for inspection.
-Results logged to
-/var/folders/dw/kmw_z3yn035_rwps2mh1n5q80000gn/T/bundler20210328-34165
--rzwojsmysql2-0.5.3/extensions/x86_64-darwin-17/3.0.0/mysql2-0.5.3/gem
-_make.out
-An error occurred while installing mysql2 (0.5.3), and
+openssl@1.1 is keg-only, which means it was not symlinked into /usr/local,
+because macOS provides LibreSSL.
-Bundler cannot continue.
-Make sure that `gem install mysql2 -v '0.5.3' --source
+If you need to have openssl@1.1 first in your PATH, run:
-'https://rubygems.org/'` succeeds before bundling.
+  echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> /Users/ユーザ名/.b
+ash_profile
+For compilers to find openssl@1.1 you may need to set:
+  export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
+  export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
+For pkg-config to find openssl@1.1 you may need to set:
+  export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"
-In Gemfile:
+==> Summary
+????  /usr/local/Cellar/openssl@1.1/1.1.1k: 8,071 files, 18.5MB
+Removing: /usr/local/Cellar/openssl@1.1/1.1.1j... (8,071 files, 18.5MB)
+Removing: /Users/ユーザ名/Library/Caches/Homebrew/openssl@1.1--1.1.1j.big_sur.bot
-  mysql2
+tle.tar.gz... (5.4MB)
 ```
 ```
-$ gem install mysql2
+$ brew install openssl@1.1
-Building native extensions. This could take a while...
+Warning: openssl@1.1 1.1.1k is already installed and up-to-date.
+To reinstall 1.1.1k, run:
-ERROR:  Error installing mysql2:
+  brew reinstall openssl@1.1
-        ERROR: Failed to build gem native extension.
+```
-    current directory: /Users/masatosankai/.rbenv/versions/3.0.0
+```
-/lib/ruby/gems/3.0.0/gems/mysql2-0.5.3/ext/mysql2
-/Users/masatosankai/.rbenv/versions/3.0.0/bin/ruby -I /Users/mas
-atosankai/.rbenv/versions/3.0.0/lib/ruby/3.0.0 -r ./siteconf2021
-0328-34496-t0ef0t.rb extconf.rb
+$ brew reinstall openssl@1.1
-checking for rb_absint_size()... yes
-checking for rb_absint_singlebit_p()... yes
-checking for rb_wait_for_single_fd()... yes
------
-Using mysql_config at /usr/local/opt/mysql@5.7/bin/mysql_config
------
+==> Downloading https://homebrew.bintray.com/bottles/openssl%401.1-1.1.1k.big_sur.bot
+Already downloaded: /Users/ユーザ名/Library/Caches/Homebrew/downloads/fae83f76186
+7e592ca8209f4cf851a681825ea9a2b5af870b9237aa35ca1ef0f--openssl@1.1-1.1.1k.big_sur.bot
+tle.tar.gz
-checking for mysql.h... yes
+==> Reinstalling openssl@1.1
-checking for errmsg.h... yes
-checking for SSL_MODE_DISABLED in mysql.h... yes
-checking for SSL_MODE_PREFERRED in mysql.h... yes
-checking for SSL_MODE_REQUIRED in mysql.h... yes
-checking for SSL_MODE_VERIFY_CA in mysql.h... yes
-checking for SSL_MODE_VERIFY_IDENTITY in mysql.h... yes
-checking for MYSQL.net.vio in mysql.h... yes
+==> Pouring openssl@1.1-1.1.1k.big_sur.bottle.tar.gz
-checking for MYSQL.net.pvio in mysql.h... no
-checking for MYSQL_ENABLE_CLEARTEXT_PLUGIN in mysql.h... yes
-checking for SERVER_QUERY_NO_GOOD_INDEX_USED in mysql.h... yes
-checking for SERVER_QUERY_NO_INDEX_USED in mysql.h... yes
-checking for SERVER_QUERY_WAS_SLOW in mysql.h... yes
-checking for MYSQL_OPTION_MULTI_STATEMENTS_ON in mysql.h... yes
-checking for MYSQL_OPTION_MULTI_STATEMENTS_OFF in mysql.h... yes
-checking for my_bool in mysql.h... yes
------
-Don't know how to set rpath on your system, if MySQL libraries a
+==> Regenerating CA certificate bundle from keychain, this may take a while...
+==> Caveats
+A CA file has been bootstrapped using certificates from the system
-re not in path mysql2 may not load
+keychain. To add additional certificates, place .pem files in
------
------
-Setting libpath to /usr/local/opt/mysql@5.7/lib
+  /usr/local/etc/openssl@1.1/certs
------
-creating Makefile
-current directory: /Users/masatosankai/.rbenv/versions/3.0.0/lib
-/ruby/gems/3.0.0/gems/mysql2-0.5.3/ext/mysql2
-make "DESTDIR=" clean
-current directory: /Users/masatosankai/.rbenv/versions/3.0.0/lib
+and run
-/ruby/gems/3.0.0/gems/mysql2-0.5.3/ext/mysql2
+  /usr/local/opt/openssl@1.1/bin/c_rehash
-make "DESTDIR="
-compiling client.c
-client.c:787:14: warning: incompatible pointer types passing 'VA
-LUE (void *)' (aka 'unsigned long (void *)') to parameter of typ
-e 'VALUE (*)(VALUE)' (aka 'unsigned long (*)(unsigned long)') [-
-Wincompatible-pointer-types]
-  rb_rescue2(do_send_query, (VALUE)&args, disconnect_and_raise,
-self, rb_eException, (VALUE)0);
-             ^~~~~~~~~~~~~
-/Users/masatosankai/.rbenv/versions/3.0.0/include/ruby-3.0.0/rub
-y/internal/iterator.h:51:25: note: passing argument to parameter
- here
-VALUE rb_rescue2(VALUE(*)(VALUE),VALUE,VALUE(*)(VALUE,VALUE),VAL
-UE,...);
-                        ^
-client.c:795:16: warning: incompatible pointer types passing 'VA
-LUE (void *)' (aka 'unsigned long (void *)') to parameter of typ
-e 'VALUE (*)(VALUE)' (aka 'unsigned long (*)(unsigned long)') [-
-Wincompatible-pointer-types]
-    rb_rescue2(do_query, (VALUE)&async_args, disconnect_and_rais
-e, self, rb_eException, (VALUE)0);
-               ^~~~~~~~
-/Users/masatosankai/.rbenv/versions/3.0.0/include/ruby-3.0.0/rub
-y/internal/iterator.h:51:25: note: passing argument to parameter
- here
-VALUE rb_rescue2(VALUE(*)(VALUE),VALUE,VALUE(*)(VALUE,VALUE),VAL
-UE,...);
-^
-2 warnings generated.
-compiling infile.c
-compiling mysql2_ext.c
-compiling result.c
-compiling statement.c
-linking shared-object mysql2/mysql2.bundle
-ld: library not found for -lssl
-clang: error: linker command failed with exit code 1 (use -v to
-see invocation)
-make: *** [mysql2.bundle] Error 1
+openssl@1.1 is keg-only, which means it was not symlinked into /usr/local,
-make failed, exit code 2
+because macOS provides LibreSSL.
-Gem files will remain installed in /Users/masatosankai/.rbenv/ve
+If you need to have openssl@1.1 first in your PATH, run:
-rsions/3.0.0/lib/ruby/gems/3.0.0/gems/mysql2-0.5.3 for inspectio
+  echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> /Users/ユーザ名/.b
-n.
+ash_profile
+For compilers to find openssl@1.1 you may need to set:
-Results logged to /Users/masatosankai/.rbenv/versions/3.0.0/lib/
+  export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
+  export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
+For pkg-config to find openssl@1.1 you may need to set:
+  export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"
+==> Summary
-ruby/gems/3.0.0/extensions/x86_64-darwin-17/3.0.0/mysql2-0.5.3/g
+????  /usr/local/Cellar/openssl@1.1/1.1.1k: 8,071 files, 18.5MB
-em_make.out
 ```
 ```
-$ gem install mysql2 -v '0.5.3' --source 'https://rubygems.org/'
+$ gem install mysql2 -- --with-cppflags=-I/usr/l
+ocal/opt/openssl@1.1/include --with-ldflags=-L/usr/local/opt/openssl@1.1/lib
+Building native extensions with: '--with-cppflags=-I/usr/local/opt/openssl@1.1/includ
+e --with-ldflags=-L/usr/local/opt/openssl@1.1/lib'
-Building native extensions. This could take a while...
+This could take a while...
-ERROR:  Error installing mysql2:
-        ERROR: Failed to build gem native extension.
+ERROR:  While executing gem ... (Errno::EACCES)
+    Permission denied @ rb_sysopen - /Users/ユーザ名/.rbenv/versions/3.0.0/lib/ru
+by/gems/3.0.0/build_info/mysql2-0.5.3.info
+```
-    current directory: /Users/masatosankai/.rbenv/versions/3.0.0/lib/ruby
-/gems/3.0.0/gems/mysql2-0.5.3/ext/mysql2
-/Users/masatosankai/.rbenv/versions/3.0.0/bin/ruby -I /Users/masatosankai
-/.rbenv/versions/3.0.0/lib/ruby/3.0.0 -r ./siteconf20210328-34853-lzd1f4.
-rb extconf.rb
+```
-checking for rb_absint_size()... yes
+$ brew info openssl@1.1
-checking for rb_absint_singlebit_p()... yes
-checking for rb_wait_for_single_fd()... yes
------
-Using mysql_config at /usr/local/opt/mysql@5.7/bin/mysql_config
+openssl@1.1: stable 1.1.1k (bottled) [keg-only]
+Cryptography and SSL/TLS Toolkit
+https://openssl.org/
+/usr/local/Cellar/openssl@1.1/1.1.1k (8,071 files, 18.5MB)
+  Poured from bottle on 2021-03-29 at 14:37:20
+From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/openssl@1.1.rb
+License: OpenSSL
+==> Caveats
+A CA file has been bootstrapped using certificates from the system
+keychain. To add additional certificates, place .pem files in
+  /usr/local/etc/openssl@1.1/certs
+and run
+  /usr/local/opt/openssl@1.1/bin/c_rehash
+openssl@1.1 is keg-only, which means it was not symlinked into /usr/local,
+because macOS provides LibreSSL.
+If you need to have openssl@1.1 first in your PATH, run:
+  echo 'export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"' >> /Users/ユーザ名/.b
+ash_profile
+For compilers to find openssl@1.1 you may need to set:
+  export LDFLAGS="-L/usr/local/opt/openssl@1.1/lib"
+  export CPPFLAGS="-I/usr/local/opt/openssl@1.1/include"
+For pkg-config to find openssl@1.1 you may need to set:
+  export PKG_CONFIG_PATH="/usr/local/opt/openssl@1.1/lib/pkgconfig"
+==> Analytics
+install: 841,099 (30 days), 2,355,026 (90 days), 8,918,368 (365 days)
+install-on-request: 73,357 (30 days), 317,809 (90 days), 1,268,061 (365 days)
+build-error: 0 (30 days)
+```
+```
+$ bundle config --local build.mysql2 "--with-cpp
+flags=-I/usr/local/opt/openssl@1.1/include --with-ldflags=-L/usr/local/opt/openssl@1.
+1/lib"
+You are replacing the current local value of build.mysql2, which is currently "--with
+-ldflags=-L/usr/local/opt/openssl@1.1/lib --with-cppflags=-I/usr/local/opt/openssl@1.
+1/include"
+```
+```
+$ bundle install
+Fetching gem metadata from https://rubygems.org/.
+Using bundler 2.2.3
+Following files may not be writable, so sudo is needed:
+  /Users/ユーザ名/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/build_info/mysql2-0.5
+.3.info
+Fetching mysql2 0.5.3
+Your user account isn't allowed to install to the system RubyGems.
+  You can cancel this installation and run:
+      bundle config set --local path 'vendor/bundle'
+      bundle install
+  to install the gems into ./vendor/bundle/, or you can enter your password
+  and install the bundled gems to RubyGems using sudo.
+  Password:
+Your user account isn't allowed to install to the system RubyGems.
+  You can cancel this installation and run:
+      bundle config set --local path 'vendor/bundle'
+      bundle install
+  to install the gems into ./vendor/bundle/, or you can enter your password
+  and install the bundled gems to RubyGems using sudo.
+  Password:
+Installing mysql2 0.5.3 with native extensions
+Bundle complete! 1 Gemfile dependency, 2 gems now installed.
+Use `bundle info [gemname]` to see where a bundled gem is installed.
+```
+```
+$ bundle install
+Using bundler 2.2.3
+Using mysql2 0.5.3
+Following files may not be writable, so sudo is needed:
+  /Users/ユーザ名/.rbenv/versions/3.0.0/lib/ruby/gems/3.0.0/build_info/mysql2-0.5
+.3.info
+Bundle complete! 1 Gemfile dependency, 2 gems now installed.
+Use `bundle info [gemname]` to see where a bundled gem is installed.
 ```

文章の追加。

2021/03/29 06:36

投稿

Marchan4

スコア15

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -1,3 +1,7 @@
+使用環境はrubyバージョン3.0.0, mysqlバージョン5.7,　bundlerバージョン2.2.3です。
+使用機器macOS Big Sur バージョン11.2.2です。使用中のテキストエディタはAtomです。
 rbenvを使って``ruby 3.0.0``をインストールしたり、Homebrewを使って(brewコマンドを使って)``mysql 5.7 ``をインストールした場合、どのようなコマンドを入力すればよいのでしょうか。
 rubyの現在のバージョンは以下の通りです。