Electricmonk

Ferry Boender

Programmer, DevOpper, Open Source enthusiast.

Blog

Archive for September 2007

Very slow subquery due to HAVING

Today, I was quite mystified by a very slow running query. There was a table named ‘bar’ with about 3000 rows. I wanted to list all the rows that had a duplicate value for a certain field (‘foo’), and only those rows. The solution was to build a query that selected the rows where the […]

AFDB. Keep your mind to yourself

A link related to the previous post: The Aluminum Foil Deflector Beanie. Thanks Aczid.

Did you know? Secret anti-communism network in europe

Did you know that, after World War II came to an end, a secret organisation called “Gladio“, funded by the CIA and NATO, was brought to life in Europe in order to (amongst other things) neutralise communistic influences? The organisation spanned almost the whole of West-Europe, including countries such as Belgium, Germany, The Netherlands, France, […]

DDoS attack paralyses Estonia

Hackers Take Down the Most Wired Country in Europe: At exactly 11 pm, Estonia was slammed with traffic coming in at more than 4 million packets per second, a 200-fold surge. Globally, nearly 1 million computers suddenly navigated to a multitude of Estonian sites, ranging from the foreign ministry to the major banks. It was […]

Dutch consumer rights organisation recommends Ubuntu

The dutch consumer-rights organisation ‘Consumentenbond’ has recommended Ubuntu as a possible alternative to Vista after it received 4200 complaints about Vista in four weeks. Translation of the dutch Nu.nl article: Flood of complaints about Windows Vista AMSTERDAM – Consumer organisation ‘Consumentenbond’ has collected 4200 complaints about Vista in four weeks. Vista still isn’t a viable […]

Why spamfilters are useless

I used to never get spam, until I made a little mistake in my mail client and sent mail to a mailinglist under my real email address. My address wound up on the big bad public internet, and a few hours later the first spam emails started to come in. I installed a quite sophisticated […]

PHP Configuration hell

From the Apache2 configuration file for host example.com: php_admin_value upload_tmp_dir “/var/www/example.com/tmp/” From the file /var/www/example.com/htdocs/test.php: var_dump(ini_get(“upload_tmp_dir”)); Output: string(29) “/var/www/example.com/tmp/” Then, after trying to upload a file, from the /var/www/example.com/logs/error.log: [Sun Sep 02 18:09:05 2007] [error] [client 88.211.179.104] PHP Warning: Unknown: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/example.com/) in Unknown on […]

The text of all posts on this blog, unless specificly mentioned otherwise, are licensed under this license.