Skip to content

Instantly share code, notes, and snippets.

@rushipkar90
rushipkar90 / mysqlslowq.pl
Last active March 1, 2020 10:01
mysqlslowq.pl
#!/usr/bin/perl
%accounts = ();
$lines = `grep ^# /var/log/mysql_slow_query.log`;
$correctMonth = 0;
foreach (split("\n", $lines)) {
chomp;
if ($_ =~ /# User\@Host: ([a-z0-9_]+)/) {
@rushipkar90
rushipkar90 / netstat.sh
Created September 25, 2015 16:53
netstat.sh
#!/bin/sh
netstat -ntap | awk '{print $5}' | cut -d ":" -f1 | sort | uniq -c | sort -n
@rushipkar90
rushipkar90 / ps.sh
Created September 25, 2015 16:52
ps.sh
#!/bin/sh
ps aux | awk '{print $1}' | sort | uniq -c | sort -n
@rushipkar90
rushipkar90 / raise_php_mem_limit.sh
Created September 25, 2015 16:52
raise_php_mem_limit.sh
#!/bin/bash
if [ $# -lt 2 ]; then
echo "No arguments supplied"
echo "usage: sh raise_php_mem_limit.sh <username> <new memory limit value> i.e. raise_php_mem_limit.sh username 64"
exit 1
fi
if [ ! -d /home/$1 ]; then
echo "User doesn't exist"
@rushipkar90
rushipkar90 / reseller_autoterminate.sh
Created September 25, 2015 16:50
reseller_autoterminate.sh
#!/bin/bash
# Directory to store log files in
DST=/root/autotermination_logs
# Create DST if it doesn't exist
if [ ! -d "$DST" ]; then
mkdir -p $DST
fi
@rushipkar90
rushipkar90 / root_owner_change.sh
Created September 25, 2015 16:49
root_owner_change.sh
#!/bin/sh
USERS_PATH="/var/cpanel/users"
for l in `ls -A $USERS_PATH | grep -v hpspprt`
do
sed -i '/OWNER=root/s//OWNER=hpspprt/' $USERS_PATH"/"$l
done
/scripts/updateuserdomains
@rushipkar90
rushipkar90 / rsync_homedir_fix.sh
Created September 25, 2015 16:44
rsync_homedir_fix.sh
#!/bin/bash
for rspaths in `grep path /etc/rsyncd.conf |awk '{print $3}'`; do
username=`echo $rspaths|awk -F/ '{print $3}'`;
realpath=`grep $username /etc/passwd|awk -F: '{print $6}'`;
#echo "DEBUG: realpath variable = $realpath";
#echo "DEBUG: rspaths variable = $rspaths";
@rushipkar90
rushipkar90 / setup_custom_php_ini.sh
Created September 25, 2015 16:44
setup_custom_php_ini.sh
#!/bin/bash
if [ $# -lt 1 ]; then
echo "No arguments supplied"
echo "usage: sh setup_custom_php_ini.sh <username>"
exit 1
fi
homedir=`grep $1 /etc/passwd|awk -F: '{print $6}'`
@rushipkar90
rushipkar90 / spam_sender_block.sh
Created September 25, 2015 16:43
spam_sender_block.sh
#!/bin/bash
#
# Bronco May 2014
#
CONF=/etc/exim.conf.local
CHANGE=0
main() {
if [ -n "$(diff $CONF /tmp/exim.conf.local)" ] && [ -f "/tmp/exim.conf.local" ]; then
echo "Replacing the config..."
mv $CONF /home/bronco/exim.conf.local.$(date +%s)
@rushipkar90
rushipkar90 / updateclam.sh
Created September 25, 2015 16:43
updateclam.sh
#!/bin/sh
cd /var/clamav/;rm -f daily.cvd;wget http://db.local.clamav.net/daily.cvd; chown clamav: daily.cvd;