Linux入門 MariaDBインストール

WordPressを利用するにはデータベースが必要だにょろ

データベースは知らないけど、キャットベースで遊ぶのは楽しいにゃ

それも関係ないにょろ!


データベースとはデータの集まりです。
サーバの中で効率的にデータを管理するため、データベースを利用します。
そのデータベースを管理するためのソフトウェアをデータベース管理システムと呼びますが、日常的にはソフトウェアの事もデータベースと呼んでいます。

WordPressを利用するにはデータベースが必要になりますので、ここでは、MariaDB(マリアデービー)というデータベースソフトをインストールします。

MariaDB(マリアデービー)とは
MySQLから派生したデータベース管理システムです。
MySQLがOracleに買収されて以降、代替として利用されることが多くなりました。

1.MariaDBをインストールします。

[root@wordpress chatora]#  dnf install -y mariadb-server
Last metadata expiration check: 2:30:01 ago on Mon 23 Nov 2020 10:43:01 AM UTC.
Dependencies resolved.
================================================================================
 Package                    Arch   Version                      Repo       Size
================================================================================
Installing:
 mariadb-server             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream  16 M
Installing dependencies:
 libaio                     x86_64 0.3.112-1.el8                BaseOS     33 k
 mariadb                    x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 6.1 M
 mariadb-common             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream  62 k
 mariadb-connector-c        x86_64 3.0.7-1.el8                  AppStream 148 k
 mariadb-connector-c-config noarch 3.0.7-1.el8                  AppStream  13 k
 mariadb-errmsg             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 232 k
 perl-Carp                  noarch 1.42-396.el8                 BaseOS     30 k
 perl-DBD-MySQL             x86_64 4.046-3.module_el8.1.0+203+e45423dc
                                                                AppStream 156 k
 perl-DBI                   x86_64 1.641-3.module_el8.1.0+199+8f0a6bbd
                                                                AppStream 740 k
 perl-Data-Dumper           x86_64 2.167-399.el8                BaseOS     58 k
 perl-Digest                noarch 1.17-395.el8                 AppStream  27 k
 perl-Digest-MD5            x86_64 2.55-396.el8                 AppStream  37 k
 perl-Encode                x86_64 4:2.97-3.el8                 BaseOS    1.5 M
 perl-Errno                 x86_64 1.28-416.el8                 BaseOS     76 k
 perl-Exporter              noarch 5.72-396.el8                 BaseOS     34 k
 perl-File-Path             noarch 2.15-2.el8                   BaseOS     38 k
 perl-File-Temp             noarch 0.230.600-1.el8              BaseOS     63 k
 perl-Getopt-Long           noarch 1:2.50-4.el8                 BaseOS     63 k
 perl-HTTP-Tiny             noarch 0.074-1.el8                  BaseOS     58 k
 perl-IO                    x86_64 1.38-416.el8                 BaseOS    141 k
 perl-MIME-Base64           x86_64 3.15-396.el8                 BaseOS     31 k
 perl-Math-BigInt           noarch 1:1.9998.11-7.el8            BaseOS    196 k
 perl-Math-Complex          noarch 1.59-416.el8                 BaseOS    108 k
 perl-Net-SSLeay            x86_64 1.88-1.el8                   AppStream 379 k
 perl-PathTools             x86_64 3.74-1.el8                   BaseOS     90 k
 perl-Pod-Escapes           noarch 1:1.07-395.el8               BaseOS     20 k
 perl-Pod-Perldoc           noarch 3.28-396.el8                 BaseOS     86 k
 perl-Pod-Simple            noarch 1:3.35-395.el8               BaseOS    213 k
 perl-Pod-Usage             noarch 4:1.69-395.el8               BaseOS     34 k
 perl-Scalar-List-Utils     x86_64 3:1.49-2.el8                 BaseOS     68 k
 perl-Socket                x86_64 4:2.027-3.el8                BaseOS     59 k
 perl-Storable              x86_64 1:3.11-3.el8                 BaseOS     98 k
 perl-Term-ANSIColor        noarch 4.06-396.el8                 BaseOS     46 k
 perl-Term-Cap              noarch 1.17-395.el8                 BaseOS     23 k
 perl-Text-ParseWords       noarch 3.30-395.el8                 BaseOS     18 k
 perl-Text-Tabs+Wrap        noarch 2013.0523-395.el8            BaseOS     24 k
 perl-Time-Local            noarch 1:1.280-1.el8                BaseOS     34 k
 perl-URI                   noarch 1.73-3.el8                   AppStream 116 k
 perl-Unicode-Normalize     x86_64 1.25-396.el8                 BaseOS     82 k
 perl-constant              noarch 1.33-396.el8                 BaseOS     25 k
 perl-interpreter           x86_64 4:5.26.3-416.el8             BaseOS    6.3 M
 perl-libnet                noarch 3.11-3.el8                   AppStream 121 k
 perl-libs                  x86_64 4:5.26.3-416.el8             BaseOS    1.6 M
 perl-macros                x86_64 4:5.26.3-416.el8             BaseOS     72 k
 perl-parent                noarch 1:0.237-1.el8                BaseOS     20 k
 perl-podlators             noarch 4.11-1.el8                   BaseOS    118 k
 perl-threads               x86_64 1:2.21-2.el8                 BaseOS     61 k
 perl-threads-shared        x86_64 1.58-2.el8                   BaseOS     48 k
 psmisc                     x86_64 23.1-4.el8                   BaseOS    150 k
Installing weak dependencies:
 mariadb-backup             x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 6.0 M
 mariadb-gssapi-server      x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream  49 k
 mariadb-server-utils       x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
                                                                AppStream 1.6 M
 perl-IO-Socket-IP          noarch 0.39-5.el8                   AppStream  47 k
 perl-IO-Socket-SSL         noarch 2.066-4.el8                  AppStream 297 k
 perl-Mozilla-CA            noarch 20160104-7.el8               AppStream  15 k
Enabling module streams:
 mariadb                           10.3
 perl                              5.26
 perl-DBD-MySQL                    4.046
 perl-DBI                          1.641

Transaction Summary
================================================================================
Install  56 Packages

Total download size: 44 M
Installed size: 209 M
Downloading Packages:
(1/56): mariadb-common-10.3.17-1.module_el8.1.0 246 kB/s |  62 kB     00:00
(2/56): mariadb-connector-c-3.0.7-1.el8.x86_64. 1.2 MB/s | 148 kB     00:00
(3/56): mariadb-connector-c-config-3.0.7-1.el8. 231 kB/s |  13 kB     00:00
(4/56): mariadb-errmsg-10.3.17-1.module_el8.1.0 1.9 MB/s | 232 kB     00:00
(5/56): mariadb-gssapi-server-10.3.17-1.module_ 835 kB/s |  49 kB     00:00
(6/56): mariadb-10.3.17-1.module_el8.1.0+257+48 8.7 MB/s | 6.1 MB     00:00
(7/56): mariadb-backup-10.3.17-1.module_el8.1.0 8.3 MB/s | 6.0 MB     00:00
(8/56): mariadb-server-utils-10.3.17-1.module_e  20 MB/s | 1.6 MB     00:00
(9/56): perl-DBD-MySQL-4.046-3.module_el8.1.0+2 2.4 MB/s | 156 kB     00:00
(10/56): perl-DBI-1.641-3.module_el8.1.0+199+8f  10 MB/s | 740 kB     00:00
(11/56): perl-Digest-1.17-395.el8.noarch.rpm    439 kB/s |  27 kB     00:00
(12/56): perl-Digest-MD5-2.55-396.el8.x86_64.rp 617 kB/s |  37 kB     00:00
(13/56): perl-IO-Socket-IP-0.39-5.el8.noarch.rp 759 kB/s |  47 kB     00:00
(14/56): perl-IO-Socket-SSL-2.066-4.el8.noarch. 4.5 MB/s | 297 kB     00:00
(15/56): perl-Mozilla-CA-20160104-7.el8.noarch. 247 kB/s |  15 kB     00:00
(16/56): perl-URI-1.73-3.el8.noarch.rpm         1.8 MB/s | 116 kB     00:00
(17/56): perl-Net-SSLeay-1.88-1.el8.x86_64.rpm  5.0 MB/s | 379 kB     00:00
(18/56): perl-libnet-3.11-3.el8.noarch.rpm      1.9 MB/s | 121 kB     00:00
(19/56): libaio-0.3.112-1.el8.x86_64.rpm        552 kB/s |  33 kB     00:00
(20/56): perl-Carp-1.42-396.el8.noarch.rpm      496 kB/s |  30 kB     00:00
(21/56): perl-Data-Dumper-2.167-399.el8.x86_64. 974 kB/s |  58 kB     00:00
(22/56): perl-Errno-1.28-416.el8.x86_64.rpm     1.2 MB/s |  76 kB     00:00
(23/56): perl-Encode-2.97-3.el8.x86_64.rpm       19 MB/s | 1.5 MB     00:00
(24/56): mariadb-server-10.3.17-1.module_el8.1.  23 MB/s |  16 MB     00:00
(25/56): perl-Exporter-5.72-396.el8.noarch.rpm  449 kB/s |  34 kB     00:00
(26/56): perl-File-Path-2.15-2.el8.noarch.rpm   616 kB/s |  38 kB     00:00
(27/56): perl-File-Temp-0.230.600-1.el8.noarch. 1.0 MB/s |  63 kB     00:00
(28/56): perl-Getopt-Long-2.50-4.el8.noarch.rpm 1.0 MB/s |  63 kB     00:00
(29/56): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm  948 kB/s |  58 kB     00:00
(30/56): perl-IO-1.38-416.el8.x86_64.rpm        2.3 MB/s | 141 kB     00:00
(31/56): perl-MIME-Base64-3.15-396.el8.x86_64.r 519 kB/s |  31 kB     00:00
(32/56): perl-Math-BigInt-1.9998.11-7.el8.noarc 3.0 MB/s | 196 kB     00:00
(33/56): perl-Math-Complex-1.59-416.el8.noarch. 1.8 MB/s | 108 kB     00:00
(34/56): perl-PathTools-3.74-1.el8.x86_64.rpm   1.5 MB/s |  90 kB     00:00
(35/56): perl-Pod-Escapes-1.07-395.el8.noarch.r 338 kB/s |  20 kB     00:00
(36/56): perl-Pod-Perldoc-3.28-396.el8.noarch.r 1.4 MB/s |  86 kB     00:00
(37/56): perl-Pod-Simple-3.35-395.el8.noarch.rp 3.4 MB/s | 213 kB     00:00
(38/56): perl-Pod-Usage-1.69-395.el8.noarch.rpm 566 kB/s |  34 kB     00:00
(39/56): perl-Scalar-List-Utils-1.49-2.el8.x86_ 1.1 MB/s |  68 kB     00:00
(40/56): perl-Socket-2.027-3.el8.x86_64.rpm     987 kB/s |  59 kB     00:00
(41/56): perl-Storable-3.11-3.el8.x86_64.rpm    1.6 MB/s |  98 kB     00:00
(42/56): perl-Term-ANSIColor-4.06-396.el8.noarc 790 kB/s |  46 kB     00:00
(43/56): perl-Term-Cap-1.17-395.el8.noarch.rpm  386 kB/s |  23 kB     00:00
(44/56): perl-Text-ParseWords-3.30-395.el8.noar 295 kB/s |  18 kB     00:00
(45/56): perl-Text-Tabs+Wrap-2013.0523-395.el8. 415 kB/s |  24 kB     00:00
(46/56): perl-Time-Local-1.280-1.el8.noarch.rpm 567 kB/s |  34 kB     00:00
(47/56): perl-Unicode-Normalize-1.25-396.el8.x8 1.3 MB/s |  82 kB     00:00
(48/56): perl-constant-1.33-396.el8.noarch.rpm  434 kB/s |  25 kB     00:00
(49/56): perl-libs-5.26.3-416.el8.x86_64.rpm     18 MB/s | 1.6 MB     00:00
(50/56): perl-macros-5.26.3-416.el8.x86_64.rpm  1.2 MB/s |  72 kB     00:00
(51/56): perl-parent-0.237-1.el8.noarch.rpm     306 kB/s |  20 kB     00:00
(52/56): perl-podlators-4.11-1.el8.noarch.rpm   2.0 MB/s | 118 kB     00:00
(53/56): perl-threads-2.21-2.el8.x86_64.rpm     1.0 MB/s |  61 kB     00:00
(54/56): perl-threads-shared-1.58-2.el8.x86_64. 816 kB/s |  48 kB     00:00
(55/56): perl-interpreter-5.26.3-416.el8.x86_64  24 MB/s | 6.3 MB     00:00
(56/56): psmisc-23.1-4.el8.x86_64.rpm           2.4 MB/s | 150 kB     00:00
--------------------------------------------------------------------------------
Total                                            19 MB/s |  44 MB     00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Running scriptlet: mariadb-connector-c-3.0.7-1.el8.x86_64                 1/1
  Preparing        :                                                        1/1
  Installing       : perl-Exporter-5.72-396.el8.noarch                     1/56
  Installing       : perl-libs-4:5.26.3-416.el8.x86_64                     2/56
  Installing       : perl-Carp-1.42-396.el8.noarch                         3/56
  Installing       : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64            4/56
  Installing       : perl-parent-1:0.237-1.el8.noarch                      5/56
  Installing       : mariadb-connector-c-config-3.0.7-1.el8.noarch         6/56
  Installing       : mariadb-common-3:10.3.17-1.module_el8.1.0+257+4873    7/56
  Installing       : mariadb-connector-c-3.0.7-1.el8.x86_64                8/56
  Installing       : perl-Text-ParseWords-3.30-395.el8.noarch              9/56
  Installing       : libaio-0.3.112-1.el8.x86_64                          10/56
  Installing       : mariadb-errmsg-3:10.3.17-1.module_el8.1.0+257+4873   11/56
  Installing       : perl-Term-ANSIColor-4.06-396.el8.noarch              12/56
  Installing       : perl-macros-4:5.26.3-416.el8.x86_64                  13/56
  Installing       : perl-Errno-1.28-416.el8.x86_64                       14/56
  Installing       : perl-Socket-4:2.027-3.el8.x86_64                     15/56
  Installing       : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         16/56
  Installing       : perl-Unicode-Normalize-1.25-396.el8.x86_64           17/56
  Installing       : perl-File-Path-2.15-2.el8.noarch                     18/56
  Installing       : perl-IO-1.38-416.el8.x86_64                          19/56
  Installing       : perl-PathTools-3.74-1.el8.x86_64                     20/56
  Installing       : perl-constant-1.33-396.el8.noarch                    21/56
  Installing       : perl-threads-1:2.21-2.el8.x86_64                     22/56
  Installing       : perl-threads-shared-1.58-2.el8.x86_64                23/56
  Installing       : perl-interpreter-4:5.26.3-416.el8.x86_64             24/56
  Installing       : perl-MIME-Base64-3.15-396.el8.x86_64                 25/56
  Installing       : perl-IO-Socket-IP-0.39-5.el8.noarch                  26/56
  Installing       : perl-Data-Dumper-2.167-399.el8.x86_64                27/56
  Installing       : perl-File-Temp-0.230.600-1.el8.noarch                28/56
  Installing       : perl-Storable-1:3.11-3.el8.x86_64                    29/56
  Installing       : perl-Time-Local-1:1.280-1.el8.noarch                 30/56
  Installing       : perl-Digest-1.17-395.el8.noarch                      31/56
  Installing       : perl-Digest-MD5-2.55-396.el8.x86_64                  32/56
  Installing       : perl-Net-SSLeay-1.88-1.el8.x86_64                    33/56
  Installing       : perl-Math-Complex-1.59-416.el8.noarch                34/56
  Installing       : perl-Math-BigInt-1:1.9998.11-7.el8.noarch            35/56
  Installing       : perl-Pod-Escapes-1:1.07-395.el8.noarch               36/56
  Installing       : perl-Term-Cap-1.17-395.el8.noarch                    37/56
  Installing       : perl-Mozilla-CA-20160104-7.el8.noarch                38/56
  Installing       : perl-Encode-4:2.97-3.el8.x86_64                      39/56
  Installing       : perl-Pod-Simple-1:3.35-395.el8.noarch                40/56
  Installing       : perl-Getopt-Long-1:2.50-4.el8.noarch                 41/56
  Installing       : perl-podlators-4.11-1.el8.noarch                     42/56
  Installing       : perl-Pod-Usage-4:1.69-395.el8.noarch                 43/56
  Installing       : perl-Pod-Perldoc-3.28-396.el8.noarch                 44/56
  Installing       : perl-HTTP-Tiny-0.074-1.el8.noarch                    45/56
  Installing       : perl-IO-Socket-SSL-2.066-4.el8.noarch                46/56
  Installing       : perl-libnet-3.11-3.el8.noarch                        47/56
  Installing       : perl-URI-1.73-3.el8.noarch                           48/56
  Installing       : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6   49/56
  Installing       : perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc   50/56
  Installing       : psmisc-23.1-4.el8.x86_64                             51/56
  Installing       : mariadb-backup-3:10.3.17-1.module_el8.1.0+257+4873   52/56
  Installing       : mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+2   53/56
  Installing       : mariadb-server-utils-3:10.3.17-1.module_el8.1.0+25   54/56
  Running scriptlet: mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Installing       : mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Running scriptlet: mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873   55/56
  Installing       : mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8   56/56
  Running scriptlet: mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8   56/56
  Verifying        : mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x8    1/56
  Verifying        : mariadb-backup-3:10.3.17-1.module_el8.1.0+257+4873    2/56
  Verifying        : mariadb-common-3:10.3.17-1.module_el8.1.0+257+4873    3/56
  Verifying        : mariadb-connector-c-3.0.7-1.el8.x86_64                4/56
  Verifying        : mariadb-connector-c-config-3.0.7-1.el8.noarch         5/56
  Verifying        : mariadb-errmsg-3:10.3.17-1.module_el8.1.0+257+4873    6/56
  Verifying        : mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+2    7/56
  Verifying        : mariadb-server-3:10.3.17-1.module_el8.1.0+257+4873    8/56
  Verifying        : mariadb-server-utils-3:10.3.17-1.module_el8.1.0+25    9/56
  Verifying        : perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc   10/56
  Verifying        : perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_6   11/56
  Verifying        : perl-Digest-1.17-395.el8.noarch                      12/56
  Verifying        : perl-Digest-MD5-2.55-396.el8.x86_64                  13/56
  Verifying        : perl-IO-Socket-IP-0.39-5.el8.noarch                  14/56
  Verifying        : perl-IO-Socket-SSL-2.066-4.el8.noarch                15/56
  Verifying        : perl-Mozilla-CA-20160104-7.el8.noarch                16/56
  Verifying        : perl-Net-SSLeay-1.88-1.el8.x86_64                    17/56
  Verifying        : perl-URI-1.73-3.el8.noarch                           18/56
  Verifying        : perl-libnet-3.11-3.el8.noarch                        19/56
  Verifying        : libaio-0.3.112-1.el8.x86_64                          20/56
  Verifying        : perl-Carp-1.42-396.el8.noarch                        21/56
  Verifying        : perl-Data-Dumper-2.167-399.el8.x86_64                22/56
  Verifying        : perl-Encode-4:2.97-3.el8.x86_64                      23/56
  Verifying        : perl-Errno-1.28-416.el8.x86_64                       24/56
  Verifying        : perl-Exporter-5.72-396.el8.noarch                    25/56
  Verifying        : perl-File-Path-2.15-2.el8.noarch                     26/56
  Verifying        : perl-File-Temp-0.230.600-1.el8.noarch                27/56
  Verifying        : perl-Getopt-Long-1:2.50-4.el8.noarch                 28/56
  Verifying        : perl-HTTP-Tiny-0.074-1.el8.noarch                    29/56
  Verifying        : perl-IO-1.38-416.el8.x86_64                          30/56
  Verifying        : perl-MIME-Base64-3.15-396.el8.x86_64                 31/56
  Verifying        : perl-Math-BigInt-1:1.9998.11-7.el8.noarch            32/56
  Verifying        : perl-Math-Complex-1.59-416.el8.noarch                33/56
  Verifying        : perl-PathTools-3.74-1.el8.x86_64                     34/56
  Verifying        : perl-Pod-Escapes-1:1.07-395.el8.noarch               35/56
  Verifying        : perl-Pod-Perldoc-3.28-396.el8.noarch                 36/56
  Verifying        : perl-Pod-Simple-1:3.35-395.el8.noarch                37/56
  Verifying        : perl-Pod-Usage-4:1.69-395.el8.noarch                 38/56
  Verifying        : perl-Scalar-List-Utils-3:1.49-2.el8.x86_64           39/56
  Verifying        : perl-Socket-4:2.027-3.el8.x86_64                     40/56
  Verifying        : perl-Storable-1:3.11-3.el8.x86_64                    41/56
  Verifying        : perl-Term-ANSIColor-4.06-396.el8.noarch              42/56
  Verifying        : perl-Term-Cap-1.17-395.el8.noarch                    43/56
  Verifying        : perl-Text-ParseWords-3.30-395.el8.noarch             44/56
  Verifying        : perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch         45/56
  Verifying        : perl-Time-Local-1:1.280-1.el8.noarch                 46/56
  Verifying        : perl-Unicode-Normalize-1.25-396.el8.x86_64           47/56
  Verifying        : perl-constant-1.33-396.el8.noarch                    48/56
  Verifying        : perl-interpreter-4:5.26.3-416.el8.x86_64             49/56
  Verifying        : perl-libs-4:5.26.3-416.el8.x86_64                    50/56
  Verifying        : perl-macros-4:5.26.3-416.el8.x86_64                  51/56
  Verifying        : perl-parent-1:0.237-1.el8.noarch                     52/56
  Verifying        : perl-podlators-4.11-1.el8.noarch                     53/56
  Verifying        : perl-threads-1:2.21-2.el8.x86_64                     54/56
  Verifying        : perl-threads-shared-1.58-2.el8.x86_64                55/56
  Verifying        : psmisc-23.1-4.el8.x86_64                             56/56

Installed:
  libaio-0.3.112-1.el8.x86_64
  mariadb-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-backup-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-common-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-connector-c-3.0.7-1.el8.x86_64
  mariadb-connector-c-config-3.0.7-1.el8.noarch
  mariadb-errmsg-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-gssapi-server-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-server-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  mariadb-server-utils-3:10.3.17-1.module_el8.1.0+257+48736ea6.x86_64
  perl-Carp-1.42-396.el8.noarch
  perl-DBD-MySQL-4.046-3.module_el8.1.0+203+e45423dc.x86_64
  perl-DBI-1.641-3.module_el8.1.0+199+8f0a6bbd.x86_64
  perl-Data-Dumper-2.167-399.el8.x86_64
  perl-Digest-1.17-395.el8.noarch
  perl-Digest-MD5-2.55-396.el8.x86_64
  perl-Encode-4:2.97-3.el8.x86_64
  perl-Errno-1.28-416.el8.x86_64
  perl-Exporter-5.72-396.el8.noarch
  perl-File-Path-2.15-2.el8.noarch
  perl-File-Temp-0.230.600-1.el8.noarch
  perl-Getopt-Long-1:2.50-4.el8.noarch
  perl-HTTP-Tiny-0.074-1.el8.noarch
  perl-IO-1.38-416.el8.x86_64
  perl-IO-Socket-IP-0.39-5.el8.noarch
  perl-IO-Socket-SSL-2.066-4.el8.noarch
  perl-MIME-Base64-3.15-396.el8.x86_64
  perl-Math-BigInt-1:1.9998.11-7.el8.noarch
  perl-Math-Complex-1.59-416.el8.noarch
  perl-Mozilla-CA-20160104-7.el8.noarch
  perl-Net-SSLeay-1.88-1.el8.x86_64
  perl-PathTools-3.74-1.el8.x86_64
  perl-Pod-Escapes-1:1.07-395.el8.noarch
  perl-Pod-Perldoc-3.28-396.el8.noarch
  perl-Pod-Simple-1:3.35-395.el8.noarch
  perl-Pod-Usage-4:1.69-395.el8.noarch
  perl-Scalar-List-Utils-3:1.49-2.el8.x86_64
  perl-Socket-4:2.027-3.el8.x86_64
  perl-Storable-1:3.11-3.el8.x86_64
  perl-Term-ANSIColor-4.06-396.el8.noarch
  perl-Term-Cap-1.17-395.el8.noarch
  perl-Text-ParseWords-3.30-395.el8.noarch
  perl-Text-Tabs+Wrap-2013.0523-395.el8.noarch
  perl-Time-Local-1:1.280-1.el8.noarch
  perl-URI-1.73-3.el8.noarch
  perl-Unicode-Normalize-1.25-396.el8.x86_64
  perl-constant-1.33-396.el8.noarch
  perl-interpreter-4:5.26.3-416.el8.x86_64
  perl-libnet-3.11-3.el8.noarch
  perl-libs-4:5.26.3-416.el8.x86_64
  perl-macros-4:5.26.3-416.el8.x86_64
  perl-parent-1:0.237-1.el8.noarch
  perl-podlators-4.11-1.el8.noarch
  perl-threads-1:2.21-2.el8.x86_64
  perl-threads-shared-1.58-2.el8.x86_64
  psmisc-23.1-4.el8.x86_64

Complete!

2.サービスを開始します。

[root@wordpress chatora]# systemctl start mariadb

3.自動起動を有効にします。

[root@wordpress chatora]# systemctl enable mariadb
Created symlink /etc/systemd/system/mysql.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/mysqld.service → /usr/lib/systemd/system/mariadb.service.
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /usr/lib/systemd/system/mariadb.service.

4.初期設定を行います。

[root@wordpress chatora]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB 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? [Y/n]
 ... 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? [Y/n]
 ... Success!

By default, MariaDB 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? [Y/n]
 - 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? [Y/n]
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

5.データベースで日本語を利用するため、文字コードを設定します。
17行目付近、[mysqld]の下の行に、文字コードの設定を追加します。

[root@wordpress chatora]# vi /etc/my.cnf.d/mariadb-server.cnf

character-set-server = utf8mb4

13行目付近、[client-mariadb]の下の行に、文字コードの設定を追加します。

[root@wordpress chatora]# vi /etc/my.cnf.d/client.cnf

character-set-server = utf8mb4

6.設定を反映させるため、再起動します。

[root@wordpress chatora]# systemctl restart mariadb

MariaDBの名前は、開発者の次女の名前からつけられたにょろ

Linux入門 SSL証明書の導入

ウェブサイトを公開する際、SSLで暗号化するのが一般出来になってきているにょろ

アンコウ?
アジとかサンマの方が好きにゃ!

魚の話じゃないにょろ!


SSL(エスエスエル)とは、通信を暗号化するための仕組みです。
ウェブサイトの通信を暗号化するためには、SSL証明書を導入する必要があります。
以前は、ショッピングサイトの購入フォームなど、一部のページしかSSL証明書は使用されていませんでしたが、Googleが常時SSL化を推奨したため、ウェブサイトのすべてのページをSSLで暗号化する事が一般的になりました。
今回は、無料でSSL証明書を利用できるLet’s Encrypt(レッツ・エンクリプト)を利用してウェブサイトを常時SSL化します。

Let’s Encrypt(レッツ・エンクリプト)とは
無償で利用できるSSL認証局です。Certbotなどのプログラムを利用して自動的にSSL証明書を導入する事ができます。
一般的な有償のSSL証明書は有効期間1年の場合が多いですが、Let’s Encryptで取得できるSSL証明書の期間は90日間になります。

Let’s Encrypt – フリーな SSL/TLS 証明書
https://letsencrypt.org/ja/

Cerbotとは
Let’s EncryptのSSL証明書を導入するためのプログラムです。

1.mode_sslをインストールします。

[root@wordpress chatora]# dnf install -y mod_ssl
Last metadata expiration check: 1:54:17 ago on Sun 15 Nov 2020 10:25:30 AM UTC.
Dependencies resolved.
================================================================================
 Package         Arch   Version                                 Repo       Size
================================================================================
Installing:
 mod_ssl         x86_64 1:2.4.37-21.module_el8.2.0+494+1df74eae AppStream 132 k
Upgrading:
 httpd           x86_64 2.4.37-21.module_el8.2.0+494+1df74eae   AppStream 1.7 M
 httpd-filesystem
                 noarch 2.4.37-21.module_el8.2.0+494+1df74eae   AppStream  36 k
 httpd-tools     x86_64 2.4.37-21.module_el8.2.0+494+1df74eae   AppStream 103 k
Installing dependencies:
 sscg            x86_64 2.3.3-14.el8                            AppStream  49 k

Transaction Summary
================================================================================
Install  2 Packages
Upgrade  3 Packages

Total download size: 2.0 M
Downloading Packages:
(1/5): sscg-2.3.3-14.el8.x86_64.rpm             138 kB/s |  49 kB     00:00
(2/5): httpd-filesystem-2.4.37-21.module_el8.2. 109 kB/s |  36 kB     00:00
(3/5): mod_ssl-2.4.37-21.module_el8.2.0+494+1df 192 kB/s | 132 kB     00:00
(4/5): httpd-tools-2.4.37-21.module_el8.2.0+494 184 kB/s | 103 kB     00:00
(5/5): httpd-2.4.37-21.module_el8.2.0+494+1df74 1.0 MB/s | 1.7 MB     00:01
--------------------------------------------------------------------------------
Total                                           1.0 MB/s | 2.0 MB     00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Running scriptlet: httpd-filesystem-2.4.37-21.module_el8.2.0+494+1df74e   1/1
  Running scriptlet: httpd-filesystem-2.4.37-21.module_el8.2.0+494+1df74e   1/8
  Upgrading        : httpd-filesystem-2.4.37-21.module_el8.2.0+494+1df74e   1/8
  Upgrading        : httpd-tools-2.4.37-21.module_el8.2.0+494+1df74eae.x8   2/8
  Upgrading        : httpd-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64     3/8
  Running scriptlet: httpd-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64     3/8
  Installing       : sscg-2.3.3-14.el8.x86_64                               4/8
  Installing       : mod_ssl-1:2.4.37-21.module_el8.2.0+494+1df74eae.x86_   5/8
  Running scriptlet: httpd-2.4.37-21.module_el8.2.0+382+15b0afa8.x86_64     6/8
  Cleanup          : httpd-2.4.37-21.module_el8.2.0+382+15b0afa8.x86_64     6/8
  Running scriptlet: httpd-2.4.37-21.module_el8.2.0+382+15b0afa8.x86_64     6/8
  Cleanup          : httpd-filesystem-2.4.37-21.module_el8.2.0+382+15b0af   7/8
  Cleanup          : httpd-tools-2.4.37-21.module_el8.2.0+382+15b0afa8.x8   8/8
  Running scriptlet: httpd-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64     8/8
  Running scriptlet: httpd-tools-2.4.37-21.module_el8.2.0+382+15b0afa8.x8   8/8
  Verifying        : mod_ssl-1:2.4.37-21.module_el8.2.0+494+1df74eae.x86_   1/8
  Verifying        : sscg-2.3.3-14.el8.x86_64                               2/8
  Verifying        : httpd-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64     3/8
  Verifying        : httpd-2.4.37-21.module_el8.2.0+382+15b0afa8.x86_64     4/8
  Verifying        : httpd-filesystem-2.4.37-21.module_el8.2.0+494+1df74e   5/8
  Verifying        : httpd-filesystem-2.4.37-21.module_el8.2.0+382+15b0af   6/8
  Verifying        : httpd-tools-2.4.37-21.module_el8.2.0+494+1df74eae.x8   7/8
  Verifying        : httpd-tools-2.4.37-21.module_el8.2.0+382+15b0afa8.x8   8/8

Upgraded:
  httpd-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64
  httpd-filesystem-2.4.37-21.module_el8.2.0+494+1df74eae.noarch
  httpd-tools-2.4.37-21.module_el8.2.0+494+1df74eae.x86_64

Installed:
  mod_ssl-1:2.4.37-21.module_el8.2.0+494+1df74eae.x86_64
  sscg-2.3.3-14.el8.x86_64

Complete!

2.EPELリポジトリをインストールします。

[root@wordpress chatora]# dnf install -y epel-release
Last metadata expiration check: 1:59:38 ago on Sun 15 Nov 2020 10:25:30 AM UTC.
Dependencies resolved.
================================================================================
 Package               Architecture    Version            Repository       Size
================================================================================
Installing:
 epel-release          noarch          8-8.el8            extras           23 k

Transaction Summary
================================================================================
Install  1 Package

Total download size: 23 k
Installed size: 32 k
Downloading Packages:
epel-release-8-8.el8.noarch.rpm                 295 kB/s |  23 kB     00:00
--------------------------------------------------------------------------------
Total                                           6.2 kB/s |  23 kB     00:03
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Installing       : epel-release-8-8.el8.noarch                            1/1
  Running scriptlet: epel-release-8-8.el8.noarch                            1/1
  Verifying        : epel-release-8-8.el8.noarch                            1/1

Installed:
  epel-release-8-8.el8.noarch

Complete!

3.Cerbotをインストールします。

[root@wordpress chatora]# dnf install -y certbot python3-certbot-apache
Last metadata expiration check: 0:00:23 ago on Sun 15 Nov 2020 12:26:34 PM UTC.
Dependencies resolved.
================================================================================
 Package                   Arch   Version                       Repo       Size
================================================================================
Installing:
 certbot                   noarch 1.9.0-1.el8                   epel       48 k
 python3-certbot-apache    noarch 1.9.0-1.el8                   epel      143 k
Installing dependencies:
 augeas-libs               x86_64 1.12.0-5.el8                  BaseOS    436 k
 python3-acme              noarch 1.9.0-1.el8                   epel       88 k
 python3-augeas            noarch 0.5.0-12.el8                  AppStream  31 k
 python3-certbot           noarch 1.9.0-1.el8                   epel      382 k
 python3-chardet           noarch 3.0.4-7.el8                   BaseOS    195 k
 python3-configargparse    noarch 0.14.0-6.el8                  epel       36 k
 python3-distro            noarch 1.4.0-2.module_el8.1.0+245+c39af44f
                                                                AppStream  37 k
 python3-josepy            noarch 1.2.0-5.el8                   epel       95 k
 python3-ndg_httpsclient   noarch 0.5.1-4.el8                   epel       53 k
 python3-parsedatetime     noarch 2.5-1.el8                     epel       79 k
 python3-pyasn1            noarch 0.3.7-6.el8                   AppStream 126 k
 python3-pyrfc3339         noarch 1.1-1.el8                     epel       19 k
 python3-pysocks           noarch 1.6.8-3.el8                   BaseOS     34 k
 python3-pytz              noarch 2017.2-9.el8                  AppStream  54 k
 python3-requests          noarch 2.20.0-2.1.el8_1              BaseOS    123 k
 python3-requests-toolbelt noarch 0.9.1-4.el8                   epel       91 k
 python3-urllib3           noarch 1.24.2-4.el8                  BaseOS    176 k
 python3-zope-component    noarch 4.3.0-8.el8                   epel      313 k
 python3-zope-event        noarch 4.2.0-12.el8                  epel      210 k
 python3-zope-interface    x86_64 4.6.0-1.el8                   epel      158 k
Installing weak dependencies:
 python-josepy-doc         noarch 1.2.0-5.el8                   epel       21 k

Transaction Summary
================================================================================
Install  23 Packages

Total download size: 2.9 M
Installed size: 11 M
Downloading Packages:
(1/23): python3-augeas-0.5.0-12.el8.noarch.rpm  111 kB/s |  31 kB     00:00
(2/23): python3-distro-1.4.0-2.module_el8.1.0+2 106 kB/s |  37 kB     00:00
(3/23): python3-pyasn1-0.3.7-6.el8.noarch.rpm   207 kB/s | 126 kB     00:00
(4/23): augeas-libs-1.12.0-5.el8.x86_64.rpm     1.3 MB/s | 436 kB     00:00
(5/23): python3-pytz-2017.2-9.el8.noarch.rpm    133 kB/s |  54 kB     00:00
(6/23): python3-pysocks-1.6.8-3.el8.noarch.rpm  775 kB/s |  34 kB     00:00
(7/23): python3-urllib3-1.24.2-4.el8.noarch.rpm 3.8 MB/s | 176 kB     00:00
(8/23): python3-chardet-3.0.4-7.el8.noarch.rpm  939 kB/s | 195 kB     00:00
(9/23): python3-requests-2.20.0-2.1.el8_1.noarc 594 kB/s | 123 kB     00:00
(10/23): python-josepy-doc-1.2.0-5.el8.noarch.r 121 kB/s |  21 kB     00:00
(11/23): certbot-1.9.0-1.el8.noarch.rpm         204 kB/s |  48 kB     00:00
(12/23): python3-certbot-apache-1.9.0-1.el8.noa 1.2 MB/s | 143 kB     00:00
(13/23): python3-acme-1.9.0-1.el8.noarch.rpm    380 kB/s |  88 kB     00:00
(14/23): python3-configargparse-0.14.0-6.el8.no 634 kB/s |  36 kB     00:00
(15/23): python3-josepy-1.2.0-5.el8.noarch.rpm  1.6 MB/s |  95 kB     00:00
(16/23): python3-certbot-1.9.0-1.el8.noarch.rpm 1.6 MB/s | 382 kB     00:00
(17/23): python3-ndg_httpsclient-0.5.1-4.el8.no 934 kB/s |  53 kB     00:00
(18/23): python3-parsedatetime-2.5-1.el8.noarch 1.3 MB/s |  79 kB     00:00
(19/23): python3-pyrfc3339-1.1-1.el8.noarch.rpm 320 kB/s |  19 kB     00:00
(20/23): python3-requests-toolbelt-0.9.1-4.el8. 1.5 MB/s |  91 kB     00:00
(21/23): python3-zope-event-4.2.0-12.el8.noarch 3.6 MB/s | 210 kB     00:00
(22/23): python3-zope-interface-4.6.0-1.el8.x86 2.7 MB/s | 158 kB     00:00
(23/23): python3-zope-component-4.3.0-8.el8.noa 2.6 MB/s | 313 kB     00:00
--------------------------------------------------------------------------------
Total                                           1.5 MB/s | 2.9 MB     00:01
warning: /var/cache/dnf/epel-6519ee669354a484/packages/certbot-1.9.0-1.el8.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 2f86d6a1: NOKEY
Extra Packages for Enterprise Linux 8 - x86_64   89 kB/s | 1.6 kB     00:00
Importing GPG key 0x2F86D6A1:
 Userid     : "Fedora EPEL (8) <epel@fedoraproject.org>"
 Fingerprint: 94E2 79EB 8D8F 25B2 1810 ADF1 21EA 45AB 2F86 D6A1
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-8
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                        1/1
  Installing       : python3-zope-event-4.2.0-12.el8.noarch                1/23
  Installing       : python3-zope-interface-4.6.0-1.el8.x86_64             2/23
  Installing       : python3-zope-component-4.3.0-8.el8.noarch             3/23
  Installing       : python3-pyrfc3339-1.1-1.el8.noarch                    4/23
  Installing       : python3-pytz-2017.2-9.el8.noarch                      5/23
  Installing       : python3-parsedatetime-2.5-1.el8.noarch                6/23
  Installing       : python3-ndg_httpsclient-0.5.1-4.el8.noarch            7/23
  Installing       : python3-configargparse-0.14.0-6.el8.noarch            8/23
  Installing       : python-josepy-doc-1.2.0-5.el8.noarch                  9/23
  Installing       : python3-josepy-1.2.0-5.el8.noarch                    10/23
  Installing       : python3-pysocks-1.6.8-3.el8.noarch                   11/23
  Installing       : python3-urllib3-1.24.2-4.el8.noarch                  12/23
  Installing       : python3-chardet-3.0.4-7.el8.noarch                   13/23
  Installing       : python3-requests-2.20.0-2.1.el8_1.noarch             14/23
  Installing       : python3-requests-toolbelt-0.9.1-4.el8.noarch         15/23
  Installing       : augeas-libs-1.12.0-5.el8.x86_64                      16/23
  Running scriptlet: augeas-libs-1.12.0-5.el8.x86_64                      16/23
  Installing       : python3-augeas-0.5.0-12.el8.noarch                   17/23
  Installing       : python3-pyasn1-0.3.7-6.el8.noarch                    18/23
  Installing       : python3-acme-1.9.0-1.el8.noarch                      19/23
  Installing       : python3-distro-1.4.0-2.module_el8.1.0+245+c39af44f   20/23
  Installing       : python3-certbot-1.9.0-1.el8.noarch                   21/23
  Installing       : certbot-1.9.0-1.el8.noarch                           22/23
  Running scriptlet: certbot-1.9.0-1.el8.noarch                           22/23
  Installing       : python3-certbot-apache-1.9.0-1.el8.noarch            23/23
  Running scriptlet: python3-certbot-apache-1.9.0-1.el8.noarch            23/23
  Verifying        : python3-augeas-0.5.0-12.el8.noarch                    1/23
  Verifying        : python3-distro-1.4.0-2.module_el8.1.0+245+c39af44f    2/23
  Verifying        : python3-pyasn1-0.3.7-6.el8.noarch                     3/23
  Verifying        : python3-pytz-2017.2-9.el8.noarch                      4/23
  Verifying        : augeas-libs-1.12.0-5.el8.x86_64                       5/23
  Verifying        : python3-chardet-3.0.4-7.el8.noarch                    6/23
  Verifying        : python3-pysocks-1.6.8-3.el8.noarch                    7/23
  Verifying        : python3-requests-2.20.0-2.1.el8_1.noarch              8/23
  Verifying        : python3-urllib3-1.24.2-4.el8.noarch                   9/23
  Verifying        : certbot-1.9.0-1.el8.noarch                           10/23
  Verifying        : python-josepy-doc-1.2.0-5.el8.noarch                 11/23
  Verifying        : python3-acme-1.9.0-1.el8.noarch                      12/23
  Verifying        : python3-certbot-1.9.0-1.el8.noarch                   13/23
  Verifying        : python3-certbot-apache-1.9.0-1.el8.noarch            14/23
  Verifying        : python3-configargparse-0.14.0-6.el8.noarch           15/23
  Verifying        : python3-josepy-1.2.0-5.el8.noarch                    16/23
  Verifying        : python3-ndg_httpsclient-0.5.1-4.el8.noarch           17/23
  Verifying        : python3-parsedatetime-2.5-1.el8.noarch               18/23
  Verifying        : python3-pyrfc3339-1.1-1.el8.noarch                   19/23
  Verifying        : python3-requests-toolbelt-0.9.1-4.el8.noarch         20/23
  Verifying        : python3-zope-component-4.3.0-8.el8.noarch            21/23
  Verifying        : python3-zope-event-4.2.0-12.el8.noarch               22/23
  Verifying        : python3-zope-interface-4.6.0-1.el8.x86_64            23/23

Installed:
  augeas-libs-1.12.0-5.el8.x86_64
  certbot-1.9.0-1.el8.noarch
  python-josepy-doc-1.2.0-5.el8.noarch
  python3-acme-1.9.0-1.el8.noarch
  python3-augeas-0.5.0-12.el8.noarch
  python3-certbot-1.9.0-1.el8.noarch
  python3-certbot-apache-1.9.0-1.el8.noarch
  python3-chardet-3.0.4-7.el8.noarch
  python3-configargparse-0.14.0-6.el8.noarch
  python3-distro-1.4.0-2.module_el8.1.0+245+c39af44f.noarch
  python3-josepy-1.2.0-5.el8.noarch
  python3-ndg_httpsclient-0.5.1-4.el8.noarch
  python3-parsedatetime-2.5-1.el8.noarch
  python3-pyasn1-0.3.7-6.el8.noarch
  python3-pyrfc3339-1.1-1.el8.noarch
  python3-pysocks-1.6.8-3.el8.noarch
  python3-pytz-2017.2-9.el8.noarch
  python3-requests-2.20.0-2.1.el8_1.noarch
  python3-requests-toolbelt-0.9.1-4.el8.noarch
  python3-urllib3-1.24.2-4.el8.noarch
  python3-zope-component-4.3.0-8.el8.noarch
  python3-zope-event-4.2.0-12.el8.noarch
  python3-zope-interface-4.6.0-1.el8.x86_64

Complete!

4.証明書の取得(webroot)します。

[root@wordpress chatora]# certbot certonly --webroot -w /var/www/html/ -d linux.gakubu.net -m chatora@ciel.gakubu.net --agree-tos
Saving debug log to /var/log/letsencrypt/letsencrypt.log
Plugins selected: Authenticator webroot, Installer None

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Would you be willing, once your first certificate is successfully issued, to
share your email address with the Electronic Frontier Foundation, a founding
partner of the Let's Encrypt project and the non-profit organization that
develops Certbot? We'd like to send you email about our work encrypting the web,
EFF news, campaigns, and ways to support digital freedom.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
(Y)es/(N)o: N
Obtaining a new certificate
Performing the following challenges:
http-01 challenge for linux.gakubu.net
Using the webroot path /var/www/html for all unmatched domains.
Waiting for verification...
Cleaning up challenges

IMPORTANT NOTES:
 - Congratulations! Your certificate and chain have been saved at:
   /etc/letsencrypt/live/linux.gakubu.net/fullchain.pem
   Your key file has been saved at:
   /etc/letsencrypt/live/linux.gakubu.net/privkey.pem
   Your cert will expire on 2021-02-13. To obtain a new or tweaked
   version of this certificate in the future, simply run certbot
   again. To non-interactively renew *all* of your certificates, run
   "certbot renew"
 - If you like Certbot, please consider supporting our work by:

   Donating to ISRG / Let's Encrypt:   https://letsencrypt.org/donate
   Donating to EFF:                    https://eff.org/donate-le

5.取得した証明書をApacheに設定します。

[root@wordpress chatora]# vi /etc/httpd/conf.d/ssl.conf

#   Point SSLCertificateFile at a PEM encoded certificate.  If
#   the certificate is encrypted, then you will be prompted for a
#   pass phrase.  Note that restarting httpd will prompt again.  Keep
#   in mind that if you have both an RSA and a DSA certificate you
#   can configure both in parallel (to also allow the use of DSA
#   ciphers, etc.)
#   Some ECC cipher suites (http://www.ietf.org/rfc/rfc4492.txt)
#   require an ECC certificate which can also be configured in
#   parallel.
#SSLCertificateFile /etc/pki/tls/certs/localhost.crt
SSLCertificateFile /etc/letsencrypt/live/linux.gakubu.net/fullchain.pem

#   Server Private Key:
#   If the key is not combined with the certificate, use this
#   directive to point at the key file.  Keep in mind that if
#   you've both a RSA and a DSA private key you can configure
#   both in parallel (to also allow the use of DSA ciphers, etc.)
#   ECC keys, when in use, can also be configured in parallel
#SSLCertificateKeyFile /etc/pki/tls/private/localhost.key
SSLCertificateKeyFile /etc/letsencrypt/live/linux.gakubu.net/privkey.pem

6.Apacheを再起動します。

[root@wordpress chatora]# systemctl restart httpd

7.ブラウザから、httpsをつけて、ウェブサイトにアクセスします。

アドレスに鍵マークが表示された状態で、テストページが表示されれば成功です。


SSLの有効期限は90日間だにょろ
忘れずに更新するにょろ!