Comment for Michael Carden about comment spam

I read on PLOA that Michael Carden briefly tried to open his blog for comments, only to find:

The WordPress UI balked at deleting 194,000 (okay, I ignored it for a while) comment spams. I had to dig in as admin and run a fun sql query on the database to delete all 47 meg of them.

I guess I’ve got a couple of suggestions for Michael to make his life a little easier should he decide to try again.

  1. Akismet has an option to “Automatically discard spam comments older than a month“, that might help (though it’d be nice to be able to adjust the time).
  2. Run, do not walk, to Rich Boakes most excellent Worst Offenders plugin. This will both group comments for deletion based on various criteria but also (if you have permission) add Apache “Deny From” rules for the offending IP addresses. It’s also worth bumping the number of IP addresses it can ban up, Donna’s blog is up to over 8,000 at the moment!
  3. There are also tools like Bad Behaviour to try and catch bots before they get to you and if you are a member of Project Honeypot then there is the http:BL WordPress Plugin to check and block IP’s listed as baddies there.

Anyway, I hope that helps some people out.

Rails GIS Hacks

A good friend and ex-colleague of mine, Shoaib Burq, will be running an afternoon tutorial on the 17th September at RailsConf Europe called Rails GIS Hacks.

Since the advent of Google Maps and a number of other free web APIs for mapping, there has been an exponential increase in the number of mapshups and geography-related web sites. In this tutorial we will introduce what’s happening in the Ruby/Rails Geographic Information space. We will go from defining the key concepts behind the geospatial technology to developing a full-blown mapping application in Rails. In the process, we will make use of a number of cool Rails plug-ins that will let us integrate external geographic data sources as well us share our own data. […]

Sounds like fun.. 🙂

LCA 2008 – Call For Papers now open

Linux.Conf.Au 2008, which will be held right here in Melbourne, has just (( I started writing this around 11am, now I get to post it about 9 hours later.. )) opened up its Call For Papers, some come on in!

The closing date of the CFP will be 20th July 2007.

They are also accepting proposals for mini-confs too.

The mini-conferences are dedicated conference streams for specific communities of interest. The linux.conf.au organisers provide the space, and leave the rest up to the organiser of each mini-conf. Mini-conf speakers and delegates need to register for the main conference to participate.

Go on, give those of us on the LCA 2008 papers committee something exciting to read!

Blocked by the Great Firewall of China

Inspired by Alec, I just checked using the Great Firewall of China checking site and found out that my site, along with Donna’s, her blog, her podcast, the site for her first book and the web site we set up to promote self-employment for folks on the Autism spectrum, Auties.org, are all blocked!

Blocked by the Great Firewall of China

Presumably it’s working by IP address and so anything that happens to be on that IP address is persona non-grata in China. 🙁

I did a bit of testing and found that VPAC (where I work) is blocked too, as is Melbourne Uni.