Linux – firewalld

2021-02-25 / tau / コメントする

概要

firewalldはファイアーウォールの機能を提供するサービス。

ステータスの確認

ステータスの確認にはsystemctlコマンドを使う。

[vagrant@localhost ~]$ systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

[vagrant@localhost ~]$ systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

Active: inactive (dead)

Docs: man:firewalld(1)

active (running)の場合は実行中、inactive (dead)の場合は停止中。

ステータスの設定

ステータスの設定・変更には、suでsystemctlコマンドを使う。

firewalldの有効化

有効化はsudo systemctl start firewalld。

[vagrant@localhost ~]$ sudo systemctl start firewalld
[vagrant@localhost ~]$ systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: active (running) since 木 2021-02-25 22:22:46 JST; 7s ago
     Docs: man:firewalld(1)
 Main PID: 27554 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─27554 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid

[vagrant@localhost ~]$ sudo systemctl start firewalld

[vagrant@localhost ~]$ systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

Active: active (running) since 木 2021-02-25 22:22:46 JST; 7s ago

Docs: man:firewalld(1)

Main PID: 27554 (firewalld)

CGroup: /system.slice/firewalld.service

└─27554 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid

firewalldの無効化

無効化はsudo systemctl stop firewalld。

[vagrant@localhost ~]$ systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

[vagrant@localhost ~]$ systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

Active: inactive (dead)

Docs: man:firewalld(1)

Linux – SELinux

2021-02-25 / tau / コメントする

概要

SELinuxはシステムへのアクセス制御のための機能。

ステータスの確認

SELinuxの動作状況はgetenforceコマンドで確認。

[vagrant@localhost ~]$ getenforce
Permissive

1 2	[vagrant@localhost ~]$ getenforce Permissive

ステータスは3種類。

Permissive: アクセス制御は無効、警告メッセージを表示。
Enforcing: アクセス制御が有効。
Disabled: SELinuxは無効。

ステータスの変更

一時的な設定～setenforce

suでsetenforceコマンドを使い、Permissive/Enforcingを設定。

sudo setenforce 0/1

0でPermissing、1でEnforcing

起動時の設定～/etc/selinux/config

/etc/selinux/configファイル中、SELINUXの行をコメントアウトして設定すると、起動時のステータスが設定される。

# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - No SELinux policy is loaded.

Vagrant – MySQLのインストール – CentOS7

2021-02-24 / tau / コメントする

概要

Vagrant + VirtualBoxのCentOS7にMySQLをインストールした記録。

yumによるMySQLサイトからのダウンロード実行などのほか、パスワード設定でちょっと時間がかかった。

インストール

参考にさせていただいたサイト：【最新版】CentOSにMySQLをインストールする方法

レポジトリーへの登録

予めコンソールでVagrantのCentOSを起動しておき、MySQL Community Downloadsサイトで以下の作業。

Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent), RPM Packageの”Download”をクリック
ダウンロードページの下部、”No thanks, just start my download.”を右クリックしてURLをコピー
CentOSのコンソールでsuとして以下を実行して、yumレポジトリーに追加

[vagrant@localhost ~]$ sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
読み込んだプラグイン:fastestmirror
mysql80-community-release-el7-3.noarch.rpm               |  25 kB     00:00
/var/tmp/yum-root-hTMBLt/mysql80-community-release-el7-3.noarch.rpm を調べています: mysql80-community-release-el7-3.noarch
/var/tmp/yum-root-hTMBLt/mysql80-community-release-el7-3.noarch.rpm をインストール済みとして設定しています
依存性の解決をしています
--> トランザクションの確認を実行しています。
---> パッケージ mysql80-community-release.noarch 0:el7-3 を インストール
--> 依存性解決を終了しました。

依存性を解決しました

================================================================================
Package             アーキテクチャー
                            バージョン
                                  リポジトリー                             容量
================================================================================
インストール中:
mysql80-community-release
                     noarch el7-3 /mysql80-community-release-el7-3.noarch  31 k

トランザクションの要約
================================================================================
インストール  1 パッケージ

合計容量: 31 k
インストール容量: 31 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  インストール中          : mysql80-community-release-el7-3.noarch          1/1
  検証中                  : mysql80-community-release-el7-3.noarch          1/1

インストール:
  mysql80-community-release.noarch 0:el7-3

完了しました!

[vagrant@localhost ~]$ sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

読み込んだプラグイン:fastestmirror

mysql80-community-release-el7-3.noarch.rpm | 25 kB 00:00

/var/tmp/yum-root-hTMBLt/mysql80-community-release-el7-3.noarch.rpm を調べています: mysql80-community-release-el7-3.noarch

/var/tmp/yum-root-hTMBLt/mysql80-community-release-el7-3.noarch.rpm をインストール済みとして設定しています

依存性の解決をしています

--> トランザクションの確認を実行しています。

---> パッケージ mysql80-community-release.noarch 0:el7-3 をインストール

--> 依存性解決を終了しました。

依存性を解決しました

================================================================================

Package アーキテクチャー

バージョン

リポジトリー容量

================================================================================

インストール中:

mysql80-community-release

noarch el7-3 /mysql80-community-release-el7-3.noarch 31 k

トランザクションの要約

================================================================================

インストール 1 パッケージ

合計容量: 31 k

インストール容量: 31 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

インストール中 : mysql80-community-release-el7-3.noarch 1/1

検証中 : mysql80-community-release-el7-3.noarch 1/1

インストール:

mysql80-community-release.noarch 0:el7-3

完了しました!

レポジトリーの確認

MySQLがレポジトリーにあることを確認。レポジトリーは/etc/yum.repos.d/に格納されている。

mysql-community-source.repoとmysql-community.repoの2つが確認できる。

[vagrant@localhost ~]$ ls /etc/yum.repos.d/
CentOS-Base.repo       CentOS-Sources.repo        mysql-community-source.repo
CentOS-CR.repo         CentOS-Vault.repo          mysql-community.repo
CentOS-Debuginfo.repo  CentOS-fasttrack.repo
CentOS-Media.repo      CentOS-x86_64-kernel.repo

[vagrant@localhost ~]$ ls /etc/yum.repos.d/

CentOS-Base.repo CentOS-Sources.repo mysql-community-source.repo

CentOS-CR.repo CentOS-Vault.repo mysql-community.repo

CentOS-Debuginfo.repo CentOS-fasttrack.repo

CentOS-Media.repo CentOS-x86_64-kernel.repo

MySQLのインストール

まだMySQLはレポジトリーに登録されただけなので、suでyumを使ってインストール。4分ほどかかった。

[vagrant@localhost ~]$ sudo yum install mysql-community-server
読み込んだプラグイン:fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
base                                                     | 3.6 kB     00:00
extras                                                   | 2.9 kB     00:00
mysql-connectors-community                               | 2.6 kB     00:00
mysql-tools-community                                    | 2.6 kB     00:00
mysql80-community                                        | 2.6 kB     00:00
updates                                                  | 2.9 kB     00:00
(1/3): mysql80-community/x86_64/primary_db                 | 142 kB   00:00
(2/3): mysql-tools-community/x86_64/primary_db             |  85 kB   00:00
(3/3): mysql-connectors-community/x86_64/primary_db        |  72 kB   00:00
依存性の解決をしています
--> トランザクションの確認を実行しています。
---> パッケージ mysql-community-server.x86_64 0:8.0.23-1.el7 を インストール
--> 依存性の処理をしています: mysql-community-common(x86-64) = 8.0.23-1.el7 のパッケージ: mysql-community-server-8.0.23-1.el7.x86_64
--> 依存性の処理をしています: mysql-community-client(x86-64) >= 8.0.11 のパッケ ージ: mysql-community-server-8.0.23-1.el7.x86_64
--> トランザクションの確認を実行しています。
---> パッケージ mysql-community-client.x86_64 0:8.0.23-1.el7 を インストール
--> 依存性の処理をしています: mysql-community-client-plugins = 8.0.23-1.el7 のパッケージ: mysql-community-client-8.0.23-1.el7.x86_64
--> 依存性の処理をしています: mysql-community-libs(x86-64) >= 8.0.11 のパッケー ジ: mysql-community-client-8.0.23-1.el7.x86_64
---> パッケージ mysql-community-common.x86_64 0:8.0.23-1.el7 を インストール
--> トランザクションの確認を実行しています。
---> パッケージ mariadb-libs.x86_64 1:5.5.65-1.el7 を 不要
--> 依存性の処理をしています: libmysqlclient.so.18()(64bit) のパッケージ: 2:postfix-2.10.1-9.el7.x86_64
--> 依存性の処理をしています: libmysqlclient.so.18(libmysqlclient_18)(64bit) の パッケージ: 2:postfix-2.10.1-9.el7.x86_64
---> パッケージ mysql-community-client-plugins.x86_64 0:8.0.23-1.el7 を インストール
---> パッケージ mysql-community-libs.x86_64 0:8.0.23-1.el7 を 非推奨
--> トランザクションの確認を実行しています。
---> パッケージ mysql-community-libs-compat.x86_64 0:8.0.23-1.el7 を 非推奨
--> 依存性解決を終了しました。

依存性を解決しました

================================================================================
Package                         アーキテクチャー
                                         バージョン    リポジトリー        容量
================================================================================
インストール中:
mysql-community-libs            x86_64  8.0.23-1.el7  mysql80-community  4.6 M
     mariadb-libs.x86_64 1:5.5.65-1.el7 を入れ替えます
mysql-community-libs-compat     x86_64  8.0.23-1.el7  mysql80-community  1.2 M
     mariadb-libs.x86_64 1:5.5.65-1.el7 を入れ替えます
mysql-community-server          x86_64  8.0.23-1.el7  mysql80-community  518 M
依存性関連でのインストールをします:
mysql-community-client          x86_64  8.0.23-1.el7  mysql80-community   48 M
mysql-community-client-plugins  x86_64  8.0.23-1.el7  mysql80-community  237 k
mysql-community-common          x86_64  8.0.23-1.el7  mysql80-community  621 k

トランザクションの要約
================================================================================
インストール  3 パッケージ (+3 個の依存関係のパッケージ)

総ダウンロード容量: 573 M
Is this ok [y/d/N]: y
Downloading packages:
警告: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm: ヘッダー V3 DSA/SHA1 Signature、鍵 ID 5072e1f5: NOKEY
mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm の公開鍵がインストールさ れていません
(1/6): mysql-community-client-plugins-8.0.23-1.el7.x86_64. | 237 kB   00:00
(2/6): mysql-community-common-8.0.23-1.el7.x86_64.rpm      | 621 kB   00:00
(3/6): mysql-community-libs-8.0.23-1.el7.x86_64.rpm        | 4.6 MB   00:00
(4/6): mysql-community-libs-compat-8.0.23-1.el7.x86_64.rpm | 1.2 MB   00:00
(5/6): mysql-community-client-8.0.23-1.el7.x86_64.rpm      |  48 MB   00:03
(6/6): mysql-community-server-8.0.23-1.el7.x86_64.rpm      | 518 MB   00:23
--------------------------------------------------------------------------------
合計                                                24 MB/s | 573 MB  00:24
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql から鍵を取得中です。
Importing GPG key 0x5072E1F5:
Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package    : mysql80-community-release-el7-3.noarch (@/mysql80-community-release-el7-3.noarch)
From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
上記の処理を行います。よろしいでしょうか？ [y/N]y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  インストール中          : mysql-community-common-8.0.23-1.el7.x86_64      1/7
  インストール中          : mysql-community-client-plugins-8.0.23-1.el7.x   2/7
  インストール中          : mysql-community-libs-8.0.23-1.el7.x86_64        3/7
  インストール中          : mysql-community-client-8.0.23-1.el7.x86_64      4/7
  インストール中          : mysql-community-server-8.0.23-1.el7.x86_64      5/7
  インストール中          : mysql-community-libs-compat-8.0.23-1.el7.x86_   6/7
  削除中                  : 1:mariadb-libs-5.5.65-1.el7.x86_64              7/7
  検証中                  : mysql-community-client-8.0.23-1.el7.x86_64      1/7
  検証中                  : mysql-community-libs-compat-8.0.23-1.el7.x86_   2/7
  検証中                  : mysql-community-libs-8.0.23-1.el7.x86_64        3/7
  検証中                  : mysql-community-client-plugins-8.0.23-1.el7.x   4/7
  検証中                  : mysql-community-server-8.0.23-1.el7.x86_64      5/7
  検証中                  : mysql-community-common-8.0.23-1.el7.x86_64      6/7
  検証中                  : 1:mariadb-libs-5.5.65-1.el7.x86_64              7/7

インストール:
  mysql-community-libs.x86_64 0:8.0.23-1.el7
  mysql-community-libs-compat.x86_64 0:8.0.23-1.el7
  mysql-community-server.x86_64 0:8.0.23-1.el7

依存性関連をインストールしました:
  mysql-community-client.x86_64 0:8.0.23-1.el7
  mysql-community-client-plugins.x86_64 0:8.0.23-1.el7
  mysql-community-common.x86_64 0:8.0.23-1.el7

置換:
  mariadb-libs.x86_64 1:5.5.65-1.el7

完了しました!

100

101

102

103

104

105

106

107

108

109

[vagrant@localhost ~]$ sudo yum install mysql-community-server

読み込んだプラグイン:fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

base | 3.6 kB 00:00

extras | 2.9 kB 00:00

mysql-connectors-community | 2.6 kB 00:00

mysql-tools-community | 2.6 kB 00:00

mysql80-community | 2.6 kB 00:00

updates | 2.9 kB 00:00

(1/3): mysql80-community/x86_64/primary_db | 142 kB 00:00

(2/3): mysql-tools-community/x86_64/primary_db | 85 kB 00:00

(3/3): mysql-connectors-community/x86_64/primary_db | 72 kB 00:00

依存性の解決をしています

--> トランザクションの確認を実行しています。

---> パッケージ mysql-community-server.x86_64 0:8.0.23-1.el7 をインストール

--> 依存性の処理をしています: mysql-community-common(x86-64) = 8.0.23-1.el7 のパッケージ: mysql-community-server-8.0.23-1.el7.x86_64

--> 依存性の処理をしています: mysql-community-client(x86-64) >= 8.0.11 のパッケージ: mysql-community-server-8.0.23-1.el7.x86_64

--> トランザクションの確認を実行しています。

---> パッケージ mysql-community-client.x86_64 0:8.0.23-1.el7 をインストール

--> 依存性の処理をしています: mysql-community-client-plugins = 8.0.23-1.el7 のパッケージ: mysql-community-client-8.0.23-1.el7.x86_64

--> 依存性の処理をしています: mysql-community-libs(x86-64) >= 8.0.11 のパッケージ: mysql-community-client-8.0.23-1.el7.x86_64

---> パッケージ mysql-community-common.x86_64 0:8.0.23-1.el7 をインストール

--> トランザクションの確認を実行しています。

---> パッケージ mariadb-libs.x86_64 1:5.5.65-1.el7 を不要

--> 依存性の処理をしています: libmysqlclient.so.18()(64bit) のパッケージ: 2:postfix-2.10.1-9.el7.x86_64

--> 依存性の処理をしています: libmysqlclient.so.18(libmysqlclient_18)(64bit) のパッケージ: 2:postfix-2.10.1-9.el7.x86_64

---> パッケージ mysql-community-client-plugins.x86_64 0:8.0.23-1.el7 をインストール

---> パッケージ mysql-community-libs.x86_64 0:8.0.23-1.el7 を非推奨

--> トランザクションの確認を実行しています。

---> パッケージ mysql-community-libs-compat.x86_64 0:8.0.23-1.el7 を非推奨

--> 依存性解決を終了しました。

依存性を解決しました

================================================================================

Package アーキテクチャー

バージョンリポジトリー容量

================================================================================

インストール中:

mysql-community-libs x86_64 8.0.23-1.el7 mysql80-community 4.6 M

mariadb-libs.x86_64 1:5.5.65-1.el7 を入れ替えます

mysql-community-libs-compat x86_64 8.0.23-1.el7 mysql80-community 1.2 M

mariadb-libs.x86_64 1:5.5.65-1.el7 を入れ替えます

mysql-community-server x86_64 8.0.23-1.el7 mysql80-community 518 M

依存性関連でのインストールをします:

mysql-community-client x86_64 8.0.23-1.el7 mysql80-community 48 M

mysql-community-client-plugins x86_64 8.0.23-1.el7 mysql80-community 237 k

mysql-community-common x86_64 8.0.23-1.el7 mysql80-community 621 k

トランザクションの要約

================================================================================

インストール 3 パッケージ (+3 個の依存関係のパッケージ)

総ダウンロード容量: 573 M

Is this ok [y/d/N]: y

Downloading packages:

警告: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm: ヘッダー V3 DSA/SHA1 Signature、鍵 ID 5072e1f5: NOKEY

mysql-community-client-plugins-8.0.23-1.el7.x86_64.rpm の公開鍵がインストールされていません

(1/6): mysql-community-client-plugins-8.0.23-1.el7.x86_64. | 237 kB 00:00

(2/6): mysql-community-common-8.0.23-1.el7.x86_64.rpm | 621 kB 00:00

(3/6): mysql-community-libs-8.0.23-1.el7.x86_64.rpm | 4.6 MB 00:00

(4/6): mysql-community-libs-compat-8.0.23-1.el7.x86_64.rpm | 1.2 MB 00:00

(5/6): mysql-community-client-8.0.23-1.el7.x86_64.rpm | 48 MB 00:03

(6/6): mysql-community-server-8.0.23-1.el7.x86_64.rpm | 518 MB 00:23

--------------------------------------------------------------------------------

合計 24 MB/s | 573 MB 00:24

file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql から鍵を取得中です。

Importing GPG key 0x5072E1F5:

Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"

Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5

Package : mysql80-community-release-el7-3.noarch (@/mysql80-community-release-el7-3.noarch)

From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

上記の処理を行います。よろしいでしょうか？ [y/N]y

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

インストール中 : mysql-community-common-8.0.23-1.el7.x86_64 1/7

インストール中 : mysql-community-client-plugins-8.0.23-1.el7.x 2/7

インストール中 : mysql-community-libs-8.0.23-1.el7.x86_64 3/7

インストール中 : mysql-community-client-8.0.23-1.el7.x86_64 4/7

インストール中 : mysql-community-server-8.0.23-1.el7.x86_64 5/7

インストール中 : mysql-community-libs-compat-8.0.23-1.el7.x86_ 6/7

削除中 : 1:mariadb-libs-5.5.65-1.el7.x86_64 7/7

検証中 : mysql-community-client-8.0.23-1.el7.x86_64 1/7

検証中 : mysql-community-libs-compat-8.0.23-1.el7.x86_ 2/7

検証中 : mysql-community-libs-8.0.23-1.el7.x86_64 3/7

検証中 : mysql-community-client-plugins-8.0.23-1.el7.x 4/7

検証中 : mysql-community-server-8.0.23-1.el7.x86_64 5/7

検証中 : mysql-community-common-8.0.23-1.el7.x86_64 6/7

検証中 : 1:mariadb-libs-5.5.65-1.el7.x86_64 7/7

インストール:

mysql-community-libs.x86_64 0:8.0.23-1.el7

mysql-community-libs-compat.x86_64 0:8.0.23-1.el7

mysql-community-server.x86_64 0:8.0.23-1.el7

依存性関連をインストールしました:

mysql-community-client.x86_64 0:8.0.23-1.el7

mysql-community-client-plugins.x86_64 0:8.0.23-1.el7

mysql-community-common.x86_64 0:8.0.23-1.el7

置換:

mariadb-libs.x86_64 1:5.5.65-1.el7

完了しました!

インストール確認

インストールされたMySQLのバージョンを確認。

[vagrant@localhost ~]$ mysql --version
mysql  Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)

1 2	[vagrant@localhost ~]$ mysql --version mysql Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)

MySQLの起動・停止

インストール直後の停止状態確認

状態確認は一般ユーザーでもsystemctlで可能。

[vagrant@localhost ~]$ systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html

[vagrant@localhost ~]$ systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: inactive (dead)

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

MySQLサーバーの起動

起動するにはsuとしてsystemctlを実行する必要がある。

[vagrant@localhost ~]$ sudo systemctl start mysqld

1	[vagrant@localhost ~]$ sudo systemctl start mysqld

起動状態の確認

[vagrant@localhost ~]$ systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 水 2021-02-24 22:02:36 JST; 1min 18s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 3855 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 3931 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─3931 /usr/sbin/mysqld

[vagrant@localhost ~]$ systemctl status mysqld

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since 水 2021-02-24 22:02:36 JST; 1min 18s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 3855 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 3931 (mysqld)

Status: "Server is operational"

CGroup: /system.slice/mysqld.service

└─3931 /usr/sbin/mysqld

MySQLサーバーの停止

停止するにはsuとしてsystemctlを実行する必要がある。

[vagrant@localhost ~]$ sudo systemctl stop mysqld

1	[vagrant@localhost ~]$ sudo systemctl stop mysqld

パスワードの変更

初期状態でパスワードがわからない

MySQLインストール直後にrootでログインしようとしたとき、パスワードがわからずログインできなかった。

[vagrant@localhost ~]$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[vagrant@localhost ~]$ mysql -u root -p

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ログファイルの確認

初期パスワードはログファイルに残されているとのことで、ログからパスワードを確認。

参考にさせていただいたサイト：MySQL 5.7 をインストールしたら最初に行うセットアップ

[vagrant@localhost ~]$ sudo cat /var/log/mysqld.log
2021-02-24T13:02:26.971954Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.23) initializing of server in progress as process 3886
2021-02-24T13:02:26.996117Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-24T13:02:28.192700Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-02-24T13:02:30.637069Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: *lgAhfrei14z
2021-02-24T13:02:34.919538Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 3931
2021-02-24T13:02:34.959485Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-24T13:02:35.576877Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-02-24T13:02:35.861735Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-02-24T13:02:36.232357Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-02-24T13:02:36.232866Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-02-24T13:02:36.291310Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2021-02-24T13:05:18.091708Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.23).
2021-02-24T13:05:19.449527Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-24T13:06:21.311866Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 4099
2021-02-24T13:06:21.337118Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-24T13:06:21.919265Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-02-24T13:06:22.233315Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-02-24T13:06:22.439130Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-02-24T13:06:22.439818Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-02-24T13:06:22.488668Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.

[vagrant@localhost ~]$ sudo cat /var/log/mysqld.log

2021-02-24T13:02:26.971954Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.23) initializing of server in progress as process 3886

2021-02-24T13:02:26.996117Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2021-02-24T13:02:28.192700Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2021-02-24T13:02:30.637069Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: *lgAhfrei14z

2021-02-24T13:02:34.919538Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 3931

2021-02-24T13:02:34.959485Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2021-02-24T13:02:35.576877Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2021-02-24T13:02:35.861735Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

2021-02-24T13:02:36.232357Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2021-02-24T13:02:36.232866Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2021-02-24T13:02:36.291310Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.

2021-02-24T13:05:18.091708Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.23).

2021-02-24T13:05:19.449527Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.

2021-02-24T13:06:21.311866Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 4099

2021-02-24T13:06:21.337118Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2021-02-24T13:06:21.919265Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2021-02-24T13:06:22.233315Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock

2021-02-24T13:06:22.439130Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2021-02-24T13:06:22.439818Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.

2021-02-24T13:06:22.488668Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.

ログイン成功

このパスワードを入力して無事ログイン。

[vagrant@localhost ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.23

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

[vagrant@localhost ~]$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 13

Server version: 8.0.23

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

最初のパスワード変更(強い制約)

CentOSのコマンドラインからmysql_secure_installationでパスワードを変更。このとき、デフォルトでパスワードに強い制約がかかっていて戸惑った。

ルートのパスワードを変更するか
anonymusユーザーを消すかどうか
リモートでのrootのログインを禁止するかどうか
テスト用のデータベースを削除するかどうか
権限テーブルを再読み込みするかどうか

[vagrant@localhost ~]$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The existing password for the user account root has expired. Please set a new password.

New password:
↑
パスワードの制約条件のため何度か繰り返した
↓
Re-enter new password:

The 'validate_password' component is installed on the server.
The subsequent steps will run with the existing configuration
of the component.
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : y

New password:

Re-enter new password:

Estimated strength of the password: 25
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
... Failed! Error: Your password does not satisfy the current policy requirements

New password:

Re-enter new password:

Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Success.


Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Success.

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
- Dropping test database...
Success.

- Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
Success.

All done!

[vagrant@localhost ~]$ mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The existing password for the user account root has expired. Please set a new password.

New password:

↑

パスワードの制約条件のため何度か繰り返した

↓

Re-enter new password:

The 'validate_password' component is installed on the server.

The subsequent steps will run with the existing configuration

of the component.

Using existing password for root.

Estimated strength of the password: 100

Change the password for root ? ((Press y|Y for Yes, any other key for No) : y

New password:

Re-enter new password:

Estimated strength of the password: 25

Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y

... Failed! Error: Your password does not satisfy the current policy requirements

New password:

Re-enter new password:

Estimated strength of the password: 100

Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y

By default, a MySQL installation has an anonymous user,

allowing anyone to log into MySQL without having to have

a user account created for them. This is intended only for

testing, and to make the installation go a bit smoother.

You should remove them before moving into a production

environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

Success.

Normally, root should only be allowed to connect from

'localhost'. This ensures that someone cannot guess at

the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y

Success.

By default, MySQL comes with a database named 'test' that

anyone can access. This is also intended only for testing,

and should be removed before moving into a production

environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

- Dropping test database...

Success.

- Removing privileges on test database...

Success.

Reloading the privilege tables will ensure that all changes

made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

Success.

All done!

パスワード制約条件の変更

この時点のバージョンでは、パスワード検証の変数名がネット上の情報と少し違っていた。

mysql> show global variables like 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             | 8      |
| validate_password.mixed_case_count   | 1      |
| validate_password.number_count       | 1      |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.01 sec)

mysql> show global variables like 'validate_password%';

+--------------------------------------+--------+

| Variable_name | Value |

+--------------------------------------+--------+

| validate_password.check_user_name | ON |

| validate_password.dictionary_file | |

| validate_password.length | 8 |

| validate_password.mixed_case_count | 1 |

| validate_password.number_count | 1 |

| validate_password.policy | MEDIUM |

| validate_password.special_char_count | 1 |

+--------------------------------------+--------+

7 rows in set (0.01 sec)

パスワード制約の変更

パスワード制約の強度を一番低くし、文字数を6文字以上とした。

mysql> SET GLOBAL validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL validate_password.length=6;
Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL validate_password.policy=LOW;

Query OK, 0 rows affected (0.00 sec)

mysql> SET GLOBAL validate_password.length=6;

Query OK, 0 rows affected (0.00 sec)

MySQLのUPDATEはエラー

MySQLのUPDATEでパスワード変更しようとしたが文法エラーで通らない。

mysql> UPDATE mysql.user SET password=password('******') WHERE user='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('******') WHERE user='root'' at line 1

1 2	mysql> UPDATE mysql.user SET password=password('****') WHERE user='root'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('****') WHERE user='root'' at line 1

mysqladminでパスワード変更に成功

CentOSのコマンドラインに戻ってmysqladminを試したところ、パスワード変更に成功。

[vagrant@localhost ~]$ mysqladmin -u root password '******' -p
Enter password:
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[vagrant@localhost ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 24
Server version: 8.0.23 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

[vagrant@localhost ~]$ mysqladmin -u root password '******' -p

Enter password:

mysqladmin: [Warning] Using a password on the command line interface can be insecure.

Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

[vagrant@localhost ~]$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 24

Server version: 8.0.23 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Vagrant/CentOS7 – rbenv/Rubyインストール

2021-02-24 / tau / コメントする

概要

VagrantのCentOS7仮想環境にrbenv&Rubyをインストールした記録。

ホスト：Windows10
ゲスト：Vagrant + VirtualBox + bento/CentOS-7.7

Gitのインストール

yumによるGitのインストール

suでyumを実行してGitをインストールする。

[vagrant@localhost ~]$ sudo yum install git
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
base                                                     | 3.6 kB     00:00
extras                                                   | 2.9 kB     00:00
updates                                                  | 2.9 kB     00:00
Resolving Dependencies
--> Running transaction check
---> Package git.x86_64 0:1.8.3.1-23.el7_8 will be installed
--> Processing Dependency: perl-Git = 1.8.3.1-23.el7_8 for package: git-1.8.3.1-23.el7_8.x86_64
--> Processing Dependency: perl(Term::ReadKey) for package: git-1.8.3.1-23.el7_8.x86_64
--> Processing Dependency: perl(Git) for package: git-1.8.3.1-23.el7_8.x86_64
--> Processing Dependency: perl(Error) for package: git-1.8.3.1-23.el7_8.x86_64
--> Running transaction check
---> Package perl-Error.noarch 1:0.17020-2.el7 will be installed
---> Package perl-Git.noarch 0:1.8.3.1-23.el7_8 will be installed
---> Package perl-TermReadKey.x86_64 0:2.30-20.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package                Arch         Version                   Repository  Size
================================================================================
Installing:
git                    x86_64       1.8.3.1-23.el7_8          base       4.4 M
Installing for dependencies:
perl-Error             noarch       1:0.17020-2.el7           base        32 k
perl-Git               noarch       1.8.3.1-23.el7_8          base        56 k
perl-TermReadKey       x86_64       2.30-20.el7               base        31 k

Transaction Summary
================================================================================
Install  1 Package (+3 Dependent packages)

Total download size: 4.5 M
Installed size: 22 M
Is this ok [y/d/N]: y
Downloading packages:
(1/4): perl-Error-0.17020-2.el7.noarch.rpm                 |  32 kB   00:00
(2/4): perl-Git-1.8.3.1-23.el7_8.noarch.rpm                |  56 kB   00:00
(3/4): perl-TermReadKey-2.30-20.el7.x86_64.rpm             |  31 kB   00:00
(4/4): git-1.8.3.1-23.el7_8.x86_64.rpm                     | 4.4 MB   00:00
--------------------------------------------------------------------------------
Total                                              8.7 MB/s | 4.5 MB  00:00
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : 1:perl-Error-0.17020-2.el7.noarch                            1/4
  Installing : perl-TermReadKey-2.30-20.el7.x86_64                          2/4
  Installing : perl-Git-1.8.3.1-23.el7_8.noarch                             3/4
  Installing : git-1.8.3.1-23.el7_8.x86_64                                  4/4
  Verifying  : git-1.8.3.1-23.el7_8.x86_64                                  1/4
  Verifying  : 1:perl-Error-0.17020-2.el7.noarch                            2/4
  Verifying  : perl-Git-1.8.3.1-23.el7_8.noarch                             3/4
  Verifying  : perl-TermReadKey-2.30-20.el7.x86_64                          4/4

Installed:
  git.x86_64 0:1.8.3.1-23.el7_8

Dependency Installed:
  perl-Error.noarch 1:0.17020-2.el7        perl-Git.noarch 0:1.8.3.1-23.el7_8
  perl-TermReadKey.x86_64 0:2.30-20.el7

Complete!

[vagrant@localhost ~]$ sudo yum install git

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

base | 3.6 kB 00:00

extras | 2.9 kB 00:00

updates | 2.9 kB 00:00

Resolving Dependencies

--> Running transaction check

---> Package git.x86_64 0:1.8.3.1-23.el7_8 will be installed

--> Processing Dependency: perl-Git = 1.8.3.1-23.el7_8 for package: git-1.8.3.1-23.el7_8.x86_64

--> Processing Dependency: perl(Term::ReadKey) for package: git-1.8.3.1-23.el7_8.x86_64

--> Processing Dependency: perl(Git) for package: git-1.8.3.1-23.el7_8.x86_64

--> Processing Dependency: perl(Error) for package: git-1.8.3.1-23.el7_8.x86_64

--> Running transaction check

---> Package perl-Error.noarch 1:0.17020-2.el7 will be installed

---> Package perl-Git.noarch 0:1.8.3.1-23.el7_8 will be installed

---> Package perl-TermReadKey.x86_64 0:2.30-20.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

================================================================================

Installing:

git x86_64 1.8.3.1-23.el7_8 base 4.4 M

Installing for dependencies:

perl-Error noarch 1:0.17020-2.el7 base 32 k

perl-Git noarch 1.8.3.1-23.el7_8 base 56 k

perl-TermReadKey x86_64 2.30-20.el7 base 31 k

Transaction Summary

================================================================================

Install 1 Package (+3 Dependent packages)

Total download size: 4.5 M

Installed size: 22 M

Is this ok [y/d/N]: y

Downloading packages:

(1/4): perl-Error-0.17020-2.el7.noarch.rpm | 32 kB 00:00

(2/4): perl-Git-1.8.3.1-23.el7_8.noarch.rpm | 56 kB 00:00

(3/4): perl-TermReadKey-2.30-20.el7.x86_64.rpm | 31 kB 00:00

(4/4): git-1.8.3.1-23.el7_8.x86_64.rpm | 4.4 MB 00:00

--------------------------------------------------------------------------------

Total 8.7 MB/s | 4.5 MB 00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : 1:perl-Error-0.17020-2.el7.noarch 1/4

Installing : perl-TermReadKey-2.30-20.el7.x86_64 2/4

Installing : perl-Git-1.8.3.1-23.el7_8.noarch 3/4

Installing : git-1.8.3.1-23.el7_8.x86_64 4/4

Verifying : git-1.8.3.1-23.el7_8.x86_64 1/4

Verifying : 1:perl-Error-0.17020-2.el7.noarch 2/4

Verifying : perl-Git-1.8.3.1-23.el7_8.noarch 3/4

Verifying : perl-TermReadKey-2.30-20.el7.x86_64 4/4

Installed:

git.x86_64 0:1.8.3.1-23.el7_8

Dependency Installed:

perl-Error.noarch 1:0.17020-2.el7 perl-Git.noarch 0:1.8.3.1-23.el7_8

perl-TermReadKey.x86_64 0:2.30-20.el7

Complete!

確認

[vagrant@localhost ~]$ git --version
git version 1.8.3.1

1 2	[vagrant@localhost ~]$ git --version git version 1.8.3.1

rbenvのインストール

ユーザー環境へのrbenvのダウンロード

カレントディレクトリーの確認。

[vagrant@localhost ~]$ pwd
/home/vagrant

1 2	[vagrant@localhost ~]$ pwd /home/vagrant

Gitでユーザー環境にrbenvをclone(ダウンロード)。

[vagrant@localhost ~]$ git clone https://github.com/sstephenson/rbenv.git ~/.rbenv
Cloning into '/home/vagrant/.rbenv'...
remote: Enumerating objects: 2886, done.
remote: Total 2886 (delta 0), reused 0 (delta 0), pack-reused 2886
Receiving objects: 100% (2886/2886), 562.66 KiB | 373.00 KiB/s, done.
Resolving deltas: 100% (1801/1801), done.

[vagrant@localhost ~]$ git clone https://github.com/sstephenson/rbenv.git ~/.rbenv

Cloning into '/home/vagrant/.rbenv'...

remote: Enumerating objects: 2886, done.

remote: Total 2886 (delta 0), reused 0 (delta 0), pack-reused 2886

Receiving objects: 100% (2886/2886), 562.66 KiB | 373.00 KiB/s, done.

Resolving deltas: 100% (1801/1801), done.

/home/vagrand下に.rbenvフォルダーが作成され、その下にフォルダー・ファイル群が展開される。

.bash_profileの設定

$PATHの確認

[vagrant@localhost ~]$ echo $PATH
/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/vagrant/.local/bin:/home/vagrant/bin

1 2	[vagrant@localhost ~]$ echo $PATH /usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/vagrant/.local/bin:/home/vagrant/bin

.bash_profileの確認

[vagrant@localhost ~]$ cat ./.bash_profile# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

[vagrant@localhost ~]$ cat ./.bash_profile# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

PATHの追加

$echo 'export PATH=通したいパス:$PATH' >> .bash_profile

rbenvの場合は

echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile

起動時のrbenv init実行設定

echo 'eval "$(rbenv init -)"' >> ~/.bash_profile

設定後の.bash_profile

[vagrant@localhost ~]$ echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile
[vagrant@localhost ~]$ echo 'eval "$(rbenv init -)"' >> ~/.bash_profile
[vagrant@localhost ~]$ cat ./.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export PATH="$HOME/.rbenv/bin:$PATH"
eval "$(rbenv init -)"

[vagrant@localhost ~]$ echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile

[vagrant@localhost ~]$ echo 'eval "$(rbenv init -)"' >> ~/.bash_profile

[vagrant@localhost ~]$ cat ./.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

export PATH="$HOME/.rbenv/bin:$PATH"

eval "$(rbenv init -)"

.bash_profileを修正したら、ターミナルを再起動して.bash_profileを反映させる。

rbenvの確認

[vagrant@localhost ~]$ rbenv
rbenv 1.1.2-44-gd604acb
Usage: rbenv <command> [<args>]

Some useful rbenv commands are:
   commands    List all available rbenv commands
   local       Set or show the local application-specific Ruby version
   global      Set or show the global Ruby version
   shell       Set or show the shell-specific Ruby version
   rehash      Rehash rbenv shims (run this after installing executables)
   version     Show the current Ruby version and its origin
   versions    List installed Ruby versions
   which       Display the full path to an executable
   whence      List all Ruby versions that contain the given executable

See `rbenv help <command>' for information on a specific command.
For full documentation, see: https://github.com/rbenv/rbenv#readme

[vagrant@localhost ~]$ rbenv

rbenv 1.1.2-44-gd604acb

Usage: rbenv <command> [<args>]

Some useful rbenv commands are:

commands List all available rbenv commands

local Set or show the local application-specific Ruby version

global Set or show the global Ruby version

shell Set or show the shell-specific Ruby version

rehash Rehash rbenv shims (run this after installing executables)

version Show the current Ruby version and its origin

versions List installed Ruby versions

which Display the full path to an executable

whence List all Ruby versions that contain the given executable

See `rbenv help <command>' for information on a specific command.

For full documentation, see: https://github.com/rbenv/rbenv#readme

ruby-build

ユーザー環境へのruby-buildのダウンロード

Gitでユーザー環境にruby-buildをclone(ダウンロード)。

[vagrant@localhost ~]$ git clone https://github.com/sstephenson/ruby-build.git ~/.rbenv/plugins/ruby-build
Cloning into '/home/vagrant/.rbenv/plugins/ruby-build'...
remote: Enumerating objects: 101, done.
remote: Counting objects: 100% (101/101), done.
remote: Compressing objects: 100% (87/87), done.
remote: Total 11408 (delta 78), reused 22 (delta 10), pack-reused 11307
Receiving objects: 100% (11408/11408), 2.42 MiB | 1.97 MiB/s, done.
Resolving deltas: 100% (7545/7545), done.

[vagrant@localhost ~]$ git clone https://github.com/sstephenson/ruby-build.git ~/.rbenv/plugins/ruby-build

Cloning into '/home/vagrant/.rbenv/plugins/ruby-build'...

remote: Enumerating objects: 101, done.

remote: Counting objects: 100% (101/101), done.

remote: Compressing objects: 100% (87/87), done.

remote: Total 11408 (delta 78), reused 22 (delta 10), pack-reused 11307

Receiving objects: 100% (11408/11408), 2.42 MiB | 1.97 MiB/s, done.

Resolving deltas: 100% (7545/7545), done.

Ruby

ライブラリーのインストール

gcc, make, openssl-devel, readline-develが必要になるので、yumでインストール。

[vagrant@localhost ~]$ sudo yum install gcc make openssl-devel readline-devel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
Package gcc-4.8.5-44.el7.x86_64 already installed and latest version
Package 1:make-3.82-24.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package openssl-devel.x86_64 1:1.0.2k-21.el7_9 will be installed
--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-21.el7_9 for package: 1:openssl-devel-1.0.2k-21.el7_9.x86_64
--> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.2k-21.el7_9.x86_64
---> Package readline-devel.x86_64 0:6.2-11.el7 will be installed
--> Processing Dependency: ncurses-devel for package: readline-devel-6.2-11.el7.x86_64
--> Running transaction check
---> Package krb5-devel.x86_64 0:1.15.1-50.el7 will be installed
--> Processing Dependency: libkadm5(x86-64) = 1.15.1-50.el7 for package: krb5-devel-1.15.1-50.el7.x86_64
--> Processing Dependency: krb5-libs(x86-64) = 1.15.1-50.el7 for package: krb5-devel-1.15.1-50.el7.x86_64
--> Processing Dependency: libverto-devel for package: krb5-devel-1.15.1-50.el7.x86_64
--> Processing Dependency: libselinux-devel for package: krb5-devel-1.15.1-50.el7.x86_64
--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.15.1-50.el7.x86_64
--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.15.1-50.el7.x86_64
---> Package ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed
---> Package openssl-libs.x86_64 1:1.0.2k-19.el7 will be updated
--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-19.el7 for package: 1:openssl-1.0.2k-19.el7.x86_64
---> Package openssl-libs.x86_64 1:1.0.2k-21.el7_9 will be an update
--> Running transaction check
---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
---> Package krb5-libs.x86_64 0:1.15.1-46.el7 will be updated
---> Package krb5-libs.x86_64 0:1.15.1-50.el7 will be an update
---> Package libcom_err-devel.x86_64 0:1.42.9-19.el7 will be installed
--> Processing Dependency: libcom_err(x86-64) = 1.42.9-19.el7 for package: libcom_err-devel-1.42.9-19.el7.x86_64
---> Package libkadm5.x86_64 0:1.15.1-50.el7 will be installed
---> Package libselinux-devel.x86_64 0:2.5-15.el7 will be installed
--> Processing Dependency: libsepol-devel(x86-64) >= 2.5-10 for package: libselinux-devel-2.5-15.el7.x86_64
--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-15.el7.x86_64
--> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-15.el7.x86_64
---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
---> Package openssl.x86_64 1:1.0.2k-19.el7 will be updated
---> Package openssl.x86_64 1:1.0.2k-21.el7_9 will be an update
--> Running transaction check
---> Package libcom_err.x86_64 0:1.42.9-17.el7 will be updated
--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: e2fsprogs-libs-1.42.9-17.el7.x86_64
--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: e2fsprogs-1.42.9-17.el7.x86_64
--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: libss-1.42.9-17.el7.x86_64
---> Package libcom_err.x86_64 0:1.42.9-19.el7 will be an update
---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be installed
---> Package pcre-devel.x86_64 0:8.32-17.el7 will be installed
--> Running transaction check
---> Package e2fsprogs.x86_64 0:1.42.9-17.el7 will be updated
---> Package e2fsprogs.x86_64 0:1.42.9-19.el7 will be an update
---> Package e2fsprogs-libs.x86_64 0:1.42.9-17.el7 will be updated
---> Package e2fsprogs-libs.x86_64 0:1.42.9-19.el7 will be an update
---> Package libss.x86_64 0:1.42.9-17.el7 will be updated
---> Package libss.x86_64 0:1.42.9-19.el7 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package                 Arch       Version                   Repository   Size
================================================================================
Installing:
openssl-devel           x86_64     1:1.0.2k-21.el7_9         updates     1.5 M
readline-devel          x86_64     6.2-11.el7                base        139 k
Installing for dependencies:
keyutils-libs-devel     x86_64     1.5.8-3.el7               base         37 k
krb5-devel              x86_64     1.15.1-50.el7             base        273 k
libcom_err-devel        x86_64     1.42.9-19.el7             base         32 k
libkadm5                x86_64     1.15.1-50.el7             base        179 k
libselinux-devel        x86_64     2.5-15.el7                base        187 k
libsepol-devel          x86_64     2.5-10.el7                base         77 k
libverto-devel          x86_64     0.2.5-4.el7               base         12 k
ncurses-devel           x86_64     5.9-14.20130511.el7_4     base        712 k
pcre-devel              x86_64     8.32-17.el7               base        480 k
Updating for dependencies:
e2fsprogs               x86_64     1.42.9-19.el7             base        701 k
e2fsprogs-libs          x86_64     1.42.9-19.el7             base        168 k
krb5-libs               x86_64     1.15.1-50.el7             base        809 k
libcom_err              x86_64     1.42.9-19.el7             base         42 k
libss                   x86_64     1.42.9-19.el7             base         47 k
openssl                 x86_64     1:1.0.2k-21.el7_9         updates     493 k
openssl-libs            x86_64     1:1.0.2k-21.el7_9         updates     1.2 M

Transaction Summary
================================================================================
Install  2 Packages (+9 Dependent packages)
Upgrade             ( 7 Dependent packages)

Total download size: 7.0 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for base
No Presto metadata available for updates
(1/18): e2fsprogs-libs-1.42.9-19.el7.x86_64.rpm            | 168 kB   00:00
(2/18): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm         |  37 kB   00:00
(3/18): krb5-devel-1.15.1-50.el7.x86_64.rpm                | 273 kB   00:00
(4/18): e2fsprogs-1.42.9-19.el7.x86_64.rpm                 | 701 kB   00:00
(5/18): krb5-libs-1.15.1-50.el7.x86_64.rpm                 | 809 kB   00:00
(6/18): libcom_err-1.42.9-19.el7.x86_64.rpm                |  42 kB   00:00
(7/18): libcom_err-devel-1.42.9-19.el7.x86_64.rpm          |  32 kB   00:00
(8/18): libkadm5-1.15.1-50.el7.x86_64.rpm                  | 179 kB   00:00
(9/18): libselinux-devel-2.5-15.el7.x86_64.rpm             | 187 kB   00:00
(10/18): libsepol-devel-2.5-10.el7.x86_64.rpm              |  77 kB   00:00
(11/18): libss-1.42.9-19.el7.x86_64.rpm                    |  47 kB   00:00
(12/18): libverto-devel-0.2.5-4.el7.x86_64.rpm             |  12 kB   00:00
(13/18): ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm    | 712 kB   00:00
(14/18): openssl-1.0.2k-21.el7_9.x86_64.rpm                | 493 kB   00:00
(15/18): openssl-devel-1.0.2k-21.el7_9.x86_64.rpm          | 1.5 MB   00:00
(16/18): openssl-libs-1.0.2k-21.el7_9.x86_64.rpm           | 1.2 MB   00:00
(17/18): pcre-devel-8.32-17.el7.x86_64.rpm                 | 480 kB   00:00
(18/18): readline-devel-6.2-11.el7.x86_64.rpm              | 139 kB   00:00
--------------------------------------------------------------------------------
Total                                              5.1 MB/s | 7.0 MB  00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : libcom_err-1.42.9-19.el7.x86_64                             1/25
  Updating   : 1:openssl-libs-1.0.2k-21.el7_9.x86_64                       2/25
  Updating   : krb5-libs-1.15.1-50.el7.x86_64                              3/25
  Installing : libkadm5-1.15.1-50.el7.x86_64                               4/25
  Updating   : libss-1.42.9-19.el7.x86_64                                  5/25
  Updating   : e2fsprogs-libs-1.42.9-19.el7.x86_64                         6/25
  Installing : libcom_err-devel-1.42.9-19.el7.x86_64                       7/25
  Installing : libsepol-devel-2.5-10.el7.x86_64                            8/25
  Installing : ncurses-devel-5.9-14.20130511.el7_4.x86_64                  9/25
  Installing : libverto-devel-0.2.5-4.el7.x86_64                          10/25
  Installing : pcre-devel-8.32-17.el7.x86_64                              11/25
  Installing : libselinux-devel-2.5-15.el7.x86_64                         12/25
  Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64                     13/25
  Installing : krb5-devel-1.15.1-50.el7.x86_64                            14/25
  Installing : 1:openssl-devel-1.0.2k-21.el7_9.x86_64                     15/25
  Installing : readline-devel-6.2-11.el7.x86_64                           16/25
  Updating   : e2fsprogs-1.42.9-19.el7.x86_64                             17/25
  Updating   : 1:openssl-1.0.2k-21.el7_9.x86_64                           18/25
  Cleanup    : e2fsprogs-1.42.9-17.el7.x86_64                             19/25
  Cleanup    : 1:openssl-1.0.2k-19.el7.x86_64                             20/25
  Cleanup    : krb5-libs-1.15.1-46.el7.x86_64                             21/25
  Cleanup    : 1:openssl-libs-1.0.2k-19.el7.x86_64                        22/25
  Cleanup    : e2fsprogs-libs-1.42.9-17.el7.x86_64                        23/25
  Cleanup    : libss-1.42.9-17.el7.x86_64                                 24/25
  Cleanup    : libcom_err-1.42.9-17.el7.x86_64                            25/25
  Verifying  : libselinux-devel-2.5-15.el7.x86_64                          1/25
  Verifying  : keyutils-libs-devel-1.5.8-3.el7.x86_64                      2/25
  Verifying  : libss-1.42.9-19.el7.x86_64                                  3/25
  Verifying  : libcom_err-1.42.9-19.el7.x86_64                             4/25
  Verifying  : pcre-devel-8.32-17.el7.x86_64                               5/25
  Verifying  : libkadm5-1.15.1-50.el7.x86_64                               6/25
  Verifying  : libverto-devel-0.2.5-4.el7.x86_64                           7/25
  Verifying  : ncurses-devel-5.9-14.20130511.el7_4.x86_64                  8/25
  Verifying  : 1:openssl-1.0.2k-21.el7_9.x86_64                            9/25
  Verifying  : e2fsprogs-libs-1.42.9-19.el7.x86_64                        10/25
  Verifying  : libsepol-devel-2.5-10.el7.x86_64                           11/25
  Verifying  : 1:openssl-libs-1.0.2k-21.el7_9.x86_64                      12/25
  Verifying  : readline-devel-6.2-11.el7.x86_64                           13/25
  Verifying  : 1:openssl-devel-1.0.2k-21.el7_9.x86_64                     14/25
  Verifying  : e2fsprogs-1.42.9-19.el7.x86_64                             15/25
  Verifying  : krb5-devel-1.15.1-50.el7.x86_64                            16/25
  Verifying  : krb5-libs-1.15.1-50.el7.x86_64                             17/25
  Verifying  : libcom_err-devel-1.42.9-19.el7.x86_64                      18/25
  Verifying  : e2fsprogs-libs-1.42.9-17.el7.x86_64                        19/25
  Verifying  : libcom_err-1.42.9-17.el7.x86_64                            20/25
  Verifying  : krb5-libs-1.15.1-46.el7.x86_64                             21/25
  Verifying  : 1:openssl-libs-1.0.2k-19.el7.x86_64                        22/25
  Verifying  : e2fsprogs-1.42.9-17.el7.x86_64                             23/25
  Verifying  : 1:openssl-1.0.2k-19.el7.x86_64                             24/25
  Verifying  : libss-1.42.9-17.el7.x86_64                                 25/25

Installed:
  openssl-devel.x86_64 1:1.0.2k-21.el7_9   readline-devel.x86_64 0:6.2-11.el7

Dependency Installed:
  keyutils-libs-devel.x86_64 0:1.5.8-3.el7
  krb5-devel.x86_64 0:1.15.1-50.el7
  libcom_err-devel.x86_64 0:1.42.9-19.el7
  libkadm5.x86_64 0:1.15.1-50.el7
  libselinux-devel.x86_64 0:2.5-15.el7
  libsepol-devel.x86_64 0:2.5-10.el7
  libverto-devel.x86_64 0:0.2.5-4.el7
  ncurses-devel.x86_64 0:5.9-14.20130511.el7_4
  pcre-devel.x86_64 0:8.32-17.el7

Dependency Updated:
  e2fsprogs.x86_64 0:1.42.9-19.el7       e2fsprogs-libs.x86_64 0:1.42.9-19.el7
  krb5-libs.x86_64 0:1.15.1-50.el7       libcom_err.x86_64 0:1.42.9-19.el7
  libss.x86_64 0:1.42.9-19.el7           openssl.x86_64 1:1.0.2k-21.el7_9
  openssl-libs.x86_64 1:1.0.2k-21.el7_9

Complete!

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

[vagrant@localhost ~]$ sudo yum install gcc make openssl-devel readline-devel

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

Package gcc-4.8.5-44.el7.x86_64 already installed and latest version

Package 1:make-3.82-24.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package openssl-devel.x86_64 1:1.0.2k-21.el7_9 will be installed

--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-21.el7_9 for package: 1:openssl-devel-1.0.2k-21.el7_9.x86_64

--> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.2k-21.el7_9.x86_64

---> Package readline-devel.x86_64 0:6.2-11.el7 will be installed

--> Processing Dependency: ncurses-devel for package: readline-devel-6.2-11.el7.x86_64

--> Running transaction check

---> Package krb5-devel.x86_64 0:1.15.1-50.el7 will be installed

--> Processing Dependency: libkadm5(x86-64) = 1.15.1-50.el7 for package: krb5-devel-1.15.1-50.el7.x86_64

--> Processing Dependency: krb5-libs(x86-64) = 1.15.1-50.el7 for package: krb5-devel-1.15.1-50.el7.x86_64

--> Processing Dependency: libverto-devel for package: krb5-devel-1.15.1-50.el7.x86_64

--> Processing Dependency: libselinux-devel for package: krb5-devel-1.15.1-50.el7.x86_64

--> Processing Dependency: libcom_err-devel for package: krb5-devel-1.15.1-50.el7.x86_64

--> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.15.1-50.el7.x86_64

---> Package ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed

---> Package openssl-libs.x86_64 1:1.0.2k-19.el7 will be updated

--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.2k-19.el7 for package: 1:openssl-1.0.2k-19.el7.x86_64

---> Package openssl-libs.x86_64 1:1.0.2k-21.el7_9 will be an update

--> Running transaction check

---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed

---> Package krb5-libs.x86_64 0:1.15.1-46.el7 will be updated

---> Package krb5-libs.x86_64 0:1.15.1-50.el7 will be an update

---> Package libcom_err-devel.x86_64 0:1.42.9-19.el7 will be installed

--> Processing Dependency: libcom_err(x86-64) = 1.42.9-19.el7 for package: libcom_err-devel-1.42.9-19.el7.x86_64

---> Package libkadm5.x86_64 0:1.15.1-50.el7 will be installed

---> Package libselinux-devel.x86_64 0:2.5-15.el7 will be installed

--> Processing Dependency: libsepol-devel(x86-64) >= 2.5-10 for package: libselinux-devel-2.5-15.el7.x86_64

--> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-15.el7.x86_64

--> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-15.el7.x86_64

---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed

---> Package openssl.x86_64 1:1.0.2k-19.el7 will be updated

---> Package openssl.x86_64 1:1.0.2k-21.el7_9 will be an update

--> Running transaction check

---> Package libcom_err.x86_64 0:1.42.9-17.el7 will be updated

--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: e2fsprogs-libs-1.42.9-17.el7.x86_64

--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: e2fsprogs-1.42.9-17.el7.x86_64

--> Processing Dependency: libcom_err(x86-64) = 1.42.9-17.el7 for package: libss-1.42.9-17.el7.x86_64

---> Package libcom_err.x86_64 0:1.42.9-19.el7 will be an update

---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be installed

---> Package pcre-devel.x86_64 0:8.32-17.el7 will be installed

--> Running transaction check

---> Package e2fsprogs.x86_64 0:1.42.9-17.el7 will be updated

---> Package e2fsprogs.x86_64 0:1.42.9-19.el7 will be an update

---> Package e2fsprogs-libs.x86_64 0:1.42.9-17.el7 will be updated

---> Package e2fsprogs-libs.x86_64 0:1.42.9-19.el7 will be an update

---> Package libss.x86_64 0:1.42.9-17.el7 will be updated

---> Package libss.x86_64 0:1.42.9-19.el7 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

================================================================================

Installing:

openssl-devel x86_64 1:1.0.2k-21.el7_9 updates 1.5 M

readline-devel x86_64 6.2-11.el7 base 139 k

Installing for dependencies:

keyutils-libs-devel x86_64 1.5.8-3.el7 base 37 k

krb5-devel x86_64 1.15.1-50.el7 base 273 k

libcom_err-devel x86_64 1.42.9-19.el7 base 32 k

libkadm5 x86_64 1.15.1-50.el7 base 179 k

libselinux-devel x86_64 2.5-15.el7 base 187 k

libsepol-devel x86_64 2.5-10.el7 base 77 k

libverto-devel x86_64 0.2.5-4.el7 base 12 k

ncurses-devel x86_64 5.9-14.20130511.el7_4 base 712 k

pcre-devel x86_64 8.32-17.el7 base 480 k

Updating for dependencies:

e2fsprogs x86_64 1.42.9-19.el7 base 701 k

e2fsprogs-libs x86_64 1.42.9-19.el7 base 168 k

krb5-libs x86_64 1.15.1-50.el7 base 809 k

libcom_err x86_64 1.42.9-19.el7 base 42 k

libss x86_64 1.42.9-19.el7 base 47 k

openssl x86_64 1:1.0.2k-21.el7_9 updates 493 k

openssl-libs x86_64 1:1.0.2k-21.el7_9 updates 1.2 M

Transaction Summary

================================================================================

Install 2 Packages (+9 Dependent packages)

Upgrade ( 7 Dependent packages)

Total download size: 7.0 M

Is this ok [y/d/N]: y

Downloading packages:

No Presto metadata available for base

No Presto metadata available for updates

(1/18): e2fsprogs-libs-1.42.9-19.el7.x86_64.rpm | 168 kB 00:00

(2/18): keyutils-libs-devel-1.5.8-3.el7.x86_64.rpm | 37 kB 00:00

(3/18): krb5-devel-1.15.1-50.el7.x86_64.rpm | 273 kB 00:00

(4/18): e2fsprogs-1.42.9-19.el7.x86_64.rpm | 701 kB 00:00

(5/18): krb5-libs-1.15.1-50.el7.x86_64.rpm | 809 kB 00:00

(6/18): libcom_err-1.42.9-19.el7.x86_64.rpm | 42 kB 00:00

(7/18): libcom_err-devel-1.42.9-19.el7.x86_64.rpm | 32 kB 00:00

(8/18): libkadm5-1.15.1-50.el7.x86_64.rpm | 179 kB 00:00

(9/18): libselinux-devel-2.5-15.el7.x86_64.rpm | 187 kB 00:00

(10/18): libsepol-devel-2.5-10.el7.x86_64.rpm | 77 kB 00:00

(11/18): libss-1.42.9-19.el7.x86_64.rpm | 47 kB 00:00

(12/18): libverto-devel-0.2.5-4.el7.x86_64.rpm | 12 kB 00:00

(13/18): ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm | 712 kB 00:00

(14/18): openssl-1.0.2k-21.el7_9.x86_64.rpm | 493 kB 00:00

(15/18): openssl-devel-1.0.2k-21.el7_9.x86_64.rpm | 1.5 MB 00:00

(16/18): openssl-libs-1.0.2k-21.el7_9.x86_64.rpm | 1.2 MB 00:00

(17/18): pcre-devel-8.32-17.el7.x86_64.rpm | 480 kB 00:00

(18/18): readline-devel-6.2-11.el7.x86_64.rpm | 139 kB 00:00

--------------------------------------------------------------------------------

Total 5.1 MB/s | 7.0 MB 00:01

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Updating : libcom_err-1.42.9-19.el7.x86_64 1/25

Updating : 1:openssl-libs-1.0.2k-21.el7_9.x86_64 2/25

Updating : krb5-libs-1.15.1-50.el7.x86_64 3/25

Installing : libkadm5-1.15.1-50.el7.x86_64 4/25

Updating : libss-1.42.9-19.el7.x86_64 5/25

Updating : e2fsprogs-libs-1.42.9-19.el7.x86_64 6/25

Installing : libcom_err-devel-1.42.9-19.el7.x86_64 7/25

Installing : libsepol-devel-2.5-10.el7.x86_64 8/25

Installing : ncurses-devel-5.9-14.20130511.el7_4.x86_64 9/25

Installing : libverto-devel-0.2.5-4.el7.x86_64 10/25

Installing : pcre-devel-8.32-17.el7.x86_64 11/25

Installing : libselinux-devel-2.5-15.el7.x86_64 12/25

Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64 13/25

Installing : krb5-devel-1.15.1-50.el7.x86_64 14/25

Installing : 1:openssl-devel-1.0.2k-21.el7_9.x86_64 15/25

Installing : readline-devel-6.2-11.el7.x86_64 16/25

Updating : e2fsprogs-1.42.9-19.el7.x86_64 17/25

Updating : 1:openssl-1.0.2k-21.el7_9.x86_64 18/25

Cleanup : e2fsprogs-1.42.9-17.el7.x86_64 19/25

Cleanup : 1:openssl-1.0.2k-19.el7.x86_64 20/25

Cleanup : krb5-libs-1.15.1-46.el7.x86_64 21/25

Cleanup : 1:openssl-libs-1.0.2k-19.el7.x86_64 22/25

Cleanup : e2fsprogs-libs-1.42.9-17.el7.x86_64 23/25

Cleanup : libss-1.42.9-17.el7.x86_64 24/25

Cleanup : libcom_err-1.42.9-17.el7.x86_64 25/25

Verifying : libselinux-devel-2.5-15.el7.x86_64 1/25

Verifying : keyutils-libs-devel-1.5.8-3.el7.x86_64 2/25

Verifying : libss-1.42.9-19.el7.x86_64 3/25

Verifying : libcom_err-1.42.9-19.el7.x86_64 4/25

Verifying : pcre-devel-8.32-17.el7.x86_64 5/25

Verifying : libkadm5-1.15.1-50.el7.x86_64 6/25

Verifying : libverto-devel-0.2.5-4.el7.x86_64 7/25

Verifying : ncurses-devel-5.9-14.20130511.el7_4.x86_64 8/25

Verifying : 1:openssl-1.0.2k-21.el7_9.x86_64 9/25

Verifying : e2fsprogs-libs-1.42.9-19.el7.x86_64 10/25

Verifying : libsepol-devel-2.5-10.el7.x86_64 11/25

Verifying : 1:openssl-libs-1.0.2k-21.el7_9.x86_64 12/25

Verifying : readline-devel-6.2-11.el7.x86_64 13/25

Verifying : 1:openssl-devel-1.0.2k-21.el7_9.x86_64 14/25

Verifying : e2fsprogs-1.42.9-19.el7.x86_64 15/25

Verifying : krb5-devel-1.15.1-50.el7.x86_64 16/25

Verifying : krb5-libs-1.15.1-50.el7.x86_64 17/25

Verifying : libcom_err-devel-1.42.9-19.el7.x86_64 18/25

Verifying : e2fsprogs-libs-1.42.9-17.el7.x86_64 19/25

Verifying : libcom_err-1.42.9-17.el7.x86_64 20/25

Verifying : krb5-libs-1.15.1-46.el7.x86_64 21/25

Verifying : 1:openssl-libs-1.0.2k-19.el7.x86_64 22/25

Verifying : e2fsprogs-1.42.9-17.el7.x86_64 23/25

Verifying : 1:openssl-1.0.2k-19.el7.x86_64 24/25

Verifying : libss-1.42.9-17.el7.x86_64 25/25

Installed:

openssl-devel.x86_64 1:1.0.2k-21.el7_9 readline-devel.x86_64 0:6.2-11.el7

Dependency Installed:

keyutils-libs-devel.x86_64 0:1.5.8-3.el7

krb5-devel.x86_64 0:1.15.1-50.el7

libcom_err-devel.x86_64 0:1.42.9-19.el7

libkadm5.x86_64 0:1.15.1-50.el7

libselinux-devel.x86_64 0:2.5-15.el7

libsepol-devel.x86_64 0:2.5-10.el7

libverto-devel.x86_64 0:0.2.5-4.el7

ncurses-devel.x86_64 0:5.9-14.20130511.el7_4

pcre-devel.x86_64 0:8.32-17.el7

Dependency Updated:

e2fsprogs.x86_64 0:1.42.9-19.el7 e2fsprogs-libs.x86_64 0:1.42.9-19.el7

krb5-libs.x86_64 0:1.15.1-50.el7 libcom_err.x86_64 0:1.42.9-19.el7

libss.x86_64 0:1.42.9-19.el7 openssl.x86_64 1:1.0.2k-21.el7_9

openssl-libs.x86_64 1:1.0.2k-21.el7_9

Complete!

インストール可能なパッケージの確認

ruby-envでインストール可能なパッケージを確認する。

-listは最近の安定バージョンのみ表示
--list-allはインストール可能な全バージョンを表示

[vagrant@localhost ~]$ rbenv install -l
2.5.8
2.6.6
2.7.2
3.0.0
jruby-9.2.14.0
mruby-2.1.2
rbx-5.0
truffleruby-21.0.0
truffleruby+graalvm-21.0.0

Only latest stable releases for each Ruby implementation are shown.
Use 'rbenv install --list-all / -L' to show all local versions.

[vagrant@localhost ~]$ rbenv install -l

2.5.8

2.6.6

2.7.2

3.0.0

jruby-9.2.14.0

mruby-2.1.2

rbx-5.0

truffleruby-21.0.0

truffleruby+graalvm-21.0.0

Only latest stable releases for each Ruby implementation are shown.

Use 'rbenv install --list-all / -L' to show all local versions.

Rubyのインストール

今回は3.0.0をインストール。3～4分ほどかかった。

[vagrant@localhost ~]$ rbenv install 3.0.0
Downloading ruby-3.0.0.tar.gz...
-> https://cache.ruby-lang.org/pub/ruby/3.0/ruby-3.0.0.tar.gz
Installing ruby-3.0.0...
Installed ruby-3.0.0 to /home/vagrant/.rbenv/versions/3.0.0

[vagrant@localhost ~]$ rbenv install 3.0.0

Downloading ruby-3.0.0.tar.gz...

-> https://cache.ruby-lang.org/pub/ruby/3.0/ruby-3.0.0.tar.gz

Installing ruby-3.0.0...

Installed ruby-3.0.0 to /home/vagrant/.rbenv/versions/3.0.0

デフォルトのRubyの設定

通常使うRubyにダウンロードした3.0.0を設定。

[vagrant@localhost ~]$ rbenv global 3.0.0

1	[vagrant@localhost ~]$ rbenv global 3.0.0

確認

[vagrant@localhost ~]$ ruby -v
ruby 3.0.0p0 (2020-12-25 revision 95aff21468) [x86_64-linux]

1 2	[vagrant@localhost ~]$ ruby -v ruby 3.0.0p0 (2020-12-25 revision 95aff21468) [x86_64-linux]

参考サイト

Vagrant – 共有設定・カーネル更新

2021-02-23 / tau / コメントする

概要

Vagrantの仮想環境での共有フォルダ－設定
環境はWindows10、Vagrant、VirtualBox、bento/Centos-7.7
この過程でカーネルのアップデートが必要

Vagrant初期起動

bento/Centos-7.7の前にCentos/7のBoxで共有設定をしたときにvagrant-vbguestパッケージをインストール済みだったので、GuestAdditionsの不整合は解決されている様子。

ただしkernelのバージョン不整合は解決されない。

C:\vagrant\centos7>vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Importing base box 'bento/centos-7.7'...
==> default: Matching MAC address for NAT networking...
==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...

.....

[default] GuestAdditions versions on your host (6.1.18) and guest (6.1.6) do not match.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
Resolving Dependencies
--> Running transaction check
---> Package centos-release.x86_64 0:7-8.2003.0.el7.centos will be updated
---> Package centos-release.x86_64 0:7-9.2009.1.el7.centos will be an update
--> Finished Dependency Resolution

Dependencies Resolved

.....

Updated:
  centos-release.x86_64 0:7-9.2009.1.el7.centos

Complete!
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
No package kernel-devel-3.10.0-1127.el7.x86_64 available.
Error: Nothing to do
Unmounting Virtualbox Guest Additions ISO from: /mnt
umount: /mnt: not mounted
==> default: Checking for guest additions in VM...
The following SSH command responded with a non-zero exit status.
Vagrant assumes that this means the command failed!

umount /mnt

Stdout from the command:



Stderr from the command:

umount: /mnt: not mounted

C:\vagrant\centos7>vagrant up

Bringing machine 'default' up with 'virtualbox' provider...

==> default: Importing base box 'bento/centos-7.7'...

==> default: Matching MAC address for NAT networking...

==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...

.....

[default] GuestAdditions versions on your host (6.1.18) and guest (6.1.6) do not match.

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

Resolving Dependencies

--> Running transaction check

---> Package centos-release.x86_64 0:7-8.2003.0.el7.centos will be updated

---> Package centos-release.x86_64 0:7-9.2009.1.el7.centos will be an update

--> Finished Dependency Resolution

Dependencies Resolved

.....

Updated:

centos-release.x86_64 0:7-9.2009.1.el7.centos

Complete!

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

No package kernel-devel-3.10.0-1127.el7.x86_64 available.

Error: Nothing to do

Unmounting Virtualbox Guest Additions ISO from: /mnt

umount: /mnt: not mounted

==> default: Checking for guest additions in VM...

The following SSH command responded with a non-zero exit status.

Vagrant assumes that this means the command failed!

umount /mnt

Stdout from the command:

Stderr from the command:

umount: /mnt: not mounted

SSH接続・カーネルアップデート

VagrantからSSH接続して仮想環境にログイン
仮想環境下でyumによってカーネルをアップデート

[vagrant@localhost ~]$ sudo yum -y update kernel
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
Resolving Dependencies
--> Running transaction check
---> Package kernel.x86_64 0:3.10.0-1160.15.2.el7 will be installed
--> Processing Dependency: linux-firmware >= 20190429-72 for package: kernel-3.10.0-1160.15.2.el7.x86_64
--> Running transaction check
---> Package linux-firmware.noarch 0:20200421-80.git78c0348.el7_9 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package           Arch      Version                           Repository  Size
================================================================================
Installing:
kernel            x86_64    3.10.0-1160.15.2.el7              updates     50 M
Installing for dependencies:
linux-firmware    noarch    20200421-80.git78c0348.el7_9      updates     80 M

Transaction Summary
================================================================================
Install  1 Package (+1 Dependent package)

Total download size: 131 M
Installed size: 458 M
Downloading packages:
No Presto metadata available for updates
(1/2): kernel-3.10.0-1160.15.2.el7.x86_64.rpm              |  50 MB   00:07
(2/2): linux-firmware-20200421-80.git78c0348.el7_9.noarch. |  80 MB   00:11
--------------------------------------------------------------------------------
Total                                               11 MB/s | 131 MB  00:11
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : linux-firmware-20200421-80.git78c0348.el7_9.noarch           1/2
  Installing : kernel-3.10.0-1160.15.2.el7.x86_64                           2/2

  Verifying  : linux-firmware-20200421-80.git78c0348.el7_9.noarch           1/2
  Verifying  : kernel-3.10.0-1160.15.2.el7.x86_64                           2/2

Installed:
  kernel.x86_64 0:3.10.0-1160.15.2.el7

Dependency Installed:
  linux-firmware.noarch 0:20200421-80.git78c0348.el7_9

Complete!

[vagrant@localhost ~]$ sudo yum -y update kernel

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

Resolving Dependencies

--> Running transaction check

---> Package kernel.x86_64 0:3.10.0-1160.15.2.el7 will be installed

--> Processing Dependency: linux-firmware >= 20190429-72 for package: kernel-3.10.0-1160.15.2.el7.x86_64

--> Running transaction check

---> Package linux-firmware.noarch 0:20200421-80.git78c0348.el7_9 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

================================================================================

Installing:

kernel x86_64 3.10.0-1160.15.2.el7 updates 50 M

Installing for dependencies:

linux-firmware noarch 20200421-80.git78c0348.el7_9 updates 80 M

Transaction Summary

================================================================================

Install 1 Package (+1 Dependent package)

Total download size: 131 M

Installed size: 458 M

Downloading packages:

No Presto metadata available for updates

(1/2): kernel-3.10.0-1160.15.2.el7.x86_64.rpm | 50 MB 00:07

(2/2): linux-firmware-20200421-80.git78c0348.el7_9.noarch. | 80 MB 00:11

--------------------------------------------------------------------------------

Total 11 MB/s | 131 MB 00:11

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : linux-firmware-20200421-80.git78c0348.el7_9.noarch 1/2

Installing : kernel-3.10.0-1160.15.2.el7.x86_64 2/2

Verifying : linux-firmware-20200421-80.git78c0348.el7_9.noarch 1/2

Verifying : kernel-3.10.0-1160.15.2.el7.x86_64 2/2

Installed:

kernel.x86_64 0:3.10.0-1160.15.2.el7

Dependency Installed:

linux-firmware.noarch 0:20200421-80.git78c0348.el7_9

Complete!

Vagrant再起動

exitで仮想環境から抜けてホスト環境に戻る
ホスト環境でVagrantを再起動
ここでかなり時間をかけて環境設定が行われる

[vagrant@localhost ~]$ exit
logout
Connection to 127.0.0.1 closed.

C:\vagrant\centos7>vagrant reload
==> default: Attempting graceful shutdown of VM...
==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
==> default: Forwarding ports...
    default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2222
    default: SSH username: vagrant
    default: SSH auth method: private key
    default: Warning: Connection reset. Retrying...
==> default: Machine booted and ready!
[default] No Virtualbox Guest Additions installation found.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.jaist.ac.jp
* extras: ftp.jaist.ac.jp
* updates: ftp.jaist.ac.jp
Package 1:make-3.82-24.el7.x86_64 already installed and latest version
Package bzip2-1.0.6-13.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package binutils.x86_64 0:2.27-43.base.el7 will be updated
---> Package binutils.x86_64 0:2.27-44.base.el7 will be an update
---> Package elfutils-libelf-devel.x86_64 0:0.176-5.el7 will be installed
--> Processing Dependency: elfutils-libelf(x86-64) = 0.176-5.el7 for package: elfutils-libelf-devel-0.176-5.el7.x86_64
--> Processing Dependency: pkgconfig(zlib) for package: elfutils-libelf-devel-0.176-5.el7.x86_64
---> Package gcc.x86_64 0:4.8.5-44.el7 will be installed
--> Processing Dependency: libgomp = 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: cpp = 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: libgcc >= 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64
--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-44.el7.x86_64
---> Package kernel-devel.x86_64 0:3.10.0-1160.15.2.el7 will be installed
---> Package perl.x86_64 4:5.16.3-295.el7 will be updated
---> Package perl.x86_64 4:5.16.3-299.el7_9 will be an update
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Running transaction check
---> Package cpp.x86_64 0:4.8.5-44.el7 will be installed
---> Package elfutils-libelf.x86_64 0:0.176-4.el7 will be updated
--> Processing Dependency: elfutils-libelf(x86-64) = 0.176-4.el7 for package: elfutils-libs-0.176-4.el7.x86_64
---> Package elfutils-libelf.x86_64 0:0.176-5.el7 will be an update
---> Package glibc-devel.x86_64 0:2.17-323.el7_9 will be installed
--> Processing Dependency: glibc-headers = 2.17-323.el7_9 for package: glibc-devel-2.17-323.el7_9.x86_64
--> Processing Dependency: glibc = 2.17-323.el7_9 for package: glibc-devel-2.17-323.el7_9.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-323.el7_9.x86_64
---> Package libgcc.x86_64 0:4.8.5-39.el7 will be updated
---> Package libgcc.x86_64 0:4.8.5-44.el7 will be an update
---> Package libgomp.x86_64 0:4.8.5-39.el7 will be updated
---> Package libgomp.x86_64 0:4.8.5-44.el7 will be an update
---> Package perl-libs.x86_64 4:5.16.3-295.el7 will be updated
---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be an update
---> Package zlib-devel.x86_64 0:1.2.7-19.el7_9 will be installed
--> Processing Dependency: zlib = 1.2.7-19.el7_9 for package: zlib-devel-1.2.7-19.el7_9.x86_64
--> Running transaction check
---> Package elfutils-libs.x86_64 0:0.176-4.el7 will be updated
---> Package elfutils-libs.x86_64 0:0.176-5.el7 will be an update
---> Package glibc.x86_64 0:2.17-307.el7.1 will be updated
--> Processing Dependency: glibc = 2.17-307.el7.1 for package: glibc-common-2.17-307.el7.1.x86_64
---> Package glibc.x86_64 0:2.17-323.el7_9 will be an update
---> Package glibc-headers.x86_64 0:2.17-323.el7_9 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-323.el7_9.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-323.el7_9.x86_64
---> Package zlib.x86_64 0:1.2.7-18.el7 will be updated
---> Package zlib.x86_64 0:1.2.7-19.el7_9 will be an update
--> Running transaction check
---> Package glibc-common.x86_64 0:2.17-307.el7.1 will be updated
---> Package glibc-common.x86_64 0:2.17-323.el7_9 will be an update
---> Package kernel-headers.x86_64 0:3.10.0-1160.15.2.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package                  Arch      Version                    Repository  Size
================================================================================
Installing:
elfutils-libelf-devel    x86_64    0.176-5.el7                base        40 k
gcc                      x86_64    4.8.5-44.el7               base        16 M
kernel-devel             x86_64    3.10.0-1160.15.2.el7       updates     18 M
Updating:
binutils                 x86_64    2.27-44.base.el7           base       5.9 M
perl                     x86_64    4:5.16.3-299.el7_9         updates    8.0 M
Installing for dependencies:
cpp                      x86_64    4.8.5-44.el7               base       5.9 M
glibc-devel              x86_64    2.17-323.el7_9             updates    1.1 M
glibc-headers            x86_64    2.17-323.el7_9             updates    691 k
kernel-headers           x86_64    3.10.0-1160.15.2.el7       updates    9.0 M
zlib-devel               x86_64    1.2.7-19.el7_9             updates     50 k
Updating for dependencies:
elfutils-libelf          x86_64    0.176-5.el7                base       195 k
elfutils-libs            x86_64    0.176-5.el7                base       291 k
glibc                    x86_64    2.17-323.el7_9             updates    3.6 M
glibc-common             x86_64    2.17-323.el7_9             updates     12 M
libgcc                   x86_64    4.8.5-44.el7               base       103 k
libgomp                  x86_64    4.8.5-44.el7               base       159 k
perl-libs                x86_64    4:5.16.3-299.el7_9         updates    690 k
zlib                     x86_64    1.2.7-19.el7_9             updates     90 k

Transaction Summary
================================================================================
Install  3 Packages (+5 Dependent packages)
Upgrade  2 Packages (+8 Dependent packages)

Total download size: 81 M
Downloading packages:
No Presto metadata available for base
No Presto metadata available for updates
--------------------------------------------------------------------------------
Total                                               11 MB/s |  81 MB  00:07
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : libgcc-4.8.5-44.el7.x86_64                                  1/28
  Updating   : glibc-common-2.17-323.el7_9.x86_64                          2/28
  Updating   : glibc-2.17-323.el7_9.x86_64                                 3/28
  Updating   : zlib-1.2.7-19.el7_9.x86_64                                  4/28
  Updating   : elfutils-libelf-0.176-5.el7.x86_64                          5/28
  Updating   : 4:perl-libs-5.16.3-299.el7_9.x86_64                         6/28
  Updating   : 4:perl-5.16.3-299.el7_9.x86_64                              7/28
  Updating   : binutils-2.27-44.base.el7.x86_64                            8/28
  Installing : cpp-4.8.5-44.el7.x86_64                                     9/28
  Installing : zlib-devel-1.2.7-19.el7_9.x86_64                           10/28
  Updating   : libgomp-4.8.5-44.el7.x86_64                                11/28
  Installing : kernel-headers-3.10.0-1160.15.2.el7.x86_64                 12/28
  Installing : glibc-headers-2.17-323.el7_9.x86_64                        13/28
  Installing : glibc-devel-2.17-323.el7_9.x86_64                          14/28
  Installing : gcc-4.8.5-44.el7.x86_64                                    15/28
  Installing : elfutils-libelf-devel-0.176-5.el7.x86_64                   16/28
  Installing : kernel-devel-3.10.0-1160.15.2.el7.x86_64                   17/28
  Updating   : elfutils-libs-0.176-5.el7.x86_64                           18/28
  Cleanup    : elfutils-libs-0.176-4.el7.x86_64                           19/28
  Cleanup    : 4:perl-libs-5.16.3-295.el7.x86_64                          20/28
  Cleanup    : 4:perl-5.16.3-295.el7.x86_64                               21/28
  Cleanup    : elfutils-libelf-0.176-4.el7.x86_64                         22/28
  Cleanup    : binutils-2.27-43.base.el7.x86_64                           23/28
  Cleanup    : zlib-1.2.7-18.el7.x86_64                                   24/28
  Cleanup    : libgomp-4.8.5-39.el7.x86_64                                25/28
  Cleanup    : glibc-common-2.17-307.el7.1.x86_64                         26/28
  Cleanup    : glibc-2.17-307.el7.1.x86_64                                27/28
  Cleanup    : libgcc-4.8.5-39.el7.x86_64                                 28/28
  Verifying  : glibc-headers-2.17-323.el7_9.x86_64                         1/28
  Verifying  : zlib-1.2.7-19.el7_9.x86_64                                  2/28
  Verifying  : binutils-2.27-44.base.el7.x86_64                            3/28
  Verifying  : glibc-devel-2.17-323.el7_9.x86_64                           4/28
  Verifying  : kernel-headers-3.10.0-1160.15.2.el7.x86_64                  5/28
  Verifying  : glibc-2.17-323.el7_9.x86_64                                 6/28
  Verifying  : cpp-4.8.5-44.el7.x86_64                                     7/28
  Verifying  : kernel-devel-3.10.0-1160.15.2.el7.x86_64                    8/28
  Verifying  : glibc-common-2.17-323.el7_9.x86_64                          9/28
  Verifying  : zlib-devel-1.2.7-19.el7_9.x86_64                           10/28
  Verifying  : elfutils-libelf-0.176-5.el7.x86_64                         11/28
  Verifying  : elfutils-libelf-devel-0.176-5.el7.x86_64                   12/28
  Verifying  : gcc-4.8.5-44.el7.x86_64                                    13/28
  Verifying  : 4:perl-5.16.3-299.el7_9.x86_64                             14/28
  Verifying  : 4:perl-libs-5.16.3-299.el7_9.x86_64                        15/28
  Verifying  : libgcc-4.8.5-44.el7.x86_64                                 16/28
  Verifying  : libgomp-4.8.5-44.el7.x86_64                                17/28
  Verifying  : elfutils-libs-0.176-5.el7.x86_64                           18/28
  Verifying  : 4:perl-libs-5.16.3-295.el7.x86_64                          19/28
  Verifying  : zlib-1.2.7-18.el7.x86_64                                   20/28
  Verifying  : glibc-common-2.17-307.el7.1.x86_64                         21/28
  Verifying  : libgcc-4.8.5-39.el7.x86_64                                 22/28
  Verifying  : libgomp-4.8.5-39.el7.x86_64                                23/28
  Verifying  : elfutils-libelf-0.176-4.el7.x86_64                         24/28
  Verifying  : glibc-2.17-307.el7.1.x86_64                                25/28
  Verifying  : binutils-2.27-43.base.el7.x86_64                           26/28
  Verifying  : elfutils-libs-0.176-4.el7.x86_64                           27/28
  Verifying  : 4:perl-5.16.3-295.el7.x86_64                               28/28

Installed:
  elfutils-libelf-devel.x86_64 0:0.176-5.el7      gcc.x86_64 0:4.8.5-44.el7
  kernel-devel.x86_64 0:3.10.0-1160.15.2.el7

Dependency Installed:
  cpp.x86_64 0:4.8.5-44.el7
  glibc-devel.x86_64 0:2.17-323.el7_9
  glibc-headers.x86_64 0:2.17-323.el7_9
  kernel-headers.x86_64 0:3.10.0-1160.15.2.el7
  zlib-devel.x86_64 0:1.2.7-19.el7_9

Updated:
  binutils.x86_64 0:2.27-44.base.el7       perl.x86_64 4:5.16.3-299.el7_9

Dependency Updated:
  elfutils-libelf.x86_64 0:0.176-5.el7   elfutils-libs.x86_64 0:0.176-5.el7
  glibc.x86_64 0:2.17-323.el7_9          glibc-common.x86_64 0:2.17-323.el7_9
  libgcc.x86_64 0:4.8.5-44.el7           libgomp.x86_64 0:4.8.5-44.el7
  perl-libs.x86_64 4:5.16.3-299.el7_9    zlib.x86_64 0:1.2.7-19.el7_9

Complete!
Copy iso file C:\Program Files\Oracle\VirtualBox\VBoxGuestAdditions.iso into the box /tmp/VBoxGuestAdditions.iso
Mounting Virtualbox Guest Additions ISO to: /mnt
mount: /dev/loop0 is write-protected, mounting read-only
Installing Virtualbox Guest Additions 6.1.18 - guest version is unknown
Verifying archive integrity... All good.
Uncompressing VirtualBox 6.1.18 Guest Additions for Linux........
VirtualBox Guest Additions installer
Removing installed version 6.1.6 of VirtualBox Guest Additions...
Copying additional installer modules ...
Installing additional modules ...
VirtualBox Guest Additions: Starting.
VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel
modules.  This may take a while.
VirtualBox Guest Additions: To build modules for other installed kernels, run
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup <version>
VirtualBox Guest Additions: or
VirtualBox Guest Additions:   /sbin/rcvboxadd quicksetup all
VirtualBox Guest Additions: Building the modules for kernel
3.10.0-1160.15.2.el7.x86_64.
Redirecting to /bin/systemctl start vboxadd.service
Redirecting to /bin/systemctl start vboxadd-service.service
Unmounting Virtualbox Guest Additions ISO from: /mnt
==> default: Checking for guest additions in VM...
==> default: Mounting shared folders...
    default: /vagrant => C:/vagrant/centos7
==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> default: flag to force provisioning. Provisioners marked to run always will still run.

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

[vagrant@localhost ~]$ exit

logout

Connection to 127.0.0.1 closed.

C:\vagrant\centos7>vagrant reload

==> default: Attempting graceful shutdown of VM...

==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...

==> default: Clearing any previously set forwarded ports...

==> default: Clearing any previously set network interfaces...

==> default: Preparing network interfaces based on configuration...

default: Adapter 1: nat

==> default: Forwarding ports...

default: 22 (guest) => 2222 (host) (adapter 1)

==> default: Booting VM...

==> default: Waiting for machine to boot. This may take a few minutes...

default: SSH address: 127.0.0.1:2222

default: SSH username: vagrant

default: SSH auth method: private key

default: Warning: Connection reset. Retrying...

==> default: Machine booted and ready!

[default] No Virtualbox Guest Additions installation found.

Loaded plugins: fastestmirror

Loading mirror speeds from cached hostfile

* base: ftp.jaist.ac.jp

* extras: ftp.jaist.ac.jp

* updates: ftp.jaist.ac.jp

Package 1:make-3.82-24.el7.x86_64 already installed and latest version

Package bzip2-1.0.6-13.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package binutils.x86_64 0:2.27-43.base.el7 will be updated

---> Package binutils.x86_64 0:2.27-44.base.el7 will be an update

---> Package elfutils-libelf-devel.x86_64 0:0.176-5.el7 will be installed

--> Processing Dependency: elfutils-libelf(x86-64) = 0.176-5.el7 for package: elfutils-libelf-devel-0.176-5.el7.x86_64

--> Processing Dependency: pkgconfig(zlib) for package: elfutils-libelf-devel-0.176-5.el7.x86_64

---> Package gcc.x86_64 0:4.8.5-44.el7 will be installed

--> Processing Dependency: libgomp = 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64

--> Processing Dependency: cpp = 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64

--> Processing Dependency: libgcc >= 4.8.5-44.el7 for package: gcc-4.8.5-44.el7.x86_64

--> Processing Dependency: glibc-devel >= 2.2.90-12 for package: gcc-4.8.5-44.el7.x86_64

---> Package kernel-devel.x86_64 0:3.10.0-1160.15.2.el7 will be installed

---> Package perl.x86_64 4:5.16.3-295.el7 will be updated

---> Package perl.x86_64 4:5.16.3-299.el7_9 will be an update

--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64

--> Running transaction check

---> Package cpp.x86_64 0:4.8.5-44.el7 will be installed

---> Package elfutils-libelf.x86_64 0:0.176-4.el7 will be updated

--> Processing Dependency: elfutils-libelf(x86-64) = 0.176-4.el7 for package: elfutils-libs-0.176-4.el7.x86_64

---> Package elfutils-libelf.x86_64 0:0.176-5.el7 will be an update

---> Package glibc-devel.x86_64 0:2.17-323.el7_9 will be installed

--> Processing Dependency: glibc-headers = 2.17-323.el7_9 for package: glibc-devel-2.17-323.el7_9.x86_64

--> Processing Dependency: glibc = 2.17-323.el7_9 for package: glibc-devel-2.17-323.el7_9.x86_64

--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-323.el7_9.x86_64

---> Package libgcc.x86_64 0:4.8.5-39.el7 will be updated

---> Package libgcc.x86_64 0:4.8.5-44.el7 will be an update

---> Package libgomp.x86_64 0:4.8.5-39.el7 will be updated

---> Package libgomp.x86_64 0:4.8.5-44.el7 will be an update

---> Package perl-libs.x86_64 4:5.16.3-295.el7 will be updated

---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be an update

---> Package zlib-devel.x86_64 0:1.2.7-19.el7_9 will be installed

--> Processing Dependency: zlib = 1.2.7-19.el7_9 for package: zlib-devel-1.2.7-19.el7_9.x86_64

--> Running transaction check

---> Package elfutils-libs.x86_64 0:0.176-4.el7 will be updated

---> Package elfutils-libs.x86_64 0:0.176-5.el7 will be an update

---> Package glibc.x86_64 0:2.17-307.el7.1 will be updated

--> Processing Dependency: glibc = 2.17-307.el7.1 for package: glibc-common-2.17-307.el7.1.x86_64

---> Package glibc.x86_64 0:2.17-323.el7_9 will be an update

---> Package glibc-headers.x86_64 0:2.17-323.el7_9 will be installed

--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-323.el7_9.x86_64

--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-323.el7_9.x86_64

---> Package zlib.x86_64 0:1.2.7-18.el7 will be updated

---> Package zlib.x86_64 0:1.2.7-19.el7_9 will be an update

--> Running transaction check

---> Package glibc-common.x86_64 0:2.17-307.el7.1 will be updated

---> Package glibc-common.x86_64 0:2.17-323.el7_9 will be an update

---> Package kernel-headers.x86_64 0:3.10.0-1160.15.2.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

================================================================================

Installing:

elfutils-libelf-devel x86_64 0.176-5.el7 base 40 k

gcc x86_64 4.8.5-44.el7 base 16 M

kernel-devel x86_64 3.10.0-1160.15.2.el7 updates 18 M

Updating:

binutils x86_64 2.27-44.base.el7 base 5.9 M

perl x86_64 4:5.16.3-299.el7_9 updates 8.0 M

Installing for dependencies:

cpp x86_64 4.8.5-44.el7 base 5.9 M

glibc-devel x86_64 2.17-323.el7_9 updates 1.1 M

glibc-headers x86_64 2.17-323.el7_9 updates 691 k

kernel-headers x86_64 3.10.0-1160.15.2.el7 updates 9.0 M

zlib-devel x86_64 1.2.7-19.el7_9 updates 50 k

Updating for dependencies:

elfutils-libelf x86_64 0.176-5.el7 base 195 k

elfutils-libs x86_64 0.176-5.el7 base 291 k

glibc x86_64 2.17-323.el7_9 updates 3.6 M

glibc-common x86_64 2.17-323.el7_9 updates 12 M

libgcc x86_64 4.8.5-44.el7 base 103 k

libgomp x86_64 4.8.5-44.el7 base 159 k

perl-libs x86_64 4:5.16.3-299.el7_9 updates 690 k

zlib x86_64 1.2.7-19.el7_9 updates 90 k

Transaction Summary

================================================================================

Install 3 Packages (+5 Dependent packages)

Upgrade 2 Packages (+8 Dependent packages)

Total download size: 81 M

Downloading packages:

No Presto metadata available for base

No Presto metadata available for updates

--------------------------------------------------------------------------------

Total 11 MB/s | 81 MB 00:07

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Updating : libgcc-4.8.5-44.el7.x86_64 1/28

Updating : glibc-common-2.17-323.el7_9.x86_64 2/28

Updating : glibc-2.17-323.el7_9.x86_64 3/28

Updating : zlib-1.2.7-19.el7_9.x86_64 4/28

Updating : elfutils-libelf-0.176-5.el7.x86_64 5/28

Updating : 4:perl-libs-5.16.3-299.el7_9.x86_64 6/28

Updating : 4:perl-5.16.3-299.el7_9.x86_64 7/28

Updating : binutils-2.27-44.base.el7.x86_64 8/28

Installing : cpp-4.8.5-44.el7.x86_64 9/28

Installing : zlib-devel-1.2.7-19.el7_9.x86_64 10/28

Updating : libgomp-4.8.5-44.el7.x86_64 11/28

Installing : kernel-headers-3.10.0-1160.15.2.el7.x86_64 12/28

Installing : glibc-headers-2.17-323.el7_9.x86_64 13/28

Installing : glibc-devel-2.17-323.el7_9.x86_64 14/28

Installing : gcc-4.8.5-44.el7.x86_64 15/28

Installing : elfutils-libelf-devel-0.176-5.el7.x86_64 16/28

Installing : kernel-devel-3.10.0-1160.15.2.el7.x86_64 17/28

Updating : elfutils-libs-0.176-5.el7.x86_64 18/28

Cleanup : elfutils-libs-0.176-4.el7.x86_64 19/28

Cleanup : 4:perl-libs-5.16.3-295.el7.x86_64 20/28

Cleanup : 4:perl-5.16.3-295.el7.x86_64 21/28

Cleanup : elfutils-libelf-0.176-4.el7.x86_64 22/28

Cleanup : binutils-2.27-43.base.el7.x86_64 23/28

Cleanup : zlib-1.2.7-18.el7.x86_64 24/28

Cleanup : libgomp-4.8.5-39.el7.x86_64 25/28

Cleanup : glibc-common-2.17-307.el7.1.x86_64 26/28

Cleanup : glibc-2.17-307.el7.1.x86_64 27/28

Cleanup : libgcc-4.8.5-39.el7.x86_64 28/28

Verifying : glibc-headers-2.17-323.el7_9.x86_64 1/28

Verifying : zlib-1.2.7-19.el7_9.x86_64 2/28

Verifying : binutils-2.27-44.base.el7.x86_64 3/28

Verifying : glibc-devel-2.17-323.el7_9.x86_64 4/28

Verifying : kernel-headers-3.10.0-1160.15.2.el7.x86_64 5/28

Verifying : glibc-2.17-323.el7_9.x86_64 6/28

Verifying : cpp-4.8.5-44.el7.x86_64 7/28

Verifying : kernel-devel-3.10.0-1160.15.2.el7.x86_64 8/28

Verifying : glibc-common-2.17-323.el7_9.x86_64 9/28

Verifying : zlib-devel-1.2.7-19.el7_9.x86_64 10/28

Verifying : elfutils-libelf-0.176-5.el7.x86_64 11/28

Verifying : elfutils-libelf-devel-0.176-5.el7.x86_64 12/28

Verifying : gcc-4.8.5-44.el7.x86_64 13/28

Verifying : 4:perl-5.16.3-299.el7_9.x86_64 14/28

Verifying : 4:perl-libs-5.16.3-299.el7_9.x86_64 15/28

Verifying : libgcc-4.8.5-44.el7.x86_64 16/28

Verifying : libgomp-4.8.5-44.el7.x86_64 17/28

Verifying : elfutils-libs-0.176-5.el7.x86_64 18/28

Verifying : 4:perl-libs-5.16.3-295.el7.x86_64 19/28

Verifying : zlib-1.2.7-18.el7.x86_64 20/28

Verifying : glibc-common-2.17-307.el7.1.x86_64 21/28

Verifying : libgcc-4.8.5-39.el7.x86_64 22/28

Verifying : libgomp-4.8.5-39.el7.x86_64 23/28

Verifying : elfutils-libelf-0.176-4.el7.x86_64 24/28

Verifying : glibc-2.17-307.el7.1.x86_64 25/28

Verifying : binutils-2.27-43.base.el7.x86_64 26/28

Verifying : elfutils-libs-0.176-4.el7.x86_64 27/28

Verifying : 4:perl-5.16.3-295.el7.x86_64 28/28

Installed:

elfutils-libelf-devel.x86_64 0:0.176-5.el7 gcc.x86_64 0:4.8.5-44.el7

kernel-devel.x86_64 0:3.10.0-1160.15.2.el7

Dependency Installed:

cpp.x86_64 0:4.8.5-44.el7

glibc-devel.x86_64 0:2.17-323.el7_9

glibc-headers.x86_64 0:2.17-323.el7_9

kernel-headers.x86_64 0:3.10.0-1160.15.2.el7

zlib-devel.x86_64 0:1.2.7-19.el7_9

Updated:

binutils.x86_64 0:2.27-44.base.el7 perl.x86_64 4:5.16.3-299.el7_9

Dependency Updated:

elfutils-libelf.x86_64 0:0.176-5.el7 elfutils-libs.x86_64 0:0.176-5.el7

glibc.x86_64 0:2.17-323.el7_9 glibc-common.x86_64 0:2.17-323.el7_9

libgcc.x86_64 0:4.8.5-44.el7 libgomp.x86_64 0:4.8.5-44.el7

perl-libs.x86_64 4:5.16.3-299.el7_9 zlib.x86_64 0:1.2.7-19.el7_9

Complete!

Copy iso file C:\Program Files\Oracle\VirtualBox\VBoxGuestAdditions.iso into the box /tmp/VBoxGuestAdditions.iso

Mounting Virtualbox Guest Additions ISO to: /mnt

mount: /dev/loop0 is write-protected, mounting read-only

Installing Virtualbox Guest Additions 6.1.18 - guest version is unknown

Verifying archive integrity... All good.

Uncompressing VirtualBox 6.1.18 Guest Additions for Linux........

VirtualBox Guest Additions installer

Removing installed version 6.1.6 of VirtualBox Guest Additions...

Copying additional installer modules ...

Installing additional modules ...

VirtualBox Guest Additions: Starting.

VirtualBox Guest Additions: Building the VirtualBox Guest Additions kernel

modules. This may take a while.

VirtualBox Guest Additions: To build modules for other installed kernels, run

VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup <version>

VirtualBox Guest Additions: or

VirtualBox Guest Additions: /sbin/rcvboxadd quicksetup all

VirtualBox Guest Additions: Building the modules for kernel

3.10.0-1160.15.2.el7.x86_64.

Redirecting to /bin/systemctl start vboxadd.service

Redirecting to /bin/systemctl start vboxadd-service.service

Unmounting Virtualbox Guest Additions ISO from: /mnt

==> default: Checking for guest additions in VM...

==> default: Mounting shared folders...

default: /vagrant => C:/vagrant/centos7

==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`

==> default: flag to force provisioning. Provisioners marked to run always will still run.

共有設定・再起動

共有設定の最終段階
ホスト側の共有フォルダ－を作成
vagrantfileに1行追加
vagrant reloadでVagrantを再起動
仮想環境下にもフォルダーが作成され、同期される

vagrantfile設定

config.vm.synced_folder "ホスト側パス", "ゲスト側パス"

第1引数はホスト側パスで、vagrantfileからの相対パスで指定
- ホスト側で共有ディレクトリーを作成しておく必要がある
第2引数はゲストパスで、絶対パスで指定
- ゲスト側の共有ディレクトリーはVagrantが作成してくれる

Vagrant.configure("2") do |config|
  .....
  config.vm.box = "bento/centos-7.7"
  .....
  config.vm.synced_folder "./share", "/home/vagrant/share"
  .....
end

Vagrant.configure("2") do |config|

.....

config.vm.box = "bento/centos-7.7"

.....

config.vm.synced_folder "./share", "/home/vagrant/share"

.....

end

Vagrant再起動

Vagrantを再起動すると、共有フォルダ－が作成される。

C:\vagrant\centos7>vagrant reload
==> default: Attempting graceful shutdown of VM...
==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
==> default: Forwarding ports...
    default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2222
    default: SSH username: vagrant
    default: SSH auth method: private key
    default: Warning: Connection reset. Retrying...
    default: Warning: Connection aborted. Retrying...
==> default: Machine booted and ready!
[default] GuestAdditions 6.1.18 running --- OK.
==> default: Checking for guest additions in VM...
==> default: Mounting shared folders...
    default: /vagrant => C:/vagrant/centos7
    default: /home/vagrant/share => C:/vagrant/centos7/share
==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> default: flag to force provisioning. Provisioners marked to run always will still run.

C:\vagrant\centos7>vagrant reload

==> default: Attempting graceful shutdown of VM...

==> default: Checking if box 'bento/centos-7.7' version '202005.12.0' is up to date...

==> default: Clearing any previously set forwarded ports...

==> default: Clearing any previously set network interfaces...

==> default: Preparing network interfaces based on configuration...

default: Adapter 1: nat

==> default: Forwarding ports...

default: 22 (guest) => 2222 (host) (adapter 1)

==> default: Booting VM...

==> default: Waiting for machine to boot. This may take a few minutes...

default: SSH address: 127.0.0.1:2222

default: SSH username: vagrant

default: SSH auth method: private key

default: Warning: Connection reset. Retrying...

default: Warning: Connection aborted. Retrying...

==> default: Machine booted and ready!

[default] GuestAdditions 6.1.18 running --- OK.

==> default: Checking for guest additions in VM...

==> default: Mounting shared folders...

default: /vagrant => C:/vagrant/centos7

default: /home/vagrant/share => C:/vagrant/centos7/share

==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`

==> default: flag to force provisioning. Provisioners marked to run always will still run.

フォルダー配置

ホスト側：C\vagrant\centos7\share
ゲスト側：/home/vagrant/share

Vagrant – 環境構築(旧)

2021-02-23 / tau / コメントする

概要

以降はVagrant導入後最初にインストールしたBoxの導入記録。

Vagrant CloudのCentos/7を選び、共有フォルダ－設定を試みたところ、なかなかうまく共有できなかった。

このBoxのリリースがv2004.01と結構古かったので、その後bento/Centos-7.7に変更し、比較的スムーズにフォルダー共有ができた。

Boxの導入

Boxのインストール

仮想環境のBoxをインストール。今回はVagrant Cloudから提供されているCentosOS/7を選んだ。

Vagrantからのインストールの場合は以下のコマンド。
- >vagrant box add centos/7
他のサイトからの場合、名前を指定してインストールする場合は以下のコマンド。
- >vagrant box add name url/local_file

C:\>vagrant box add centos/7
==> box: Loading metadata for box 'centos/7'
    box: URL: https://vagrantcloud.com/centos/7
This box can work with multiple providers! The providers that it
can work with are listed below. Please review the list and choose
the provider you will be working with.

1) hyperv
2) libvirt
3) virtualbox
4) vmware_desktop

Enter your choice:

C:\>vagrant box add centos/7

==> box: Loading metadata for box 'centos/7'

box: URL: https://vagrantcloud.com/centos/7

This box can work with multiple providers! The providers that it

can work with are listed below. Please review the list and choose

the provider you will be working with.

1) hyperv

2) libvirt

3) virtualbox

4) vmware_desktop

Enter your choice:

今回はVirtualBoxの仮想環境なので3を選択。以下の処理に10分オーダーの時間がかかる。

Enter your choice: 3
==> box: Adding box 'centos/7' (v2004.01) for provider: virtualbox
    box: Downloading: https://vagrantcloud.com/centos/boxes/7/versions/2004.01/providers/virtualbox.box
Download redirected to host: cloud.centos.org
    box:
    box: Calculating and comparing box checksum...
==> box: Successfully added box 'centos/7' (v2004.01) for 'virtualbox'!

Enter your choice: 3

==> box: Adding box 'centos/7' (v2004.01) for provider: virtualbox

box: Downloading: https://vagrantcloud.com/centos/boxes/7/versions/2004.01/providers/virtualbox.box

Download redirected to host: cloud.centos.org

box:

box: Calculating and comparing box checksum...

==> box: Successfully added box 'centos/7' (v2004.01) for 'virtualbox'!

インストールされたBoxの存在確認。

>vagrant box list
centos/7 (virtualbox, 2004.01)

1 2	>vagrant box list centos/7 (virtualbox, 2004.01)

この時点でSSDの容量は141 /237GB free。

仮想環境のVagrant設定

ドライブ直下にVagrantディレクトリー、その下にCentOS7のディレクトリーを作成し、そこに移動。

>mkdir \vagrant
>cd \vagrant
>mkdir centos7
>cd centos7

>mkdir \vagrant

>cd \vagrant

>mkdir centos7

>cd centos7

移動後のディレクトリー内で初期設定。ここでこのディレクトリー内にvagrantfileが作成されて、仮想環境が利用可能になる。

C:\vagrant\centos7>vagrant init centos/7
A `Vagrantfile` has been placed in this directory. You are now
ready to `vagrant up` your first virtual environment! Please read
the comments in the Vagrantfile as well as documentation on
`vagrantup.com` for more information on using Vagrant.

C:\vagrant\centos7>vagrant init centos/7

A `Vagrantfile` has been placed in this directory. You are now

ready to `vagrant up` your first virtual environment! Please read

the comments in the Vagrantfile as well as documentation on

`vagrantup.com` for more information on using Vagrant.

この時点でSSD 141/237GB freeとなり、6～7GBを使っている。

仮想環境の利用

仮想環境の起動

vagrant upコマンドで仮想環境を起動。

vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Importing base box 'centos/7'...
==> default: Matching MAC address for NAT networking...
==> default: Checking if box 'centos/7' version '2004.01' is up to date...
==> default: Setting the name of the VM: centos7_default_1613521493035_2746
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
    default: Adapter 1: nat
==> default: Forwarding ports...
    default: 22 (guest) => 2222 (host) (adapter 1)
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
    default: SSH address: 127.0.0.1:2222
    default: SSH username: vagrant
    default: SSH auth method: private key
    default: Warning: Connection aborted. Retrying...
    default: Warning: Connection reset. Retrying...
    default:
    default: Vagrant insecure key detected. Vagrant will automatically replace
    default: this with a newly generated keypair for better security.
    default:
    default: Inserting generated public key within guest...
    default: Removing insecure key from the guest if it's present...
    default: Key inserted! Disconnecting and reconnecting using new SSH key...
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
    default: No guest additions were detected on the base box for this VM! Guest
    default: additions are required for forwarded ports, shared folders, host only
    default: networking, and more. If SSH fails on this machine, please install
    default: the guest additions and repackage the box to continue.
    default:
    default: This is not an error message; everything may continue to work properly,
    default: in which case you may ignore this message.
==> default: Rsyncing folder: /cygdrive/c/vagrant/centos7/ => /vagrant

vagrant up

Bringing machine 'default' up with 'virtualbox' provider...

==> default: Importing base box 'centos/7'...

==> default: Matching MAC address for NAT networking...

==> default: Checking if box 'centos/7' version '2004.01' is up to date...

==> default: Setting the name of the VM: centos7_default_1613521493035_2746

==> default: Clearing any previously set network interfaces...

==> default: Preparing network interfaces based on configuration...

default: Adapter 1: nat

==> default: Forwarding ports...

default: 22 (guest) => 2222 (host) (adapter 1)

==> default: Booting VM...

==> default: Waiting for machine to boot. This may take a few minutes...

default: SSH address: 127.0.0.1:2222

default: SSH username: vagrant

default: SSH auth method: private key

default: Warning: Connection aborted. Retrying...

default: Warning: Connection reset. Retrying...

default:

default: Vagrant insecure key detected. Vagrant will automatically replace

default: this with a newly generated keypair for better security.

default:

default: Inserting generated public key within guest...

default: Removing insecure key from the guest if it's present...

default: Key inserted! Disconnecting and reconnecting using new SSH key...

==> default: Machine booted and ready!

==> default: Checking for guest additions in VM...

default: No guest additions were detected on the base box for this VM! Guest

default: additions are required for forwarded ports, shared folders, host only

default: networking, and more. If SSH fails on this machine, please install

default: the guest additions and repackage the box to continue.

default:

default: This is not an error message; everything may continue to work properly,

default: in which case you may ignore this message.

==> default: Rsyncing folder: /cygdrive/c/vagrant/centos7/ => /vagrant

仮想環境へのログイン

現バージョンでは、Windowsでもvagrant sshで接続できた。

>vagrant ssh
[vagrant@localhost ~]$

1 2	>vagrant ssh [vagrant@localhost ~]$

バージョンを確認。

[vagrant@localhost ~]$ cat /etc/redhat-release
CentOS Linux release 7.8.2003 (Core)

1 2	[vagrant@localhost ~]$ cat /etc/redhat-release CentOS Linux release 7.8.2003 (Core)

実行中の仮想環境の確認

仮想マシンを立ち上げたコンソールとは別のコンソールを立ち上げ、vagrant statusで確認。

C:\vagrant\centos7>vagrant status
Current machine states:

default                   running (virtualbox)

The VM is running. To stop this VM, you can run `vagrant halt` to
shut it down forcefully, or you can run `vagrant suspend` to simply
suspend the virtual machine. In either case, to restart it again,
simply run `vagrant up`.

C:\vagrant\centos7>vagrant status

Current machine states:

default running (virtualbox)

The VM is running. To stop this VM, you can run `vagrant halt` to

shut it down forcefully, or you can run `vagrant suspend` to simply

suspend the virtual machine. In either case, to restart it again,

simply run `vagrant up`.

仮想環境からのログアウト

CentOSのexitコマンドでログアウト。

[vagrant@localhost ~]$ exit
logout
Connection to 127.0.0.1 closed.

[vagrant@localhost ~]$ exit

logout

Connection to 127.0.0.1 closed.

仮想環境の停止

Windowsプロンプトでvagran haltコマンドを実行して停止。

>vagrant halt
==> default: Attempting graceful shutdown of VM...

1 2	>vagrant halt ==> default: Attempting graceful shutdown of VM...

仮想環境停止の確認

停止後のWindows環境でvagrant statusを実行すると仮想環境の停止を確認できる。

>vagrant status
Current machine states:

default                   poweroff (virtualbox)

The VM is powered off. To restart the VM, simply run `vagrant up`

>vagrant status

Current machine states:

default poweroff (virtualbox)

The VM is powered off. To restart the VM, simply run `vagrant up`

MySQL – 日付・時刻のフォーマット

2021-02-23 / tau / コメントする

概要

日付、時刻のフォーマットにはDATE_FORMAT()、TIME_FORMAT()を使う。

DATE_FORMAT(date, format);

TIME_FORMAT(time, format);

date、timeにはDATETIME型の値を入れてもよい。

書式の雛形

以下のデータで日付・時刻の書式を確認する。

mysql> SELECT * FROM test_datetime;
+---------------------+
| datetime            |
+---------------------+
| 2020-12-31 23:59:59 |
| 2021-01-01 00:01:02 |
+---------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM test_datetime;

+---------------------+

| datetime |

+---------------------+

| 2020-12-31 23:59:59 |

| 2021-01-01 00:01:02 |

+---------------------+

2 rows in set (0.00 sec)

日付

日付4or2桁でゼロ埋め	`%Y %m %d`
日付ゼロ埋めなし	`%y %c %e`
月名(短縮／全部)	`%b / %M`
曜日名(番号／短縮／全部)	`%w / %a / %W`

※曜日番号は日曜～土曜が0～6

mysql> SELECT
    ->   DATE_FORMAT(datetime, '%Y年%m月%d日') AS '日付0埋め',
    ->   DATE_FORMAT(datetime, '%y年%c月%e日') AS '日付0なし',
    ->   DATE_FORMAT(datetime, '%b : %M') AS 月名,
    ->   DATE_FORMAT(datetime, '%w : %a : %W') AS 曜日
    -> FROM test_datetime;
+----------------+--------------+----------------+--------------------+
| 日付0埋め      | 日付0なし    | 月名           | 曜日               |
+----------------+--------------+----------------+--------------------+
| 2020年12月31日 | 20年12月31日 | Dec : December | 4 : Thu : Thursday |
| 2021年01月01日 | 21年1月1日   | Jan : January  | 5 : Fri : Friday   |
+----------------+--------------+----------------+--------------------+
2 rows in set (0.00 sec)

mysql> SELECT

-> DATE_FORMAT(datetime, '%Y年%m月%d日') AS '日付0埋め',

-> DATE_FORMAT(datetime, '%y年%c月%e日') AS '日付0なし',

-> DATE_FORMAT(datetime, '%b : %M') AS 月名,

-> DATE_FORMAT(datetime, '%w : %a : %W') AS 曜日

-> FROM test_datetime;

+----------------+--------------+----------------+--------------------+

| 日付0埋め | 日付0なし | 月名 | 曜日 |

+----------------+--------------+----------------+--------------------+

| 2020年12月31日 | 20年12月31日 | Dec : December | 4 : Thu : Thursday |

| 2021年01月01日 | 21年1月1日 | Jan : January | 5 : Fri : Friday |

+----------------+--------------+----------------+--------------------+

2 rows in set (0.00 sec)

時刻

24時間制の時刻(ゼロ埋め)	%H
24時間制の時刻(ゼロ埋めなし)	%k
12時間制の時刻	%h
分(ゼロ埋め)	%i
秒(ゼロ埋め)	%s
AM/PM	`%p`

※12時間制の時刻は0時／12時の扱いに一貫性がない。

mysql> SELECT
    ->   TIME_FORMAT(datetime, '%H時%i分%s秒') AS '0埋め24H',
    ->   TIME_FORMAT(datetime, '%k時%m分%s秒') AS '0なし24H',
    ->   TIME_FORMAT(datetime, '%h時%i分%S秒 %p') AS '0埋め12H',
    ->   TIME_FORMAT(datetime, '%l時%i分%S秒 %p') AS '0なし12H'
    -> FROM test_datetime;
+--------------+--------------+-----------------+-----------------+
| 0埋め24H     | 0なし24H     | 0埋め12H        | 0なし12H        |
+--------------+--------------+-----------------+-----------------+
| 23時59分59秒 | 23時00分59秒 | 11時59分59秒 PM | 11時59分59秒 PM |
| 00時01分02秒 | 0時00分02秒  | 12時01分02秒 AM | 12時01分02秒 AM |
+--------------+--------------+-----------------+-----------------+
2 rows in set (0.00 sec)

mysql> SELECT

-> TIME_FORMAT(datetime, '%H時%i分%s秒') AS '0埋め24H',

-> TIME_FORMAT(datetime, '%k時%m分%s秒') AS '0なし24H',

-> TIME_FORMAT(datetime, '%h時%i分%S秒 %p') AS '0埋め12H',

-> TIME_FORMAT(datetime, '%l時%i分%S秒 %p') AS '0なし12H'

-> FROM test_datetime;

+--------------+--------------+-----------------+-----------------+

| 0埋め24H | 0なし24H | 0埋め12H | 0なし12H |

+--------------+--------------+-----------------+-----------------+

| 23時59分59秒 | 23時00分59秒 | 11時59分59秒 PM | 11時59分59秒 PM |

| 00時01分02秒 | 0時00分02秒 | 12時01分02秒 AM | 12時01分02秒 AM |

+--------------+--------------+-----------------+-----------------+

2 rows in set (0.00 sec)

Vagrant -vagrantfile

2021-02-23 / tau / コメントする

初期状態

VagrantとvirtualBoxのCentOS7をインストールして初期実行後のvagrantfileの内容。ファイルはCentOS7の環境構築で指定したディレクトリー下にある。

# -*- mode: ruby -*-
# vi: set ft=ruby :

# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure("2") do |config|
  # The most common configuration options are documented and commented below.
  # For a complete reference, please see the online documentation at
  # https://docs.vagrantup.com.

  # Every Vagrant development environment requires a box. You can search for
  # boxes at https://vagrantcloud.com/search.
  config.vm.box = "bento/centos-7.7"

  # Disable automatic box update checking. If you disable this, then
  # boxes will only be checked for updates when the user runs
  # `vagrant box outdated`. This is not recommended.
  # config.vm.box_check_update = false

  # Create a forwarded port mapping which allows access to a specific port
  # within the machine from a port on the host machine. In the example below,
  # accessing "localhost:8080" will access port 80 on the guest machine.
  # NOTE: This will enable public access to the opened port
  # config.vm.network "forwarded_port", guest: 80, host: 8080

  # Create a forwarded port mapping which allows access to a specific port
  # within the machine from a port on the host machine and only allow access
  # via 127.0.0.1 to disable public access
  # config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"

  # Create a private network, which allows host-only access to the machine
  # using a specific IP.
  # config.vm.network "private_network", ip: "192.168.33.10"

  # Create a public network, which generally matched to bridged network.
  # Bridged networks make the machine appear as another physical device on
  # your network.
  # config.vm.network "public_network"

  # Share an additional folder to the guest VM. The first argument is
  # the path on the host to the actual folder. The second argument is
  # the path on the guest to mount the folder. And the optional third
  # argument is a set of non-required options.
  # config.vm.synced_folder "../data", "/vagrant_data"
  config.vm.synced_folder "./share", "/home/vagrant/share" # フォルダー共有のため追加

  # Provider-specific configuration so you can fine-tune various
  # backing providers for Vagrant. These expose provider-specific options.
  # Example for VirtualBox:
  #
  # config.vm.provider "virtualbox" do |vb|
  #   # Display the VirtualBox GUI when booting the machine
  #   vb.gui = true
  #
  #   # Customize the amount of memory on the VM:
  #   vb.memory = "1024"
  # end
  #
  # View the documentation for the provider you are using for more
  # information on available options.

  # Enable provisioning with a shell script. Additional provisioners such as
  # Ansible, Chef, Docker, Puppet and Salt are also available. Please see the
  # documentation for more information about their specific syntax and use.
  # config.vm.provision "shell", inline: <<-SHELL
  #   apt-get update
  #   apt-get install -y apache2
  # SHELL
end

# -*- mode: ruby -*-

# vi: set ft=ruby :

# All Vagrant configuration is done below. The "2" in Vagrant.configure

# configures the configuration version (we support older styles for

# backwards compatibility). Please don't change it unless you know what

# you're doing.

Vagrant.configure("2") do |config|

# The most common configuration options are documented and commented below.

# For a complete reference, please see the online documentation at

# https://docs.vagrantup.com.

# Every Vagrant development environment requires a box. You can search for

# boxes at https://vagrantcloud.com/search.

config.vm.box = "bento/centos-7.7"

# Disable automatic box update checking. If you disable this, then

# boxes will only be checked for updates when the user runs

# `vagrant box outdated`. This is not recommended.

# config.vm.box_check_update = false

# Create a forwarded port mapping which allows access to a specific port

# within the machine from a port on the host machine. In the example below,

# accessing "localhost:8080" will access port 80 on the guest machine.

# NOTE: This will enable public access to the opened port

# config.vm.network "forwarded_port", guest: 80, host: 8080

# Create a forwarded port mapping which allows access to a specific port

# within the machine from a port on the host machine and only allow access

# via 127.0.0.1 to disable public access

# config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"

# Create a private network, which allows host-only access to the machine

# using a specific IP.

# config.vm.network "private_network", ip: "192.168.33.10"

# Create a public network, which generally matched to bridged network.

# Bridged networks make the machine appear as another physical device on

# your network.

# config.vm.network "public_network"

# Share an additional folder to the guest VM. The first argument is

# the path on the host to the actual folder. The second argument is

# the path on the guest to mount the folder. And the optional third

# argument is a set of non-required options.

# config.vm.synced_folder "../data", "/vagrant_data"

config.vm.synced_folder "./share", "/home/vagrant/share" # フォルダー共有のため追加

# Provider-specific configuration so you can fine-tune various

# backing providers for Vagrant. These expose provider-specific options.

# Example for VirtualBox:

# config.vm.provider "virtualbox" do |vb|

# # Display the VirtualBox GUI when booting the machine

# vb.gui = true

# # Customize the amount of memory on the VM:

# vb.memory = "1024"

# end

# View the documentation for the provider you are using for more

# information on available options.

# Enable provisioning with a shell script. Additional provisioners such as

# Ansible, Chef, Docker, Puppet and Salt are also available. Please see the

# documentation for more information about their specific syntax and use.

# config.vm.provision "shell", inline: <<-SHELL

# apt-get update

# apt-get install -y apache2

# SHELL

end

実質的な内容は以下のとおり。

Vagrant.configure("2") do |config|
  config.vm.box = "centos/7"
end

Vagrant.configure("2") do |config|

config.vm.box = "centos/7"

end

Vagrant – メモリーとディスクの容量設定

2021-02-23 / tau / コメントする

準備

vagrantfile中、virtualBox設定の部分をコメントアウトし有効にする。

  config.vm.provider "virtualbox" do |vb|
  #   # Display the VirtualBox GUI when booting the machine
  #   vb.gui = true
  #
  #   # Customize the amount of memory on the VM:
  #   vb.memory = "1024"
  end

config.vm.provider "virtualbox" do |vb|

# # Display the VirtualBox GUI when booting the machine

# vb.gui = true

# # Customize the amount of memory on the VM:

# vb.memory = "1024"

end

メモリーの設定

メモリーの割り当て容量設定は、vagrantfileに1行書くか、コメントアウトされている以下の行のコメントを外して容量を書き換えるとよい。

  #   # Customize the amount of memory on the VM:
  #   vb.memory = "1024"

1 2	# # Customize the amount of memory on the VM: # vb.memory = "1024"

数値はMB単位のメモリー割当量で、上記は1024MB = 1GBを意味している。

ディスク容量の設定

仮想マシンのディスクに割り当てる容量を設定・変更する場合、プラグインをインストールした上でvagrantfileに1行追加する。

プラグインのインストール

ホスト側でvagrant-disksizeプラグインをインストールする。

>vagrant plugin install vagrant-disksize
Installing the 'vagrant-disksize' plugin. This can take a few minutes...
Fetching vagrant-disksize-0.1.3.gem
Installed the plugin 'vagrant-disksize (0.1.3)'!

>vagrant plugin install vagrant-disksize

Installing the 'vagrant-disksize' plugin. This can take a few minutes...

Fetching vagrant-disksize-0.1.3.gem

Installed the plugin 'vagrant-disksize (0.1.3)'!

vagrantfileへの追加

以下の1行をvagrantfileに追加する(***に割り当てる容量をGB単位で指定)。

config.disksize.size = "***GB"

    config.disksize.size = "50GB"

1	config.disksize.size = "50GB"

設定の反映

メモリー／ディスクの設定をvagrantfileに書いた後、vagrantを起動／再起動する。

メモリーとディスクの容量のみ設定したvagrantfileの有効部分は以下のようになる。

Vagrant.configure("2") do |config|
  config.vm.provider "virtualbox" do |vb|
    vb.memory = "2048"
    config.disksize.size = "50GB"
  end
end

Vagrant.configure("2") do |config|

config.vm.provider "virtualbox" do |vb|

vb.memory = "2048"

config.disksize.size = "50GB"

end

メモリー容量の確認

[vagrant@localhost ~]$ free m
              total        used        free      shared  buff/cache   available
Mem:        1882092       94880     1590960        8632      196252     1639440
Swap:       2097148           0     2097148

[vagrant@localhost ~]$ free m

total used free shared buff/cache available

Mem: 1882092 94880 1590960 8632 196252 1639440

Swap: 2097148 0 2097148

ディスク容量の確認

[vagrant@localhost ~]$ df -h
Filesystem      Size  Used Avail Use% Mounted on
devtmpfs        912M     0  912M   0% /dev
tmpfs           919M     0  919M   0% /dev/shm
tmpfs           919M  8.5M  911M   1% /run
tmpfs           919M     0  919M   0% /sys/fs/cgroup
/dev/sda1        40G  3.2G   37G   8% /
tmpfs           184M     0  184M   0% /run/user/1000

[vagrant@localhost ~]$ df -h

Filesystem Size Used Avail Use% Mounted on

devtmpfs 912M 0 912M 0% /dev

tmpfs 919M 0 919M 0% /dev/shm

tmpfs 919M 8.5M 911M 1% /run

tmpfs 919M 0 919M 0% /sys/fs/cgroup

/dev/sda1 40G 3.2G 37G 8% /

tmpfs 184M 0 184M 0% /run/user/1000

MySQL – DISTINCTによる重複の排除

2021-02-23 / tau / コメントする

概要

DISTINCTはフィールドの重複を除いた結果を返す。

確認に使用するデータ

以下のデータを使う。日時ごとのパスタのメニューの注文票で、パスタはソースと麺の種類の組み合わせ。

mysql> SELECT * FROM pasta_order;
+---------------------+----------+----------------+-------+
| order_time          | source   | pasta          | price |
+---------------------+----------+----------------+-------+
| 2021-02-01 10:30:00 | トマト   | スパゲッティー |   900 |
| 2021-02-01 11:30:00 | トマト   | フィットチーネ |   900 |
| 2021-02-01 12:00:00 | オイル   | スパゲッティー |   800 |
| 2021-02-01 12:30:00 | クリーム | リングイネ     |   850 |
| 2021-02-01 13:00:00 | トマト   | リングイネ     |   900 |
| 2021-02-02 11:00:00 | トマト   | スパゲッティー |   900 |
| 2021-02-02 12:00:00 | クリーム | スパゲッティー |   850 |
| 2021-02-02 12:30:00 | トマト   | リングイネ     |   900 |
| 2021-02-02 13:00:00 | トマト   | スパゲッティー |   900 |
| 2021-02-03 10:30:00 | クリーム | スパゲッティー |   850 |
| 2021-02-03 11:00:00 | オイル   | スパゲッティー |   800 |
| 2021-02-03 11:30:00 | オイル   | フィットチーネ |   800 |
| 2021-02-03 12:00:00 | クリーム | リングイネ     |   850 |
| 2021-02-03 12:30:00 | トマト   | フィットチーネ |   900 |
| 2021-02-03 13:00:00 | オイル   | スパゲッティー |   800 |
+---------------------+----------+----------------+-------+
15 rows in set (0.00 sec)

mysql> SELECT * FROM pasta_order;

+---------------------+----------+----------------+-------+

+---------------------+----------+----------------+-------+

| 2021-02-01 10:30:00 | トマト | スパゲッティー | 900 |

| 2021-02-01 11:30:00 | トマト | フィットチーネ | 900 |

| 2021-02-01 12:00:00 | オイル | スパゲッティー | 800 |

| 2021-02-01 12:30:00 | クリーム | リングイネ | 850 |

| 2021-02-01 13:00:00 | トマト | リングイネ | 900 |

| 2021-02-02 11:00:00 | トマト | スパゲッティー | 900 |

| 2021-02-02 12:00:00 | クリーム | スパゲッティー | 850 |

| 2021-02-02 12:30:00 | トマト | リングイネ | 900 |

| 2021-02-02 13:00:00 | トマト | スパゲッティー | 900 |

| 2021-02-03 10:30:00 | クリーム | スパゲッティー | 850 |

| 2021-02-03 11:00:00 | オイル | スパゲッティー | 800 |

| 2021-02-03 11:30:00 | オイル | フィットチーネ | 800 |

| 2021-02-03 12:00:00 | クリーム | リングイネ | 850 |

| 2021-02-03 12:30:00 | トマト | フィットチーネ | 900 |

| 2021-02-03 13:00:00 | オイル | スパゲッティー | 800 |

+---------------------+----------+----------------+-------+

15 rows in set (0.00 sec)

フィールドの重複を除いた抽出

まずソース、麺それぞれのフィールドから重複を除いた結果を抽出。ソースの種類、麺の種類は3種類のため、それぞれ3つのレコードが返される。

mysql> SELECT
    ->   DISTINCT source
    -> FROM pasta_order;
+----------+
| source   |
+----------+
| トマト   |
| オイル   |
| クリーム |
+----------+
3 rows in set (0.00 sec)

mysql> SELECT
    ->   DISTINCT pasta
    -> FROM pasta_order;
+----------------+
| pasta          |
+----------------+
| スパゲッティー |
| フィットチーネ |
| リングイネ     |
+----------------+
3 rows in set (0.00 sec)

mysql> SELECT

-> DISTINCT source

-> FROM pasta_order;

+----------+

| source |

+----------+

| トマト |

| オイル |

| クリーム |

+----------+

3 rows in set (0.00 sec)

mysql> SELECT

-> DISTINCT pasta

-> FROM pasta_order;

+----------------+

| pasta |

+----------------+

| スパゲッティー |

| フィットチーネ |

| リングイネ |

+----------------+

3 rows in set (0.00 sec)

日付による集計

日付単位の表示

DATETIMEで登録されているフィールドを日付のみの表現に変更する。その結果、同じ日付で複数のソースと麺の組み合わせのレコードになる。

mysql> SELECT
    ->   DATE_FORMAT(order_time, '%Y-%m-%d') AS date,
    ->   source,
    ->   pasta
    -> FROM pasta_order;
+------------+----------+----------------+
| date       | source   | pasta          |
+------------+----------+----------------+
| 2021-02-01 | トマト   | スパゲッティー |
| 2021-02-01 | トマト   | フィットチーネ |
| 2021-02-01 | オイル   | スパゲッティー |
| 2021-02-01 | クリーム | リングイネ     |
| 2021-02-01 | トマト   | リングイネ     |
| 2021-02-02 | トマト   | スパゲッティー |
| 2021-02-02 | クリーム | スパゲッティー |
| 2021-02-02 | トマト   | リングイネ     |
| 2021-02-02 | トマト   | スパゲッティー |
| 2021-02-03 | クリーム | スパゲッティー |
| 2021-02-03 | オイル   | スパゲッティー |
| 2021-02-03 | オイル   | フィットチーネ |
| 2021-02-03 | クリーム | リングイネ     |
| 2021-02-03 | トマト   | フィットチーネ |
| 2021-02-03 | オイル   | スパゲッティー |
+------------+----------+----------------+
15 rows in set (0.00 sec)

mysql> SELECT

-> DATE_FORMAT(order_time, '%Y-%m-%d') AS date,

-> source,

-> pasta

-> FROM pasta_order;

+------------+----------+----------------+

| date | source | pasta |

+------------+----------+----------------+

| 2021-02-01 | トマト | スパゲッティー |

| 2021-02-01 | トマト | フィットチーネ |

| 2021-02-01 | オイル | スパゲッティー |

| 2021-02-01 | クリーム | リングイネ |

| 2021-02-01 | トマト | リングイネ |

| 2021-02-02 | トマト | スパゲッティー |

| 2021-02-02 | クリーム | スパゲッティー |

| 2021-02-02 | トマト | リングイネ |

| 2021-02-02 | トマト | スパゲッティー |

| 2021-02-03 | クリーム | スパゲッティー |

| 2021-02-03 | オイル | スパゲッティー |

| 2021-02-03 | オイル | フィットチーネ |

| 2021-02-03 | クリーム | リングイネ |

| 2021-02-03 | トマト | フィットチーネ |

| 2021-02-03 | オイル | スパゲッティー |

+------------+----------+----------------+

15 rows in set (0.00 sec)

日付ごとのユニークデータの数

単一のフィールド

単一フィールド中のユニークなデータの数は以下のようにしてカウントする。

COUNT(DISTINCT col)

以下は、日付ごとにグルーピングし、各日付で重複を除いたソースの数をカウントしている。2/2はクリームとトマトの2種類だけというのが反映されている。

mysql> SELECT
    ->   DATE_FORMAT(order_time, '%Y-%m-%d') AS date,
    ->   COUNT(DISTINCT source)
    -> FROM pasta_order
    -> GROUP BY date;
+------------+------------------------+
| date       | COUNT(DISTINCT source) |
+------------+------------------------+
| 2021-02-01 |                      3 |
| 2021-02-02 |                      2 |
| 2021-02-03 |                      3 |
+------------+------------------------+
3 rows in set (0.00 sec)

mysql> SELECT

-> DATE_FORMAT(order_time, '%Y-%m-%d') AS date,

-> COUNT(DISTINCT source)

-> FROM pasta_order

-> GROUP BY date;

+------------+------------------------+

| date | COUNT(DISTINCT source) |

+------------+------------------------+

| 2021-02-01 | 3 |

| 2021-02-02 | 2 |

| 2021-02-03 | 3 |

+------------+------------------------+

3 rows in set (0.00 sec)

また、日付ごとの麺の種類の数もカウントしてみる。2/2がスパゲッティーとリングイネの2種類になっている。

mysql> SELECT
    ->   DATE_FORMAT(order_time, '%Y-%m-%d') AS date,
    ->   COUNT(DISTINCT pasta)
    -> FROM pasta_order
    -> GROUP BY date;
+------------+-----------------------+
| date       | COUNT(DISTINCT pasta) |
+------------+-----------------------+
| 2021-02-01 |                     3 |
| 2021-02-02 |                     2 |
| 2021-02-03 |                     3 |
+------------+-----------------------+
3 rows in set (0.00 sec)

mysql> SELECT

-> DATE_FORMAT(order_time, '%Y-%m-%d') AS date,

-> COUNT(DISTINCT pasta)

-> FROM pasta_order

-> GROUP BY date;

+------------+-----------------------+

| date | COUNT(DISTINCT pasta) |

+------------+-----------------------+

| 2021-02-01 | 3 |

| 2021-02-02 | 2 |

| 2021-02-03 | 3 |

+------------+-----------------------+

3 rows in set (0.00 sec)

複数フィールド

複数フィールドの組み合わせがユニークなものの数のカウントは以下のようにする。

COUNT(DISTINCT CONCAT(col1, col2, ...))

以下の例では、ソースとパスタの組み合わせがユニークなものの数を日付ごとに集計する。2/2はトマトスパゲッティーが2回、2/3はオイルスパゲッティーがあり、重複を除いてカウントしている。

mysql> SELECT
    ->   DATE_FORMAT(order_time, '%Y-%m-%d') AS date,
    ->   COUNT(DISTINCT CONCAT(source, pasta))
    -> FROM pasta_order
    -> GROUP BY date;
+------------+---------------------------------------+
| date       | COUNT(DISTINCT CONCAT(source, pasta)) |
+------------+---------------------------------------+
| 2021-02-01 |                                     5 |
| 2021-02-02 |                                     3 |
| 2021-02-03 |                                     5 |
+------------+---------------------------------------+
3 rows in set (0.00 sec)

mysql> SELECT

-> DATE_FORMAT(order_time, '%Y-%m-%d') AS date,

-> COUNT(DISTINCT CONCAT(source, pasta))

-> FROM pasta_order

-> GROUP BY date;

+------------+---------------------------------------+

| date | COUNT(DISTINCT CONCAT(source, pasta)) |

+------------+---------------------------------------+

| 2021-02-01 | 5 |

| 2021-02-02 | 3 |

| 2021-02-03 | 5 |

+------------+---------------------------------------+

3 rows in set (0.00 sec)