2023 May

2023-0531 (WED) sftp login script 

#!/bin/bash

# mikeyom@gmail.com 05-2023

my_path=/var/lib/jenkins/mike_scripts/z_sftp

rm -f $my_path/result.txt

touch $my_path/result.txt

while read -u3 login

do

   user=`echo $login | awk '{print $1}'`

   pass=`echo $login | awk '{print $2}'`

   echo "" >> $my_path/result.txt

   echo "$user" >> $my_path/result.txt

   echo "" >> $my_path/result.txt

   lftp -e "set net:timeout 10" sftp://"$user":"$pass"@sftp.mikeyom.com  -e "ls; bye" | tee >> $my_path/result.txt

   echo "==================================================================" >> $my_path/result.txt

done 3< $my_path/users.txt

2023-0525 (THU) How to rename large number of files replace blank space with underscore

#!/bin/bash

for file in *.zip

do

  mv -- "$file" "${file// /_}"

done

2023-0522 (MON) Time Date Logs

#!/bin/bash

# mikeyom@gmail.com 01-2023

my_path=/tmp/z_nagios

AGO="10"

# my_year=`date +'%Y' -d "$AGO minutes ago"`

# my_month=`date +'%m' -d "$AGO minutes ago"`

# my_date=`date +'%d' -d "$AGO minutes ago"`

# my_hour=`date +'%H' -d "$AGO minutes ago"`

# my_min=`date +'%M' -d "$AGO minutes ago"`

my_year=`date +'%Y' -d "$AGO Hours ago"`

my_month=`date +'%m' -d "$AGO Hours ago"`

my_date=`date +'%d' -d "$AGO Hours ago"`

my_hour=`date +'%H' -d "$AGO Hours ago"`

my_min=`date +'%M' -d "$AGO Hours ago"`

echo $my_year

echo $my_month

echo $my_date

echo $my_hour

my_chk=`aws s3 ls s3://my_aws/logs/con_req_eve_v2/y=$my_year/m=$my_month/d=$my_date/h=$my_hour/ | wc -l`

echo "$my_chk $my_year-$my_month$my_date-$my_hour" >> $my_path/metamarket.txt

tail -n 20 $my_path/metamarket.txt > $my_path/metamarket.txt.tmp

rm -f $my_path/metamarket.txt

mv $my_path/metamarket.txt.tmp $my_path/metamarket.txt

2023-0519 (FRI) mysqldump

#!/bin/bash

# mikeyom@gmail.com 03-2023

/usr/bin/mysqldump --set-gtid-purged=OFF mydb > mydb.sql

2023-0518 (THU) Security Scan

git clone https://github.com/drwetter/testssl.sh 

#!/bin/bash

# mikeyom@gmail.com 02-2023

my_file=/home/myom/scan_ip.txt

rm -rf /home/myom/scan_results.txt

touch /home/myom/scan_results.txt

while read -u3 ip

do

    echo "=============================================" >> /home/myom/scan_results.txt

    echo "" /home/scan_results.txt

    /home/myom/testssl.sh/testssl.sh -U $ip:443 | tee -a /home/myom/scan_results.txt

    echo "" >> /home/myom/scan_results.txt

done 3< $my_file

2023-0517 (WED) mydumper and myloader

multi thread mydumper 

#!/bin/bash

# mikeyom@gmail.com 02-2024

rm -f .my.cnf

echo "y" | cp .my.cnf.failed_over .my.cnf

my_path=/home/myom

my_year=`date +'%Y'`

my_month=`date +'%m'`

my_date=`date +'%d'`

my_hour=`date +'%H'`

my_min=`date +'%M'`

today="$my_year-$my_month$my_date"

my_time="$my_year-$my_month$my_date-$my_hour$my_min"

mkdir $my_path/$today

echo "" >> $my_path/status.txt

echo "Starting the DB backup sqldump $my_time" >> $my_path/status.txt

mydumper \

--outputdir=/home/myom/$today/ \

--rows=500000 \

--build-empty-files \

--threads=5 \

--compress-protocol

/home/myom/timestamp.sh

2023-0515 (MON) Bash Forloop

#!/bin/bash

# mikeyom@gmail.com 04-2023

my_path=/var/lib/jenkins/mike_scripts/z_pub_ip

declare -a set1_list=("host1" "host2" "host3" "host4")

for my_set in "${set1_list[@]}"

do

   echo "============================================================"

   echo ""

   echo $my_set

   echo ""

   gcloud compute instances --project $my_set list | grep RUNNING > $my_path/$my_set.txt

   cat $my_path/$my_set.txt

done