Scripts

These are located at http://serverkb.co.uk/tools/

Read the README.txt for further information on these tools. The number count below is only counting .sh and .pl files.

All of these can be retrieved by clicking the Topic Header on this page, right clicking the link - Copy Link Address, then do:

wget domain.co.uk/linktofile.sh

Plesk Accounts (1) -accounts.sh

The accounts script is only used on Linux servers with Plesk below version 11 (11+ encrypts passwords) and can retrieve Plesk, FTP and email passwords. To use it you need to do the following within SSH:

wget http://serverkb.co.uk/tools/accounts.sh ; chmod +x accounts.sh
./accounts.sh

Written by Leon_Teale, modified by Byron Galietta and Sam Teale.

Advanced Service Monitor (2) - advancedmonitor.sh

This is a more advanced version a previous service monitor script , giving more output and debug possibilities.

This script will monitor and start/restart a specific service that you specify. By default it will do Apache, the Linux web server. To use it, do the following:

cd / root ; wget http://serverkb.co.uk/tools/advancedmonitor.sh ; chmod +x advancedmonitor.sh
crontab -e

In here add:

10 * * * * /root/advancedmonitor.sh

Edit the file and replace the admin email address with yours by doing:

vim advancedmonitor.sh

Replace apache2 with httpd within it if your server calls Apache httpd instead.

To start another service edit the following field:

service="apache2"

For example for MySQL have service="mysql" instead (or mysqld)

Backup databases on Plesk server (3) - backupdb.sh

This backs up all databases as .sql files and a .tar.gz containing all excluding information_schema, atmail and horde on a Plesk Linux server but does not email you them.

Email version (4) - databasedump.sh

This backs up all databases as .sql files and a .tar.gz containing all .sql excluding information_schema, atmail and horde on a Plesk Linux server and emails you them.

Only .sql files (5) - dbSQLonly.sh

Use this script if you only want .sql files in separate emails and not the extra one with all MySQL databases compressed into a .tar.gz.

For both of the above:

apt-get install mutt

or

yum install mutt

chmod 755 /sent ; chmod 755 /root/sent
vim /etc/passwd

Change the root user's home directory to / instead of /root

crontab -e

*  * * * 0 :> /root/sent

A solution may be needed for:

postdrop: warning: uid=0: File too large
sendmail: fatal: root(0): message file too big
Error sending message, child exited 75 (Deferred.).
Could not send the message.

Disk Limit Monitor (6) - disklimit.sh

This simply notifies you via email when your disk space reaches 90%. To run and install it do the following:

cd /root ; wget http://serverkb.co.uk/tools/disklimit.sh ; chmod +x disklimit.sh

Edit the file and replace the ADMIN email address with yours by doing:

vim disklimit.sh
crontab -e

In here add:

45 * * * * /root/disklimit.sh

Domain to IP conversion (7) - domaintoip.sh

This finds the IP addresses for all domains in /var/www/vhosts (this path can be edited) and outputs the results to screen and a file.

Enable the EPEL repository (8) - epel.sh

This will take into account if the Operating System is CentOS or Ubuntu.

Extra Logging (9) - extralogging.sh

Extra Logging 2 (for Plesk servers)

Registrar finder for Plesk servers (12)

Once edited with the registrar of your choice this will get the list of your domains and look up the domain registar. If it matches then it will place these in a file in the same directory you are in called our_registrar. Some server configuration has to be done first which can be found here: http://serverkb.co.uk/wiki/Linux#WHOIS_script

Mail Queue Count and Mail Warning (15 + 16)

These go together.

mailqueuecount.sh gets a queue status once a day.
mailwarning.sh runs every five minutes and will email you if your qmail mail queue is over the limit you set within it.

Install mcrypt (17) - mcrypt.sh

This will install mcrypt on Ubuntu, CentOS 5 or CentOS 6. It will also automatically enable the EPEL repository if needed.

MySQL Tuner (18) - mysqltuner.pl

This will only review your MySQL setup/performance, it will not make any changes.

wget http://serverkb.co.uk/tools/mysqltuner.pl ; chmod +x ; perl mysqltuner.pl

Engine X Monitor (20) - nginxmon.sh

This is a script to automatically monitor and check the new web server used by Plesk 11+ on Linux servers. To use it, do the following:

cd /root ; wget http://serverkb.co.uk/tools/nginxmon.sh ; chmod +x nginxmon.sh
crontab -e

#In here add:

10 * * * * /root/nginxmon.sh

#Edit the file and replace the admin email address with yours by doing:

vim nginxmon.sh

Red5 Media Server tar.gz (25)

See the following link for what Red5 is/does: http://www.red5.org/

Slow Query Log for MySQL (22) - slow.sh

HN

Snow Script (23) - snow.sh

wget http://serverkb.co.uk/tools/snow.sh
chmod +x snow.sh
./snow.sh

This puts snowfall on your screen! :) To quit, do:

CTRL + C
CTRL + L

SQL Backup for chroot (24) - sqldump.sh

This backs up databases from a chrooted Linux environment and places them in a folder called /sqlbak

Before using it please do:

chroot /usr/fs

UpdateDB (26) - updatedbscript.sh

This updates the linux index of a server if it does not already so any knew files can be found using the linux comand locate <filename>. To use it you need to do the following:

cd /root ; wget http://serverkb.co.uk/tools/updatedbscript.sh ; chmod +x updatedbscript.sh
crontab -e

#In here add:

5 * * * * /path/to/updatedbscript.sh

eXample .htaccess and .htpasswd file

Place the below .htaccess file in your document root with 644 permissions.

Options +Indexes
AuthName "Private zone"
AuthType Basic
AuthUserFile /change/this/to/full/file/path/to/.htpasswd
require valid-user

Encrypt your password by doing:

openssl passwd -1
Password: *enter your password*
Verifying - Password: *enter your password again*
<Password will appear here>

Copy the encrypted password above.

Place the below .htpasswd file anywhere in the file system:

user:EncryptedPassword

Test by going to domain.co.uk/folder

Notes

Remove spaces between file names

Guide 1

Do not use for-loops to process lists of unknown length, like a directory listing. If the list grows too long it will exceed your maximum line length (see syslimits.h) and your code will break. Using a while-loop removes this risk.

Guide 2

Realtime monitor of Apache accesslog

vim realtime.sh

#!/bin/bash
ACCESSLOG="/var/log/apache2/access_log"
DATE=`date +%d\/%b\/%Y`
TOTAL=`netstat -pant | grep :80 | wc -l`

echo "There are a total of $TOTAL port 80 connections."
echo -ne "The " ; uptime | awk '{print $8,$9,$10,$11,$12}' ; echo ""

tail -10 $ACCESSLOG | grep $DATE" | awk '{ x = $2 " " $4 " " $7 ; printf "%-15s %-20s \n", $1, x, $7}'

Run this with:

watch -n 2 ./realtime.sh

Alternatively you can use httpry. This may be best run in a screen session so you can enter in and out of it. To use it do:

wget dldmz.eu/s/httpry
chmod +x httpry
./httpry

Then go to your websites. You can output the contents to a file by using:

./httpry -o filename