.::: Repair Table & Database MySQL / MariaDB :::.

1. Repair table (sample graph_templates_graph ;)

use databasename

repair table tablename

mysql> use cacti;

Database changed

mysql>

mysql> repair table graph_templates_graph ;

+-----------------------------+--------+----------+----------+

| Table                       | Op     | Msg_type | Msg_text |

+-----------------------------+--------+----------+----------+

| cacti.graph_templates_graph | repair | status   | OK       |

+-----------------------------+--------+----------+----------+

1 row in set (0.06 sec)

mysql>

.::: Install & Configuring Free Tacacs Plus with Linux Systems Users Authentication on RHEL/CentOS 7,8,9 :::.

Tacacs Plus is an identity management solutions with a protocol for AAA services such as , authentication, authorization, accounting. It is used as a centralized authentication and identity access management to network devices. It is the protocols for security that can provide a specific authorization and centralized access to particular user to work with network devices.

1. Download freetacacs +

wget http://li.nux.ro/download/nux/misc/el7/x86_64/tac_plus-4.0.4.26-1.el7.nux.x86_64.rpm
wget http://li.nux.ro/download/nux/misc/el7/x86_64/tac_plus-debuginfo-4.0.4.26-1.el7.nux.x86_64.rpm
wget http://li.nux.ro/download/nux/misc/el7/x86_64/tac_plus-devel-4.0.4.26-1.el7.nux.x86_64.rpm

.::: Install elasticsearch, Kibana, Logtash, logtash, filebeat , Hearbeat :::.

1. Install Java

[root@radius-teguht data]# rpm -ivh jdk-12.0.1_linux-x64_bin.rpm

2. Install elasticsearch

[root@radius-teguht data]# wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-6.8.2.rpm

[root@radius-teguht data]# rpm -ivh elasticsearch-6.8.2.rpm

.::: Install Freeradius 3 on Centos7/Redhat7, Redhat 8/ Centos 8 :::.

1. Disable SE Linux
[root@radius-teguht ~]# cat /etc/selinux/config | grep SELINUX=
# SELINUX= can take one of these three values:
SELINUX=disabled
[root@radius-teguht ~]#

2. Disable firewall
[root@radius-teguht ~]# systemctl stop firewalld
[root@radius-teguht ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[root@radius-teguht ~]#

.::: Installing OTRS 6 Help Desk and ITSM software on CentOS 7 /Redhat 7 :::.

OTRS (Open source TRouble ticket System) is one of the most popular open source software used for help desk and IT Service Management. You can download, install, modify and use OTRS completely free of cost as it is licensed under the Affero General Public License V3 (AGPL). This article helps you with step-by-step instruction on how to install OTRS software on CentOS 7 Operating system.

Step 1: Update your system (optional)

Before you begin, update all installed packages in your system with the latest version available. Login to the system as root user and run the following command:

.::: How to Hidden BInd Version /DNS Version :::.

Sometimes a new vulnerability is found in DNS software and script kiddies are scanning the Internet to exploit unpatched systems. It's a best practice to hide software version on your DNS servers, although this is not a real protection it just makes a little harder to find your servers via scanning.
Use dig command to find which version is running on your name servers:

1. Verify that bind server is before hidden version
# dig @127.0.0.1 version.bind chaos txt

as example

.::: Study Kasus Praktis belajar Query create & insert table Microsoft SQL Server (Create Data Warehouse) :::.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).



A. Management User
1. Loging UsingMicrosoft Studio

.::: Install & Configure BIND 9(DNS, zone ) on Centos7/Rhel7 :::.

BIND or named is the most widely used Domain Name System (DNS) software on the Internet.On Unix-like operating systems it is the de facto standard.[7][8] It performs both of the main DNS server roles - acting as an authoritative name server for one or more specific domains, and acting as a recursive resolver for the DNS system generally.

1. Install bind
[root@server data]# yum -y install bind bind-utils

.::: Install & Using dnsperf on Centos7 & Ubuntu with example DNS testing :::.

DNSPerf and ResPerf are free tools developed by Nominum that make it simple to gather accurate latency and throughput metrics for Domain Name Service (DNS). These tools are easy-to-use and simulate typical Internet so network operators can benchmark their naming and addressing infrastructure and plan for upgrades. The latest version of the DNSPerf and ResPerf can be used with test files that include IPv6 queries.

1. Install requirement package dnsperf

.::: Create Tetris Game using Bash Script Shell on Linux/Unix :::.

1. Download script on
https://www.dropbox.com/s/j5jlh1pxyq8egsd/teguhtriharto_tetris.sh?dl=0

2. copy or create vi teguhtriharto_tetris.sh and enter script

3. run command
# sh teguhtriharto_tetris.sh

.::: Tutorial Using DATETIMEPICKER on php or other on Human time and Unix Time , Cara Menggunakan datetimepicker :::.

1. download bootstrap-datetimepicker-4.17.44.zip and jquery-ui-1.12.1.zip as example and unzip on /var/www/html or yourdisk
unzip bootstrap-datetimepicker-4.17.44.zip
unzip jquery-ui-1.12.1.zip
create file teguhtriharto.php
2. create head and link and meta
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>datetimepicker by Teguh Triharto</title>
  <link href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
  <link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.15.35/css/bootstrap-datetimepicker.min.css" rel="stylesheet">
 </head>

.::: How to Install Sangoma Driver, Wanpipe, DAHDI, LibPRI, Asterisk, Telephony Cards for elastix freepbx Without Error :::.

Sangoma cards are compatible with most commercially available servers and motherboards on the market. Our cards are available in both PCI and PCI express versions and are backwards compatible (i.e. 16x, 8x, 4x, 2x) Also available are different size brackets for 1U and 2U server form factors.

1. Selecting your Linux Operating system (Centos7 Minimal) 

on this lab 7.6.1810(3.10.0-229.el7.x86_64) 

.::: Install Openssl & Freeradius 3 using Source to other directory (/opt) :::.

default installation from yum (directory /etc/raddb})
exec=${exec:=/usr/sbin/$prog}
config_dir=${config_dir:=/etc/raddb}
config=${config:=$config_dir/radiusd.conf}
pidfile=${pidfile:=/var/run/$prog/$prog.pid}
lockfile=${lockfile:=/var/lock/subsys/radiusd}
using install from source from (directory /opt/freeradius3.0.17)
exec=${exec:=/usr/sbin/$prog}
config_dir=${config_dir:=/opt/freeradius3.0.17/etc/raddb}
config=${config:=$config_dir/radiusd.conf}
pidfile=${pidfile:=/opt/freeradius3.0.17/var/run/$prog/$prog.pid}
lockfile=${lockfile:=/opt/freeradius3.0.17/var/lock/subsys/radiusd}