.::: OID CPU Utilization for Monitoring CPU Windows, Linux, Appliance & Other :::.

CPU utilization is the sum of work handled by a Central Processing Unit. It is also used to estimate system performance. CPU utilization can vary according to the type and amount of computing task because some tasks require heavy CPU time while others require less CPU time. Process time is another name for CPU time and is the amount of time used by a CPU for processing instruction of an operating system or a computer program. CPU time is quantified in clock ticks or seconds. CPU utilization shows the burden on a processor in terms of percentage that indicates if any changes are to be made in the system otherwise it may get exhausted of capacity.

CPU utilization can be calculated by using the following formulas.

Let us define CPU utilization as U


U = 100% - (Percentage of time that is spent in idle task)


% time in idle task =

(Take the average time period of background task without load) * 100%
-------------------------------------------------------------------------------------------------------
(Avg. period of background task including some load)

.::: Add Sensor Factory on PRTG :::.

The Sensor Factory sensor is a powerful tool that allows you to monitor entire business processes that involve several components.
You can define one or more channels that combine monitoring results from other sensors or devices. You can create your own individual sensor with channels based on data from other sensors or devices.
Samples for usage are:
    Show single channels of one or more sensors in one graph.
    Use the data from single channels of one or more sensors to calculate new values (for example, you can subtract, multiply, and divide).
    Create graphs with data from other sensor channels and add horizontal lines at specific vertical positions.

.::: Add Sensor SNMP Custom on PRTG :::.

The SNMP Custom sensor monitors a single parameter that is returned by a specific Object Identifier (OID) using Simple Network Management Protocol (SNMP).
This sensor shows a single numerical value (int64) for a given OID. Each OID always refers to a specific parameter of a certain SNMP device.

base on sample monitoring palo alto using OID , this resume to monitor
1. snmpwalk device and make sure output

[root@TeguhLab ~]# snmpwalk -v2c -c public 10.10.10.10 1.3.6.1.2.1.47.1.1.1.1.7.10
SNMPv2-SMI::mib-2.47.1.1.1.1.7.10 = STRING: "Temperature @ Switch Core"
[root@TeguhLab ~]# snmpwalk -v2c -c public 10.10.10.10 1.3.6.1.2.1.99.1.1.1.4.10
SNMPv2-SMI::mib-2.99.1.1.1.4.10 = INTEGER: 51
[root@TeguhLab ~]# snmpwalk -v2c -c public 10.10.10.10 1.3.6.1.2.1.99.1.1.1.5.10
SNMPv2-SMI::mib-2.99.1.1.1.5.10 = INTEGER: 1
[root@TeguhLab ~]# snmpwalk -v2c -c public 10.10.10.10 1.3.6.1.2.1.99.1.1.1.6.10
SNMPv2-SMI::mib-2.99.1.1.1.6.10 = STRING: "(C)"
[root@TeguhLab ~]#

.::: Monitoring (OID/MIB) Temperature, Fan Speed PaloAlto Firewall On NMS(PRTG, Infosim Stablenet):::.

Palo Alto Networks, Inc. is a network and enterprise security company based in Santa Clara, California. The company’s core products are a platform that includes advanced firewalls designed to provide network security, visibility, and granular control of network activity based on application, user, and content identification and cloud-based offerings that extend those firewalls to cover other aspects of security. In 2017, Palo Alto Networks announced the availability of its new cloud-based service Logging Services, allowing customers to amass their own data.
for this Monitor Temperature, Fan speed Must enable ENTITY-SENSOR-MIB.mib

This is lab specialist for palo Alto PA-3000 / PA-3020
OID PA-3020 = OID PA-5050 =OID PA Firewall

1. Info Hardware Temperature & Fan

info OID Hardware : 1.3.6.1.2.1.47.1.1.1.1.7

[root@TeguhLab ~]# snmpwalk -v2c -c  teguht 10.10.10.10 1.3.6.1.2.1.47.1.1.1.1.7
SNMPv2-SMI::mib-2.47.1.1.1.1.7.1 = STRING: "PA-3020"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.2 = STRING: "Fan #1 RPM"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.3 = STRING: "Fan #2 RPM"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.4 = STRING: "Fan #3 RPM"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.5 = STRING: "Fan #4 RPM"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.6 = STRING: "Temperature @ Ocelot"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.7 = STRING: "Temperature @ Switch"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.8 = STRING: "Temperature @ Cavium"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.9 = STRING: "Temperature @ Intel PHY"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.10 = STRING: "Temperature @ Switch Core"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.11 = STRING: "Temperature @ Cavium Core"
[root@TeguhLab ~]#

.::: How to Create Tablespace & Check Capacity, Add datafile On existing tablespace, Change Autoextend :::.

A tablespace is a container for segments (tables, indexes, etc). A database consists of one or more tablespaces, each made up of one or more data files. Tables and indexes are created within a particular tablespace. Oracle has a limit of 64,000 data files per database.

1. Create new tablespace, create user, grant previledge

[oracle@TeguhLabOracle ~]$ more Teguhdatatgh.sql

CREATE TABLESPACE Teguhdata DATAFILE '$ORACLE_BASE/oradata/tgh/Teguhdata.dbf' size 100M AUTOEXTEND ON;

.::: How Settting & Install Package OS Centos 7 Using Repolocal, ISO File :::.

1. Make sure Iso file copying on Disk
[root@TeguhLab7 data]# ls
CentOS-7-x86_64-DVD-1708.iso                 lm_sensors-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm       net-snmp-perl-5.7.2-28.el7.x86_64.rpm  repolocal
compat-libstdc++-33-3.2.3-72.el7.i686.rpm    lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm  psensor-1.1.3                          snmpd
compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm  lm sensor.txt                                              psensor-1.1.3.tar.gz
[root@TeguhLab7 data]#


for repolocal
[root@Centos7 yum.repos.d]# df -kh
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-root   27G  7.7G   19G  29% /
devtmpfs                 2.9G     0  2.9G   0% /dev
tmpfs                    2.9G  156K  2.9G   1% /dev/shm
tmpfs                    2.9G  8.9M  2.9G   1% /run
tmpfs                    2.9G     0  2.9G   0% /sys/fs/cgroup
/dev/sda1                497M  124M  373M  25% /boot
/dev/loop0               4.3G  4.3G     0 100% /mnt
/dev/sr0                 4.1G  4.1G     0 100% /run/media/root/CentOS 7 x86_64
[root@Centos7 yum.repos.d]#

2. mounting to /mnt
[root@TeguhLab7 data]# mount -o loop CentOS-7-x86_64-DVD-1708.iso /mnt/

.::: Enable CPU Temperature Information on Linux (Rhel6/Centos6),(Rhel7/Centos7) Using lm_sensors :::.

lm_sensors (Linux monitoring sensors) is a free and open-source application that provides tools and drivers for monitoring temperatures, voltage, and fans. This document explains how to install, configure, and use lm_sensors.

A. Enable Temperature using lm_sensors

1. Download rpm lm_sensors if you using offline

For Rhel6/Centos6 Download rpm lm_sensors-3.1.1-17.el6.x86_64.rpm then copy to server

# wget  http://mirror.centos.org/centos/6/os/x86_64/Packages/lm_sensors-3.1.1-17.el6.x86_64.rpm

For Rhel7/Centos7 Download lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm, lm_sensors-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm

# wget http://mirror.centos.org/centos/7/os/x86_64/Packages/lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm

# wget https://www.rpmfind.net/linux/centos/7.4.1708/os/x86_64/Packages/lm_sensors-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm

.::: Install Cacti 1.0.x on Centos 7/Rhel 7 Using MariaDB :::.

Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG.

UPDATE:
Since new release is out, I added the procedures for upgrading cacti 1.0.1 to 1.0.x; and from 1.0.x to 1.1.x
1. Disable SELinux
[root@TeguhLab data]# cat /etc/selinux/config | grep SELINUX
# SELINUX= can take one of these three values:
SELINUX=disabled
# SELINUXTYPE= can take one of three two values:
SELINUXTYPE=targeted
[root@TeguhLab data]#

.::: Install MariaDB 10.1 On Centos/Rhel 7 Using Yum Repository :::.

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases.

MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.

1. Add MariaDB Yum Repository
Start by adding the MariaDB YUM repository file MariaDB.repo for RHEL/CentOS and Fedora systems.
# vi /etc/yum.repos.d/MariaDB.repo

Now add the following lines to your respective Linux distribution version as shown.

On CentOS 7

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

.::: Troubleshoot Error 'X-Frame-Options' to 'sameorigin'or Load denied by X-Frame-Options does not permit cross-origin framing :::.

some application. You can't change the web security setting in Application. The only way to add or remove header options would be to proxy it, e.g with haproxy. Troubleshoot Error 'X-Frame-Options' to 'sameorigin'or Load denied by X-Frame-Options does not permit cross-origin framing

1. Log Error

Error 'X-Frame-Options' to 'sameorigin'or Load denied by X-Frame-Options does not permit cross-origin framing

.:: Generate Triger Alarm Alcatel Lucent/Nokia 7750, 7450, 7210, 7705 :::.

1. Check snmp & snmptrap community
A:TeguhRouter# show system security snmp community

==============================================================================
Communities
==============================================================================
community           access  view                version   group name
------------------------------------------------------------------------------
cli-li-readwrite    n/a     li-view             v2c       cli-li-readwrite
cli-readonly        r       iso                 v2c       cli-readonly
cli-readwrite       rw      iso                 v2c       cli-readwrite
public              r       no-security         v1 v2c    snmp-ro
public              n/a     n/a                 v2c       snmp-trap
teguht              rwa     iso                 v2c       snmp-rwa
------------------------------------------------------------------------------
No. of Communities: 9
==============================================================================
A:TeguhRouter# show log snmp-trap-group       

.::: Install/Upgrade Minimal to Desktop Environment on Centos/RHEL(Redhat Enterprise Linux ) :::.

1. List Installed and Available Groups
[root@TeguhLab ~]# yum grouplist
Loaded plugins: fastestmirror
There is no installed groups file.
Maybe run: yum groups mark convert (see man yum)
Loading mirror speeds from cached hostfile
 * base: sumberterbuka.beritagar.id
 * extras: sumberterbuka.beritagar.id
 * updates: sumberterbuka.beritagar.id
Available environment groups:
   Minimal Install
   Compute Node
   Infrastructure Server
   File and Print Server
   Basic Web Server
   Virtualization Host
   Server with GUI
   GNOME Desktop
   KDE Plasma Workspaces
   Development and Creative Workstation