Hi, We tried selling this code but couldn't beat the shrink-wrapped filters, so I'd thought I'd put it out for the public.
Basically, we were selling a server with everything loaded, so not much was put into docs or installing, but a reasonably techie will be able to put all the pieces together. The app is a jsp-based WAR file for Tomcat. When SquidGuard blocks a page, the url is entered into a postgres database. Immediately, the user can enter a password which will add (page/domain, your choice) to the local "allow list". Alternatively, log into the web application, and see a list of the last three hours of blocked sites, and add any blocked (page/domains) to the allow list. Also, in the web app, one can add or remove sites from the local allow or local deny list (the app writes directly to the Berkeley 2.7.7 db files with Java). Finally a special user, the administrator, can use the web apps to add or remove other passwords. In addition, there is a shell script which uses the curl utility to update from three well-known public SquidGuard blacklists, intended to be used in a crontab. I'd be glad to offer support to the install or config at an hourly rate and would like to hear of people who are using it. http://wc-it.com/sw/sgadmin/ Thanks, Keith Keith Wannamaker, Chief Consultant Wannamaker Consulting PO Box 6665 Columbia, SC 29260 (803) 743-9609 http://wc-it.com
