Kamis, 30 Desember 2021

How to reset Ldapadmin password

  Tidak ada komentar

Create slapd password

[root@COGNOS ~]# slappasswd -h {SSHA}
New password:
Re-enter new password:
Create Ldap DB Like this
[root@COGNOS ~]# cat /root/db.ldif
dn: olcDatabase={2}hdb,cn=config
changetype: modify
replace: olcSuffix
olcSuffix: dc=dephub,dc=go,dc=id

dn: olcDatabase={2}hdb,cn=config
changetype: modify
replace: olcRootDN
olcRootDN: cn=ldapadm,dc=dephub,dc=go,dc=id

dn: olcDatabase={2}hdb,cn=config
changetype: modify
replace: olcRootPW
olcRootPW: {SSHA}TC7YpXa/BjuELlINnRxmA7Pi19yP7AIb
[root@COGNOS ~]#                                                                                           | 1.0 MB  00:00:00
Modify ldap password with following command
[root@COGNOS ~]# ldapmodify -Y EXTERNAL  -H ldapi:/// -f db.ldif
SASL/EXTERNAL authentication started
SASL username: gidNumber=0+uidNumber=0,cn=peercred,cn=external,cn=auth
modifying entry "olcDatabase={2}hdb,cn=config"

modifying entry "olcDatabase={2}hdb,cn=config"

modifying entry "olcDatabase={2}hdb,cn=config"

[root@COGNOS ~]#                                                                                | 1.0 MB  00:00:00

Kamis, 16 Desember 2021

Install DB2 Purescale on Redhat

  Tidak ada komentar

Install Package 

[root@db2psdev02 ~]# yum install cpp gcc gcc-c++ kernel-devel sg3_utils ntp patch perl-Sys-Syslog binutils ksh lsscsi m4 openssh
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
file:///cdrom/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /cdrom/repodata/repomd.xml"
Trying other mirror.
epel/x86_64/metalink                                                                                                      | 5.5 kB  00:00:00
epel                                                                                                                      | 4.7 kB  00:00:00
rhel-7-server-rpms                                                                                                        | 3.5 kB  00:00:00
(1/2): epel/x86_64/updateinfo                                                                                             | 1.0 MB  00:00:00
(2/2): epel/x86_64/primary_db                                                                                             | 7.0 MB  00:00:04
Package perl-Sys-Syslog-0.33-3.el7.x86_64 already installed and latest version
Package m4-1.4.16-10.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package binutils.x86_64 0:2.25.1-22.base.el7 will be updated
---> Package binutils.x86_64 0:2.27-44.base.el7_9.1 will be an update
---> Package cpp.x86_64 0:4.8.5-11.el7 will be updated
---> Package cpp.x86_64 0:4.8.5-44.el7 will be an update
---> Package gcc.x86_64 0:4.8.5-11.el7 will be updated
--> Processing Dependency: gcc = 4.8.5-11.el7 for package: gcc-gfortran-4.8.5-11.el7.x86_64
--> Processing Dependency: gcc = 4.8.5-11.el7 for package: libquadmath-devel-4.8.5-11.el7.x86_64
---> Package gcc.x86_64 0:4.8.5-44.el7 will be an update
--> Processing Dependency: libgomp = 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
---> Package gcc-c++.x86_64 0:4.8.5-11.el7 will be updated
---> Package gcc-c++.x86_64 0:4.8.5-44.el7 will be an update
--> Processing Dependency: libstdc++ = 4.8.5-44.el7 for package: gcc-c++-4.8.5-44.el7.x86_64
--> Processing Dependency: libstdc++-devel = 4.8.5-44.el7 for package: gcc-c++-4.8.5-44.el7.x86_64
---> Package kernel-devel.x86_64 0:3.10.0-1160.49.1.el7 will be installed
---> Package ksh.x86_64 0:20120801-26.el7 will be updated
---> Package ksh.x86_64 0:20120801-143.el7_9 will be an update
---> Package lsscsi.x86_64 0:0.27-4.el7 will be updated
---> Package lsscsi.x86_64 0:0.27-6.el7 will be an update
---> Package ntp.x86_64 0:4.2.6p5-25.el7 will be updated
---> Package ntp.x86_64 0:4.2.6p5-29.el7_8.2 will be an update
--> Processing Dependency: ntpdate = 4.2.6p5-29.el7_8.2 for package: ntp-4.2.6p5-29.el7_8.2.x86_64
--> Processing Dependency: libcrypto.so.10(OPENSSL_1.0.2)(64bit) for package: ntp-4.2.6p5-29.el7_8.2.x86_64
---> Package openssh.x86_64 0:6.6.1p1-31.el7 will be updated
--> Processing Dependency: openssh = 6.6.1p1-31.el7 for package: openssh-server-6.6.1p1-31.el7.x86_64
--> Processing Dependency: openssh = 6.6.1p1-31.el7 for package: openssh-clients-6.6.1p1-31.el7.x86_64
---> Package openssh.x86_64 0:7.4p1-22.el7_9 will be an update
---> Package patch.x86_64 0:2.7.1-8.el7 will be updated
---> Package patch.x86_64 0:2.7.1-12.el7_7 will be an update
---> Package sg3_utils.x86_64 0:1.37-9.el7 will be updated
---> Package sg3_utils.x86_64 1:1.37-19.el7 will be an update
--> Processing Dependency: sg3_utils-libs = 1:1.37-19.el7 for package: 1:sg3_utils-1.37-19.el7.x86_64
--> Running transaction check
---> Package gcc-gfortran.x86_64 0:4.8.5-11.el7 will be updated
---> Package gcc-gfortran.x86_64 0:4.8.5-44.el7 will be an update
--> Processing Dependency: libgfortran = 4.8.5-44.el7 for package: gcc-gfortran-4.8.5-44.el7.x86_64
--> Processing Dependency: libquadmath = 4.8.5-44.el7 for package: gcc-gfortran-4.8.5-44.el7.x86_64
---> Package libgcc.i686 0:4.8.5-11.el7 will be updated
---> Package libgcc.x86_64 0:4.8.5-11.el7 will be updated
---> Package libgcc.i686 0:4.8.5-44.el7 will be an update
---> Package libgcc.x86_64 0:4.8.5-44.el7 will be an update
---> Package libgomp.x86_64 0:4.8.5-11.el7 will be updated
---> Package libgomp.x86_64 0:4.8.5-44.el7 will be an update
---> Package libquadmath-devel.x86_64 0:4.8.5-11.el7 will be updated
---> Package libquadmath-devel.x86_64 0:4.8.5-44.el7 will be an update
---> Package libstdc++.i686 0:4.8.5-11.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-11.el7 will be updated
---> Package libstdc++.i686 0:4.8.5-44.el7 will be an update
---> Package libstdc++.x86_64 0:4.8.5-44.el7 will be an update
---> Package libstdc++-devel.x86_64 0:4.8.5-11.el7 will be updated
---> Package libstdc++-devel.x86_64 0:4.8.5-44.el7 will be an update
---> Package ntpdate.x86_64 0:4.2.6p5-25.el7 will be updated
---> Package ntpdate.x86_64 0:4.2.6p5-29.el7_8.2 will be an update
---> Package openssh-clients.x86_64 0:6.6.1p1-31.el7 will be updated
---> Package openssh-clients.x86_64 0:7.4p1-22.el7_9 will be an update
---> Package openssh-server.x86_64 0:6.6.1p1-31.el7 will be updated
---> Package openssh-server.x86_64 0:7.4p1-22.el7_9 will be an update
---> Package openssl-libs.x86_64 1:1.0.1e-60.el7 will be updated
--> Processing Dependency: openssl-libs(x86-64) = 1:1.0.1e-60.el7 for package: 1:openssl-1.0.1e-60.el7.x86_64
---> Package openssl-libs.x86_64 1:1.0.2k-22.el7_9 will be an update
---> Package sg3_utils-libs.x86_64 0:1.37-9.el7 will be updated
---> Package sg3_utils-libs.x86_64 1:1.37-19.el7 will be an update
--> Running transaction check
---> Package libgfortran.x86_64 0:4.8.5-11.el7 will be updated
---> Package libgfortran.x86_64 0:4.8.5-44.el7 will be an update
---> Package libquadmath.x86_64 0:4.8.5-11.el7 will be updated
---> Package libquadmath.x86_64 0:4.8.5-44.el7 will be an update
---> Package openssl.x86_64 1:1.0.1e-60.el7 will be updated
---> Package openssl.x86_64 1:1.0.2k-22.el7_9 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

 Package                             Arch                     Version                                 Repository                            Size
 kernel-devel                        x86_64                   3.10.0-1160.49.1.el7                    rhel-7-server-rpms                    18 M
 binutils                            x86_64                   2.27-44.base.el7_9.1                    rhel-7-server-rpms                   5.9 M
 cpp                                 x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   6.0 M
 gcc                                 x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                    16 M
 gcc-c++                             x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   7.2 M
 ksh                                 x86_64                   20120801-143.el7_9                      rhel-7-server-rpms                   885 k
 lsscsi                              x86_64                   0.27-6.el7                              rhel-7-server-rpms                    47 k
 ntp                                 x86_64                   4.2.6p5-29.el7_8.2                      rhel-7-server-rpms                   549 k
 openssh                             x86_64                   7.4p1-22.el7_9                          rhel-7-server-rpms                   510 k
 patch                               x86_64                   2.7.1-12.el7_7                          rhel-7-server-rpms                   111 k
 sg3_utils                           x86_64                   1:1.37-19.el7                           rhel-7-server-rpms                   646 k
Updating for dependencies:
 gcc-gfortran                        x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   6.7 M
 libgcc                              i686                     4.8.5-44.el7                            rhel-7-server-rpms                   111 k
 libgcc                              x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   103 k
 libgfortran                         x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   301 k
 libgomp                             x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   159 k
 libquadmath                         x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   190 k
 libquadmath-devel                   x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                    54 k
 libstdc++                           i686                     4.8.5-44.el7                            rhel-7-server-rpms                   319 k
 libstdc++                           x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   306 k
 libstdc++-devel                     x86_64                   4.8.5-44.el7                            rhel-7-server-rpms                   1.5 M
 ntpdate                             x86_64                   4.2.6p5-29.el7_8.2                      rhel-7-server-rpms                    87 k
 openssh-clients                     x86_64                   7.4p1-22.el7_9                          rhel-7-server-rpms                   655 k
 openssh-server                      x86_64                   7.4p1-22.el7_9                          rhel-7-server-rpms                   459 k
 openssl                             x86_64                   1:1.0.2k-22.el7_9                       rhel-7-server-rpms                   494 k
 openssl-libs                        x86_64                   1:1.0.2k-22.el7_9                       rhel-7-server-rpms                   1.2 M
 sg3_utils-libs                      x86_64                   1:1.37-19.el7                           rhel-7-server-rpms                    65 k

Transaction Summary
Install   1 Package
Upgrade  10 Packages (+16 Dependent packages)

Total download size: 69 M
Is this ok [y/d/N]: y
Downloading packages:
No Presto metadata available for rhel-7-server-rpms
(1/27): binutils-2.27-44.base.el7_9.1.x86_64.rpm                                                                          | 5.9 MB  00:00:02
(2/27): cpp-4.8.5-44.el7.x86_64.rpm                                                                                       | 6.0 MB  00:00:03
(3/27): gcc-4.8.5-44.el7.x86_64.rpm                                                                                       |  16 MB  00:00:02
(4/27): gcc-c++-4.8.5-44.el7.x86_64.rpm                                                                                   | 7.2 MB  00:00:02
(5/27): gcc-gfortran-4.8.5-44.el7.x86_64.rpm                                                                              | 6.7 MB  00:00:03
(6/27): kernel-devel-3.10.0-1160.49.1.el7.x86_64.rpm                                                                      |  18 MB  00:00:03
(7/27): libgcc-4.8.5-44.el7.i686.rpm                                                                                      | 111 kB  00:00:01
(8/27): ksh-20120801-143.el7_9.x86_64.rpm                                                                                 | 885 kB  00:00:02
(9/27): libgcc-4.8.5-44.el7.x86_64.rpm                                                                                    | 103 kB  00:00:01
(10/27): libgfortran-4.8.5-44.el7.x86_64.rpm                                                                              | 301 kB  00:00:02
(11/27): libgomp-4.8.5-44.el7.x86_64.rpm                                                                                  | 159 kB  00:00:01
(12/27): libquadmath-4.8.5-44.el7.x86_64.rpm                                                                              | 190 kB  00:00:01
(13/27): libquadmath-devel-4.8.5-44.el7.x86_64.rpm                                                                        |  54 kB  00:00:01
(14/27): libstdc++-4.8.5-44.el7.i686.rpm                                                                                  | 319 kB  00:00:01
(15/27): libstdc++-4.8.5-44.el7.x86_64.rpm                                                                                | 306 kB  00:00:01
(16/27): lsscsi-0.27-6.el7.x86_64.rpm                                                                                     |  47 kB  00:00:01
(17/27): libstdc++-devel-4.8.5-44.el7.x86_64.rpm                                                                          | 1.5 MB  00:00:02
(18/27): ntp-4.2.6p5-29.el7_8.2.x86_64.rpm                                                                                | 549 kB  00:00:02
(19/27): ntpdate-4.2.6p5-29.el7_8.2.x86_64.rpm                                                                            |  87 kB  00:00:02
(20/27): openssh-7.4p1-22.el7_9.x86_64.rpm                                                                                | 510 kB  00:00:01
(21/27): openssh-clients-7.4p1-22.el7_9.x86_64.rpm                                                                        | 655 kB  00:00:01
(22/27): openssh-server-7.4p1-22.el7_9.x86_64.rpm                                                                         | 459 kB  00:00:02
(23/27): openssl-1.0.2k-22.el7_9.x86_64.rpm                                                                               | 494 kB  00:00:02
(24/27): openssl-libs-1.0.2k-22.el7_9.x86_64.rpm                                                                          | 1.2 MB  00:00:02
(25/27): patch-2.7.1-12.el7_7.x86_64.rpm                                                                                  | 111 kB  00:00:01
(26/27): sg3_utils-1.37-19.el7.x86_64.rpm                                                                                 | 646 kB  00:00:02
(27/27): sg3_utils-libs-1.37-19.el7.x86_64.rpm                                                                            |  65 kB  00:00:01
Total                                                                                                            2.3 MB/s |  69 MB  00:00:29
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : 1:openssl-libs-1.0.2k-22.el7_9.x86_64                                                                                        1/53
  Updating   : libgcc-4.8.5-44.el7.x86_64                                                                                                   2/53
  Updating   : libquadmath-4.8.5-44.el7.x86_64                                                                                              3/53
  Updating   : libstdc++-4.8.5-44.el7.x86_64                                                                                                4/53
  Updating   : openssh-7.4p1-22.el7_9.x86_64                                                                                                5/53
  Updating   : libstdc++-devel-4.8.5-44.el7.x86_64                                                                                          6/53
  Updating   : libgfortran-4.8.5-44.el7.x86_64                                                                                              7/53
  Updating   : ntpdate-4.2.6p5-29.el7_8.2.x86_64                                                                                            8/53
  Updating   : libgomp-4.8.5-44.el7.x86_64                                                                                                  9/53
  Updating   : binutils-2.27-44.base.el7_9.1.x86_64                                                                                        10/53
  Updating   : cpp-4.8.5-44.el7.x86_64                                                                                                     11/53
  Updating   : gcc-4.8.5-44.el7.x86_64                                                                                                     12/53
  Updating   : libquadmath-devel-4.8.5-44.el7.x86_64                                                                                       13/53
  Updating   : 1:sg3_utils-libs-1.37-19.el7.x86_64                                                                                         14/53
  Updating   : 1:sg3_utils-1.37-19.el7.x86_64                                                                                              15/53
  Updating   : gcc-gfortran-4.8.5-44.el7.x86_64                                                                                            16/53
  Updating   : gcc-c++-4.8.5-44.el7.x86_64                                                                                                 17/53
  Updating   : ntp-4.2.6p5-29.el7_8.2.x86_64                                                                                               18/53
  Updating   : openssh-clients-7.4p1-22.el7_9.x86_64                                                                                       19/53
  Updating   : openssh-server-7.4p1-22.el7_9.x86_64                                                                                        20/53
  Updating   : 1:openssl-1.0.2k-22.el7_9.x86_64                                                                                            21/53
  Updating   : lsscsi-0.27-6.el7.x86_64                                                                                                    22/53
  Updating   : ksh-20120801-143.el7_9.x86_64                                                                                               23/53
  Updating   : patch-2.7.1-12.el7_7.x86_64                                                                                                 24/53
  Installing : kernel-devel-3.10.0-1160.49.1.el7.x86_64                                                                                    25/53
  Updating   : libgcc-4.8.5-44.el7.i686                                                                                                    26/53
  Updating   : libstdc++-4.8.5-44.el7.i686                                                                                                 27/53
  Cleanup    : gcc-gfortran-4.8.5-11.el7.x86_64                                                                                            28/53
  Cleanup    : gcc-c++-4.8.5-11.el7.x86_64                                                                                                 29/53
  Cleanup    : libquadmath-devel-4.8.5-11.el7.x86_64                                                                                       30/53
  Cleanup    : gcc-4.8.5-11.el7.x86_64                                                                                                     31/53
  Cleanup    : libgfortran-4.8.5-11.el7.x86_64                                                                                             32/53
  Cleanup    : ntp-4.2.6p5-25.el7.x86_64                                                                                                   33/53
  Cleanup    : openssh-server-6.6.1p1-31.el7.x86_64                                                                                        34/53
  Cleanup    : openssh-clients-6.6.1p1-31.el7.x86_64                                                                                       35/53
  Cleanup    : sg3_utils-1.37-9.el7.x86_64                                                                                                 36/53
  Cleanup    : libstdc++-devel-4.8.5-11.el7.x86_64                                                                                         37/53
  Cleanup    : libstdc++-4.8.5-11.el7                                                                                                      38/53
  Cleanup    : libstdc++-4.8.5-11.el7                                                                                                      39/53
  Cleanup    : openssh-6.6.1p1-31.el7.x86_64                                                                                               40/53
  Cleanup    : ntpdate-4.2.6p5-25.el7.x86_64                                                                                               41/53
  Cleanup    : binutils-2.25.1-22.base.el7.x86_64                                                                                          42/53
  Cleanup    : 1:openssl-1.0.1e-60.el7.x86_64                                                                                              43/53
  Cleanup    : libgcc-4.8.5-11.el7                                                                                                         44/53
  Cleanup    : 1:openssl-libs-1.0.1e-60.el7.x86_64                                                                                         45/53
  Cleanup    : libgcc-4.8.5-11.el7                                                                                                         46/53
  Cleanup    : sg3_utils-libs-1.37-9.el7.x86_64                                                                                            47/53
  Cleanup    : libquadmath-4.8.5-11.el7.x86_64                                                                                             48/53
  Cleanup    : cpp-4.8.5-11.el7.x86_64                                                                                                     49/53
  Cleanup    : libgomp-4.8.5-11.el7.x86_64                                                                                                 50/53
  Cleanup    : lsscsi-0.27-4.el7.x86_64                                                                                                    51/53
  Cleanup    : ksh-20120801-26.el7.x86_64                                                                                                  52/53
  Cleanup    : patch-2.7.1-8.el7.x86_64                                                                                                    53/53
rhel-7-server-rpms/7Server/x86_64/productid                                                                               | 2.1 kB  00:00:00
  Verifying  : 1:sg3_utils-1.37-19.el7.x86_64                                                                                               1/53
  Verifying  : gcc-c++-4.8.5-44.el7.x86_64                                                                                                  2/53
  Verifying  : gcc-gfortran-4.8.5-44.el7.x86_64                                                                                             3/53
  Verifying  : kernel-devel-3.10.0-1160.49.1.el7.x86_64                                                                                     4/53
  Verifying  : libquadmath-devel-4.8.5-44.el7.x86_64                                                                                        5/53
  Verifying  : openssh-7.4p1-22.el7_9.x86_64                                                                                                6/53
  Verifying  : libgcc-4.8.5-44.el7.i686                                                                                                     7/53
  Verifying  : libquadmath-4.8.5-44.el7.x86_64                                                                                              8/53
  Verifying  : 1:sg3_utils-libs-1.37-19.el7.x86_64                                                                                          9/53
  Verifying  : 1:openssl-1.0.2k-22.el7_9.x86_64                                                                                            10/53
  Verifying  : cpp-4.8.5-44.el7.x86_64                                                                                                     11/53
  Verifying  : libstdc++-devel-4.8.5-44.el7.x86_64                                                                                         12/53
  Verifying  : patch-2.7.1-12.el7_7.x86_64                                                                                                 13/53
  Verifying  : binutils-2.27-44.base.el7_9.1.x86_64                                                                                        14/53
  Verifying  : libgfortran-4.8.5-44.el7.x86_64                                                                                             15/53
  Verifying  : gcc-4.8.5-44.el7.x86_64                                                                                                     16/53
  Verifying  : openssh-clients-7.4p1-22.el7_9.x86_64                                                                                       17/53
  Verifying  : libstdc++-4.8.5-44.el7.i686                                                                                                 18/53
  Verifying  : ksh-20120801-143.el7_9.x86_64                                                                                               19/53
  Verifying  : ntpdate-4.2.6p5-29.el7_8.2.x86_64                                                                                           20/53
  Verifying  : 1:openssl-libs-1.0.2k-22.el7_9.x86_64                                                                                       21/53
  Verifying  : lsscsi-0.27-6.el7.x86_64                                                                                                    22/53
  Verifying  : libgcc-4.8.5-44.el7.x86_64                                                                                                  23/53
  Verifying  : openssh-server-7.4p1-22.el7_9.x86_64                                                                                        24/53
  Verifying  : libstdc++-4.8.5-44.el7.x86_64                                                                                               25/53
  Verifying  : libgomp-4.8.5-44.el7.x86_64                                                                                                 26/53
  Verifying  : ntp-4.2.6p5-29.el7_8.2.x86_64                                                                                               27/53
  Verifying  : gcc-c++-4.8.5-11.el7.x86_64                                                                                                 28/53
  Verifying  : sg3_utils-libs-1.37-9.el7.x86_64                                                                                            29/53
  Verifying  : cpp-4.8.5-11.el7.x86_64                                                                                                     30/53
  Verifying  : libstdc++-4.8.5-11.el7.x86_64                                                                                               31/53
  Verifying  : 1:openssl-1.0.1e-60.el7.x86_64                                                                                              32/53
  Verifying  : libgcc-4.8.5-11.el7.i686                                                                                                    33/53
  Verifying  : 1:openssl-libs-1.0.1e-60.el7.x86_64                                                                                         34/53
  Verifying  : sg3_utils-1.37-9.el7.x86_64                                                                                                 35/53
  Verifying  : binutils-2.25.1-22.base.el7.x86_64                                                                                          36/53
  Verifying  : libgfortran-4.8.5-11.el7.x86_64                                                                                             37/53
  Verifying  : ntp-4.2.6p5-25.el7.x86_64                                                                                                   38/53
  Verifying  : openssh-server-6.6.1p1-31.el7.x86_64                                                                                        39/53
  Verifying  : patch-2.7.1-8.el7.x86_64                                                                                                    40/53
  Verifying  : libquadmath-devel-4.8.5-11.el7.x86_64                                                                                       41/53
  Verifying  : openssh-clients-6.6.1p1-31.el7.x86_64                                                                                       42/53
  Verifying  : libquadmath-4.8.5-11.el7.x86_64                                                                                             43/53
  Verifying  : ntpdate-4.2.6p5-25.el7.x86_64                                                                                               44/53
  Verifying  : lsscsi-0.27-4.el7.x86_64                                                                                                    45/53
  Verifying  : libgcc-4.8.5-11.el7.x86_64                                                                                                  46/53
  Verifying  : gcc-gfortran-4.8.5-11.el7.x86_64                                                                                            47/53
  Verifying  : openssh-6.6.1p1-31.el7.x86_64                                                                                               48/53
  Verifying  : libstdc++-4.8.5-11.el7.i686                                                                                                 49/53
  Verifying  : ksh-20120801-26.el7.x86_64                                                                                                  50/53
  Verifying  : libstdc++-devel-4.8.5-11.el7.x86_64                                                                                         51/53
  Verifying  : libgomp-4.8.5-11.el7.x86_64                                                                                                 52/53
  Verifying  : gcc-4.8.5-11.el7.x86_64                                                                                                     53/53

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

  binutils.x86_64 0:2.27-44.base.el7_9.1   cpp.x86_64 0:4.8.5-44.el7        gcc.x86_64 0:4.8.5-44.el7         gcc-c++.x86_64 0:4.8.5-44.el7
  ksh.x86_64 0:20120801-143.el7_9          lsscsi.x86_64 0:0.27-6.el7       ntp.x86_64 0:4.2.6p5-29.el7_8.2   openssh.x86_64 0:7.4p1-22.el7_9
  patch.x86_64 0:2.7.1-12.el7_7            sg3_utils.x86_64 1:1.37-19.el7

Dependency Updated:
  gcc-gfortran.x86_64 0:4.8.5-44.el7               libgcc.i686 0:4.8.5-44.el7                   libgcc.x86_64 0:4.8.5-44.el7
  libgfortran.x86_64 0:4.8.5-44.el7                libgomp.x86_64 0:4.8.5-44.el7                libquadmath.x86_64 0:4.8.5-44.el7
  libquadmath-devel.x86_64 0:4.8.5-44.el7          libstdc++.i686 0:4.8.5-44.el7                libstdc++.x86_64 0:4.8.5-44.el7
  libstdc++-devel.x86_64 0:4.8.5-44.el7            ntpdate.x86_64 0:4.2.6p5-29.el7_8.2          openssh-clients.x86_64 0:7.4p1-22.el7_9
  openssh-server.x86_64 0:7.4p1-22.el7_9           openssl.x86_64 1:1.0.2k-22.el7_9             openssl-libs.x86_64 1:1.0.2k-22.el7_9
  sg3_utils-libs.x86_64 1:1.37-19.el7

[root@db2psdev02 ~]#

Check Mysql Databases Size

Minggu, 28 November 2021

Check Databases and Tables Size Mysql MariaDB

  Tidak ada komentar

Check Mysql Databases Size

MariaDB [(none)]> show databases;
| Database            |
| information_schema  |
| mysql               |
| performance_schema  |
| portal_final |
4 rows in set (0.00 sec)

MariaDB [(none)]>
MariaDB [(none)]> SELECT table_schema "DB Name",
    ->         ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    -> FROM information_schema.tables
    -> GROUP BY table_schema;
| DB Name             | DB Size in MB |
| information_schema  |           0.1 |
| mysql               |           0.6 |
| performance_schema  |           0.0 |
| portal_final        |        2477.2 |
4 rows in set, 2 warnings (0.15 sec)

MariaDB [(none)]> exit

Check Mysql Table Size

MariaDB [(none)]> SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "ilk3db" ORDER BY (data_length + index_length) DESC;
| Table          | Size (MB) |
| pkk_rambutan   |    598.67 |
| pkk_melon      |    536.73 |
| m_apel         |     19.61 |
| m_jeruk        |      2.34 |
4 rows in set (0.001 sec)

MariaDB [(none)]>

How to create and update IBM Domino Keyring

  Tidak ada komentar

Create new keyring

C:\Program Files (x86)\HCL\Notes>kyrtool.exe create -k "C:\Program Files (x86)\HCL\Notes\keyring.kyr" -p password

Keyfile C:\Program Files (x86)\HCL\Notes\keyring.kyr created successfully

Merge key and pem certificate to server.txt

C:\Program Files (x86)\HCL\Notes>type mykey.key my.pem>server.txt



Verify the certificate

C:\Program Files (x86)\HCL\Notes>kyrtool.exe verify "C:\Program Files (x86)\HCL\Notes\server.txt"

KyrTool v1.1

Successfully read 2048 bit RSA private key
INFO: Successfully read 2 certificates
ERROR: Private key does not match leaf certificate
ERROR: IssuerName of cert 0 does NOT match the SubjectName of cert 1
WARNING: Final certificate in chain is not self-signed

Import the certificate to keyring

C:\Program Files (x86)\HCL\Notes>kyrtool import all -k "C:\Users\myuser\OneDrive - Office 365 Original\Documents\mykeyring.kyr" -i "C:\Program Files (x86)\HCL\Notes\server.txt"
Using keyring path 'C:\Users\myuser\OneDrive - Office 365 Original\Documents\mykeyring.kyr'
Successfully read 2048 bit RSA private key SECIssUpdateKeyringPrivateKey succeeded SECIssUpdateKeyringLeafCert succeeded C:\Program Files (x86)\HCL\Notes>

Finish, if you want to update ssl on existing keyring, here the command

Update old keyring with new ssl certificate

C:\Program Files (x86)\HCL\Notes>kyrtool import all -k "C:\Users\myuser\OneDrive - Office 365 Original\Documents\myold.kyr" -i "C:\Program Files (x86)\HCL\Notes\server2.txt"

Using keyring path 'C:\Users\myuser\OneDrive - Office 365 Original\Documents\myold.kyr'
Successfully read 2048 bit RSA private key SECIssUpdateKeyringPrivateKey succeeded SECIssUpdateKeyringLeafCert succeeded C:\Program Files (x86)\HCL\Notes>

Jumat, 17 September 2021

How to upgrade Vmware Esxi 6.5 to 6.7

  Tidak ada komentar

Execute command bellow

[root@localhost:~] esxcli software vib update -d /vmfs/volumes/datastore1/Upgrade\ Esxi/VMware-ESXi-6.7.0-8169922-LNV-20180408.zip
Installation Result
   Message: The update completed successfully, but the system needs to be rebooted for the changes to be effective.
   Reboot Required: true
   VIBs Installed: ELX_bootbank_elx-esx-libelxima.so_11.4.1210.0-03, EMU_bootbank_brcmfcoe_11.4.1216.0-1OEM.650.0.0.4598673, EMU_bootbank_elxiscsi_11.4.1210.0-1OEM.650.0.0.4598673, EMU_bootbank_elxnet_11.4.1205.0-1OEM.650.0.0.4598673, Lenovo_bootbank_lnvcustomization_6.70-20.1, VMW_bootbank_ata-libata-92_3.00.9.2-16vmw.670.0.0.8169922, VMW_bootbank_ata-pata-amd_0.3.10-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-atiixp_0.4.6-4vmw.670.0.0.8169922, VMW_bootbank_ata-pata-cmd64x_0.2.5-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-hpt3x2n_0.3.4-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-pdc2027x_1.0-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-serverworks_0.4.3-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-sil680_0.4.8-3vmw.670.0.0.8169922, VMW_bootbank_ata-pata-via_0.3.3-2vmw.670.0.0.8169922, VMW_bootbank_block-cciss_3.6.14-10vmw.670.0.0.8169922, VMW_bootbank_bnxtnet_20.6.101.7-11vmw.670.0.0.8169922, VMW_bootbank_char-random_1.0-3vmw.670.0.0.8169922, VMW_bootbank_ehci-ehci-hcd_1.0-4vmw.670.0.0.8169922, VMW_bootbank_hid-hid_1.0-3vmw.670.0.0.8169922, VMW_bootbank_ima-qla4xxx_2.02.18-1vmw.670.0.0.8169922, VMW_bootbank_ipmi-ipmi-devintf_39.1-4vmw.670.0.0.8169922, VMW_bootbank_ipmi-ipmi-msghandler_39.1-4vmw.670.0.0.8169922, VMW_bootbank_ipmi-ipmi-si-drv_39.1-4vmw.670.0.0.8169922, VMW_bootbank_lpfc_11.4.33.1-6vmw.670.0.0.8169922, VMW_bootbank_lsi-mr3_7.702.13.00-4vmw.670.0.0.8169922, VMW_bootbank_lsi-msgpt2_20.00.04.00-4vmw.670.0.0.8169922, VMW_bootbank_lsi-msgpt35_03.00.01.00-10vmw.670.0.0.8169922, VMW_bootbank_lsi-msgpt3_16.00.01.00-1vmw.670.0.0.8169922, VMW_bootbank_misc-cnic-register_1.78.75.v60.7-1vmw.670.0.0.8169922, VMW_bootbank_misc-drivers_6.7.0-0.0.8169922, VMW_bootbank_mtip32xx-native_3.9.6-1vmw.670.0.0.8169922, VMW_bootbank_ne1000_0.8.3-4vmw.670.0.0.8169922, VMW_bootbank_nenic_1.0.11.0-1vmw.670.0.0.8169922, VMW_bootbank_net-bnx2_2.2.4f.v60.10-2vmw.670.0.0.8169922, VMW_bootbank_net-cdc-ether_1.0-3vmw.670.0.0.8169922, VMW_bootbank_net-cnic_1.78.76.v60.13-2vmw.670.0.0.8169922, VMW_bootbank_net-e1000_8.0.3.1-5vmw.670.0.0.8169922, VMW_bootbank_net-e1000e_3.2.2.1-2vmw.670.0.0.8169922, VMW_bootbank_net-enic_2.1.2.38-2vmw.670.0.0.8169922, VMW_bootbank_net-fcoe_1., VMW_bootbank_net-forcedeth_0.61-2vmw.670.0.0.8169922, VMW_bootbank_net-libfcoe-92_1., VMW_bootbank_net-mlx4-core_1.9.7.0-1vmw.670.0.0.8169922, VMW_bootbank_net-mlx4-en_1.9.7.0-1vmw.670.0.0.8169922, VMW_bootbank_net-nx-nic_5.0.621-5vmw.670.0.0.8169922, VMW_bootbank_net-tg3_3.131d.v60.4-2vmw.670.0.0.8169922, VMW_bootbank_net-usbnet_1.0-3vmw.670.0.0.8169922, VMW_bootbank_net-vmxnet3_1.1.3.0-3vmw.670.0.0.8169922, VMW_bootbank_nhpsa_2.0.22-1vmw.670.0.0.8169922, VMW_bootbank_nmlx4-core_3.17.9.12-1vmw.670.0.0.8169922, VMW_bootbank_nmlx4-en_3.17.9.12-1vmw.670.0.0.8169922, VMW_bootbank_nmlx4-rdma_3.17.9.12-1vmw.670.0.0.8169922, VMW_bootbank_nmlx5-core_4.17.9.12-1vmw.670.0.0.8169922, VMW_bootbank_ntg3_4.1.3.0-1vmw.670.0.0.8169922, VMW_bootbank_nvme_1.2.1.34-1vmw.670.0.0.8169922, VMW_bootbank_nvmxnet3_2.0.0.27-1vmw.670.0.0.8169922, VMW_bootbank_ohci-usb-ohci_1.0-3vmw.670.0.0.8169922, VMW_bootbank_pvscsi_0.1-2vmw.670.0.0.8169922, VMW_bootbank_qedentv_2.0.6.4-8vmw.670.0.0.8169922, VMW_bootbank_qfle3_1.0.50.11-9vmw.670.0.0.8169922, VMW_bootbank_qflge_1.1.0.11-1vmw.670.0.0.8169922, VMW_bootbank_sata-ahci_3.0-26vmw.670.0.0.8169922, VMW_bootbank_sata-ata-piix_2.12-10vmw.670.0.0.8169922, VMW_bootbank_sata-sata-nv_3.5-4vmw.670.0.0.8169922, VMW_bootbank_sata-sata-promise_2.12-3vmw.670.0.0.8169922, VMW_bootbank_sata-sata-sil24_1.1-1vmw.670.0.0.8169922, VMW_bootbank_sata-sata-sil_2.3-4vmw.670.0.0.8169922, VMW_bootbank_sata-sata-svw_2.3-3vmw.670.0.0.8169922, VMW_bootbank_scsi-aacraid_1.1.5.1-9vmw.670.0.0.8169922, VMW_bootbank_scsi-adp94xx_1.0.8.12-6vmw.670.0.0.8169922, VMW_bootbank_scsi-aic79xx_3.1-6vmw.670.0.0.8169922, VMW_bootbank_scsi-bnx2fc_1.78.78.v60.8-1vmw.670.0.0.8169922, VMW_bootbank_scsi-bnx2i_2.78.76.v60.8-1vmw.670.0.0.8169922, VMW_bootbank_scsi-fnic_1.5.0.45-3vmw.670.0.0.8169922, VMW_bootbank_scsi-hpsa_6.0.0.84-3vmw.670.0.0.8169922, VMW_bootbank_scsi-ips_7.12.05-4vmw.670.0.0.8169922, VMW_bootbank_scsi-iscsi-linux-92_1.0.0.2-3vmw.670.0.0.8169922, VMW_bootbank_scsi-libfc-92_1., VMW_bootbank_scsi-megaraid-mbox_2.20.5.1-6vmw.670.0.0.8169922, VMW_bootbank_scsi-megaraid-sas_6.603.55.00-2vmw.670.0.0.8169922, VMW_bootbank_scsi-megaraid2_2.00.4-9vmw.670.0.0.8169922, VMW_bootbank_scsi-mpt2sas_19.00.00.00-2vmw.670.0.0.8169922, VMW_bootbank_scsi-mptsas_4.23.01.00-10vmw.670.0.0.8169922, VMW_bootbank_scsi-mptspi_4.23.01.00-10vmw.670.0.0.8169922, VMW_bootbank_scsi-qla4xxx_5.01.03.2-7vmw.670.0.0.8169922, VMW_bootbank_shim-iscsi-linux-9-2-1-0_6.7.0-0.0.8169922, VMW_bootbank_shim-iscsi-linux-9-2-2-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libata-9-2-1-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libata-9-2-2-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libfc-9-2-1-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libfc-9-2-2-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libfcoe-9-2-1-0_6.7.0-0.0.8169922, VMW_bootbank_shim-libfcoe-9-2-2-0_6.7.0-0.0.8169922, VMW_bootbank_shim-vmklinux-9-2-1-0_6.7.0-0.0.8169922, VMW_bootbank_shim-vmklinux-9-2-2-0_6.7.0-0.0.8169922, VMW_bootbank_shim-vmklinux-9-2-3-0_6.7.0-0.0.8169922, VMW_bootbank_uhci-usb-uhci_1.0-3vmw.670.0.0.8169922, VMW_bootbank_usb-storage-usb-storage_1.0-3vmw.670.0.0.8169922, VMW_bootbank_usbcore-usb_1.0-3vmw.670.0.0.8169922, VMW_bootbank_vmkata_0.1-1vmw.670.0.0.8169922, VMW_bootbank_vmkplexer-vmkplexer_6.7.0-0.0.8169922, VMW_bootbank_vmkusb_0.1-1vmw.670.0.0.8169922, VMW_bootbank_vmw-ahci_1.2.0-6vmw.670.0.0.8169922, VMW_bootbank_xhci-xhci_1.0-3vmw.670.0.0.8169922, VMware_bootbank_cpu-microcode_6.7.0-0.0.8169922, VMware_bootbank_esx-base_6.7.0-0.0.8169922, VMware_bootbank_esx-dvfilter-generic-fastpath_6.7.0-0.0.8169922, VMware_bootbank_esx-ui_1.25.0-7872652, VMware_bootbank_esx-xserver_6.7.0-0.0.8169922, VMware_bootbank_lsu-hp-hpsa-plugin_2.0.0-13vmw.670.0.0.8169922, VMware_bootbank_lsu-lsi-lsi-mr3-plugin_1.0.0-12vmw.670.0.0.8169922, VMware_bootbank_lsu-lsi-lsi-msgpt3-plugin_1.0.0-8vmw.670.0.0.8169922, VMware_bootbank_lsu-lsi-megaraid-sas-plugin_1.0.0-9vmw.670.0.0.8169922, VMware_bootbank_lsu-lsi-mpt2sas-plugin_2.0.0-7vmw.670.0.0.8169922, VMware_bootbank_native-misc-drivers_6.7.0-0.0.8169922, VMware_bootbank_qlnativefc_3.0.1.0-5vmw.670.0.0.8169922, VMware_bootbank_rste_2.0.2.0088-7vmw.670.0.0.8169922, VMware_bootbank_vmware-esx-esxcli-nvme-plugin_1.2.0.32-0.0.8169922, VMware_bootbank_vsan_6.7.0-0.0.8169922, VMware_bootbank_vsanhealth_6.7.0-0.0.8169922, VMware_locker_tools-light_10.2.0.7253323-8169922
   VIBs Removed: Avago_bootbank_lsi-mr3_7.700.24.00-1OEM.650.0.0.4598673, Avago_bootbank_lsi-msgpt35_01.00.04.00-1OEM.650.0.0.4598673, BCM_bootbank_bnxtnet_20.6.101.0-1OEM.650.0.0.4598673, ELX_bootbank_elx-esx-libelxima.so_11.2.1152.0-03, EMU_bootbank_brcmfcoe_11.2.1153.13-1OEM.650.0.0.4240417, EMU_bootbank_elxiscsi_11.2.1152.0-1OEM.650.0.0.4240417, EMU_bootbank_elxnet_11.2.1149.0-1OEM.650.0.0.4240417, EMU_bootbank_lpfc_11.2.156.20-1OEM.650.0.0.4240417, Lenovo_bootbank_lnvcustomization_6.5-02, MEL_bootbank_nmlx4-core_3.15.5.5-1OEM.600.0.0.2768847, MEL_bootbank_nmlx4-en_3.15.5.5-1OEM.600.0.0.2768847, MEL_bootbank_nmlx4-rdma_3.15.5.5-1OEM.600.0.0.2768847, MEL_bootbank_nmlx5-core_4.16.8.8-1OEM.650.0.0.4598673, QLC_bootbank_qfle3_1.0.28.0-1OEM.650.0.0.4240417, QLogic_bootbank_qlnativefc_2.1.50.0-1OEM.600.0.0.2768847, VMW_bootbank_ata-libata-92_3.00.9.2-16vmw.650.0.0.4564106, VMW_bootbank_ata-pata-amd_0.3.10-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-atiixp_0.4.6-4vmw.650.0.0.4564106, VMW_bootbank_ata-pata-cmd64x_0.2.5-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-hpt3x2n_0.3.4-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-pdc2027x_1.0-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-serverworks_0.4.3-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-sil680_0.4.8-3vmw.650.0.0.4564106, VMW_bootbank_ata-pata-via_0.3.3-2vmw.650.0.0.4564106, VMW_bootbank_block-cciss_3.6.14-10vmw.650.0.0.4564106, VMW_bootbank_char-random_1.0-3vmw.650.0.0.4564106, VMW_bootbank_ehci-ehci-hcd_1.0-4vmw.650.0.14.5146846, VMW_bootbank_hid-hid_1.0-3vmw.650.0.0.4564106, VMW_bootbank_ima-qla4xxx_2.02.18-1vmw.650.0.0.4564106, VMW_bootbank_ipmi-ipmi-devintf_39.1-4vmw.650.0.0.4564106, VMW_bootbank_ipmi-ipmi-msghandler_39.1-4vmw.650.0.0.4564106, VMW_bootbank_ipmi-ipmi-si-drv_39.1-4vmw.650.0.0.4564106, VMW_bootbank_lsi-msgpt2_20.00.01.00-3vmw.650.0.0.4564106, VMW_bootbank_lsi-msgpt3_12.00.02.00-11vmw.650.0.0.4564106, VMW_bootbank_misc-cnic-register_1.78.75.v60.7-1vmw.650.0.0.4564106, VMW_bootbank_misc-drivers_6.5.0-0.14.5146846, VMW_bootbank_mtip32xx-native_3.9.5-1vmw.650.0.0.4564106, VMW_bootbank_ne1000_0.8.0-11vmw.650.0.14.5146846, VMW_bootbank_nenic_1.0.0.2-1vmw.650.0.0.4564106, VMW_bootbank_net-bnx2_2.2.4f.v60.10-2vmw.650.0.0.4564106, VMW_bootbank_net-cdc-ether_1.0-3vmw.650.0.0.4564106, VMW_bootbank_net-cnic_1.78.76.v60.13-2vmw.650.0.0.4564106, VMW_bootbank_net-e1000_8.0.3.1-5vmw.650.0.0.4564106, VMW_bootbank_net-e1000e_3.2.2.1-2vmw.650.0.0.4564106, VMW_bootbank_net-enic_2.1.2.38-2vmw.650.0.0.4564106, VMW_bootbank_net-fcoe_1., VMW_bootbank_net-forcedeth_0.61-2vmw.650.0.0.4564106, VMW_bootbank_net-libfcoe-92_1., VMW_bootbank_net-mlx4-core_1.9.7.0-1vmw.650.0.0.4564106, VMW_bootbank_net-mlx4-en_1.9.7.0-1vmw.650.0.0.4564106, VMW_bootbank_net-nx-nic_5.0.621-5vmw.650.0.0.4564106, VMW_bootbank_net-tg3_3.131d.v60.4-2vmw.650.0.0.4564106, VMW_bootbank_net-usbnet_1.0-3vmw.650.0.0.4564106, VMW_bootbank_net-vmxnet3_1.1.3.0-3vmw.650.0.0.4564106, VMW_bootbank_nhpsa_2.0.6-3vmw.650.0.0.4564106, VMW_bootbank_ntg3_4.1.0.0-1vmw.650.0.0.4564106, VMW_bootbank_nvme_1.2.0.32-2vmw.650.0.0.4564106, VMW_bootbank_nvmxnet3_2.0.0.22-1vmw.650.0.0.4564106, VMW_bootbank_ohci-usb-ohci_1.0-3vmw.650.0.0.4564106, VMW_bootbank_pvscsi_0.1-1vmw.650.0.0.4564106, VMW_bootbank_qedentv_2.0.3.29-1vmw.650.0.0.4564106, VMW_bootbank_qflge_1.1.0.3-1vmw.650.0.0.4564106, VMW_bootbank_sata-ahci_3.0-22vmw.650.0.0.4564106, VMW_bootbank_sata-ata-piix_2.12-10vmw.650.0.0.4564106, VMW_bootbank_sata-sata-nv_3.5-4vmw.650.0.0.4564106, VMW_bootbank_sata-sata-promise_2.12-3vmw.650.0.0.4564106, VMW_bootbank_sata-sata-sil24_1.1-1vmw.650.0.0.4564106, VMW_bootbank_sata-sata-sil_2.3-4vmw.650.0.0.4564106, VMW_bootbank_sata-sata-svw_2.3-3vmw.650.0.0.4564106, VMW_bootbank_scsi-aacraid_1.1.5.1-9vmw.650.0.0.4564106, VMW_bootbank_scsi-adp94xx_1.0.8.12-6vmw.650.0.0.4564106, VMW_bootbank_scsi-aic79xx_3.1-5vmw.650.0.0.4564106, VMW_bootbank_scsi-bnx2fc_1.78.78.v60.8-1vmw.650.0.0.4564106, VMW_bootbank_scsi-bnx2i_2.78.76.v60.8-1vmw.650.0.0.4564106, VMW_bootbank_scsi-fnic_1.5.0.45-3vmw.650.0.0.4564106, VMW_bootbank_scsi-hpsa_6.0.0.84-1vmw.650.0.0.4564106, VMW_bootbank_scsi-ips_7.12.05-4vmw.650.0.0.4564106, VMW_bootbank_scsi-iscsi-linux-92_1.0.0.2-3vmw.650.0.0.4564106, VMW_bootbank_scsi-libfc-92_1., VMW_bootbank_scsi-megaraid-mbox_2.20.5.1-6vmw.650.0.0.4564106, VMW_bootbank_scsi-megaraid-sas_6.603.55.00-2vmw.650.0.0.4564106, VMW_bootbank_scsi-megaraid2_2.00.4-9vmw.650.0.0.4564106, VMW_bootbank_scsi-mpt2sas_19.00.00.00-1vmw.650.0.0.4564106, VMW_bootbank_scsi-mptsas_4.23.01.00-10vmw.650.0.0.4564106, VMW_bootbank_scsi-mptspi_4.23.01.00-10vmw.650.0.0.4564106, VMW_bootbank_scsi-qla4xxx_5.01.03.2-7vmw.650.0.0.4564106, VMW_bootbank_shim-iscsi-linux-9-2-1-0_6.5.0-0.0.4564106, VMW_bootbank_shim-iscsi-linux-9-2-2-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libata-9-2-1-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libata-9-2-2-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libfc-9-2-1-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libfc-9-2-2-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libfcoe-9-2-1-0_6.5.0-0.0.4564106, VMW_bootbank_shim-libfcoe-9-2-2-0_6.5.0-0.0.4564106, VMW_bootbank_shim-vmklinux-9-2-1-0_6.5.0-0.0.4564106, VMW_bootbank_shim-vmklinux-9-2-2-0_6.5.0-0.0.4564106, VMW_bootbank_shim-vmklinux-9-2-3-0_6.5.0-0.0.4564106, VMW_bootbank_uhci-usb-uhci_1.0-3vmw.650.0.0.4564106, VMW_bootbank_usb-storage-usb-storage_1.0-3vmw.650.0.0.4564106, VMW_bootbank_usbcore-usb_1.0-3vmw.650.0.0.4564106, VMW_bootbank_vmkata_0.1-1vmw.650.0.0.4564106, VMW_bootbank_vmkplexer-vmkplexer_6.5.0-0.0.4564106, VMW_bootbank_vmkusb_0.1-1vmw.650.0.14.5146846, VMW_bootbank_vmw-ahci_1.0.0-34vmw.650.0.14.5146846, VMW_bootbank_xhci-xhci_1.0-3vmw.650.0.0.4564106, VMware_bootbank_cpu-microcode_6.5.0-0.0.4564106, VMware_bootbank_esx-base_6.5.0-0.14.5146846, VMware_bootbank_esx-dvfilter-generic-fastpath_6.5.0-0.0.4564106, VMware_bootbank_esx-tboot_6.5.0-0.0.4564106, VMware_bootbank_esx-ui_1.15.0-5069532, VMware_bootbank_esx-xserver_6.5.0-0.0.4564106, VMware_bootbank_lsu-hp-hpsa-plugin_2.0.0-3vmw.650.0.0.4564106, VMware_bootbank_lsu-lsi-lsi-mr3-plugin_1.0.0-7vmw.650.0.0.4564106, VMware_bootbank_lsu-lsi-lsi-msgpt3-plugin_1.0.0-6vmw.650.0.0.4564106, VMware_bootbank_lsu-lsi-megaraid-sas-plugin_1.0.0-7vmw.650.0.0.4564106, VMware_bootbank_lsu-lsi-mpt2sas-plugin_2.0.0-5vmw.650.0.0.4564106, VMware_bootbank_native-misc-drivers_6.5.0-0.0.4564106, VMware_bootbank_rste_2.0.2.0088-4vmw.650.0.0.4564106, VMware_bootbank_vmware-esx-esxcli-nvme-plugin_1.2.0.10-0.0.4564106, VMware_bootbank_vsan_6.5.0-0.14.5146846, VMware_bootbank_vsanhealth_6.5.0-0.14.5146846, VMware_locker_tools-light_6.5.0-0.0.4564106
   VIBs Skipped: INT_bootbank_i40en_1.5.6-1OEM.650.0.0.4598673, INT_bootbank_igbn_1.4.1-1OEM.600.0.0.2768847, INT_bootbank_ixgben_1.6.5-1OEM.600.0.0.2768847, VMW_bootbank_iavmd_1.2.0.1011-2vmw.670.0.0.8169922, VMW_bootbank_iser_1.0.0.0-1vmw.670.0.0.8169922, VMW_bootbank_lpnic_11.4.59.0-1vmw.670.0.0.8169922, VMW_bootbank_net-bnx2x_1.78.80.v60.12-2vmw.670.0.0.8169922, VMW_bootbank_net-igb_5., VMW_bootbank_net-ixgbe_3., VMW_bootbank_nmlx5-rdma_4.17.9.12-1vmw.670.0.0.8169922, VMW_bootbank_nvmxnet3-ens_2.0.0.21-1vmw.670.0.0.8169922, VMW_bootbank_qcnic_1., VMW_bootbank_qfle3f_1., VMW_bootbank_qfle3i_1., VMW_bootbank_smartpqi_1.0.1.553-10vmw.670.0.0.8169922, VMW_bootbank_vmkfcoe_1.0.0.0-1vmw.670.0.0.8169922
[root@localhost:~] esxcli --version
Script 'esxcli' version: 6.5.0
Reboot the server
[root@localhost:~] reboot

Kamis, 29 Juli 2021

Rancher Rodeo XII - RKE - Helm3

  Tidak ada komentar


Welcome to the Rancher Rodeo RKE Edition.

In this scenario, we will be walking through installing Rancher in HA mode and deploying several workloads to a cluster provisioned by Rancher.

This scenario will be following the general HA installation instructions available here: High Availability (HA) Install

We will be using two virtual machines today, cluster01 and rancher01 which are located in the tabs in the panel to the right. rancher01 will run a Kubernetes cluster and Rancher, and cluster01 will run a Kubernetes cluster and the corresponding user workloads.

Note that there are two separate Kubernetes clusters at play here, the Rancher Kubernetes Cluster is dedicated to running Rancher, while the Workload Cluster is managed by Rancher and runs on a separate virtual machine.

Important Note: HobbyFarm will tear down your provisioned resources within 10 minutes if your laptop goes to sleep or you navigate off of the HobbyFarm page. Please ensure that you do not do this, for example, during lunch or you will need to restart your scenario.

There is Pause/Resume functionality built into HobbyFarm that will allow you to pause your scenario should you have to put your laptop to sleep temporarily. Please note that pausing the scenario will not extend the end of your resources beyond this Rodeo session.

Generate an SSH Keypair for use with RKE

To start out, we will generate a new SSH Keypair and place this keypair on the node we will install Kubernetes for Rancher onto. As we will be using the rancher01 node to run Rancher + Kubernetes, we will simply copy the public key into the authorized_keys file of this node.

The following command will generate the keypair and copy it into the file.

ssh-keygen -b 2048 -t rsa -f \
/home/ubuntu/.ssh/id_rsa -N ""
cat /home/ubuntu/.ssh/id_rsa.pub \
>> /home/ubuntu/.ssh/authorized_keys
 Click to run on Rancher01

Download RKE

Rancher Kubernetes Engine (RKE) is an extremely simple, lightning fast Kubernetes installer that works everywhere.

In this step, we will download the RKE CLI to the Rancher01 node.

sudo wget -O /usr/local/bin/rke \
 Click to run on Rancher01

In order to execute RKE, we need to mark it as executable.

sudo chmod +x /usr/local/bin/rke
 Click to run on Rancher01

Next, let's validate that RKE is installed properly:

rke -v
 Click to run on Rancher01

You should have an output similar to:

rke version v1.2.1

If you receive the output as expected, you can continue on to the next step.

Install kubectl

In order to interact with our Kubernetes cluster after we install it using rke, we need to install kubectl

The following command will add an apt repository and install kubectl.

sudo curl -L https://dl.k8s.io/release/v1.21.0/bin/linux/amd64/kubectl -o /usr/local/bin/kubectl
sudo chmod +x /usr/local/bin/kubectl
 Click to run on Rancher01

After the curl command finishes, we can test kubectl and make sure it is properly installed.

kubectl version --client
 Click to run on Rancher01

Install Helm

Helm 3 is a very popular package manager for Kubernetes. It is used as the installation tool for Rancher when deploying Rancher onto a Kubernetes cluster. In order to download Helm, we need to download the Helm tar.gz, move it into the appropriate directory, and mark it as executable. Finally, we will clean up the helm artifacts that are not necessary.

sudo wget -O helm.tar.gz \
sudo tar -zxf helm.tar.gz
sudo mv linux-amd64/helm /usr/local/bin/helm
sudo chmod +x /usr/local/bin/helm
sudo rm -rf linux-amd64
sudo rm -f helm.tar.gz
 Click to run on Rancher01

After a successful installation of Helm, we should check our installation to ensure that we are ready to install Rancher.

helm version --client
 Click to run on Rancher01

Create a rancher-cluster.yml file

RKE CLI uses a YAML-formatted file to describe the configuration of our cluster. The following command will heredoc write the corresponding file onto your rancher01 node, so that RKE will be able to install Kubernetes.

RKE uses SSH tunneling, which is why we generated the keypair in the first part of this scenario.

cat << EOF > rancher-cluster.yml
  - address:
    user: ubuntu
    role: [controlplane,etcd,worker]
addon_job_timeout: 120
 Click to run on Rancher01

Run rke up

We are now ready to run rke up to install Kubernetes onto our Rancher01 node.

The following command will run rke up which will install Kubernetes onto our node.

rke up --config rancher-cluster.yml
 Click to run on Rancher01

Testing your cluster

RKE will have generated two important files:

  • kube_config_rancher-cluster.yml
  • rancher-cluster.clusterstate

in addition to your

  • rancher-cluster.yml

All of these files are extremely important for future maintenance of our cluster. When running rke on your own machines to install Kubernetes/Rancher, you must make sure you have current copies of all 3 files otherwise you can run into errors when running rke up.

The kube_config_rancher-cluster.yml file will contain a kube-admin kubernetes context that can be used to interact with your Kubernetes cluster that you've installed Rancher on.

We can soft symlink the kube_config_rancher-cluster.yml file to our /home/ubuntu/.kube/config file so that kubectl can interact with our cluster:

mkdir -p /home/ubuntu/.kube
ln -s /home/ubuntu/kube_config_rancher-cluster.yml /home/ubuntu/.kube/config
 Click to run on Rancher01

In order to test that we can properly interact with our cluster, we can execute two commands:

kubectl get nodes
 Click to run on Rancher01
kubectl get pods --all-namespaces
 Click to run on Rancher01

Install cert-manager

cert-manager is a Kubernetes add-on to automate the management and issuance of TLS certificates from various issuing sources.

The following set of steps will install cert-manager which will be used to manage the TLS certificates for Rancher.

The following command will apply the cert-manager custom resource definitions as well as label the namespace that cert-manager runs in to disable validation.

kubectl create namespace cert-manager
kubectl apply --validate=false -f https://github.com/jetstack/cert-manager/releases/download/v0.15.0/cert-manager.crds.yaml
 Click to run on Rancher01

Next, we'll add the helm repository for Jetstack

helm repo add jetstack https://charts.jetstack.io
 Click to run on Rancher01

Update your helm repository cache

helm repo update
 Click to run on Rancher01

Now, we can install cert-manager version 0.15.0

helm install \
  cert-manager jetstack/cert-manager \
  --namespace cert-manager \
  --version v0.15.0
 Click to run on Rancher01

Once the helm chart has installed, you can monitor the rollout status of both cert-manager and cert-manager-webhook

kubectl -n cert-manager rollout status deploy/cert-manager
 Click to run on Rancher01

You should eventually receive output similar to:

Waiting for deployment "cert-manager" rollout to finish: 0 of 1 updated replicas are available...

deployment "cert-manager" successfully rolled out

kubectl -n cert-manager rollout status deploy/cert-manager-webhook
 Click to run on Rancher01

You should eventually receive output similar to:

Waiting for deployment "cert-manager-webhook" rollout to finish: 0 of 1 updated replicas are available...

deployment "cert-manager-webhook" successfully rolled out

Install Rancher

We will now install Rancher in HA mode onto our Rancher01 Kubernetes cluster. The following command will add rancher-latest as a helm repository and update our local repository cache.

helm repo add rancher-stable https://releases.rancher.com/server-charts/stable
helm repo update
 Click to run on Rancher01

Next, we need to create the cattle-system namespace in our Kubernetes cluster to install Rancher into.

kubectl create namespace cattle-system
 Click to run on Rancher01

Finally, we can install Rancher using our helm install command.

helm install rancher rancher-stable/rancher \
  --namespace cattle-system \
  --set hostname=rancher. \
  --set replicas=1
 Click to run on Rancher01

Verify Rancher is Ready to Access

Before we access Rancher, we need to make sure that cert-manager has signed a certificate using the cattle-ca in order to make sure our connection to Rancher does not get interrupted. The following bash script will check for the certificate we are looking for.

while true; do curl -kv https://rancher. 2>&1 | grep -q "dynamiclistener-ca"; if [ $? != 0 ]; then echo "Rancher isn't ready yet"; sleep 5; continue; fi; break; done; echo "Rancher is Ready";
 Click to run on Rancher01

Accessing Rancher

Note: Rancher may not immediately be available at the link below, as it may be starting up still. Please continue to refresh until Rancher is available.

  1. Access Rancher Server at https://rancher.
  2. Enter a password for the default admin user when prompted.
  3. Select the default view of "I want to create or manage multiple clusters"
  4. Make sure to agree to the Terms & Conditions
  5. When prompted, the Rancher Server URL should be rancher., which is the hostname you used to access the server.
  6. Once you log in, you'll see a message similar to "Waiting for server-url to be set". Click the ellipses on the right of the local cluster, click Edit, then click Save.

You will see the Rancher UI, with the local cluster in it. The local cluster is the cluster where Rancher itself runs, and should not be used for deploying your demo workloads.

Configure Wildcard DNS Domain

For testing purposes, Rancher can integrate with Wildcard DNS services. This allows you to quickly create a publicly resolvable DNS entry that points to the ingress controller of a cluster that is managed by Rancher.

To configure the Wildcard DNS service:

  • Go to Settings
  • Edit the ingress-ip-domain setting
  • Change the value to sslip.io

    Creating A Kubernetes Lab Cluster within Rancher

    In this step, we will be creating a Kubernetes Lab environment within Rancher. Normally, in a production case, you would create a Kubernetes Cluster with multiple nodes; however, with this lab environment, we will only be using one virtual machine for the cluster.

    1. Hover over the top left dropdown, then click Global
      • The current context is shown in the upper left, and should say 'Global'
    2. Click Add Cluster
      • Note the multiple types of Kubernetes cluster Rancher supports. We will be using Existing nodes for this lab, but there are a lot of possibilities with Rancher.
    3. Click on the Existing nodes Cluster box
    4. Enter a name in the Cluster Name box
    5. Set the Kubernetes Version to a v1.18 version
    6. Click Next at the bottom.
    7. Make sure the boxes etcdControl Plane, and Worker are all ticked.
    8. Click Show advanced options to the bottom right of the Worker checkbox
    9. Enter the Public Address ( and Internal Address (
      • IMPORTANT: It is VERY important that you use the correct External and Internal addresses from the Cluster01 machine for this step, and run it on the correct machine. Failure to do this will cause the future steps to fail.
    10. Click the clipboard to Copy to Clipboard the docker run command
    11. Proceed to the next step of this scenario

      Start the Rancher Kubernetes Cluster Bootstrapping Process

      IMPORTANT NOTE: Make sure you have selected the Cluster01 tab in HobbyFarm in the window to the right. If you run this command on Rancher01 you will cause problems for your scenario session.

      1. Take the copied docker command and run it on Cluster01
      2. Once the docker run command is complete, you should see a message similiar to 1 node has registered
      3. Within the Rancher UI click on <YOUR_CLUSTER_NAME> which is the name you entered during cluster creation.
      4. You can watch the state of the cluster as your Kubernetes node Cluster01 registers with Rancher here as well as the Nodes tab
      5. Your cluster state on the Global page will change to Active
      6. Once your cluster has gone to Active you can click on it and start exploring.

        Interacting with the Kubernetes Cluster

        In this step, we will be showing basic interaction with our Kubernetes cluster.

        1. Click into your newly active cluster.
        2. Note the three dials, which illustrate cluster capacity.
        3. Click the Launch kubectl button in the top right corner of the Cluster overview page, and enter kubectl get pods --all-namespaces and observe the fact that you can interact with your Kubernetes cluster using kubectl.
        4. Also take note of the Kubeconfig File button which will generate a Kubeconfig file that can be used from your local desktop or within your deployment pipelines.
        5. Click the Ellipses in the top right corner and note the various operational options available for your cluster. We will be exploring these in a later step.

          Enable Rancher Monitoring

          To deploy the Rancher Monitoring feature, we will need to navigate to the Cluster Explorer.

          1. On your newly-created cluster, click the "Explorer" button to open the Cluster Explorer.
          2. Once the Cluster Explorer loads, use the dropdown in the upper-left section of the page, and navigate to "Apps & Marketplace."
          3. Locate the "Monitoring" chart, and click on it
          4. Select "Chart Options" on the left. Change Resource Limits > Requested CPU from 750m to 250m. This is required because our scenario virtual machine has limited CPU available.
          5. Click "Install" at the bottom of the page, and wait for the helm install operation to complete.

          Once Monitoring has been installed, you can click on that application under "Installed Apps" to view the various resources that were deployed.

          Working with Rancher Monitoring

          Once Rancher Monitoring has been deployed, we can view the various components and interact with them.

          1. In the dropdown in the upper-left corner of the Cluster Explorer, select "Monitoring"
          2. On the Monitoring Dashboard page, identify the "Grafana" link. Clicking this will proxy you to the installed Grafana server

          Once you have opened Grafana, feel free to explore the various dashboard and visualizations that have been setup by default.

          These options can be customized (metrics and graphs), but doing so is out of the scope of this scenario.

          Create a Deployment And Service

          In this step, we will be creating a Kubernetes Deployment and Kubernetes Service for an arbitrary workload. For the purposes of this lab, we will be using the docker image rancher/hello-world:latest but you can use your own docker image if you have one for testing.

          When we deploy our container in a pod, we probably want to make sure it stays running in case of failure or other disruption. Pods by nature will not be replaced when they terminate, so for a web service or something we intend to be always running, we should use a Deployment.

          The deployment is a factory for pods, so you'll notice a lot of similairities with the Pod's spec. When a deployment is created, it first creates a replica set, which in turn creates pod objects, and then continues to supervise those pods in case one or more fails.

          Note: These steps will need to be executed within the Cluster Manager. To access, click on the Cluster Manager button at the top of the page.

          1. Hover over the Dropdown next to the Rancher logo in the top left corner, hover over your cluster name, then select Default as the project.
          2. Under the Workloads tab press Deploy in the top right corner and enter the following criteria:
            • Name - helloworld
            • Docker Image - rancher/hello-world:latest
            • Click Add Port and enter 80 for the container port
            • ** NOTE: ** Note the other capabilities you have for deploying your container. We won't be covering these in this Rodeo, but you have plenty of capabilities here.
          3. Scroll down and click Launch
          4. You should see one pod get deployed and a TCP endpoint under your workload name exposing the NodePort service that has been created.
          5. Click the Arrow next to your workload that you just created, then note the + and - buttons under the replica count to the right. You can click these correspondingly and refresh your browser on the nodeport to see the changes in the pod name.

            Create a Kubernetes Ingress

            In this step, we will be creating a Layer 7 ingress to access the workload we just deployed in the previous step. For this example, we will be using xip.io as a way to provide a DNS hostname for our workload. Rancher will automatically generate a corresponding workload IP.

            1. Hover over the Dropdown next to the Rancher logo in the top left corner, hover over your cluster name, then select Default as the project.
            2. In the Default project in the Workloads section, click on the Load Balancing tab
            3. Click Add Ingress and enter the following criteria:
              • Name - helloworld
              • Leave 'Automatically generate a .sslip.io hostname' selected
              • Click the minus button on the right to remove the empty backend rule
              • Click the + Service button
              • Pick the helloworld-nodeport service from the dropdown under Target
            4. Click Save and wait for the sslip.io hostname to register, you should see the rule become Active within a few minutes.
            5. Click on the hostname and browse to the workload.

            ** Note: ** You may receive transient 404/502/503 errors while the workload stabilizes. This is due to the fact that we did not set a proper readiness probe on the workload, so Kubernetes is simply assuming the workload is healthy.

            Upgrading your Kubernetes Cluster

            This step shows how easy it is to upgrade your Kubernetes clusters within Rancher.

            1. Hover over the Dropdown next to the Rancher logo in the top left corner, then select your cluster.
            2. Click the ellipses (...) next to the Kubeconfig file button
            3. Click Edit
            4. Scroll down and select the dropdown under the Kubernetes Version
            5. Select a newer version of Kubernetes
            6. Scroll down and hit Save

            Observe that your Kubernetes cluster will now be upgraded.


            Congratulations, you have finished the Scenario. If you would like to tear down your lab environment, you can click the "Finish" button, otherwise, continue to work with your Kubernetes cluster while keeping HobbyFarm in the background.