Version 1.0
Author: Falko Timme <ft [at] falkotimme [dot] com>
Last edited 10/01/2008

GreenSQL (or greensql-fw) is a firewall for MySQL databases that filters SQL injection attacks. It works as a reverse proxy, i.e., it takes the SQL queries, checks them, passes them on to the MySQL database and delivers back the result from the MySQL database. It comes with a web interface (called greensql-console) so that you can manage GreenSQL through a web browser. This guide shows how you can install GreenSQL and its web interface on a Debian Etch server.

I do not issue any guarantee that this will work for you!

I have tested this on a Debian Etch server where MySQL and Apache are already installed. I will use the virtual

Nowadays, within the growing web 2.0 environment you may want to have some anonymity, and use other IP addresses than your own IP. Or, for some special purposes - a few IPs or more, frequently changed. So no one will be able to track you. A solution exists, and it is called Tor Project, or simply tor. There are a lot of articles and howtos giving you the idea of how it works, I'm not going to describe here onion routing and its principles, I'll rather tell you how practically pull out the maximum out of it.

So, let's start.

Major disadvantages of tor, with all its benefits like security (however, tor manufacturers advice not to rely on its strong anonymity, because there are some cases, when it is possible to track young h4x0r...) are:

1. Long enough session (6

Version 1.0
Author: Falko Timme <ft [at] falkotimme [dot] com>
Last edited 10/08/2008

Gufw is a graphical frontend for managing an iptables firewall on an Ubuntu 8.04 desktop. It is based on ufw and enables you to allow or block pre-configured, common p2p, or individual ports. This guide shows how you can install and use Gufw on Ubuntu 8.04.

I do not issue any guarantee that this will work for you!

Open Firefox and go to http://gufw.tuxfamily.org/index.html. Click on the Download link:

(JavaScript must be enabled in your browser to view the large image as an image overlay.)

In the Firefox download dialogue, select Open with GDebi Package Installer (default):

(JavaScript must be enabled in

Openfiler is a high performance operating system tailored for use as a SAN/NAS appliance. This configuration will enable two Openfiler appliances to work in an Active/Passive high availability scenario.

Install Openfiler 2.3 on both boxes utilizing a disk setup such as the following: