This little tool is pretty useful for administrators who wear the hat of both system admin and DBA on Linux/MySQL boxes. I wrote it as kind of a joke for our Perl developers, but now I use it just about every day for everything from at prompt hackups to full on table space utilization monitoring scripts.

The snippet has the library script that you can source into scripts that actually do work, as well as a script that uses the functions in the libraries. Anyone who has used the C API should be able to relate to using this script.

It's pretty fast and lightweight. It makes only one external call to mysql and sed per query. The rest is all bash builtins. Requires bash > 3.0

Truncate String

Fixed missing $ sign.

Ping, PingOMatic service for an updated. Requires: The Inutio XML-RPC Library.

Get a List of Folders and/or Files

This is a simple PHP script that will show whether a certain port/socket of a certain computer is currently open/active.

Function that splits a given string into sections based on the allowed length for a section. Does not split words up. Splits string on Space character (can be set to another character)

This routine checks a client's IP address against a few open lists of blacklisted IP addresses, returns TRUE if the ip is a known proxy.

List files in your current di

Mass email list of email addresses from a mysql db table.