.::: .::: Additional OIS/MIB on Rhell/Redhat/Centos7 or Why SNMP is unable to query the interface, disk, memory, and CPU information in Red Hat Enterprise Linux? :::.

SNMP, or Simple Network Management Protocol, is widely used to communicate with and monitor network devices, servers, and more, all via IP. In this case, we’ll be installing an SNMP agent on a CentOS 6.5 server, which will allow for collection of data from our server, and make the information available to a remote SNMP manager.

1.    Make sure package net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
   # yum install net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
   # rpm -q net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
2.  Go to your product manufacturer and download the product's MIB & activation MIB/add MIB UCD-SNMP-MIB<cpu memory example>
3. Rename the mib to UCD-SNMP-MIB.txt
4. Copy the MIB inside /usr/share/snmp/mibs/
5.    Edit /etc/snmp/snmp.conf

.::: Simple Configuration Enable SNMP on Centos 6 & Centos 7 :::.

SNMP, or Simple Network Management Protocol, is widely used to communicate with and monitor network devices, servers, and more, all via IP. In this case, we’ll be installing an SNMP agent on a CentOS 6.5 server, which will allow for collection of data from our server, and make the information available to a remote SNMP manager.

1.    Make sure net-snmp utilitas package on centos7
  # yum install net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python
  # rpm -q net-snmp net-snmp-libs net-snmp-utils net-snmp-perl net-snmp-python 

.::: How To Change eth1 to eth0 Permanent :::.

1. Check hardware address
[root@SAMprimer ~]# ifconfig -a
eth1      Link encap:Ethernet  HWaddr 00:0C:29:55:44:33 
          inet addr:192.168.1.10  Bcast:192.168.5.255  Mask:255.255.255.0
          inet6 addr: fe80::20c:29ff:fe54:5242/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:6757447 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3520232 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000
          RX bytes:9595152162 (8.9 GiB)  TX bytes:298962001 (285.1 MiB)

.::: How to Backup & Restore database MySQL Cacti Windows & Linux :::.

Study Case : MySQL for CactiNMS

Simple Step
1. capture device before backup
2. backup database mysql for cacti
3. add/delete for testing delete & capture
4. restore database mysql for cacti
5. capture device after restore

.::: How To Using SNMPGET, SNMPWALK, SNMP Generator & SYSLOG Generator, SNMPTrap, Syslog Trap :::.

System logging (SYSLOG) messages generator. SYSLOG protocol is used by network devices/hosts to send messages over the network. In computing, syslog is a widely used standard for message logging. It permits separation of the software that generates messages, the system that stores them, and the software that reports and analyzes them.

.::: How To Change UUID Bios Machine Linux Using KVM Redhat Enterprise Linux (RHEL) ::.

A universally unique identifier (UUID) is an identifier standard used in software construction. A UUID is simply a 128-bit value. The meaning of each bit is defined by any of several variants.

For human-readable display, many systems use a canonical format using hexadecimal text with inserted hyphen characters. For example:

lshal | grep system.hardware.uuid | tr '[A-Z]' '[a-z]'
   
[root@TEGUHapp ~]# lshal | grep system.hardware.uuid | tr '[A-Z]' '[a-z]'
  system.hardware.uuid = 'ecf8da19-bcae-4e95-8725-c4e2d7aaba50'  (string)
[root@TEGUHapp ~]#

.::: How To Configured Transaction IsolationLevel Level READ_COMMITED! on MySQL Server :::.

1. Get Error on log NMS

2015-06-15 12:06:57,158 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The MySQL Server must be configured for Transaction IsolationLevel Level READ_COMMITED!
2015-06-15 12:06:57,167 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The StableNet® Server will now exit due to this fatal error!
2015-06-15 12:06:57,174 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,178 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,184 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) If this problem occurs again at the same position please
2015-06-15 12:06:57,193 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) contact Infosim GmbH & Co. KG, support@infosim.net, +49 931 205 92 200

.::: Install OPManager NMS on Windows :::.

ManageEngine makes enterprise IT management software for IT administrators and IT managers working in small, medium, and large enterprises. It is a division of Zoho Corporation, a privately held company headquartered in Pleasanton, CA (USA) with offices in North America, Europe, and Asia.[1]

Formed in 1999, ManageEngine develops web-based software for Network management, Server and Application management, Active Directory management, Desktop Management, Mobile device management, IT help desk, and Security management.[2]

1. Install On Windows

.::: Simple Reset Password root MySQL on Windows, Solaris, Linux, Centos, Redhat, Freebsd, Ubuntu and another :::.

 MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ "My S-Q-L", and unofficially as /maɪ ˈsiːkwəl/ "My Sequel") is an open-source relational database management system (RDBMS); in July 2013, it was the world's second most[a] widely used RDBMS, and the most widely used open-source client–server model RDBMS. It is named after co-founder Michael Widenius's daughter, My. The SQL acronym stands for Structured Query Language. 

.::: Installation MySQL on Windows, Create User & Database on MySQL :::.

MySQL is a relational database management system (RDBMS), and ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools,^[21][22] or use MySQL "front-ends", desktop software and web applications that create and manage MySQL databases, build database structures, back up data, inspect status, and work with data records.^{[23][24][25][26]} The official set of MySQL front-end tools, MySQL Workbench is actively developed by Oracle, and is freely available for use.^[27]

.::: Study Kasus Praktis belajar Query create & insert table MySQL / MariaDB (Create Data Warehouse) :::.

MariaDB merupakan versi pengembangan terbuka dan mandiri dari MySQL. Sejak diakuisisinya MySQL oleh Oracle pada September 2010, Monty Program sebagai penulis awal kode sumber MySQL memisahkan diri dari pengembangan dan membuat versi yang lebih mandiri yakni MariaDB. .


A. Management User
1. Loging Using root

create database teguht;
create user 'teguh' identified by 'triharto';
grant all privileges on teguht.* to 'teguh'@'%' identified by 'triharto' with grant option;
FLUSH PRIVILEGES;

c:\Program Files\MariaDB 10.1\bin>mysql -u root -p
Enter password: ****
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2752
Server version: 10.1.14-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database teguht;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> create user 'teguh' identified by 'triharto';

.::: Daftar Isi / Table Of Contents Teguh Triharto Learning Centre :::.

Lembar halaman yg menjadi petunjuk pokok isi buku beserta nomor halaman

A table of contents, usually headed simply "Contents" and abbreviated informally as TOC, is a list of the parts of a book or document organized in the order in which the parts appear. The contents usually includes the titles or descriptions of the first-level headers, such as chapter titles in longer works, and often includes second-level or section titles (A-heads) within the chapters as well, and occasionally even third-level titles (subsections or B-heads). The depth of detail in tables of contents depends on the length of the work, with longer works having less.

.::: Definition : Oracle Database SQL Certified Expert & ID Card & Syllabus :::.

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Retrieving Data Using the SQL SELECT Statement

• List the capabilities of SQL SELECT statements  
• Execute a basic SELECT statement 
• Describe how schema objects work