IP geographic location

GeoIP is a nice service that provides free databases with IP to country/city relations. They have very nice APIs which might eventually come in handy when doing your every-day log analysis.

Given that I needed to find the assigned IPs to a certain country, and that the C API I saw provided no means of doing it, I created a small script that will drop all the IP addresses in a plaintext file. The information is taken from the CSV database.


./country2ip.sh database.csv Country_Name output_file


It is not intended to be efficient and it certainly is not. It is intended to be effective and it serves its purpose. Be aware of the extremely large files that it may generate.

Download here.

Some interesting info:

Brasil: 25,583,219 unique IP addresses
Uruguay: 17,174,982 unique IP addresses
Argentina: 4,996,274 unique IP addresses
Chile: 4,295,697 unique IP addresses
Venezuela: 3,186,405 unique IP addresses
Colombia: 3,120,548 unique IP addresses
Peru: 1,077,608 unique IP addresses
Ecuador: 767,728 unique IP addresses
Bolivia: 354,207 unique IP addresses
Paraguay: 83,328 unique IP addresses

Mesdames, monsieurs, suite a un mouvement social…

One of the many faces of France, its strikes, has popped out during the last months. Two transport strikes in less than a month is just too much. Even the French, who take strikes as a god given right, have started to get pissed at the transporters. Why should they retire at 50 while the rest of the people retire later?

I never knew so many people could fit in a sigle wagon. I never laughed so hard at the French people covering their noses with their scarfs because of the smell of a clochard.

There other things that amaze me. The strike itself is so organized you chan check at the tranporter’s webpage the frequence and percentage of trains currently rolling through the streets. I wonder, if they are on strike, who is in charge of updating these pages? Wouldn’t we all be better off if that person rose from its chair and started driving one of the trains?

I like the French way for some things, but this is way too much.

---

Photo taken by awk @ the Eiffel Tower in Paris (October 2007)