Dec 312012
 

I this special idea about banning spammers:

echo "select comment_author_IP from wp_comments where comment_approved = 'spam'" | \
   mysql --skip-column-names -u root wordpress_danlangilleorg | \
   xargs -n 1 -J % sudo pfctl -t idiots -T add %

Anyone care to explain how this works?

Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive

  One Response to “Killing spammers”

  1. I’m not sure you still need the info but it just get the IP address of authors of comments marked as spam and put them into a Packet Filter table called idiots.
    On your Packet Filter configuration, you should reject all connections coming from this table (see 29.3.3.4. Using Tables in ).