Category: FromSitesTree.com

A Data Warehouse is a storage of an organization’s historical data. Usually, data warehouse is built to provide a decision support system to the management. Data warehouse can be mined (using data mining) and queried to collect overall and summarized business information that significantly helps in decision making. It can provide trends over many years. …

Continue reading

  Most BI projects usually fail. It is not due to the errors in the construction steps but due to the inappropriate design steps and methodologies. Waterfall method is not appropriate for BI. A method like developmental spiral may be more appropriate. Ref: [W. A. Giovinazzo ] Steps in developmental spiral: Definition, Analysis, Design, Development, …

Continue reading

AutoFS and Mounting in Linux/Redhat/CentOS echo “AutoFS – Automatic FS system Mounting – Dec 26th, 2017 by Sayed” check if Autofs installed or not yum list installed | grep autofs I just installed; hence it is there you can install with yum -y install autofs 944 yum -y install autofs then you can enable autofs …

Continue reading

RHCE: MariaDB Administration on Redhat/Fedora/CentOS Check if mariaDB is installed or not 130 yum list installed | grep ^mariadb mariaDB originated from MySQL – after MySQL Got Bought by Oracle 133 yum list installed | grep ^mariadb I see – installed though not completely Output: mariadb-libs.x86_64 1:5.5.52-1.el7 @anaconda There are two other components: mariaDB – …

Continue reading

The idea was : use two servers; server1, and server2 create user: user1 in both server1 and server2 use nmtui to assign IP Addresses to both use ifdown and ifup to check if IPs are assigned properly change /etc/hosts and add the server ips and names use ping to know that you can reach each …

Continue reading

echo “Dec 22nd 2017” 321 pvs 322 output 323 PV VG Fmt Attr PSize PFree 324 /dev/sda2 cl lvm2 a– 19.00g 0 325 pvs 326 vgs 327 lsblk 328 vgdisplay 329 vgdisplay | grep “PE Size” 330 PE Size 4.00 MiB 331 vgdisplay > vgdisplay20171222.txt 332 vgdisplay | grep ‘PE Size’> vgdisplay20171222.txt 333 lvs 334 …

Continue reading

echo “Dec 24th, 2017” 532 echo “Basic Networking in Linux” 533 hostname 534 uname -a 535 uname -n 536 cat /etc/hostname 537 nmcli general hostname 538 changing hostname temporarily 539 hostname server10.example.com 540 for permanent change 541 hostnamectl set-hostname server100.example.com 542 or change /etc/hostname file 543 vim /etc/hostname 544 restart systemctl 545 systemctl restart systemd-hostnamed …

Continue reading

598 echo “dec 24th, 2017” 599 echo “NTP Client” 600 yum list ntp 601 yum list installed |grep ntp 602 To activate ntp 603 yum -y install ntp system-config-date 604 cat /etc/ntp.conf 605 grep ^server /etc/ntp.conf 606 systemctl restart ntpd 607 systemctl enable ntpd 608 systemctl start ntpd 609 ntpq -p 612 nmtui 613 ip …

Continue reading

Yum is a software installation manager for Redhat Linux and Related. yum is a better tool than rpm. Here, we will take the rpm packages as come with Redhat/Centos and then we will host those packages on our own Repo Server for yum. i.e. yum will use this Repo to find installers rather than going …

Continue reading

44 firewall-cmd –state 45 systemctl status firewalld 46 firewall-cmd –reload 47 systemctl restart firewalld.service systemctl restart firewalld 48 firewall-cmd –get-default-zone 49 firewall-cmd –get-active-zones 50 firewall-cmd –get-zones 51 firewall-cmd –get-zone-of-interface=ens33 52 firewall-cmd –list-all 53 firewall-cmd –list-all-zones 54 firewall-cmd –get-default-zone 55 firewall-cmd –get-active-zones 56 firewall-cmd –list-all 57 firewall-cmd –get-zones 58 firewall-cmd –list-all-zones 59 firewall-cmd –list-all –zone external …

Continue reading