.::: Enable Crontab on Linux/Unix Platform :::.

Crontab  is  the program used to install, remove or list the tables used to drive the cron(8) daemon.  Each user can have their own crontab, and though these are files in /var/spool/ , they are not intended to be edited directly. For SELinux in mls mode can be even more crontabs - for  each  range.  For  more  see selinux(8).

The  cron jobs could be allow or disallow for different users. For classical crontab there exists cron.allow and cron.deny files.  If cron.allow file exists, then you must be listed therein in order to be allowed to use this command.  If the cron.allow file does not exist but the cron.deny file  does  exist,  then you must not be listed in the cron.deny file in order to use this command.  If neither of these files exists, only the super user will be allowed to use this command.  The second option is using PAM authentication, where you set up users, which could  or  couldn’t  use  crontab  and  also  system  cron  jobs  from /etc/cron.d/.

::: How to Upgrade RHEL/Redhat Enterprise Linux 7 Using Repolocal, ISO & Online :::.

1. capture release version before upgrade
[root@teguhlab yum.repos.d]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@teguhlab yum.repos.d]#

2. Mounting Image Rhel 7.3/Latest Using ISO File or DVD Room/Repolocal
detail on http://teguhth.blogspot.co.id/2017/07/how-settting-install-package-os-redhat.html

3. Clean all
# yum clean all
# subscription-manager clean
All local data removed

.::: How Settting & Install Package OS Redhat Enterprise Linux(Rhel) 7 Using Repolocal, ISO File & rpm file :::.

A. Using Repolocal(DVD)
1. Make sure DVD mounting
[root@teguhlab yum.repos.d]# df -kh
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda3       261G  3.0G  258G   2% /
devtmpfs        9.8G     0  9.8G   0% /dev
tmpfs           9.8G   84K  9.8G   1% /dev/shm
tmpfs           9.8G  9.0M  9.8G   1% /run
tmpfs           9.8G     0  9.8G   0% /sys/fs/cgroup
/dev/sda1       187M  146M   42M  78% /boot
tmpfs           2.0G   20K  2.0G   1% /run/user/0
/dev/sr0        3.6G  3.6G     0 100% /run/media/root/RHEL-7.3 Server.x86_64
[root@teguhlab yum.repos.d]#

.::: Troubleshoot MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] :::.

1. Problem MySQL cannot start & tried restart
[root@TeguhLab ~]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[root@TeguhLab ~]# service mysql restart
MySQL server PID file could not be found!                  [FAILED]
Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/TeguhLab.pid).
[root@TeguhLab ~]#

result "MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]"

.::: Sample Calculate interface bandwidth utilization % Using IfSpeed, IfHighSpeed :::.

base on calculation bandwith utilization 32 bits and 64 bits.
http://teguhth.blogspot.co.id/2017/06/how-to-calculate-bandwidth-utilization.html
here as example calculation base on value snmpwalk/snmpget

Counter32 Bits
1.3.6.1.2.1.2.2.1                          ifEntry                                              NODE
1.3.6.1.2.1.2.2.1.1                        ifIndex                                              LEAF  InterfaceIndex
1.3.6.1.2.1.2.2.1.2                        ifDescr                                              LEAF  DisplayString
1.3.6.1.2.1.2.2.1.3                        ifType                                               LEAF  IANAifType
1.3.6.1.2.1.2.2.1.4                        ifMtu                                                LEAF  Integer32
1.3.6.1.2.1.2.2.1.5                        ifSpeed                                              LEAF  Gauge32

.::: How To Calculate Bandwidth Utilization Using SNMP :::.

Problem

It is sometimes necessary to calculate bandwidth use with SNMP.
Solution

Use this solution to solve this problem.

How you calculate use depends on how data is presented for what you want to measure. Interface use is the primary measure used for network use. Use this formulas, based on whether the connection you measure is half-duplex or full-duplex. Shared LAN connections tend to be half-duplex, mainly because contention detection requires that a device listen before it transmits. WAN connections are full-duplex because the connection is point-to-point; both devices can transmit and receive at the same time because they know there is only one other device that shares the connection. Because MIB-II variables are stored as counters, you must take two poll cycles and figure the difference between the two (hence, the delta used in the equation).

.::: Cacti Template Alcatel Memory Usage Utilization On % Persen 7750, 7705, 7450, 7210 :::.

Alcatel Memory Usage Utilization 7750, 7705, 7450, 7210

== OID Memory ==
1.3.6.1.4.1.6527.3.1.2.1.1.1 sgiCpuUsage LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.2 sgiMemoryUsed LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.3 sgiMemoryAvailable LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.4 sgiMemoryPoolAllocated LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.2.3.4.1.18          tmnxCpmCardMemorySize                                LEAF  Unsigned32

.::: Cacti Template Alcatel Temperature Slot A On 7750, 7705, 7450, 7210 :::.

== OID Memory ==
1.3.6.1.4.1.6527.3.1.2.2.1.8.1.8 tmnxHwName LEAF TNamedItemOrEmpty
1.3.6.1.4.1.6527.3.1.2.2.1.8.1.18 tmnxHwTemperature LEAF Integer32
1.3.6.1.4.1.6527.3.1.2.2.1.8.1.19  tmnxHwTempThreshold   LEAF  Integer32

.::: Cacti Template Alcatel Memory Usage Utilization 7750, 7705, 7450, 7210 :::.

Alcatel Memory Usage Utilization 7750, 7705, 7450, 7210

== OID Memory ==
1.3.6.1.4.1.6527.3.1.2.1.1.1 sgiCpuUsage LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.2 sgiMemoryUsed LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.3 sgiMemoryAvailable LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.1.1.4 sgiMemoryPoolAllocated LEAF Unsigned32
1.3.6.1.4.1.6527.3.1.2.2.3.4.1.18          tmnxCpmCardMemorySize                                LEAF  Unsigned32

.::: Simple, Advanced & Full Power Level Tuning Performance MySQL or MariaDB :::.

1. copying/backup my.cnf on linux/unix or my.ini on windows
Linux
[root@SAMLab mysql]# cat /etc/my.cnf

Windows
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

C:\Users\teguh.triharto>cd C:\ProgramData\MySQL\MySQL Server 5.7

C:\ProgramData\MySQL\MySQL Server 5.7>dir
 Volume in drive C has no label.
 Volume Serial Number is 40FC-A9B1

.::: Install MySQL 57 On Linux Rhel/Centos using RPM/Offline :::.

1. Download rpm instalation from http://dev.mysql.com/downloads/mysql/ as sample

mysql-community-common-5.7.16-1.el6.x86_64.rpm
mysql-community-libs-5.7.16-1.el6.x86_64.rpm
mysql-community-devel-5.7.16-1.el6.x86_64.rpm
mysql-community-client-5.7.16-1.el6.x86_64.rpm
mysql-community-server-5.7.16-1.el6.x86_64.rpm

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-common-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-libs-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-devel-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-client-5.7.16-1.el6.x86_64.rpm
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-community-server-5.7.16-1.el6.x86_64.rpm

[root@TEGUHTH mysql]# ls -lh
total 173M
-rw-r--r-- 1 root root  23M Nov  7 15:19 mysql-community-client-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 328K Nov 10 15:20 mysql-community-common-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 3.6M Nov 10 14:08 mysql-community-devel-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 2.1M Nov  7 15:21 mysql-community-libs-5.7.16-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 144M Nov  7 15:06 mysql-community-server-5.7.16-1.el6.x86_64.rpm
[root@TEGUHTH mysql]#

.::: [FIX] Error 1075 The Dependency Service Does Not Exist Or Has Been Marked For Deletion or Cannot Enable Aero Windows:::.

We have already seen many issues regarding various services, when dependency service do not coordinate, the actual service failed to start as a consequence of this. Recently, we came around the similar problem for Security Center service. If you can’t start Security Center service, checkout this fix. After applying the same fix, one of my reader asked that he now gets different error and thus can’t start the service. This is what he received now:

    Windows could not start the Security Center service on Local Computer.

    Error 1075: The dependency service does not exist or has been marked for deletio

.::: Change Mirror Server Instance to Single User/Server on SQL Server 2012,2014,2016 :::.

1. Open SQL using SQL Management Studio

2. Open Mirror Server Instance and query and execute
alter database teguhtrihartodb set partner off
go
restore database teguhtrihartodb with recovery
go

3. expand Database on SQL Management Studio