2023.09.28
Controller
1. SQL 패키지설치
[root@controller ~]# yum install mariadb mariadb-server python2-PyMySQL
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.navercorp.com
* centos-qemu-ev: mirror.navercorp.com
* extras: mirror.navercorp.com
* updates: mirror.navercorp.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 3:10.1.20-2.el7 will be installed
--> Processing Dependency: /usr/bin/perl for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(Exporter) for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(Fcntl) for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(File::Temp) for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(Getopt::Long) for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(IPC::Open3) for package: 3:mariadb-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(Sys::Hostname) for package: 3:mariadb-10.1.20-2.el7.x86_64
---> Package mariadb-server.x86_64 3:10.1.20-2.el7 will be installed
--> Processing Dependency: mariadb-errmsg(x86-64) = 3:10.1.20-2.el7 for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: lsof for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: net-tools for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(DBD::mysql) for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(DBI) for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: perl(File::Path) for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: rsync for package: 3:mariadb-server-10.1.20-2.el7.x86_64
--> Processing Dependency: socat for package: 3:mariadb-server-10.1.20-2.el7.x86_64
---> Package python2-PyMySQL.noarch 0:0.7.11-1.el7 will be installed
--> Running transaction check
---> Package lsof.x86_64 0:4.87-6.el7 will be installed
---> Package mariadb-errmsg.x86_64 3:10.1.20-2.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package perl.x86_64 4:5.16.3-299.el7_9 will be installed
--> Processing Dependency: perl-libs = 4:5.16.3-299.el7_9 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-macros for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl-libs for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-299.el7_9.x86_64
--> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-299.el7_9.x86_64
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
--> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
--> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
---> Package rsync.x86_64 0:3.1.2-12.el7_9 will be installed
---> Package socat.x86_64 0:1.7.3.2-2.el7 will be installed
--> Running transaction check
---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
--> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
--> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
--> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
--> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
---> Package perl-libs.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-macros.x86_64 4:5.16.3-299.el7_9 will be installed
---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
--> Running transaction check
---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
---> Package perl-Pod-Escapes.noarch 1:1.04-299.el7_9 will be installed
---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
--> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
--> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=============================================================================================
Package Arch Version Repository Size
=============================================================================================
Installing:
mariadb x86_64 3:10.1.20-2.el7 centos-openstack-queens 6.3 M
mariadb-server x86_64 3:10.1.20-2.el7 centos-openstack-queens 19 M
python2-PyMySQL noarch 0.7.11-1.el7 centos-openstack-queens 150 k
Installing for dependencies:
lsof x86_64 4.87-6.el7 base 331 k
mariadb-errmsg x86_64 3:10.1.20-2.el7 centos-openstack-queens 200 k
net-tools x86_64 2.0-0.25.20131004git.el7 base 306 k
perl x86_64 4:5.16.3-299.el7_9 updates 8.0 M
perl-Carp noarch 1.26-244.el7 base 19 k
perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k
perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k
perl-DBD-MySQL x86_64 4.023-6.el7 base 140 k
perl-DBI x86_64 1.627-4.el7 base 802 k
perl-Data-Dumper x86_64 2.145-3.el7 base 47 k
perl-Encode x86_64 2.51-7.el7 base 1.5 M
perl-Exporter noarch 5.68-3.el7 base 28 k
perl-File-Path noarch 2.09-2.el7 base 26 k
perl-File-Temp noarch 0.23.01-3.el7 base 56 k
perl-Filter x86_64 1.49-3.el7 base 76 k
perl-Getopt-Long noarch 2.40-3.el7 base 56 k
perl-HTTP-Tiny noarch 0.033-3.el7 base 38 k
perl-IO-Compress noarch 2.061-2.el7 base 260 k
perl-Net-Daemon noarch 0.48-5.el7 base 51 k
perl-PathTools x86_64 3.40-5.el7 base 82 k
perl-PlRPC noarch 0.2020-14.el7 base 36 k
perl-Pod-Escapes noarch 1:1.04-299.el7_9 updates 52 k
perl-Pod-Perldoc noarch 3.20-4.el7 base 87 k
perl-Pod-Simple noarch 1:3.28-4.el7 base 216 k
perl-Pod-Usage noarch 1.63-3.el7 base 27 k
perl-Scalar-List-Utils x86_64 1.27-248.el7 base 36 k
perl-Socket x86_64 2.010-5.el7 base 49 k
perl-Storable x86_64 2.45-3.el7 base 77 k
perl-Text-ParseWords noarch 3.29-4.el7 base 14 k
perl-Time-HiRes x86_64 4:1.9725-3.el7 base 45 k
perl-Time-Local noarch 1.2300-2.el7 base 24 k
perl-constant noarch 1.27-2.el7 base 19 k
perl-libs x86_64 4:5.16.3-299.el7_9 updates 690 k
perl-macros x86_64 4:5.16.3-299.el7_9 updates 44 k
perl-parent noarch 1:0.225-244.el7 base 12 k
perl-podlators noarch 2.5.1-3.el7 base 112 k
perl-threads x86_64 1.87-4.el7 base 49 k
perl-threads-shared x86_64 1.43-6.el7 base 39 k
rsync x86_64 3.1.2-12.el7_9 updates 408 k
socat x86_64 1.7.3.2-2.el7 base 290 k
Transaction Summary
=============================================================================================
Install 3 Packages (+40 Dependent packages)
Total download size: 40 M
Installed size: 178 M
Is this ok [y/d/N]: y
Downloading packages:
(1/43): lsof-4.87-6.el7.x86_64.rpm | 331 kB 00:00:00
(2/43): mariadb-errmsg-10.1.20-2.el7.x86_64.rpm | 200 kB 00:00:00
(3/43): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm | 306 kB 00:00:00
(4/43): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm | 32 kB 00:00:00
(5/43): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm | 57 kB 00:00:00
(6/43): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm | 140 kB 00:00:00
(7/43): perl-DBI-1.627-4.el7.x86_64.rpm | 802 kB 00:00:00
(8/43): perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:00
(9/43): perl-Carp-1.26-244.el7.noarch.rpm | 19 kB 00:00:00
(10/43): perl-Encode-2.51-7.el7.x86_64.rpm | 1.5 MB 00:00:00
(11/43): perl-File-Path-2.09-2.el7.noarch.rpm | 26 kB 00:00:00
(12/43): perl-File-Temp-0.23.01-3.el7.noarch.rpm | 56 kB 00:00:00
(13/43): perl-Exporter-5.68-3.el7.noarch.rpm | 28 kB 00:00:00
(14/43): perl-Filter-1.49-3.el7.x86_64.rpm | 76 kB 00:00:00
(15/43): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm | 38 kB 00:00:00
(16/43): perl-IO-Compress-2.061-2.el7.noarch.rpm | 260 kB 00:00:00
(17/43): perl-5.16.3-299.el7_9.x86_64.rpm | 8.0 MB 00:00:01
(18/43): perl-Net-Daemon-0.48-5.el7.noarch.rpm | 51 kB 00:00:00
(19/43): mariadb-10.1.20-2.el7.x86_64.rpm | 6.3 MB 00:00:02
(20/43): perl-PathTools-3.40-5.el7.x86_64.rpm | 82 kB 00:00:00
(21/43): perl-Getopt-Long-2.40-3.el7.noarch.rpm | 56 kB 00:00:00
(22/43): mariadb-server-10.1.20-2.el7.x86_64.rpm | 19 MB 00:00:01
(23/43): perl-PlRPC-0.2020-14.el7.noarch.rpm | 36 kB 00:00:00
(24/43): perl-Pod-Escapes-1.04-299.el7_9.noarch.rpm | 52 kB 00:00:00
(25/43): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm | 87 kB 00:00:00
(26/43): perl-Pod-Usage-1.63-3.el7.noarch.rpm | 27 kB 00:00:00
(27/43): perl-Pod-Simple-3.28-4.el7.noarch.rpm | 216 kB 00:00:00
(28/43): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm | 36 kB 00:00:00
(29/43): perl-Socket-2.010-5.el7.x86_64.rpm | 49 kB 00:00:00
(30/43): perl-Storable-2.45-3.el7.x86_64.rpm | 77 kB 00:00:00
(31/43): perl-Text-ParseWords-3.29-4.el7.noarch.rpm | 14 kB 00:00:00
(32/43): perl-Time-HiRes-1.9725-3.el7.x86_64.rpm | 45 kB 00:00:00
(33/43): perl-Time-Local-1.2300-2.el7.noarch.rpm | 24 kB 00:00:00
(34/43): perl-constant-1.27-2.el7.noarch.rpm | 19 kB 00:00:00
(35/43): perl-parent-0.225-244.el7.noarch.rpm | 12 kB 00:00:00
(36/43): perl-podlators-2.5.1-3.el7.noarch.rpm | 112 kB 00:00:00
(37/43): perl-threads-1.87-4.el7.x86_64.rpm | 49 kB 00:00:00
(38/43): perl-threads-shared-1.43-6.el7.x86_64.rpm | 39 kB 00:00:00
(39/43): python2-PyMySQL-0.7.11-1.el7.noarch.rpm | 150 kB 00:00:00
(40/43): perl-macros-5.16.3-299.el7_9.x86_64.rpm | 44 kB 00:00:00
(41/43): perl-libs-5.16.3-299.el7_9.x86_64.rpm | 690 kB 00:00:00
(42/43): rsync-3.1.2-12.el7_9.x86_64.rpm | 408 kB 00:00:00
(43/43): socat-1.7.3.2-2.el7.x86_64.rpm | 290 kB 00:00:00
---------------------------------------------------------------------------------------------
Total 10 MB/s | 40 MB 00:00:03
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : 1:perl-parent-0.225-244.el7.noarch 1/43
Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 2/43
Installing : perl-podlators-2.5.1-3.el7.noarch 3/43
Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 4/43
Installing : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch 5/43
Installing : perl-Encode-2.51-7.el7.x86_64 6/43
Installing : perl-Text-ParseWords-3.29-4.el7.noarch 7/43
Installing : perl-Pod-Usage-1.63-3.el7.noarch 8/43
Installing : 4:perl-macros-5.16.3-299.el7_9.x86_64 9/43
Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 10/43
Installing : perl-Exporter-5.68-3.el7.noarch 11/43
Installing : perl-constant-1.27-2.el7.noarch 12/43
Installing : perl-Socket-2.010-5.el7.x86_64 13/43
Installing : perl-Time-Local-1.2300-2.el7.noarch 14/43
Installing : perl-Carp-1.26-244.el7.noarch 15/43
Installing : perl-Storable-2.45-3.el7.x86_64 16/43
Installing : perl-PathTools-3.40-5.el7.x86_64 17/43
Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 18/43
Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 19/43
Installing : perl-File-Temp-0.23.01-3.el7.noarch 20/43
Installing : perl-File-Path-2.09-2.el7.noarch 21/43
Installing : perl-threads-shared-1.43-6.el7.x86_64 22/43
Installing : perl-threads-1.87-4.el7.x86_64 23/43
Installing : perl-Filter-1.49-3.el7.x86_64 24/43
Installing : 4:perl-libs-5.16.3-299.el7_9.x86_64 25/43
Installing : perl-Getopt-Long-2.40-3.el7.noarch 26/43
Installing : 4:perl-5.16.3-299.el7_9.x86_64 27/43
Installing : perl-Data-Dumper-2.145-3.el7.x86_64 28/43
Installing : 3:mariadb-10.1.20-2.el7.x86_64 29/43
Installing : perl-Net-Daemon-0.48-5.el7.noarch 30/43
Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 31/43
Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 32/43
Installing : perl-IO-Compress-2.061-2.el7.noarch 33/43
Installing : perl-PlRPC-0.2020-14.el7.noarch 34/43
Installing : perl-DBI-1.627-4.el7.x86_64 35/43
Installing : perl-DBD-MySQL-4.023-6.el7.x86_64 36/43
Installing : socat-1.7.3.2-2.el7.x86_64 37/43
Installing : 3:mariadb-errmsg-10.1.20-2.el7.x86_64 38/43
Installing : lsof-4.87-6.el7.x86_64 39/43
Installing : net-tools-2.0-0.25.20131004git.el7.x86_64 40/43
Installing : rsync-3.1.2-12.el7_9.x86_64 41/43
Installing : 3:mariadb-server-10.1.20-2.el7.x86_64 42/43
Installing : python2-PyMySQL-0.7.11-1.el7.noarch 43/43
Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/43
Verifying : perl-IO-Compress-2.061-2.el7.noarch 2/43
Verifying : rsync-3.1.2-12.el7_9.x86_64 3/43
Verifying : perl-threads-shared-1.43-6.el7.x86_64 4/43
Verifying : 4:perl-Time-HiRes-1.9725-3.el7.x86_64 5/43
Verifying : perl-DBD-MySQL-4.023-6.el7.x86_64 6/43
Verifying : perl-Exporter-5.68-3.el7.noarch 7/43
Verifying : perl-constant-1.27-2.el7.noarch 8/43
Verifying : perl-PathTools-3.40-5.el7.x86_64 9/43
Verifying : perl-Socket-2.010-5.el7.x86_64 10/43
Verifying : 3:mariadb-10.1.20-2.el7.x86_64 11/43
Verifying : 1:perl-parent-0.225-244.el7.noarch 12/43
Verifying : 4:perl-macros-5.16.3-299.el7_9.x86_64 13/43
Verifying : perl-Net-Daemon-0.48-5.el7.noarch 14/43
Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 15/43
Verifying : perl-File-Temp-0.23.01-3.el7.noarch 16/43
Verifying : net-tools-2.0-0.25.20131004git.el7.x86_64 17/43
Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 18/43
Verifying : perl-Getopt-Long-2.40-3.el7.noarch 19/43
Verifying : perl-Time-Local-1.2300-2.el7.noarch 20/43
Verifying : 1:perl-Pod-Escapes-1.04-299.el7_9.noarch 21/43
Verifying : perl-DBI-1.627-4.el7.x86_64 22/43
Verifying : perl-Carp-1.26-244.el7.noarch 23/43
Verifying : 3:mariadb-server-10.1.20-2.el7.x86_64 24/43
Verifying : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64 25/43
Verifying : perl-Storable-2.45-3.el7.x86_64 26/43
Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 27/43
Verifying : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64 28/43
Verifying : lsof-4.87-6.el7.x86_64 29/43
Verifying : perl-Pod-Usage-1.63-3.el7.noarch 30/43
Verifying : perl-PlRPC-0.2020-14.el7.noarch 31/43
Verifying : perl-Encode-2.51-7.el7.x86_64 32/43
Verifying : 3:mariadb-errmsg-10.1.20-2.el7.x86_64 33/43
Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 34/43
Verifying : perl-podlators-2.5.1-3.el7.noarch 35/43
Verifying : 4:perl-5.16.3-299.el7_9.x86_64 36/43
Verifying : perl-File-Path-2.09-2.el7.noarch 37/43
Verifying : perl-threads-1.87-4.el7.x86_64 38/43
Verifying : perl-Filter-1.49-3.el7.x86_64 39/43
Verifying : python2-PyMySQL-0.7.11-1.el7.noarch 40/43
Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 41/43
Verifying : 4:perl-libs-5.16.3-299.el7_9.x86_64 42/43
Verifying : socat-1.7.3.2-2.el7.x86_64 43/43
Installed:
mariadb.x86_64 3:10.1.20-2.el7 mariadb-server.x86_64 3:10.1.20-2.el7
python2-PyMySQL.noarch 0:0.7.11-1.el7
Dependency Installed:
lsof.x86_64 0:4.87-6.el7 mariadb-errmsg.x86_64 3:10.1.20-2.el7
net-tools.x86_64 0:2.0-0.25.20131004git.el7 perl.x86_64 4:5.16.3-299.el7_9
perl-Carp.noarch 0:1.26-244.el7 perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7
perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-6.el7
perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7
perl-Encode.x86_64 0:2.51-7.el7 perl-Exporter.noarch 0:5.68-3.el7
perl-File-Path.noarch 0:2.09-2.el7 perl-File-Temp.noarch 0:0.23.01-3.el7
perl-Filter.x86_64 0:1.49-3.el7 perl-Getopt-Long.noarch 0:2.40-3.el7
perl-HTTP-Tiny.noarch 0:0.033-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7
perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PathTools.x86_64 0:3.40-5.el7
perl-PlRPC.noarch 0:0.2020-14.el7 perl-Pod-Escapes.noarch 1:1.04-299.el7_9
perl-Pod-Perldoc.noarch 0:3.20-4.el7 perl-Pod-Simple.noarch 1:3.28-4.el7
perl-Pod-Usage.noarch 0:1.63-3.el7 perl-Scalar-List-Utils.x86_64 0:1.27-248.el7
perl-Socket.x86_64 0:2.010-5.el7 perl-Storable.x86_64 0:2.45-3.el7
perl-Text-ParseWords.noarch 0:3.29-4.el7 perl-Time-HiRes.x86_64 4:1.9725-3.el7
perl-Time-Local.noarch 0:1.2300-2.el7 perl-constant.noarch 0:1.27-2.el7
perl-libs.x86_64 4:5.16.3-299.el7_9 perl-macros.x86_64 4:5.16.3-299.el7_9
perl-parent.noarch 1:0.225-244.el7 perl-podlators.noarch 0:2.5.1-3.el7
perl-threads.x86_64 0:1.87-4.el7 perl-threads-shared.x86_64 0:1.43-6.el7
rsync.x86_64 0:3.1.2-12.el7_9 socat.x86_64 0:1.7.3.2-2.el7
Complete!
2. openstack.cnf 파일 생성 및 편집
[root@controller ~]# cat /etc/my.cnf.d/openstack.cnf
[mysqld]
bind-address = 192.168.56.10
default-storage-engine = innodb
innodb_file_per_table = on
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8/etc/my.cnf.d/openstack.cnf 파일을 생성 후 편집한다. openstack.cnf 파일은 존재하지 않는 파일이므로 생성해야한다.(필요한 경우 기존 구성 파일을 /etc/my.cnf.d/ 에 백업한다)
- [mysqld] 섹션을 생성하고, 다른 노드들이 관리 네트워크를 통한 액세스를 활성화하기 위해 컨트롤러 노드의 관리 IP 주소를 bind-address 키로 설정한다. 유용한 옵션 및 UTF-8 문자셋을 활성화하기 위해 부가적인 키를 설정한다.
3. 데이터베이스 서비스 재시작
[root@controller ~]# systemctl enable mariadb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
[root@controller ~]# systemctl start mariadb.service
[root@controller ~]# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2023-09-28 13:04:01 KST; 10s ago
Process: 8704 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS)
Process: 8517 ExecStartPre=/usr/libexec/mysql-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Process: 8494 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
Main PID: 8676 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─8676 /usr/libexec/mysqld --basedir=/usr
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: See the MariaDB Knowledgebase at h...e
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: MySQL manual for more instructions.
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: Please report any problems at http...a
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: The latest information about Maria....
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: You can find additional informatio...:
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: http://dev.mysql.com
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: Consider joining MariaDB's strong ...:
Sep 28 13:04:01 controller mysql-prepare-db-dir[8517]: https://mariadb.org/get-involved/
Sep 28 13:04:01 controller mysqld[8676]: 2023-09-28 13:04:01 139768391481536 [Note] /us......
Sep 28 13:04:01 controller systemd[1]: Started MariaDB 10.1 database server.
Hint: Some lines were ellipsized, use -l to show in full.
4. mysql_secure_installation 설치 및 실행
[root@controller ~]# 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] y
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] 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? [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!mysql_secure_installation 스크립트를 실행하여 데이터베이스 서비스 보안을 강화한다. 특히, 데이터베이스 root 계정에 대한 암호를 설정한다
'Cloud > Openstack' 카테고리의 다른 글
| [Centos7/Openstack]Openstack구축(7)-Install Etcd (0) | 2023.09.28 |
|---|---|
| [Centos7/Openstack]Openstack 구축(5) - Install Message Queu (0) | 2023.09.28 |
| [Centos7/Openstack]Openstack구축(3)-Install Openstack Package (0) | 2023.09.28 |
| [Centos7/Openstack]Openstack 구축(2)-Install NTP(Network Time Protocol) (0) | 2023.09.28 |
| [Centos7/Openstack]Openstack구축(1)-Network설정하기 (0) | 2023.09.26 |