Folks:
Below is an updated version of the "dead_wood" script. The key change is that I've added a way of providing a password for those that have password protected their MYSQL data bases. I don't have password protection on my MYSQL data base and I am able to confirm it works properly with no password. Linuxgeek has confirmed that it works properly on his password-protected MYSQL data base -- thanks to Linuxgeek for running that test for me!
Marc
Code: #! /bin/bash
#
# This scropt will look for orphased ".nuv" files in /myth/tv
# directory and delete them. It will also check the data base
# for references to non-existant ".nuv" files, and create a
# dummy ".nuv" file where necessary. To protect your system
# from "run away" deletions, this script uses the following
# logic:
#
# 1. It will not do anything to a "nuv" file that is referenced in the
# "recorded shows" listing of the myth data base.
# 2. It will not do anything to a "nuv" file that is less than 2 hours old.
# 3. If it detects more than 8 "nuv" files that appear to be orphaned,
# it will exit without taking any action.
# 4. Files that pass the previous 3 tests are not deleted. Instead they are
# moved to the directory /myth/tv/TRASH. If they remain untouched in this
# directory for 7 days, then they are automatically deleted.
#
#
TV="/myth/tv"
TRASH=$TV/TRASH
AGE="7"
MAX=8
PASSWORD=""
#
# Verify existance of input directories
#
if [ ! -e "$TV" ]
then
echo "$TV does not exist -- script halted."
exit 1
fi
mkdir -p $TRASH
if [ ! -e "$TRASH" ]
then
echo "Unable to created directory $TRASH"
exit 1
fi
if [ "$PASSWORD" == "" ]
then
PASS=""
else
PASS="-p$PASSWORD"
fi
#
# Create a list of files that exist in $TV that aren't in the DB
# and a list of files that exist in the DB that aren't in $TV.
#
mysql -uroot mythconverg $PASS -B --exec \
"select chanid,DATE_FORMAT(starttime,'%Y%m%d%H%i%s'),\
DATE_FORMAT(endtime,'%Y%m%d%H%i%s') \
from recorded;" >/tmp/mythclean.db
cat /tmp/mythclean.db | grep -v "^chanid" | sed -e "s/\t/_/g" | \
sed -e "s/$/.nuv/" | sed -e "s#^#$TV/#" | sort > /tmp/nuv-db-list
find $TV -maxdepth 1 -name \*.nuv -mmin +120 -print | sort > /tmp/nuv-files
orphaned_files=(`join -v 2 /tmp/nuv-db-list /tmp/nuv-files`)
missing_files=(`join -v 1 /tmp/nuv-db-list /tmp/nuv-files`)
#
# If a file exists in $TV, has not been modified for at least 1 day,
# and is not referenced in the database, then move it to the trash can
#
if [ ${#orphaned_files[@]} -gt $MAX ]
then
echo ${#orphaned_files[@]} nuv files were identified for removal, but
echo script is configured to limit removals to $MAX files.
echo No action taken.
exit 1
fi
for f in ${orphaned_files[@]};
do
echo Moving $f to the trash can
touch $f
mv -f $f $TRASH
if [ -e $f.png ]
then
echo Moving $f.png to the trash can
touch $f.png
mv -f $f.png $TRASH
fi
done
#
# Empty the trash can of all files that are older the $AGE days.
#
echo ""
echo "Checking $TRASH for files more than $AGE days old."
find $TRASH -maxdepth 1 -mtime "+$AGE" -a \( -name \*.nuv -o -name \*.png \) \
-print -exec rm -f \{\} \; | sed -e "s/^/ Removing file /"
#
# Create a dummy "nuv" file for any DB entry that does not point at
# a vaild file in $TV.
#
sleep 1
echo ""
echo "Checking for missing nuv files"
for f in ${missing_files[@]};
do
if [ ! -e "$f" ]
then
echo " Creating missing file $f"
echo "Dummy" > $f
fi
done
exit 0
|
