______________________________________________________________________________ / Once there was this conductor see, who had a bass problem. You see, during \ | a portion of Beethovan's Ninth Symphony in which there are no bass violin | | parts, one of the bassists always passed a bottle of scotch around. So, | | to remind himself that the basses usually required an extra cue towards the | | end of the symphony, the conductor would fasten a piece of string around the | | page of the score before the bass cue. As the basses grew more and more | | inebriated, two of them fell asleep. The conductor grew quite nervous (he | | was very concerned about the pitch) because it was the bottom of the ninth; | \ the score was tied and the basses were loaded with two out. / ------------------------------------------------------------------------------ \ ^__^ \ (oo)\_______ (__)\ )\/\ ||----w | || || rap@ada:~$ dbase01 X11 forwarding request failed on channel 0 Last login: Wed Nov 23 11:00:01 2016 from ada.phas.ubc.ca [root@dbase01 ~]# yum install xorg-x11-xauth Installed: xorg-x11-xauth.x86_64 1:1.0.9-1.el7 Dependency Installed: libICE.x86_64 0:1.0.9-2.el7 libSM.x86_64 0:1.2.2-2.el7 libX11.x86_64 0:1.6.3-3.el7 libX11-common.noarch 0:1.6.3-3.el7 libXau.x86_64 0:1.0.8-2.1.el7 libXext.x86_64 0:1.3.3-3.el7 libXmu.x86_64 0:1.1.2-2.el7 libXt.x86_64 0:1.1.4-6.1.el7 libxcb.x86_64 0:1.11-4.el7 =========================================================================================== /etc/ssh/sshd_config chgs needed. AddressFamily inet #PermitRootLogin without-password PermitRootLogin yes X11Forwarding yes =========================================================================================== [root@dbase01 ~]# yum install -y mariadb mariadb-server Installed: mariadb.x86_64 1:5.5.52-1.el7 mariadb-server.x86_64 1:5.5.52-1.el7 Dependency Installed: 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-5.el7 perl-DBI.x86_64 0:1.627-4.el7 perl-Data-Dumper.x86_64 0:2.145-3.el7 perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7 perl-PlRPC.noarch 0:0.2020-14.el7 [root@dbase01 ~]# systemctl enable mariadb Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service. [root@dbase01 ~]# systemctl start mariadb [root@dbase01 ~]# mysql_secure_installation [root@dbase01 ~]# cd /opt [root@dbase01 opt]# mkdir mysqltuner [root@dbase01 opt]# cd mysqltuner/ [root@dbase01 mysqltuner]# wget http://mysqltuner.pl/ -O mysqltuner.pl 2016-11-23 12:22:06 (8.49 MB/s) - ‘mysqltuner.pl’ saved [204670/204670] [root@dbase01 mysqltuner]# wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt -O basic_passwords.txt 2016-11-23 12:22:15 (58.3 MB/s) - ‘basic_passwords.txt’ saved [3909/3909] [root@dbase01 mysqltuner]# wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv -O vulnerabilities.csv 2016-11-23 12:22:26 (9.26 MB/s) - ‘vulnerabilities.csv’ saved [552398/552398] [root@dbase01 mysqltuner]# chmod +x mysqltuner.pl [root@dbase01 mysqltuner]# ll total 744 -rw-------. 1 root root 3909 Nov 23 12:22 basic_passwords.txt -rwx------. 1 root root 204670 Nov 23 12:22 mysqltuner.pl -rw-------. 1 root root 552398 Nov 23 12:22 vulnerabilities.csv ======================================================================= [root@dbase01 ~]# yum install httpd Installed: httpd.x86_64 0:2.4.6-45.el7 Dependency Installed: apr.x86_64 0:1.4.8-3.el7 apr-util.x86_64 0:1.5.2-6.el7 httpd-tools.x86_64 0:2.4.6-45.el7 mailcap.noarch 0:2.1.41-2.el7 [root@dbase01 ~]# vim /etc/yum.repos.d/MariaDB.repo [root@dbase01 ~]# cat /etc/yum.repos.d/MariaDB.repo # MariaDB 10.1 RedHat repository list - created 2016-11-23 21:58 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/rhel7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 [root@dbase01]# hostnamectl set-hostname dbase01.phas.ubc.ca --static [root@dbase01 conf.d]# yum install php Installed: php.x86_64 0:5.4.16-42.el7 ======================================================================= [root@dbase01 ~]# firewall-cmd --state running [root@dbase01 ~]# firewall-cmd --get-default-zone public [root@dbase01 ~]# firewall-cmd --get-active-zones public interfaces: ens192 [root@dbase01 ~]# firewall-cmd --list-all public (active) target: default icmp-block-inversion: no interfaces: ens192 sources: services: dhcpv6-client ssh ports: protocols: masquerade: no forward-ports: sourceports: icmp-blocks: rich rules: [root@dbase01 ~]# firewall-cmd --get-zones work drop internal external trusted home dmz public block [root@dbase01 ~]# firewall-cmd --zone=public --add-service=http success [root@dbase01 ~]# firewall-cmd --zone=public --add-service=https [root@dbase01 opt]# sudo firewall-cmd --zone=public --permanent --add-service=https success [root@dbase01 opt]# sudo firewall-cmd --zone=public --permanent --add-service=http success [root@dbase01 conf.d]# yum -y install mod_ssl openssl Package 1:openssl-1.0.1e-60.el7.x86_64 already installed and latest version Installed: mod_ssl.x86_64 1:2.4.6-45.el7 ======================================================================= ======================================================================= 17-03-21 [root@dbase01 mysql]# fdisk -l | grep sd Disk /dev/sda: 268 MB, 268435456 bytes, 524288 sectors /dev/sda1 * 2048 524287 261120 83 Linux Disk /dev/sdb: 34.4 GB, 34359738368 bytes, 67108864 sectors Disk /dev/sdc: 34.4 GB, 34359738368 bytes, 67108864 sectors [root@dbase01 mysql]# fdisk /dev/sdc Device does not contain a recognized partition table Building a new DOS disklabel with disk identifier 0xefdf062a. Command (m for help): print Disk /dev/sdc: 34.4 GB, 34359738368 bytes, 67108864 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0xefdf062a Device Boot Start End Blocks Id System Command (m for help): n Partition type: p primary (0 primary, 0 extended, 4 free) e extended Select (default p): p Partition number (1-4, default 1): First sector (2048-67108863, default 2048): Using default value 2048 Last sector, +sectors or +size{K,M,G} (2048-67108863, default 67108863): Using default value 67108863 Partition 1 of type Linux and of size 32 GiB is set Command (m for help): print Disk /dev/sdc: 34.4 GB, 34359738368 bytes, 67108864 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0xefdf062a Device Boot Start End Blocks Id System /dev/sdc1 2048 67108863 33553408 83 Linux Command (m for help): t Selected partition 1 Hex code (type L to list all codes): 8e Changed type of partition 'Linux' to 'Linux LVM' Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. [root@dbase01 mysql]# pvcreate /dev/sdc1 Physical volume "/dev/sdc1" successfully created. [root@dbase01 mysql]# pvscan PV /dev/sdb VG VGroot lvm2 [32.00 GiB / 0 free] PV /dev/sdc1 lvm2 [32.00 GiB] Total: 2 [64.00 GiB] / in use: 1 [32.00 GiB] / in no VG: 1 [32.00 GiB] [root@dbase01 mysql]# vgcreate VGmysql /dev/sdc1 Volume group "VGmysql" successfully created [root@dbase01 mysql]# lvcreate --name LVmysql -l 100%FREE VGmysql Logical volume "LVmysql" created. [root@dbase01 mysql]# lvdisplay --- Logical volume --- LV Path /dev/VGmysql/LVmysql LV Name LVmysql VG Name VGmysql LV UUID N0AVNQ-1JM0-yfmE-34hB-qocq-NxAk-wHXTEe LV Write Access read/write LV Creation host, time dbase01.phas.ubc.ca, 2017-03-21 15:13:22 -0700 LV Status available # open 0 LV Size 32.00 GiB Current LE 8191 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 8192 Block device 253:11 -- more lvs removed for brevity --- [root@dbase01 mysql]# ls -l /dev/VGmysql/LVmysql lrwxrwxrwx. 1 root root 8 Mar 21 15:13 /dev/VGmysql/LVmysql -> ../dm-11 [root@dbase01 mysql]# mkfs.xfs /dev/VGmysql/LVmysql meta-data=/dev/VGmysql/LVmysql isize=512 agcount=4, agsize=2096896 blks = sectsz=512 attr=2, projid32bit=1 = crc=1 finobt=0, sparse=0 data = bsize=4096 blocks=8387584, imaxpct=25 = sunit=0 swidth=0 blks naming =version 2 bsize=4096 ascii-ci=0 ftype=1 log =internal log bsize=4096 blocks=4095, version=2 = sectsz=512 sunit=0 blks, lazy-count=1 realtime =none extsz=4096 blocks=0, rtextents=0 [root@dbase01 mysql]# pwd /var/lib/mysql [root@dbase01 mysql]# systemctl stop mariadb [root@dbase01 mysql]# pwd /var/lib/mysql [root@dbase01 mysql]# ll total 110656 drwx------. 2 mysql mysql 4096 Mar 17 15:06 accounts -rw-rw----. 1 mysql mysql 16384 Mar 21 15:15 aria_log.00000001 -rw-rw----. 1 mysql mysql 52 Mar 21 15:15 aria_log_control drwx------. 2 mysql mysql 4096 Mar 16 11:38 bbnanofabUNUSED drwx------. 2 mysql mysql 4096 Mar 17 15:08 BPS drwx------. 2 mysql mysql 4096 Mar 17 15:09 devcrypt drwx------. 2 mysql mysql 4096 Mar 17 15:10 directory drwx------. 2 mysql mysql 4096 Mar 17 15:27 gradstudents -rw-rw----. 1 mysql mysql 12582912 Mar 21 15:15 ibdata1 -rw-rw----. 1 mysql mysql 50331648 Mar 21 15:15 ib_logfile0 -rw-rw----. 1 mysql mysql 50331648 Mar 21 09:02 ib_logfile1 -rw-rw----. 1 mysql mysql 0 Nov 23 14:41 multi-master.info drwx--x--x. 2 mysql mysql 4096 Mar 17 16:02 mysql drwx------. 2 mysql mysql 4096 Feb 27 14:19 outreach drwx------. 2 mysql mysql 19 Mar 17 16:02 performance_schema drwx------. 2 mysql mysql 4096 Jan 12 10:43 pykota drwx------. 2 mysql mysql 4096 Jan 12 10:43 pykotatest drwx------. 2 mysql mysql 4096 Mar 16 11:39 sysadmin drwx------. 2 mysql mysql 19 Jan 12 10:43 test [root@dbase01 mysql]# cd .. [root@dbase01 lib]# mv mysql mysql.hold [root@dbase01 lib]# mkdir mysql [root@dbase01 lib]# chown mysql:mysql mysql [root@dbase01 lib]# vim /etc/fstab [root@dbase01 mysql]# grep LVm /etc/fstab /dev/mapper/VGmysql-LVmysql /var/lib/mysql xfs defaults 1 2 [root@dbase01 lib]# ls -l /dev/mapper/VGmysql-LVmysql lrwxrwxrwx. 1 root root 8 Mar 21 15:14 /dev/mapper/VGmysql-LVmysql -> ../dm-11 [root@dbase01 lib]# mount /var/lib/mysql [root@dbase01 lib]# pwd /var/lib [root@dbase01 lib]# cd mysql [root@dbase01 mysql]# ll total 0 [root@dbase01 mysql]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGroot-LVroot 9.0G 4.4G 4.7G 49% / devtmpfs 482M 0 482M 0% /dev tmpfs 493M 4.0K 493M 1% /dev/shm tmpfs 493M 6.7M 486M 2% /run tmpfs 493M 0 493M 0% /sys/fs/cgroup none 493M 0 493M 0% /run/shm /dev/sda1 252M 140M 113M 56% /boot /dev/mapper/VGroot-LVtmp 3.0G 33M 2.9G 2% /tmp /dev/mapper/VGroot-LVhome 6.3G 33M 6.3G 1% /home /dev/mapper/VGroot-LVvar 3.9G 1.1G 2.9G 26% /var /dev/mapper/VGroot-LVlog 3.9G 38M 3.9G 1% /var/log /dev/mapper/VGroot-LVaudit 1021M 72M 949M 8% /var/log/audit tmpfs 99M 0 99M 0% /run/user/0 /dev/mapper/VGmysql-LVmysql 32G 33M 32G 1% /var/lib/mysql [root@dbase01 mysql]# rpm -qa | grep -i mariadb MariaDB-shared-10.1.22-1.el7.centos.x86_64 MariaDB-server-10.1.22-1.el7.centos.x86_64 MariaDB-client-10.1.22-1.el7.centos.x86_64 MariaDB-common-10.1.22-1.el7.centos.x86_64 [root@dbase01 mysql]# yum remove MariaDB-server Removed: MariaDB-server.x86_64 0:10.1.22-1.el7.centos [root@dbase01 mysql]# pwd /var/lib/mysql [root@dbase01 mysql]# ll total 0 [root@dbase01 mysql]# yum -y install MariaDB-server PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h dbase01.phas.ubc.ca password 'new-password' Alternatively you can run: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com libsemanage.map_file: Unable to open /usr/share/mysql/policy/selinux/mariadb.pp (No such file or directory). libsemanage.semanage_direct_install_file: Unable to read file /usr/share/mysql/policy/selinux/mariadb.pp (No such file or directory). /usr/sbin/semodule: Failed on /usr/share/mysql/policy/selinux/mariadb.pp! Verifying : MariaDB-server-10.1.22-1.el7.centos.x86_64 1/1 Installed: MariaDB-server.x86_64 0:10.1.22-1.el7.centos [root@dbase01 mysql]# systemctl enable mariadb [root@dbase01 mysql]# systemctl start mariadb [root@dbase01 mysql]# /usr/bin/mysql_secure_installation All done! If you've completed all of the above steps, your MariaDB installation should now be secure. ======================================================================= 18-11-02 [EduCld-RH7-dbase01]# yum update ============================================================================================================= Package Arch Version Repository Size ============================================================================================================= Updating: MariaDB-client x86_64 10.1.37-1.el7.centos mariadb 40 M MariaDB-common x86_64 10.1.37-1.el7.centos mariadb 123 k MariaDB-server x86_64 10.1.37-1.el7.centos mariadb 104 M MariaDB-shared x86_64 10.1.37-1.el7.centos mariadb 1.3 M device-mapper x86_64 7:1.02.149-10.el7_6.2 rhel-x86_64-server-7 292 k device-mapper-event x86_64 7:1.02.149-10.el7_6.2 rhel-x86_64-server-7 188 k device-mapper-event-libs x86_64 7:1.02.149-10.el7_6.2 rhel-x86_64-server-7 187 k device-mapper-libs x86_64 7:1.02.149-10.el7_6.2 rhel-x86_64-server-7 320 k galera x86_64 25.3.24-1.rhel7.el7.centos mariadb 8.1 M lvm2 x86_64 7:2.02.180-10.el7_6.2 rhel-x86_64-server-7 1.3 M lvm2-libs x86_64 7:2.02.180-10.el7_6.2 rhel-x86_64-server-7 1.1 M tzdata noarch 2018g-1.el7 rhel-x86_64-server-7 484 k Updated: MariaDB-client.x86_64 0:10.1.37-1.el7.centos MariaDB-common.x86_64 0:10.1.37-1.el7.centos MariaDB-server.x86_64 0:10.1.37-1.el7.centos MariaDB-shared.x86_64 0:10.1.37-1.el7.centos device-mapper.x86_64 7:1.02.149-10.el7_6.2 device-mapper-event.x86_64 7:1.02.149-10.el7_6.2 device-mapper-event-libs.x86_64 7:1.02.149-10.el7_6.2 device-mapper-libs.x86_64 7:1.02.149-10.el7_6.2 galera.x86_64 0:25.3.24-1.rhel7.el7.centos lvm2.x86_64 7:2.02.180-10.el7_6.2 lvm2-libs.x86_64 7:2.02.180-10.el7_6.2 tzdata.noarch 0:2018g-1.el7 ======================================================================= 19-01-29 Removed: kernel.x86_64 0:3.10.0-693.17.1.el7 Installed: kernel.x86_64 0:3.10.0-957.1.3.el7 Updated: NetworkManager.x86_64 1:1.12.0-8.el7_6 NetworkManager-adsl.x86_64 1:1.12.0-8.el7_6 NetworkManager-bluetooth.x86_64 1:1.12.0-8.el7_6 NetworkManager-config-server.noarch 1:1.12.0-8.el7_6 NetworkManager-libnm.x86_64 1:1.12.0-8.el7_6 NetworkManager-ppp.x86_64 1:1.12.0-8.el7_6 NetworkManager-team.x86_64 1:1.12.0-8.el7_6 NetworkManager-tui.x86_64 1:1.12.0-8.el7_6 NetworkManager-wifi.x86_64 1:1.12.0-8.el7_6 NetworkManager-wwan.x86_64 1:1.12.0-8.el7_6 certbot.noarch 0:0.29.1-1.el7 cronie.x86_64 0:1.4.11-20.el7_6 cronie-anacron.x86_64 0:1.4.11-20.el7_6 ipset.x86_64 0:6.38-3.el7_6 ipset-libs.x86_64 0:6.38-3.el7_6 kernel-tools.x86_64 0:3.10.0-957.1.3.el7 kernel-tools-libs.x86_64 0:3.10.0-957.1.3.el7 libgudev1.x86_64 0:219-62.el7_6.2 perl.x86_64 4:5.16.3-294.el7_6 perl-Pod-Escapes.noarch 1:1.04-294.el7_6 perl-libs.x86_64 4:5.16.3-294.el7_6 perl-macros.x86_64 4:5.16.3-294.el7_6 php-tcpdf.noarch 0:6.2.26-1.el7 php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.26-1.el7 python-perf.x86_64 0:3.10.0-957.1.3.el7 python2-acme.noarch 0:0.29.1-1.el7 python2-certbot.noarch 0:0.29.1-1.el7 python2-certbot-apache.noarch 0:0.29.1-1.el7 python2-mock.noarch 0:1.0.1-10.el7 python2-psutil.x86_64 0:2.2.1-4.el7 selinux-policy.noarch 0:3.13.1-229.el7_6.6 selinux-policy-targeted.noarch 0:3.13.1-229.el7_6.6 subscription-manager.x86_64 0:1.21.10-3.el7_6 subscription-manager-rhsm.x86_64 0:1.21.10-3.el7_6 subscription-manager-rhsm-certificates.x86_64 0:1.21.10-3.el7_6 systemd.x86_64 0:219-62.el7_6.2 systemd-libs.x86_64 0:219-62.el7_6.2 systemd-python.x86_64 0:219-62.el7_6.2 systemd-sysv.x86_64 0:219-62.el7_6.2 tzdata.noarch 0:2018i-1.el7 Complete! ======================================================================= 19-01-31 [EduCld-RH7-dbase01]# yum update Removed: kernel.x86_64 0:3.10.0-957.el7 Installed: kernel.x86_64 0:3.10.0-957.5.1.el7 Updated: augeas-libs.x86_64 0:1.4.0-6.el7_6.1 bind-libs-lite.x86_64 32:9.9.4-73.el7_6 bind-license.noarch 32:9.9.4-73.el7_6 device-mapper.x86_64 7:1.02.149-10.el7_6.3 device-mapper-event.x86_64 7:1.02.149-10.el7_6.3 device-mapper-event-libs.x86_64 7:1.02.149-10.el7_6.3 device-mapper-libs.x86_64 7:1.02.149-10.el7_6.3 freetype.x86_64 0:2.8-12.el7_6.1 glibc.x86_64 0:2.17-260.el7_6.3 glibc-common.x86_64 0:2.17-260.el7_6.3 grub2.x86_64 1:2.02-0.76.el7.1 grub2-common.noarch 1:2.02-0.76.el7.1 grub2-pc.x86_64 1:2.02-0.76.el7.1 grub2-pc-modules.noarch 1:2.02-0.76.el7.1 grub2-tools.x86_64 1:2.02-0.76.el7.1 grub2-tools-extra.x86_64 1:2.02-0.76.el7.1 grub2-tools-minimal.x86_64 1:2.02-0.76.el7.1 kernel-tools.x86_64 0:3.10.0-957.5.1.el7 kernel-tools-libs.x86_64 0:3.10.0-957.5.1.el7 krb5-libs.x86_64 0:1.15.1-37.el7_6 libgudev1.x86_64 0:219-62.el7_6.3 lvm2.x86_64 7:2.02.180-10.el7_6.3 lvm2-libs.x86_64 7:2.02.180-10.el7_6.3 nss.x86_64 0:3.36.0-7.1.el7_6 nss-sysinit.x86_64 0:3.36.0-7.1.el7_6 nss-tools.x86_64 0:3.36.0-7.1.el7_6 nss-util.x86_64 0:3.36.0-1.1.el7_6 openldap.x86_64 0:2.4.44-21.el7_6 policycoreutils.x86_64 0:2.5-29.el7_6.1 policycoreutils-python.x86_64 0:2.5-29.el7_6.1 python-perf.x86_64 0:3.10.0-957.5.1.el7 selinux-policy.noarch 0:3.13.1-229.el7_6.9 selinux-policy-targeted.noarch 0:3.13.1-229.el7_6.9 systemd.x86_64 0:219-62.el7_6.3 systemd-libs.x86_64 0:219-62.el7_6.3 systemd-python.x86_64 0:219-62.el7_6.3 systemd-sysv.x86_64 0:219-62.el7_6.3 ======================================================================= 19-03-14 update Removed: kernel.x86_64 0:3.10.0-957.1.3.el7 Installed: kernel.x86_64 0:3.10.0-957.10.1.el7 Updated: NetworkManager.x86_64 1:1.12.0-10.el7_6 NetworkManager-adsl.x86_64 1:1.12.0-10.el7_6 NetworkManager-bluetooth.x86_64 1:1.12.0-10.el7_6 NetworkManager-config-server.noarch 1:1.12.0-10.el7_6 NetworkManager-libnm.x86_64 1:1.12.0-10.el7_6 NetworkManager-ppp.x86_64 1:1.12.0-10.el7_6 NetworkManager-team.x86_64 1:1.12.0-10.el7_6 NetworkManager-tui.x86_64 1:1.12.0-10.el7_6 NetworkManager-wifi.x86_64 1:1.12.0-10.el7_6 NetworkManager-wwan.x86_64 1:1.12.0-10.el7_6 dbus.x86_64 1:1.10.24-13.el7_6 dbus-libs.x86_64 1:1.10.24-13.el7_6 gnutls.x86_64 0:3.3.29-9.el7_6 kernel-tools.x86_64 0:3.10.0-957.10.1.el7 kernel-tools-libs.x86_64 0:3.10.0-957.10.1.el7 libblkid.x86_64 0:2.23.2-59.el7_6.1 libgcc.x86_64 0:4.8.5-36.el7_6.1 libgomp.x86_64 0:4.8.5-36.el7_6.1 libmount.x86_64 0:2.23.2-59.el7_6.1 libsmartcols.x86_64 0:2.23.2-59.el7_6.1 libstdc++.x86_64 0:4.8.5-36.el7_6.1 libuuid.x86_64 0:2.23.2-59.el7_6.1 nss-pem.x86_64 0:1.0.3-5.el7_6.1 python-perf.x86_64 0:3.10.0-957.10.1.el7 shadow-utils.x86_64 2:4.1.5.1-25.el7_6.1 tuned.noarch 0:2.10.0-6.el7_6.3 util-linux.x86_64 0:2.23.2-59.el7_6.1 xfsprogs.x86_64 0:4.5.0-19.el7_6 Complete! ======================================================================= 19-04-17 add disk [EduCld-RH7-dbase01]# ll /dev/disk/by-path/ total 0 lrwxrwxrwx. 1 root root 9 Jul 18 2018 pci-0000:00:07.1-ata-2.0 -> ../../sr0 lrwxrwxrwx. 1 root root 9 Jul 18 2018 pci-0000:03:00.0-scsi-0:0:0:0 -> ../../sda lrwxrwxrwx. 1 root root 10 Jul 18 2018 pci-0000:03:00.0-scsi-0:0:0:0-part1 -> ../../sda1 lrwxrwxrwx. 1 root root 9 Jul 18 2018 pci-0000:03:00.0-scsi-0:0:1:0 -> ../../sdb lrwxrwxrwx. 1 root root 9 Jul 18 2018 pci-0000:03:00.0-scsi-0:0:2:0 -> ../../sdc lrwxrwxrwx. 1 root root 10 Jul 18 2018 pci-0000:03:00.0-scsi-0:0:2:0-part1 -> ../../sdc1 Needed above info to choose Bus Number and Unit Number (chose 0 3) in EduCloud console. Using the naming conventions of devfs this becomes: Added 65,536 MB disk (Van Standard PG02, Paravirtual (SCSI), Bus 0, Unit 3) hit save and seemed OK. Now on dbase01: [EduCld-RH7-dbase01]# fdisk -l | grep sd Disk /dev/sda: 268 MB, 268435456 bytes, 524288 sectors /dev/sda1 * 2048 524287 261120 83 Linux Disk /dev/sdb: 34.4 GB, 34359738368 bytes, 67108864 sectors Disk /dev/sdc: 34.4 GB, 34359738368 bytes, 67108864 sectors /dev/sdc1 2048 67108863 33553408 8e Linux LVM Disk /dev/sdd: 68.7 GB, 68719476736 bytes, 134217728 sectors [EduCld-RH7-dbase01]# fdisk /dev/sdd Welcome to fdisk (util-linux 2.23.2). Changes will remain in memory only, until you decide to write them. Be careful before using the write command. Device does not contain a recognized partition table Building a new DOS disklabel with disk identifier 0x8d423c88. Command (m for help): print Disk /dev/sdd: 68.7 GB, 68719476736 bytes, 134217728 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x8d423c88 Device Boot Start End Blocks Id System Command (m for help): n Partition type: p primary (0 primary, 0 extended, 4 free) e extended Select (default p): p Partition number (1-4, default 1): First sector (2048-134217727, default 2048): Using default value 2048 Last sector, +sectors or +size{K,M,G} (2048-134217727, default 134217727): Using default value 134217727 Partition 1 of type Linux and of size 64 GiB is set Command (m for help): print Disk /dev/sdd: 68.7 GB, 68719476736 bytes, 134217728 sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk label type: dos Disk identifier: 0x8d423c88 Device Boot Start End Blocks Id System /dev/sdd1 2048 134217727 67107840 83 Linux Command (m for help): t Selected partition 1 Hex code (type L to list all codes): 8e Changed type of partition 'Linux' to 'Linux LVM' Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. [EduCld-RH7-dbase01]# pvcreate /dev/sdd1 Physical volume "/dev/sdd1" successfully created. [EduCld-RH7-dbase01]# pvscan PV /dev/sdc1 VG VGmysql lvm2 [<32.00 GiB / 0 free] PV /dev/sdb VG VGroot lvm2 [<32.00 GiB / 0 free] PV /dev/sdd1 lvm2 [<64.00 GiB] Total: 3 [127.99 GiB] / in use: 2 [63.99 GiB] / in no VG: 1 [<64.00 GiB] [EduCld-RH7-dbase01]# vgcreate VGbackup /dev/sdd1 Volume group "VGbackup" successfully created [EduCld-RH7-dbase01]# lvcreate --name LVbackup -l 100%FREE VGbackup Logical volume "LVbackup" created. [EduCld-RH7-dbase01]# lvdisplay -- more lvs removed for brevity --- --- Logical volume --- LV Path /dev/VGbackup/LVbackup LV Name LVbackup VG Name VGbackup LV UUID SxhdxH-ydu0-LRJz-mlT9-YGDv-LIo2-5PK8tI LV Write Access read/write LV Creation host, time dbase01.phas.ubc.ca, 2019-04-17 15:56:59 -0700 LV Status available # open 0 LV Size <64.00 GiB Current LE 16383 Segments 1 Allocation inherit Read ahead sectors auto - currently set to 256 Block device 253:12 -- more lvs removed for brevity --- [EduCld-RH7-dbase01]# ls -l /dev/VGbackup/LVbackup lrwxrwxrwx. 1 root root 8 Apr 17 15:56 /dev/VGbackup/LVbackup -> ../dm-12 [EduCld-RH7-dbase01]# mkfs.xfs /dev/VGbackup/LVbackup meta-data=/dev/VGbackup/LVbackup isize=512 agcount=4, agsize=4194048 blks = sectsz=512 attr=2, projid32bit=1 = crc=1 finobt=0, sparse=0 data = bsize=4096 blocks=16776192, imaxpct=25 = sunit=0 swidth=0 blks naming =version 2 bsize=4096 ascii-ci=0 ftype=1 log =internal log bsize=4096 blocks=8191, version=2 = sectsz=512 sunit=0 blks, lazy-count=1 realtime =none extsz=4096 blocks=0, rtextents=0 [EduCld-RH7-dbase01]# vim /etc/fstab [EduCld-RH7-dbase01]# grep LVbackup /etc/fstab /dev/mapper/VGbackup-LVbackup /backups xfs defaults 1 2 [EduCld-RH7-dbase01]# cd / [EduCld-RH7-dbase01]# mkdir backups [EduCld-RH7-dbase01]# mount /backups [EduCld-RH7-dbase01]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGroot-LVroot 9.0G 5.0G 4.1G 56% / devtmpfs 480M 0 480M 0% /dev tmpfs 492M 4.0K 492M 1% /dev/shm tmpfs 492M 51M 442M 11% /run tmpfs 492M 0 492M 0% /sys/fs/cgroup none 492M 0 492M 0% /run/shm /dev/mapper/VGroot-LVtmp 3.0G 33M 2.9G 2% /tmp /dev/mapper/VGroot-LVvar 3.9G 1.9G 2.1G 49% /var /dev/mapper/VGroot-LVhome 6.3G 4.4G 1.9G 70% /home /dev/mapper/VGmysql-LVmysql 32G 22G 11G 66% /var/lib/mysql /dev/sda1 252M 148M 105M 59% /boot /dev/mapper/VGroot-LVlog 3.9G 46M 3.9G 2% /var/log /dev/mapper/VGroot-LVaudit 1021M 70M 952M 7% /var/log/audit tmpfs 99M 0 99M 0% /run/user/0 /dev/mapper/VGbackup-LVbackup 64G 33M 64G 1% /backups ======================================================================= 2020-04-30 Updated: python2-parsedatetime.noarch 0:2.4-6.el7 python2-pyrfc3339.noarch 0:1.1-3.el7 ======================================================================= 2020-06-08 Removed: kernel.x86_64 0:3.10.0-1062.el7 Installed: kernel.x86_64 0:3.10.0-1127.10.1.el7 Updated: MariaDB-client.x86_64 0:10.1.45-1.el7.centos MariaDB-common.x86_64 0:10.1.45-1.el7.centos MariaDB-server.x86_64 0:10.1.45-1.el7.centos MariaDB-shared.x86_64 0:10.1.45-1.el7.centos augeas-libs.x86_64 0:1.4.0-9.el7_8.1 bind-export-libs.x86_64 32:9.11.4-16.P2.el7_8.6 bind-libs.x86_64 32:9.11.4-16.P2.el7_8.6 bind-libs-lite.x86_64 32:9.11.4-16.P2.el7_8.6 bind-license.noarch 32:9.11.4-16.P2.el7_8.6 bind-utils.x86_64 32:9.11.4-16.P2.el7_8.6 binutils.x86_64 0:2.27-43.base.el7_8.1 certbot.noarch 0:1.4.0-1.el7 device-mapper.x86_64 7:1.02.164-7.el7_8.2 device-mapper-event.x86_64 7:1.02.164-7.el7_8.2 device-mapper-event-libs.x86_64 7:1.02.164-7.el7_8.2 device-mapper-libs.x86_64 7:1.02.164-7.el7_8.2 galera.x86_64 0:25.3.29-1.rhel7.el7.centos git.x86_64 0:1.8.3.1-23.el7_8 kernel-tools.x86_64 0:3.10.0-1127.10.1.el7 kernel-tools-libs.x86_64 0:3.10.0-1127.10.1.el7 libgudev1.x86_64 0:219-73.el7_8.6 lvm2.x86_64 7:2.02.186-7.el7_8.2 lvm2-libs.x86_64 7:2.02.186-7.el7_8.2 open-vm-tools.x86_64 0:10.3.10-2.el7_8.1 perl-Git.noarch 0:1.8.3.1-23.el7_8 python-perf.x86_64 0:3.10.0-1127.10.1.el7 python-requests-toolbelt.noarch 0:0.8.0-3.el7 python-syspurpose.x86_64 0:1.24.26-3.el7_8 python2-acme.noarch 0:1.4.0-2.el7 python2-certbot.noarch 0:1.4.0-1.el7 python2-certbot-apache.noarch 0:1.4.0-1.el7 python2-configargparse.noarch 0:0.11.0-2.el7 subscription-manager.x86_64 0:1.24.26-3.el7_8 subscription-manager-rhsm.x86_64 0:1.24.26-3.el7_8 subscription-manager-rhsm-certificates.x86_64 0:1.24.26-3.el7_8 systemd.x86_64 0:219-73.el7_8.6 systemd-libs.x86_64 0:219-73.el7_8.6 systemd-python.x86_64 0:219-73.el7_8.6 systemd-sysv.x86_64 0:219-73.el7_8.6 tzdata.noarch 0:2020a-1.el7 yum-utils.noarch 0:1.1.31-54.el7_8 ======================================================================= 2020-06-11 # yum install rkhunter # rkhunter --propupd ======================================================================= 2020-09-01 Removed: kernel.x86_64 0:3.10.0-1062.12.1.el7 Installed: kernel.x86_64 0:3.10.0-1127.19.1.el7 Updated: MariaDB-client.x86_64 0:10.1.46-1.el7.centos MariaDB-common.x86_64 0:10.1.46-1.el7.centos MariaDB-server.x86_64 0:10.1.46-1.el7.centos MariaDB-shared.x86_64 0:10.1.46-1.el7.centos ca-certificates.noarch 0:2020.2.41-70.0.el7_8 certbot.noarch 0:1.6.0-1.el7 curl.x86_64 0:7.29.0-57.el7_8.1 dbus.x86_64 1:1.10.24-14.el7_8 dbus-libs.x86_64 1:1.10.24-14.el7_8 grub2.x86_64 1:2.02-0.86.el7_8 grub2-common.noarch 1:2.02-0.86.el7_8 grub2-pc.x86_64 1:2.02-0.86.el7_8 grub2-pc-modules.noarch 1:2.02-0.86.el7_8 grub2-tools.x86_64 1:2.02-0.86.el7_8 grub2-tools-extra.x86_64 1:2.02-0.86.el7_8 grub2-tools-minimal.x86_64 1:2.02-0.86.el7_8 kernel-tools.x86_64 0:3.10.0-1127.19.1.el7 kernel-tools-libs.x86_64 0:3.10.0-1127.19.1.el7 libcurl.x86_64 0:7.29.0-57.el7_8.1 libgudev1.x86_64 0:219-73.el7_8.9 microcode_ctl.x86_64 2:2.1-61.10.el7_8 ntp.x86_64 0:4.2.6p5-29.el7_8.2 ntpdate.x86_64 0:4.2.6p5-29.el7_8.2 python-perf.x86_64 0:3.10.0-1127.19.1.el7 python-syspurpose.x86_64 0:1.24.26-4.el7_8 python2-acme.noarch 0:1.6.0-1.el7 python2-certbot.noarch 0:1.6.0-1.el7 python2-certbot-apache.noarch 0:1.6.0-1.el7 python2-qpid-proton.x86_64 0:0.31.0-3.el7 qpid-proton-c.x86_64 0:0.31.0-3.el7 rsyslog.x86_64 0:8.24.0-52.el7_8.2 selinux-policy.noarch 0:3.13.1-266.el7_8.1 selinux-policy-targeted.noarch 0:3.13.1-266.el7_8.1 subscription-manager.x86_64 0:1.24.26-4.el7_8 subscription-manager-rhsm.x86_64 0:1.24.26-4.el7_8 subscription-manager-rhsm-certificates.x86_64 0:1.24.26-4.el7_8 systemd.x86_64 0:219-73.el7_8.9 systemd-libs.x86_64 0:219-73.el7_8.9 systemd-python.x86_64 0:219-73.el7_8.9 systemd-sysv.x86_64 0:219-73.el7_8.9 ======================================================================= 2020-09-08 /etc/profile.d/tmout.sh #!/bin/bash # 3600s = 60m TMOUT=3600 readonly TMOUT export TMOUT ======================================================================= 2020-11-12 # yum -y install redhat-lsb-core Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. No package redhat-lsb-core available. Error: Nothing to do [root@dbase01-EduCld-RH7 ~] 14:27:19 # subscription-manager register --org="UBCPhysicsAndAstronomy" --activationkey="PHAS-RHEL7" The system has been registered with ID: 609ca697-aaf2-4f84-b662-6e8d1efe3e03 The registered system name is: dbase01.phas.ubc.ca Installed Product Current Status: Product Name: Red Hat Enterprise Linux Server Status: Subscribed [root@dbase01-EduCld-RH7 ~] 14:28:23 # yum -y install redhat-lsb-core Installed: redhat-lsb-core.x86_64 0:4.1-27.el7 Dependency Installed: at.x86_64 0:3.1.13-24.el7 cups-client.x86_64 1:1.6.3-51.el7 cups-libs.x86_64 1:1.6.3-51.el7 ed.x86_64 0:1.9-4.el7 m4.x86_64 0:1.4.16-10.el7 patch.x86_64 0:2.7.1-12.el7_7 psmisc.x86_64 0:22.20-17.el7 redhat-lsb-submod-security.x86_64 0:4.1-27.el7 spax.x86_64 0:1.5.2-13.el7 time.x86_64 0:1.7-45.el7 ======================================================================= Jan 21 14:15:13 Updated: 7:device-mapper-libs-1.02.170-6.el7_9.3.x86_64 Jan 21 14:15:13 Updated: 7:device-mapper-1.02.170-6.el7_9.3.x86_64 Jan 21 14:15:13 Updated: 7:device-mapper-event-libs-1.02.170-6.el7_9.3.x86_64 Jan 21 14:15:13 Updated: python2-acme-1.11.0-1.el7.noarch Jan 21 14:15:14 Updated: python2-certbot-1.11.0-1.el7.noarch Jan 21 14:15:14 Updated: 32:bind-license-9.11.4-26.P2.el7_9.3.noarch Jan 21 14:15:14 Updated: 32:bind-libs-lite-9.11.4-26.P2.el7_9.3.x86_64 Jan 21 14:15:14 Updated: 32:bind-libs-9.11.4-26.P2.el7_9.3.x86_64 Jan 21 14:15:23 Updated: certbot-1.11.0-1.el7.noarch Jan 21 14:15:23 Updated: 7:device-mapper-event-1.02.170-6.el7_9.3.x86_64 Jan 21 14:15:24 Updated: 7:lvm2-libs-2.02.187-6.el7_9.3.x86_64 Jan 21 14:15:24 Updated: subscription-manager-rhsm-certificates-1.24.45-1.el7_9.x86_64 Jan 21 14:15:24 Updated: subscription-manager-rhsm-1.24.45-1.el7_9.x86_64 Jan 21 14:15:24 Updated: 2:vim-filesystem-7.4.629-8.el7_9.x86_64 Jan 21 14:15:27 Updated: 2:vim-common-7.4.629-8.el7_9.x86_64 Jan 21 14:15:27 Updated: python-syspurpose-1.24.45-1.el7_9.x86_64 Jan 21 14:15:28 Updated: subscription-manager-1.24.45-1.el7_9.x86_64 Jan 21 14:15:28 Updated: 2:vim-enhanced-7.4.629-8.el7_9.x86_64 Jan 21 14:15:29 Updated: 7:lvm2-2.02.187-6.el7_9.3.x86_64 Jan 21 14:15:29 Updated: python2-certbot-apache-1.11.0-1.el7.noarch Jan 21 14:15:29 Updated: 32:bind-utils-9.11.4-26.P2.el7_9.3.x86_64 Jan 21 14:15:29 Updated: 2:vim-minimal-7.4.629-8.el7_9.x86_64 Jan 21 14:15:31 Updated: tzdata-2020f-1.el7.noarch Jan 21 14:15:46 Updated: 2:microcode_ctl-2.1-73.4.el7_9.x86_64 Jan 21 14:15:46 Updated: 32:bind-export-libs-9.11.4-26.P2.el7_9.3.x86_64 Jan 21 14:15:46 Updated: epel-release-7-13.noarch ======================================================================== Feb 01 07:29:01 Updated: qpid-proton-c-0.33.0-1.el7.x86_64 Feb 01 07:29:01 Updated: python2-qpid-proton-0.33.0-1.el7.x86_64 ===================================================================================================== Feb 03 13:13:09 Updated: glibc.x86_64 2.17-322.el7_9 Feb 03 13:13:16 Updated: glibc-common.x86_64 2.17-322.el7_9 Feb 03 13:13:16 Updated: perl-libs.x86_64 4:5.16.3-299.el7_9 Feb 03 13:13:16 Updated: perl-macros.x86_64 4:5.16.3-299.el7_9 Feb 03 13:13:19 Updated: perl.x86_64 4:5.16.3-299.el7_9 Feb 03 13:13:20 Updated: kernel-tools-libs.x86_64 3.10.0-1160.15.2.el7 Feb 03 13:13:35 Updated: linux-firmware.noarch 20200421-80.git78c0348.el7_9 Feb 03 13:13:48 Installed: kernel.x86_64 3.10.0-1160.15.2.el7 Feb 03 13:13:48 Updated: kernel-tools.x86_64 3.10.0-1160.15.2.el7 Feb 03 13:13:48 Updated: perl-Pod-Escapes.noarch 1:1.04-299.el7_9 Feb 03 13:13:49 Updated: python-perf.x86_64 3.10.0-1160.15.2.el7 Feb 03 13:13:50 Updated: sudo.x86_64 1.8.23-10.el7_9.1 Feb 03 13:13:50 Updated: iwl6000g2a-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 13:13:50 Updated: iwl2000-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 13:13:50 Updated: iwl1000-firmware.noarch 1:39.31.5.1-80.el7_9 Feb 03 13:13:50 Updated: iwl4965-firmware.noarch 228.61.2.24-80.el7_9 Feb 03 13:13:50 Updated: iwl100-firmware.noarch 39.31.5.1-80.el7_9 Feb 03 13:13:50 Updated: iwl5150-firmware.noarch 8.24.2.2-80.el7_9 Feb 03 13:13:50 Updated: iwl6000g2b-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 13:13:50 Updated: iwl6050-firmware.noarch 41.28.5.1-80.el7_9 Feb 03 13:13:51 Updated: iwl3160-firmware.noarch 25.30.13.0-80.el7_9 Feb 03 13:13:51 Updated: iwl6000-firmware.noarch 9.221.4.1-80.el7_9 Feb 03 13:13:51 Updated: iwl3945-firmware.noarch 15.32.2.9-80.el7_9 Feb 03 13:13:51 Updated: iwl2030-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 13:13:51 Updated: iwl135-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 13:13:51 Updated: iwl5000-firmware.noarch 8.83.5.1_1-80.el7_9 Feb 03 13:13:53 Updated: iwl7260-firmware.noarch 25.30.13.0-80.el7_9 Feb 03 13:13:53 Updated: iwl105-firmware.noarch 18.168.6.1-80.el7_9 Feb 03 15:24:43 Updated: systemd-libs-219-78.el7_9.3.x86_64 Feb 03 15:24:43 Updated: libuuid-2.23.2-65.el7_9.1.x86_64 Feb 03 15:24:43 Updated: libblkid-2.23.2-65.el7_9.1.x86_64 Feb 03 15:24:43 Updated: libmount-2.23.2-65.el7_9.1.x86_64 Feb 03 15:24:43 Updated: zlib-1.2.7-19.el7_9.x86_64 Feb 03 15:24:46 Updated: systemd-219-78.el7_9.3.x86_64 Feb 03 15:24:46 Updated: libsmartcols-2.23.2-65.el7_9.1.x86_64 Feb 03 15:24:47 Updated: util-linux-2.23.2-65.el7_9.1.x86_64 Feb 03 15:24:47 Updated: tuned-2.11.0-11.el7_9.noarch Feb 03 15:24:47 Updated: systemd-python-219-78.el7_9.3.x86_64 Feb 03 15:24:47 Updated: systemd-sysv-219-78.el7_9.3.x86_64 Feb 03 15:24:47 Updated: libgudev1-219-78.el7_9.3.x86_64 Feb 03 15:24:49 Updated: tzdata-2021a-1.el7.noarch ===================================================================================================== 2021-02-03 # subscription-manager unregister; subscription-manager clean; subscription-manager register --org=UBCITServices --activationkey=RHEL7; subscription-manager repos --enable=rhel-7-server-optional-rpms; yum upgrade Unregistering from: satellite6.it.ubc.ca:443/rhsm System has been unregistered. All local data removed The system has been registered with ID: 4e060e1f-de0a-4f6f-9e54-b25fba9b253d The registered system name is: dbase01.phas.ubc.ca Installed Product Current Status: Product Name: Red Hat Enterprise Linux Server Status: Subscribed Repository 'rhel-7-server-optional-rpms' is enabled for this system. Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager rhel-7-server-optional-rpms | 1.8 kB 00:00:00 rhel-7-server-rpms | 2.0 kB 00:00:00 Not using downloaded rhel-7-server-rpms/repomd.xml because it is older than what we have: Current : Wed Feb 3 12:24:38 2021 Downloaded: Wed Jan 27 23:42:10 2021 rhel-7-server-satellite-tools-6.6-rpms | 2.1 kB 00:00:00 (1/2): rhel-7-server-optional-rpms/7Server/x86_64/updateinfo | 2.9 MB 00:00:00 (2/2): rhel-7-server-optional-rpms/7Server/x86_64/primary | 6.6 MB 00:00:01 rhel-7-server-optional-rpms 22504/22504 No packages marked for update Uploading Enabled Repositories Report Loaded plugins: product-id, subscription-manager ===================================================================================================== 2021-02-04 # subscription-manager repos --list-enabled; subscription-manager repos --disable=rhel-7-server-satellite-tools-6.6-rpms; yum upgrade +----------------------------------------------------------+ Available Repositories in /etc/yum.repos.d/redhat.repo +----------------------------------------------------------+ Repo ID: rhel-7-server-optional-rpms Repo Name: Red Hat Enterprise Linux 7 Server - Optional (RPMs) Repo URL: https://satellite6.it.ubc.ca/pulp/repos/UBCITServices/Library/RHEL-7/content/dist/rhel/server/7/$releasever/$basearch/optional/o s Enabled: 1 Repo ID: rhel-7-server-rpms Repo Name: Red Hat Enterprise Linux 7 Server (RPMs) Repo URL: https://satellite6.it.ubc.ca/pulp/repos/UBCITServices/Library/RHEL-7/content/dist/rhel/server/7/$releasever/$basearch/os Enabled: 1 Repo ID: rhel-7-server-satellite-tools-6.6-rpms Repo Name: Red Hat Satellite Tools 6.6 (for RHEL 7 Server) (RPMs) Repo URL: https://satellite6.it.ubc.ca/pulp/repos/UBCITServices/Library/RHEL-7/content/dist/rhel/server/7/7Server/$basearch/sat-tools/6.6/ os Enabled: 1 Repository 'rhel-7-server-satellite-tools-6.6-rpms' is disabled for this system. Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager rhel-7-server-optional-rpms | 1.8 kB 00:00:00 rhel-7-server-rpms | 2.0 kB 00:00:00 No packages marked for update Uploading Enabled Repositories Report Loaded plugins: product-id, subscription-manager ===================================================================================================== Feb 23 00:03:59 Updated: xterm.x86_64 295-3.el7_9.1 Feb 23 11:15:36 Updated: python-gofer-2.12.5-7.el7sat.noarch Feb 23 11:15:37 Updated: gofer-2.12.5-7.el7sat.noarch Feb 23 11:15:37 Updated: python-gofer-proton-2.12.5-7.el7sat.noarch Feb 23 11:15:43 Updated: glibc-2.17-323.el7_9.x86_64 Feb 23 11:15:57 Updated: glibc-common-2.17-323.el7_9.x86_64 Feb 23 11:15:58 Updated: katello-host-tools-fact-plugin-3.5.4-1.el7sat.noarch Feb 23 11:15:58 Updated: katello-host-tools-3.5.4-1.el7sat.noarch Feb 23 11:15:58 Updated: katello-agent-3.5.4-1.el7sat.noarch Feb 23 11:16:22 Updated: 2:microcode_ctl-2.1-73.8.el7_9.x86_64 ===================================================================================================== ===================================================================================================== Apr 20 13:47:24 Updated: 1:grub2-common-2.02-0.87.el7_9.6.noarch Apr 20 13:47:24 Updated: 7:device-mapper-libs-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 7:device-mapper-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 7:device-mapper-event-libs-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 1:grub2-tools-minimal-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:25 Updated: 1:grub2-tools-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:26 Updated: 1:grub2-tools-extra-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:27 Updated: 7:device-mapper-event-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:27 Updated: 7:lvm2-libs-2.02.187-6.el7_9.4.x86_64 Apr 20 13:47:28 Updated: 1:grub2-pc-modules-2.02-0.87.el7_9.6.noarch Apr 20 13:47:28 Updated: 1:grub2-pc-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:28 Updated: 1:grub2-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:29 Updated: 7:lvm2-2.02.187-6.el7_9.4.x86_64 Apr 20 13:47:29 Updated: redhat-release-server-7.9-6.el7_9.x86_64 Apr 20 13:47:30 Updated: 1:dmidecode-3.2-5.el7_9.1.x86_64 Apr 20 13:47:30 Updated: open-vm-tools-11.0.5-3.el7_9.2.x86_64 ===================================================================================================== Apr 20 13:47:24 Updated: 1:grub2-common-2.02-0.87.el7_9.6.noarch Apr 20 13:47:24 Updated: 7:device-mapper-libs-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 7:device-mapper-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 7:device-mapper-event-libs-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:24 Updated: 1:grub2-tools-minimal-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:25 Updated: 1:grub2-tools-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:26 Updated: 1:grub2-tools-extra-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:27 Updated: 7:device-mapper-event-1.02.170-6.el7_9.4.x86_64 Apr 20 13:47:27 Updated: 7:lvm2-libs-2.02.187-6.el7_9.4.x86_64 Apr 20 13:47:28 Updated: 1:grub2-pc-modules-2.02-0.87.el7_9.6.noarch Apr 20 13:47:28 Updated: 1:grub2-pc-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:28 Updated: 1:grub2-2.02-0.87.el7_9.6.x86_64 Apr 20 13:47:29 Updated: 7:lvm2-2.02.187-6.el7_9.4.x86_64 Apr 20 13:47:29 Updated: redhat-release-server-7.9-6.el7_9.x86_64 Apr 20 13:47:30 Updated: 1:dmidecode-3.2-5.el7_9.1.x86_64 Apr 20 13:47:30 Updated: open-vm-tools-11.0.5-3.el7_9.2.x86_64 ===================================================================================================== NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT fd0 2:0 1 4K 0 disk sda 8:0 0 256M 0 disk └─sda1 8:1 0 255M 0 part /boot sdb 8:16 0 32G 0 disk ├─VGroot-ThinPool_tmeta 253:0 0 28M 0 lvm │ └─VGroot-ThinPool-tpool 253:2 0 32G 0 lvm │ ├─VGroot-LVroot 253:3 0 9G 0 lvm / │ ├─VGroot-LVswap 253:4 0 3.9G 0 lvm [SWAP] │ ├─VGroot-ThinPool 253:7 0 32G 1 lvm │ ├─VGroot-LVhome 253:8 0 6.3G 0 lvm /home │ ├─VGroot-LVaudit 253:9 0 1G 0 lvm /var/log/audit │ ├─VGroot-LVlog 253:10 0 3.9G 0 lvm /var/log │ ├─VGroot-LVtmp 253:11 0 3G 0 lvm /var/tmp │ └─VGroot-LVvar 253:12 0 3.9G 0 lvm /var └─VGroot-ThinPool_tdata 253:1 0 32G 0 lvm └─VGroot-ThinPool-tpool 253:2 0 32G 0 lvm ├─VGroot-LVroot 253:3 0 9G 0 lvm / ├─VGroot-LVswap 253:4 0 3.9G 0 lvm [SWAP] ├─VGroot-ThinPool 253:7 0 32G 1 lvm ├─VGroot-LVhome 253:8 0 6.3G 0 lvm /home ├─VGroot-LVaudit 253:9 0 1G 0 lvm /var/log/audit ├─VGroot-LVlog 253:10 0 3.9G 0 lvm /var/log ├─VGroot-LVtmp 253:11 0 3G 0 lvm /var/tmp └─VGroot-LVvar 253:12 0 3.9G 0 lvm /var sdc 8:32 0 32G 0 disk └─sdc1 8:33 0 32G 0 part └─VGmysql-LVmysql 253:6 0 32G 0 lvm /var/lib/mysql sdd 8:48 0 64G 0 disk └─sdd1 8:49 0 64G 0 part └─VGbackup-LVbackup 253:5 0 64G 0 lvm /backups sr0 11:0 1 1024M 0 rom ===================================================================================================== ===================================================================================================== May 31 16:13:52 Updated: glibc-2.17-324.el7_9.x86_64 May 31 16:13:58 Updated: glibc-common-2.17-324.el7_9.x86_64 May 31 16:13:58 Updated: 7:device-mapper-1.02.170-6.el7_9.5.x86_64 May 31 16:13:58 Updated: 7:device-mapper-libs-1.02.170-6.el7_9.5.x86_64 May 31 16:13:58 Updated: 7:device-mapper-event-libs-1.02.170-6.el7_9.5.x86_64 May 31 16:13:59 Updated: 7:device-mapper-event-1.02.170-6.el7_9.5.x86_64 May 31 16:13:59 Updated: 7:lvm2-libs-2.02.187-6.el7_9.5.x86_64 May 31 16:13:59 Updated: qpid-proton-c-0.34.0-1.el7.x86_64 May 31 16:14:00 Updated: kernel-tools-libs-3.10.0-1160.25.1.el7.x86_64 May 31 16:14:00 Updated: python-syspurpose-1.24.48-1.el7_9.x86_64 May 31 16:14:01 Updated: python-firewall-0.6.3-13.el7_9.noarch May 31 16:14:01 Updated: firewalld-filesystem-0.6.3-13.el7_9.noarch May 31 16:14:01 Updated: subscription-manager-rhsm-certificates-1.24.48-1.el7_9.x86_64 May 31 16:14:01 Updated: subscription-manager-rhsm-1.24.48-1.el7_9.x86_64 May 31 16:14:01 Updated: subscription-manager-1.24.48-1.el7_9.x86_64 May 31 16:14:02 Updated: firewalld-0.6.3-13.el7_9.noarch May 31 16:14:02 Updated: kernel-tools-3.10.0-1160.25.1.el7.x86_64 May 31 16:14:02 Updated: python2-qpid-proton-0.34.0-1.el7.x86_64 May 31 16:14:03 Updated: 7:lvm2-2.02.187-6.el7_9.5.x86_64 May 31 16:14:04 Updated: kexec-tools-2.0.15-51.el7_9.2.x86_64 May 31 16:14:04 Updated: open-vm-tools-11.0.5-3.el7_9.3.x86_64 May 31 16:14:04 Updated: dnsmasq-2.76-17.el7_9.1.x86_64 May 31 16:14:04 Updated: python-perf-3.10.0-1160.25.1.el7.x86_64 May 31 16:14:05 Updated: rkhunter-1.4.6-3.el7.noarch May 31 16:14:20 Installed: kernel-3.10.0-1160.25.1.el7.x86_64 ===================================================================================================== 22-07-21 # yum udpate dbase01 ERROR: http://yum.mariadb.org/10.1/rhel7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found Trying other mirror. To address this issue please refer to the below knowledge base article https://access.redhat.com/articles/1320623 If above article doesn't help to resolve this issue please open a ticket with Red Hat Support. One of the configured repositories failed (MariaDB), and yum doesn't have enough cached data to continue. At this point the only safe thing yum can do is fail. There are a few ways to work "fix" this: 1. Contact the upstream for the repository and get them to fix the problem. 2. Reconfigure the baseurl/etc. for the repository, to point to a working upstream. This is most often useful if you are using a newer distribution release than is supported by the repository (and the packages for the previous distribution release still work). 3. Run the command with the repository temporarily disabled yum --disablerepo=mariadb ... 4. Disable the repository permanently, so yum won't use it by default. Yum will then just ignore the repository until you permanently enable it again or use --enablerepo for temporary usage: yum-config-manager --disable mariadb or subscription-manager repos --disable=mariadb 5. Configure the failing repository to be skipped, if it is unavailable. Note that yum will try to contact the repo. when it runs most commands, so will have to try and fail each time (and thus. yum will be be much slower). If it is a very temporary problem though, this is often a nice compromise: yum-config-manager --save --setopt=mariadb.skip_if_unavailable=true failure: repodata/repomd.xml from mariadb: [Errno 256] No more mirrors to try. http://yum.mariadb.org/10.1/rhel7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found 0 # yum-config-manager --disable mariadb Loaded plugins: product-id, subscription-manager ======================================================= repo: mariadb ======================================================= [mariadb] async = True bandwidth = 0 base_persistdir = /var/lib/yum/repos/x86_64/7Server baseurl = http://yum.mariadb.org/10.1/rhel7-amd64 cache = 0 cachedir = /var/cache/yum/x86_64/7Server/mariadb check_config_file_age = True compare_providers_priority = 80 cost = 1000 deltarpm_metadata_percentage = 100 deltarpm_percentage = enabled = 0 enablegroups = True exclude = failovermethod = priority ftp_disable_epsv = False gpgcadir = /var/lib/yum/repos/x86_64/7Server/mariadb/gpgcadir gpgcakey = gpgcheck = True gpgdir = /var/lib/yum/repos/x86_64/7Server/mariadb/gpgdir gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB hdrdir = /var/cache/yum/x86_64/7Server/mariadb/headers http_caching = all includepkgs = ip_resolve = keepalive = True keepcache = False mddownloadpolicy = sqlite mdpolicy = group:small mediaid = metadata_expire = 21600 metadata_expire_filter = read-only:present metalink = minrate = 0 mirrorlist = mirrorlist_expire = 86400 name = MariaDB old_base_cache_dir = password = persistdir = /var/lib/yum/repos/x86_64/7Server/mariadb pkgdir = /var/cache/yum/x86_64/7Server/mariadb/packages proxy = False proxy_dict = proxy_password = proxy_username = repo_gpgcheck = False retries = 10 skip_if_unavailable = False ssl_check_cert_permissions = True sslcacert = sslclientcert = sslclientkey = sslverify = True throttle = 0 timeout = 30.0 ui_id = mariadb ui_repoid_vars = releasever, basearch username = ===================================================================================================== 22-07-21 migrate users from dbase01 to dbase03 https://wisdmlabs.com/blog/migrate-mysql-users-one-server-another/ # cd /etc/automysqlbackup/ # mysql -B -N -uroot -p -e "SELECT CONCAT('\'', user,'\'@\'', host, '\'') FROM user WHERE user != 'debian-sys-maint' AND user != 'root' AND user != ''" mysql > mysql_all_users.txt # vim mysql_all_users.txt # while read line; do mysql -B -N -uroot -p -e "SHOW GRANTS FOR $line"; done < mysql_all_users.txt > mysql_all_users_sql.sql # vim mysql_all_users_sql.sql # sed -i 's/$/;/' mysql_all_users_sql.sql # vim mysql_all_users_sql.sql Importing the Users Transfer this file onto the new server. On the new server: Navigate to the directory where you have stored the file and execute the cmd below: #mysql -u root -p < mysql_all_users_sql.sql ===================================================================================================== 22-07-22 slow ssh logins, paused for seconds after pledge: filesystem systemctl restart systemd-logind fixed the problem. ===================================================================================================== 22-08-01 aliased dbase01 to dabse03, renamed dbase01 to dbase01x ===================================================================================================== 22-08-02 stopped mariadb.service and disabled it. ===================================================================================================== =====================================================================================================