mansurali901

#!/bin/bash
# Script is setup for Mysql Replication Monitoring
# Author        Mansur UlHasan
# Mail          [email protected]

# Mail Function

# Variables
HOME="/usr/local/cron"
Err1=`mysql -pv1t@m1nC -e 'show slave status \G;' |grep Last_Errno:`

mansurali901

#!/bin/bash
# This script is tested on CentOS for Installing Apache from Source Code
# Author Mansur UlHasan
# Sr, Network & Sys Admin
# GFK Etilize Pak

# To install C/C++ Compilers, AutoConf and AutoMake
yum install gcc gcc-c++ autoconf automake -y

# Install Perl Compatible Regular Expressions Libraries (PCRE)

mansurali901

FROM ubuntu:16.04
MAINTAINER Mansur Ul Hasan <[email protected]>
RUN apt-get update -y
RUN apt-get install openssh-server -y
RUN mkdir /var/run/sshd
RUN echo 'root:Crawling!@#' | chpasswd
RUN sed -i 's/PermitRootLogin prohibit-password/PermitRootLogin yes/' /etc/ssh/sshd_config

# SSH login fix. Otherwise user is kicked off after login
RUN sed 's@session\s*required\s*pam_loginuid.so@session optional pam_loginuid.so@g' -i /etc/pam.d/sshd

mansurali901

#!/bin/bash
# SQUID Installation automation
# Author Mansur Ul Hasan
# [email protected]

echo "
		+++++++++++++++++++++++++++++++++++++++++++++++++++++++
		Installation script for SQUID 3.1.23 
		This script is designed by 
		Mansur Ul Hasan

mansurali901

# This script install Mongo 3.2.15 in Ubuntu 16.04
# Author Mansur Ul Hasan
# [email protected]

# Adding gpg key
apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv EA312927

# Adding MongoDB repository

echo "deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.2.list

mansurali901

#!/bin/bash
# This script install Redis 4 in RHEL7 / Ubuntu 
# This installation is done from source code.
# Author : Mansur Ul Hasan
# Email : [email protected]

# Main Function 
InstallR () {
	cd /usr/local/redis
	 make distclean

mansurali901

#!/bin/bash
# This script used to install Mysql 5.7 
# from source Code
# Author Mansur Ul Hasan
# [email protected]

# Environment Function 

PrepBuildEnvFunc () {
    

mansurali901

#!/bin/bash
# This script is designed to installation apache 
# from source code with all options using apr & 
# apr-utils and library for portability 
# Author : Mansur Ul Hasan
# EMail  : [email protected]
# Skype  : genious840
# Facebook : https://www.facebook.com/itmarkaz
# YouTube : https://www.youtube.com/user/mansur7820

mansurali901

系统数据:
  user()          当前用户
  database()      当前数据库
  version()       SQL版本号,最后为系统版本(nt-windows)
  @@datadir       数据库路径
连接型:
  concat()        concat(username,0x3a, password))
  group_concat()   select group_concat(DISTINCT file_priv, user) from mysql.user; //多个用户情况下, 查看load_file()权限
  concat_ws()     与上类似
编码:

mansurali901

#!/bin/bash
# Maintainer : Mansur Ul Hasan
# EMail : [email protected]
# LinkedIn : https://www.linkedin.com/in/mansurulhasan/
# Youtube : https://www.youtube.com/user/mansur7820/

# This script is meant to setup Kubernetes Environment on Ubuntu / Debian supported paltforms 
# We have try to cover all the required tools modules which needed by modern kubernetes 
# Disclaimer : 
# This script is well tested on ubuntu 18 and 16