I made some Squidguard RPM packages to simplify the installation process. I made some Squidguard blacklists RPM packages to facilitate installing some default blacklists for Squidguard. The blacklists in these packages are:

• http://www.squidguard.org/blacklist/
• http://cri.univ-tlse1.fr/documentations/cache/squidguard_en.html
• http://www.bn-paf.de/filter/
• http://www.ingrid.org/~harada/filtering/

You can also use APT to get these packages automatically (and unattended). When you have to convince people what Squidguard can do, it might be handy to run your existing Squid-logs through Squidguard and create charts of the output. I have a script that actually does that, but I need to rewrite it a bit.

The ouput is a CSV file that contains the source IP address, the blocked destination name, the blocked URL and the original timestamp (and a human readable one).

You can use Gnumeric, Open Office or even Excel to generate some nice charts to show management.