Using ZSH ZMV to Force Add Leading Zeros

Given a list of episodes that are named with single digits, but you'd like leading zeros:

S1E1.avi
S1E2.avi
S1E3.avi
S1E4.avi

zmv 'S([0-9])E([0-9]).(*)' 'S${(l:2::0:)1}E${(l:2::0:)2}.$3'

They'd now be renamed as follows:

S01E01.avi
S01E02.avi
S01E03.avi
S01E04.avi

Using ZSH ZMV to Rename Split an Episode to Two Episodes

Given a list of episodes that are named to be one, but actually need to span two episodes:

S01E01.avi
S01E02.avi
S01E03.avi
S01E04.avi

zmv 'S([0-9][0-9])E([0-9][0-9]).(*)' 'S$1E${(l:2::0:)$((($2 * 2) - 1))}-E${(l:2::0:)$(($2 * 2))}.$3'

They'd now be renamed as follows:

S01E01-E02.avi
S01E03-E04.avi
S01E05-E06.avi
S01E07-E08.avi

This will also force leading zeros on S and E should they originally be single digits.

Outgoing Email Counts For DirectAdmin Users

Replace $user with the system user and it will return a count of outgoing mails, per-user for the current day ($user and $user.bytes in this directory reset at midnight)

cat /etc/virtual/usage/$user.bytes | grep outgoing | awk -F= '{print $4}' | awk -F\& '{print $1}' | sort | uniq -c | sort -n

Find Files Sending SPAM On cPanel Exim Server

This will check your exim_mainlog and dump the paths from which mail has been sent along with the number. Check the listed directory for malware, shells, etc:

grep cwd /var/log/exim_mainlog | grep -v /var/spool | awk -F"cwd=" '{print $2}' | awk '{print $1}' | sort | uniq -c | sort -n

Find Files Sending SPAM On DirectAdmin Exim Server

This will check your exim_mainlog and dump the paths from which mail has been sent along with the number. Check the listed directory for malware, shells, etc:

grep cwd /var/log/exim/mainlog | grep -v /var/spool | awk -F"cwd=" '{print $2}' | awk '{print $1}' | sort | uniq -c | sort -n

Using ZSH ZMV To Mass Rename Files Episodes

This presumes you are in the show folder looking at all the season folders AND the shows have the following format:
### - Episode Title.mkv

zmv 'Season (*)/([0-9])(*) - (*).mkv' 'Season $1/{showtitle} - S0$2E$3 - $4.mkv'

This should leave you with:

Showtitle - S01E01 - Episode Title.mkv

...and so forth.

If you are unsure, add the -n flag to zmv and it will present you the changes versus simply making them.

Note: Replace {$showtitle} with the title of your show. Nested directories with zmv gave me trouble so consider this the one bit of lifting required to save you a bunch of time.

Find List What Programs, Services, Daemons, Applications Are Using SWAP Memory In Linux

for file in /proc/*/status ; do awk '/VmSwap|Name/{printf $2 " " $3}END{ print ""}' $file; done | sort -k 2 -n -r | less

Symlink ClamAV Binaries On A Linux cPanel Server

ln -s /usr/local/cpanel/3rdparty/bin/freshclam /usr/local/bin/freshclam
ln -s /usr/local/cpanel/3rdparty/bin/clamscan /usr/local/bin/clamscan
ln -s /usr/local/cpanel/3rdparty/bin/clamd /usr/local/bin/clamd
ln -s /usr/local/cpanel/3rdparty/bin/clamav-config /usr/local/bin/clamav-config

Install ClamAV From The Command Line On A cPanel Server

Pretty simple task here and makes installing ClamAV easier shot you not have the root password for the customers installation:

/scripts/update_local_rpm_versions --edit target_settings.clamav installed
/scripts/check_cpanel_rpms --fix --targets=clamav

Update Plesk Windows From Command Line

"%plesk_bin%"\ai.exe --console

Recursively Find All Files With Only One Line Of Text On Linux

A nice one-liner for finding files that only contain a single line of text which is often the case with Wordpress exploits.

find . -type f -print0 | xargs -0 wc -l | awk '$1==1{print $2}'

...an alternate version:

find . -type f -exec sh -c '[ 1 -eq $(wc -l {}|cut -d" " -f1) ] && echo {}' \;

Kill All Processes In Linux Via Search GREP

Sometimes killall -9 simply doesn't work with all processes and as a result you are left searching/GREPing for process names to kill them off.

This Simplifies this task by killing all processes that are the result of that search:

kill -9 `ps -ef | grep processname | grep -v grep | awk '{print $2}'`

How To Enable Disk Caching LSI/MegaRaid/PERC RAID Using MegaCli

MegaCli -LDSetProp -Cached -LAll -aAll
MegaCli -LDGetProp -DskCache -LAll -aALL
MegaCli -LDSetProp EnDskCache -LAll -aAll

How To Disable LSI/MegaRaid/PERC RAID Alarm Using MegaCli

MegaCli -AdpSetProp AlarmDsbl –aall

How To Silence LSI/MegaRaid/PERC RAID Alarm Using MegaCli

MegaCli -AdpSetProp AlarmSilence -aall

How To Disable Eximstats on cPanel

Eximstats does just what it implies, keeps stats on exim(email). Sometimes you don't care about these stats and want to free your database and I/O up for more important things. Luckily you can via the following CLI command:

/usr/local/cpanel/bin/tailwatchd -–disable=Cpanel::TailWatch::Eximstats

You may want to truncate the related tables for eximstats in MySQL before doing this (to save time if they are crashed,etc) but is not required nor necessary as the above will clear the tables (but will bawk if they are crashed, etc)

How To Fix [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Time to time on new installs of MySQL I encounter this error which is luckily very easy to fix.

From the command line simply run:

mysql_install_db --user=mysql

You may also encounter this error in part when trying to start/stop/restart the service and see:

ERROR! MySQL server PID file could not be found!

...which usually reveals itself in the err log in /var/lib/mysql

Remove PHP Malware Hack Exploit Injection

If all your PHP files have been injected on the first line with an exploit of some sort, you can use the follow FIND and SED commands to replace the entire first line with a normal PHP open tag:

find . -name '*.php' -exec sed -i '1 s/^<?php.*$/<?php/g' {} \;

Once completed, you should inspect your logs and upgrade your software to avoid future incidents.

If you are running this to clean up a Wordpress site, I recommend using this modified version which will skip the themes directory which should be processed manually (the above tends to be too greedy and will 'splode theme files):

find . -path ./wp-content/themes -prune -o -name '*.php' -exec sed -i '1 s/^<?php.*$/<?php/g' {} \;

How To Hide Warning: Permanently added to the list of known hosts From SSH Commands

Add the following to $HOME/.ssh/config

LogLevel=quiet

If you want to suppress this output per-command, add the following to your SSH command:

-o LogLevel=quiet

Sortable Output MySQL Show Processlist

This will sort the output by username. Substitute select's and order's as needed.

SELECT id,user,db,command,time,state FROM INFORMATION_SCHEMA.PROCESSLIST order by user;