Teguh Triharto Learning Center

Thursday, August 8, 2019

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

.::: How To Mirroring Microsoft SQL Server 2012, 2014, 2016, 2018 & Trouble shoot SQL Server Error 1418, 1475,1478,1412 :::.:::

sample monitoring https://teguhth.blogspot.com/2023/09/monitor-mirroring-sql-server-using-t.html

Prerequisites

For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.

The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The witness, if any, can run on any edition of SQL Server that supports database mirroring.

.::: Create Database, Table and Entry Data, Check Database Size on Microsoft SQL Server 2012 Using TSQL :::.

When working with a command or query window, the language used by SQL Server is TSQL.

Step 1 -Create Database

Create a new database called teguhtrihartodb by entering the following TSQL then pressing the “Execute” button on the top menu.

CREATE DATABASE teguhtrihartodb;

The Messages window on the bottom of the screen should say, ”Command(s) completed successfully.”

.::: How to Simple Troubleshooting Error 'Duplicate entry '9999707' on slave/master MySQL/MariaDB include repair table database:::.

1. Get Error on replication/mirroring MySQL/MariaDB
Last_Error: Error 'Duplicate entry '9999707' for key 'PRIMARY'' on query. Default database: 'teguht'. Query: 'INSERT INTO sessions (session_id, data_key, data_value, serialized) VALUES ('E6iNeYTAMo4FBl2gpoicy0kWVqYfTygv','LastScreenOverview','Action=AgentFAQExplorer;SortBy=FAQID;CategoryID=0;Nav=;OrderBy=Down;StartHit=1','0'),('E6iNeYTAMo4FBl2gpoicy0kWVqYfTygv','LastScreenView','Action=AgentFAQExplorer;SortBy=FAQID;CategoryID=0;Nav=;OrderBy=Down;StartHit=1','0'),('E6iNeYTAMo4FBl2gpoicy0kWVqYfTygv','LastViewedCategory','0','0'),('E6iNeYTAMo4FBl2gpoicy0kWVqYfTygv','UserFAQOverviewAgentFAQExplorer','Small','0'),('E6iNeYTAMo4FBl2gpoicy0kWVqYfTygv','UserLastRequest','1537333985','0')

Teguh Triharto Learning Center

Blog List

Thursday, August 8, 2019

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

Thursday, June 27, 2019

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

Monday, June 17, 2019

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

Tuesday, April 30, 2019

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

Monday, March 11, 2019

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

Wednesday, March 6, 2019

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

Friday, February 22, 2019

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

Tuesday, February 19, 2019

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

Tuesday, December 18, 2018

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

Monday, November 5, 2018

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

Wednesday, October 3, 2018

.::: How To Mirroring Microsoft SQL Server 2012, 2014, 2016, 2018 & Trouble shoot SQL Server Error 1418, 1475,1478,1412 :::.:::

Monday, October 1, 2018

.::: Create Database, Table and Entry Data, Check Database Size on Microsoft SQL Server 2012 Using TSQL :::.

Wednesday, September 19, 2018

.::: How to Simple Troubleshooting Error 'Duplicate entry '9999707' on slave/master MySQL/MariaDB include repair table database:::.

Popular Posts