Skip to content

Instantly share code, notes, and snippets.

@C00kiie
Last active Sep 20, 2020
Embed
What would you like to do?
Quick Server diagnostics
#!/bin/bash
# script: sas3/sas4 quick diagnoistics
## Author: Tyr4n7
###### To Valahala!
separator_bar="----------------------------------------------------------------------------------------------";
## check max_users ##
users_count=$(mysql -u sas -psas123 -s -N sas4 -e "select count(*) as c from sas_users" 2>/dev/null); # default passwords for sas4
echo "SAS4 Current users: $users_count";
## get license and expiration and max users ##
php -r '$sas=new \SAS4; $license = $sas->getLicense();echo "expiration: ".$license["exp"] . "\n"; echo "max_users: ". $license["mu"]." \n";'
echo $separator_bar;
#### print dmesg at the level of errors and warnings ####
echo "DMESG AT LEVEL ERROR/WARNING"
echo $separator_bar;
sudo dmesg --level warn,err
echo $separator_bar;
#### checking hardware capacity issues ####
echo "[*] Available memory:";
free -h
echo $separator_bar;
echo "[*] Storage unit diganoists:";
echo "[*] drivers:";
lsblk;
echo "[*] Left space in drives:";
df -kh;
echo $separator_bar;
#### Check if SAS processes are running #####
echo "[*] Which SAS processes are running?";
echo -ne "Process_FILE = > PID\n";
ps aux | grep "sas_" | uniq | awk '{print $11 " => "$2}';
echo $separator_bar;
############ mysqld & apache2
echo "[*] Checking other services .. "
echo $separator_bar;
echo "[*] Is mysql running?"
mysqld_path="/run/mysqld/mysqld.pid"
mysqld_=$(cat $mysqld_path &> /dev/null)
if [ $? -eq 0 ];
then
mysqld_=$(cat $mysqld_path);
echo "[*] Yes /var/mysqld/mysqld.pid => $mysqld_"
else
echo "[*] No"
fi
echo $separator_bar;
echo "[*] Is Apache2 running?"
apache2_path="/run/mysqld/mysqld.pid"
apache2d=$(cat $apache2_path &> /dev/null)
if [ $? -eq 0 ];
then
apache2d=$(cat $mysqld_path);
echo "[*] Yes /var/run/apache2/apache2.pid => $apache2d"
else
echo "[*] No"
fi
echo $separator_bar;
output=$(tail /var/log/mysql/error.log &> /dev/null);
if [ $? -eq 0 ];
then
echo "[*] Checking Mysql latest error logs (/var/log/mysql/error.log)"
tail /var/log/mysql/error.log;
echo $separator_bar;
fi
output=$(tail /var/log/apache2/access.log &> /dev/null);
if [ $? -eq 0 ];
then
echo "[*] Checking Mysql latest error logs (/var/log/apache2/access.log"
tail /var/log/apache2/access.log;
echo $separator_bar;
fi
output=$(tail /var/log/apache2/error.log &> /dev/null);
if [ $? -eq 0 ];
then
echo "[*] Checking apache2 latest error logs (/var/log/apache2/error.log"
tail /var/log/apache2/error.log;
echo $separator_bar;
fi
echo "[*] Done!";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment