The answer to comment spam: AuthImage

Last friday I spent some time to set up another personal weblog (entirely in Dutch, and not computer related, sort of. If you can understand Dutch, don’t be offended by the uri, it’s ment to be funny). But within 72 hours…Comment Spam!

Sigh…
Not willing to take the comments offline like I did on this blog, I went over to the Wordpress WiKi.

Through this excellent overview it boiled down to this:
Gudlyf’s World » WordPress Hack: AuthImage

And to my own surprise…It works!

Pix.log to MySQL using PHP

I’ve started my first open source project, sort of at least.

I have my pix logging to a central syslog server. The last weeks I’ve been googling around for a good pix.log analyzer, but they are commercial or bound to the win32 platform.

So I decided to make a web-enabled pixlog parser.
Version 0.0.1 is up and running, having parsed little over 16000 pix log entries. Right know I’m deciding how the front end should look. But it already enables me to gather some nice statistics.


mysql> SELECT count(logentry_id) AS number_entries, src_ip
-> FROM pixlogentries
-> WHERE src_ip != ''
-> GROUP BY src_ip
-> ORDER BY number_entries DESC limit 5;
+----------------+--------------+
| number_entries | src_ip |
+----------------+--------------+
| 63 | 82.48.88.45 |
| 63 | 82.131.12.31 |
| 54 | 82.224.67.67 |
| 54 | 82.135.15.15 |
| 54 | 64.75.146.37 |
+----------------+--------------+
5 rows in set (0.03 sec)


I expect to make the first version available to the public within 4-6 weeks.

Apologies Accepted - the world’s answer to sorryeverybody.com

Apologies Accepted - the world’s answer to sorryeverybody.com

And almost as funny.

Comment Spam

Sucks.

I disabled all the comment-options. I got 200 emails the last 12 hours due to comment-spam.

I’m so angry at this moment.

www.sorryeverybody.com

Those poor Americans.

Another 4 years with Bush, and some of them really feel the need to say sorry to the rest of the world.

Sorry Everybody!