On several sites I administer, I've had to deal with comment spam. Not just one or two comments, but hundreds. While Jeremy Andrew's Drupal [spam module|http://www.kerneltrap.org/jeremy/drupal/spam/] helps, I've taken the additional step of denying access to these shitheads. Here's how to do the same. # If you haven't already, install Jeremy Andrew's Drupal [spam module|http://www.kerneltrap.org/jeremy/drupal/spam/]\\\\ # After you've been hit, execute the following query: \\{{{\\select distinct hostname from spam_log where entry like '%insert action%'}}}\\ # Select all of the hostnames, then edit your .htaccess file thusly: \\{{{\\\\deny from [hostname from query above]\\\\}}}\\

Since I installed Spam Karma 2 (SK2), I've been an absolute fiend about checking to see if any spam has been harvested. Before, I'd get about 20 "please moderate such and such comment" emails a week... Sometimes more.

It's been so effective, I have to write about something else, I suppose...

So, here's what I've been doing for the past couple of days (besides working, of course):

• Working on a CSS-only (read: non-table) version of my resume
• Looking for a very lite content mangement system for the site's static content
• Fixing overheating issues on the other computers laying around the house and playing family System Administrator
• Playing around with a second-hand copy of SuSE Professional 9.1

Ok, now that Spam Karma's installed, I've turned off the Users must be registered and logged in to comment option.

Let 'em try to comment.

Mwahahahahahaha.

Dr Dave has published Spam Karma 2 for beta testing.

I've installed it, and will discuss its efficiency in the future.

edit: Wow, just looked at the options. I wish I would have found this plugin earlier.

Anyone who really wants to comment may do so. You just have to register.

For what it's worth, your efforts are in vain anyway. Every link you have posted on this or any WordPress blog is tagged with "rel=nofollow". For those of you interested enough, read this blog entry on the Google Blog.

I have three words for everyone who wanted to use my site to pimp their online casinos, cialis, viagra, phentermine, or what-have-you: neener, neener, neener.

Spammers suck ass. Comment spammers suck even more ass.