.::: Sript multiple dig domain (DNS) using Script :::.

1. Sample host
[root@server-teguht teguht]# cat hostdomain.txt
www.example.com
example.com
a.example.com
aaa.example.com
aaaa.example.com
example.com
info.example.com
cname.example.com
examplealias.example.com
[root@server-teguht teguht]#

.::: Study Kasus Praktis belajar Query create & insert table Postgress SQL (Create Data Warehouse) include via CLI & GUI :::.

1. Create database using query or GUI

CREATE DATABASE tgh

WITH

OWNER = postgres

ENCODING = 'UTF8'

LC_COLLATE = 'English_United States.1252'

LY_TYPE = 'English_United States.1252'

TABLE_SPACE = pg_default

CONNECT LIMIT = -1 ;

GRANT CREATE, CONNECT ON DATABASE tgh TO postgres;

GRANT TEMPORARY ON DATABASE tgh TO postgres WITH GRANT OPTION;

GRANT TEMPORARY, CONNECT ON DATABASE tgh TO PUBLIC ;

.::: How To Install Cursor and PowerAdmin for powerDNS :::.

after install powerdns as http://teguhth.blogspot.com/2019/08/how-to-install-powerdns-and-poweradmin.html now install poweradmin

1. Installing PowerAdmin to Manage PowerDNS
[root@powerdns-teguht ~]# yum -y install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext

2. Install additonal package
[root@powerdns-teguht ~]# yum -y install php-pear-DB php-pear-MDB2-Driver-mysqli

.::: How to Install PowerDNS and Poweradmin on CentOS 7 :::.

PowerDNS (pdns) is an open source DNS server written in C++ and released under GPL License. It has become a good alternative for the traditional DNS server Bind, designed with better performance and low memory requirements. PowerDNS provides two products, the Authoritative server, and the Recursor. The PowerDNS Authoritative server can be configured through the different backend, including the plain Bind zone files, RDBMS such as MySQL, PostgreSQL, SQLite3 or LDAP.

1. Disable /allow firewall, selinux and add hosts
[root@powerdns-teguht data]# systemctl stop firewalld
[root@powerdns-teguht data]# systemctl disable firewalld
rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service'
rm '/etc/systemd/system/basic.target.wants/firewalld.service'
[root@powerdns-teguht data]#

.::: Block a domain using RPZ on Bind DNS server on CentOS 7 Redhat 7 8 9 :::.

Domain Name Service Response Policy Zones (DNS RPZ) is a method that allows a nameserver administrator to overlay custom information on top of the global DNS to provide alternate responses to queries. It is currently implemented in the ISC BIND nameserver (9.8 or later). Another generic name for the DNS RPZ functionality is "DNS firewall".

1. Create zone for block using RPZ

[root@server-teguht ~]# cat /var/named/rpz.db

$TTL 1D

@    IN SOA ns1.example.com. root.example.com. (

                                        0      ;   serial

                                        1D     ;   refresh

                                        1H     ;   retry

                                        1W      ;  expire

                                        3H )     ; minimum

.::: Join Domain Active Directory on Centos 7 / Redhat 7, 8, 9 :::.

In Most of the Organizations users and groups are created and managed on Windows Active Directory.  We can integrate our RHEL 7 and CentOS 7 servers with AD(Active Directory) for authenticate purpose. In other words we can join our CentOS 7 and RHEL 7 Server on Windows Domain so that system admins can login to these Linux servers with AD credentials. While creating UNIX users on AD we can map these users to a specific group so that level of access is controlled centrally from AD

1. Install Package realmd, sssd, samba dan kerberos
[root@radius-teguht ~]# yum install sssd realmd oddjob oddjob-mkhomedir adcli samba-common samba-common-tools krb5-workstation openldap-clients policycoreutils-python -y

2. additional IP, domain, hostname on /etc/hosts , and /etc/resolv.conf

[root@radius-teguht ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
10.10.10.102 radius-teguht
10.10.10.110  ad ad.teguht.com
[root@radius-teguht ~]#

.::: How to Install Webmin on CentOS/Redhat 7, 8, 9 :::.

Webmin is a web-based interface for system administration for Unix. Using any modern web browser, you can setup user accounts, Apache, DNS, file sharing and much more. Webmin removes the need to manually edit Unix configuration files like /etc/passwd, and lets you manage a system from the console or remotely. See the standard modules page for a list of all the functions built into Webmin.

1. download
[root@server /]# wget http://prdownloads.sourceforge.net/webadmin/webmin-1.920-1.noarch.rpm

.::: 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>