Archive for November, 2009

Off topic

Posted: 27/11/2009 in Uncategorized

This is a real off topic for this blog.

I only want to tell about my deviantart home page.

Bye bye.

Today is a good day to die. This is the mind of all routers of our provider cos today they decide to suicide, letting us without a way to reach Internet.

Today I planned to make live the server our customer with an effort of 2 hours. But Murphy’s law is all around us and then the DSL link of our offices went down.

Well, the choice was two: a party or my hsdpa cellphone…. I chose  for the second one :(. So i decided to use the netbook as gateway for lan traffic, connecting it to my pc with ethernet cable.

What is interesting is how is versatile iptables who allow me to configure my netbook as router, and my pc as a gateway for other computer in the office.

These are the miracle four rows (on netbook)

iptables -A FORWARD -i ppp0 -o eth0 -m state –state ESTABLISHED,RELATED -j ACCEPT
iptables -A FORWARD -i eth0 -o ppp0 -j ACCEPT
iptables -A FORWARD -j LOG
iptables -t nat -A POSTROUTING -o ppp0 -j MASQUERADE

and these are the four for the pc

iptables -A FORWARD -i eth0 -o eth1 -m state –state ESTABLISHED,RELATED -j ACCEPT
iptables -A FORWARD -i eth1 -o eth0 -j ACCEPT
iptables -A FORWARD -j LOG
iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE

Obviously I make a lan between my pc and netbook configured by hand using ifconfig, and I changed the routing using route command.

This is a link of a full script that use iptables to transform a pc in a router.

I know iptables is a little bit hard to use, but there are solutions at high level as shorewall, who manage iptables and allow you to know only what you really need to know.


These are only links about my slide for the World Plone Day 09. They are very easy to understand, but for any question you ma ask…

There are two version EN and IT.

EN ->

IT ->

I hope you enjoy.

In next days i think to publish a buildout for plone for deployment. Stay tuned :).

Hi all,

this post is around AWS, my server farm.

November 25th will be the first anniversary of using Amazon Web Services. After an year, I can say that I changed my mind, but this is the end of the story, so we back to the start.

I’m a computer programmer, I love all things about that, and what I found really interesting is the low level. For example, my favorite language is C (not ++), I like to assemble pcs, create myself the boards, cables  and whatelse. In few words: hardware is my life.

One year ago, I changed my job and I started to work for Reflab, as sysadmin, and they ask me about AWS. The first reaction was not so very good: virtualization of server, no physical contact with the server,  mmmm, too much… I didn’t like it. With a package full of doubts, I made the registration and I started my first server.

The documentation was not so good in really, but merging different sources it was not so hard. I’d like to say that my first server is running today, but is not the true: I had to shutdown that server cos was a small instance for testing. What I can say is that start a server takes 5 minutes.

Now we have 11 server online who are running happy and healthy. The counter of fault is less than 5 who required to restart the server. I thing it is a good result: more the 60% of server runs 100% of time, and the other 40% runs for 99.99% of time. After that, we do not have any problem about connection or disk fault.

The conclusion: we are very enjoy about this choice.

As I say, i’m the one who likes to see his hardware, but this solution is very great.

So… Happy birthday to you, happy birthday to you 🙂

This post is asked by a friend of mine, Vincenzo Di Somma, from Canonical and he was very surprised to see an oracle db on a small netbook. In reality, it is very simple.

What you need is a netbook with 1.5GB of free space on disk. I suggest 2GB of ram too.  I make setup on ubuntu 9.04, but it works on any linux distro.

First of all, we need oracle. There’s a free version for developer called Oracle XE. This version is smaller and simpler than the full version, but the interface is the same, so if you have to develop without licence problem this is your version.

Once you have download the file, you can follow usual way to install it.

During the installation, setup asks about user and password access, obviously you can choice what you want.

The game is done.

You can access to oracle XE by web client or using another kind of client. In my case study, I used RelStorage to substitute FileStorage of Plone, but this is another story 🙂 .

Hi All

Posted: 19/11/2009 in Uncategorized

I’m Federico Guizzardi, nick Cippino or Cip (if you like). I’m working in Reflab S.r.l. ( as sysadmin. Here i want to post my experience. I hope you can enjoy with it.