Skip to content

Instantly share code, notes, and snippets.

@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 / 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 / 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 / ps.sh
Created September 25, 2015 16:52
ps.sh
#!/bin/sh
ps aux | awk '{print $1}' | sort | uniq -c | sort -n
@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 / 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 / mysqlkilluser.sh
Created September 25, 2015 16:54
mysqlkilluser.sh
#!/bin/bash
if [[ $1 != "" ]]
then
for p in `mysqladmin proc stat | grep $1 | awk '{print $2}'`
do
mysqladmin kill $p
done
else
echo "Usage: mysqlkilluser.sh <user>"
fi
@rushipkar90
rushipkar90 / mysqldbsize.pl
Created September 25, 2015 16:54
mysqldbsize.pl
#!/usr/bin/perl
use File::Basename;
@dbs = </var/lib/mysql/*_*>;
%databases = ();
foreach $dbPath (@dbs) {
$db = basename($dbPath);
chomp($size = `du -s $dbPath`);
@rushipkar90
rushipkar90 / mysql.sh
Created September 25, 2015 16:54
mysql.sh
#!/bin/sh
mysqladmin proc stat | grep -v + | cut -d "|" -f3 | sort | uniq -c | sort -n
@rushipkar90
rushipkar90 / emailpasswordreset.sh
Created October 8, 2015 11:20
Email account password reset script
1. cat /var/spool/exim/input/*/* | grep "auth_id" | awk '{print $2}' | sort | uniq -c | sort -n
2. cd /usr/local/src;
rm -fv emailpasswordreset.sh;
wget vpsmi084.hostpapavps.com/emailpasswordreset.sh;
chmod +x emailpasswordreset.sh;
sh /usr/local/src/emailpasswordreset.sh
wget vpsmi084.hostpapavps.com/mailscam.sh
sh /usr/local/src/emailpasswordreset.sh