май съм entirely obsessed..
root@clev5new:~# cat moodle.sh
#!/bin/bash

log=”/home/sentry/www/moodle_report”
echo “———————–Moodles with big cache tables———————–” >> $log
find /var/lib/mysql/* -type f -name “mdl_cache_text.MYI” -size +1500 | awk -F”/” ‘{print $5}’ >> $log
echo “———————–Moodles with big stats tables———————–” >> $log
find /var/lib/mysql/* -type f -name “mdl_stats_daily.MYI” -size +1500 | awk -F”/” ‘{print $5}’ >> $log
echo “———————–Calculating..—————————————” >> $log
for i in `cat $log |grep mdl`;
do
du -sh /var/lib/mysql/$i >> $log
du -sh /var/lib/mysql/$i/mdl_stats_daily.* >> $log
du -sh /var/lib/mysql/$i/mdl_cache_text.* >> $log
done;

---

root@clev5new:~# cat entire-moodle.sh
#!/bin/bash
log=”/home/sentry/www/entire_moodle_report”
find /var/lib/mysql/* -type f -name “mdl_user.MYI” | awk -F”/” ‘{print $5}’ >> $log
echo “———————– Calculation ———————–” >> $log
for i in `cat $log`;
do
du -sh /var/lib/mysql/$i >> $log
done;

Very neat tools for generating web based reports containing Moodle installations that have stats & cache (kewl overloadish) modules (the first script) and for such that does not have (all on our servers, at all). Useful. Mission completed, Master.

Long live bash scripting.

A neat tool for killing all the procs that belong to user

if [ "$1" == "" ]
then
echo “Usage: $0 username — will kill all processes that belong to the user and print them on the screen “
else

if [ "$1" == "root" ]
then
echo “Lapai..”
else
echo “The processes of $1 that were killed:”
echo “############################################”
ps -elf | grep “$1″
kill -9 `ps -u “$1″ | grep [0-9] | awk ‘{print $1}’`
fi
fi

#!/bin/bash
# Very Simple Tool for Generating Apache Vhosts.
# v.1.0
# \\ Brand //

echo “Which domain name you would like to generate vhost for?”
read domain
echo “Which user does this domain name belong to?”
read user
echo “Do you want to assign the domain name a dedicated IP address [y/N]“
read answer

if [ $answer = "y" ]
then
echo “Provide the dedicated IP address”
read host
else
host=`host \`hostname\` |awk ‘{print $4}’`
fi

echo “<Virtualhost $host>”
echo “ServerAlias www.$domain $domain”
echo “ServerAdmin webmaster@$domain”
echo “DocumentRoot /home/$user/public_html”
echo “BytesLog domlogs/$domain-bytes_log”
echo “<IfModule mod_php4.c>”
echo “php_admin_value open_basedir \”/home/$user/:/usr/lib/php:/usr/local/lib/php:/tmp\”"
echo “</IfModule>”
echo “<IfModule mod_php5.c>”
echo “php_admin_value open_basedir \”/home/$user/:/usr/lib/php:/usr/local/lib/php:/tmp\”"
echo “</IfModule>”
echo “User $user”
echo “Group $user”
echo “ServerName www.$domain”
echo “ScriptAlias /cgi/bin/ /home/$user/public_html/cgi-bin/”
echo “CustomLog domlogs/$domain combined”
echo “</VirtualHost>”