Blog Spamming Fight - Attempt II

A productive antispam evening...

As I've mentioned before, I've completely setup my SQL Antispam procedure and now it works good. I like this solution mainly for 2 reasons:

  • If I'll install a new skin, I don't have to modify anything on my blog.
  • I can completely customize what I define as "spam".
  • Also a human spammer can't post anything on my Blog.

this solution however has a main disadvantage:

  • this is an antispam method that involves a little modification of a .Text stored procedure, so if a day I'll update .Text to another version, I've to modify the stored again.

To keep my spam table always update with new spam definitons, I've setup a little tool that simply connects to my SQL Server and update the spam definition... useful!

When I was at the end of all this work, I had a "mail talk" with Andrea Boschin and he gaves me his CAPTCHA Image Control for testing...

He has worked on a user control for .Text easy to use and to integrate on every skin you have (you've only to modify some lines of code in your PostComment.ascx file). I've installed it (as you can see now) and it works quite good (what I'd like to improve is the image rendering... sometimes I've see that it's quite difficult to read, expecially with Firefox).

And now? What will be my final antispam choice for my Blog? The SQL solution or the CAPTCHA Control?

For the moment I've taken this decision: I'll use the two methods together! CAPTCHA Control will require a human interaction to leave a feedback on my Blog, so spam bots are completely erased. If a spam bot (quite impossible) will pass the CAPTCHA control or if a human spammer will try to post something not admitted on my Blog, their post will be automatically deleted by my SQL control. Great... I've the most spam protected Blog of the Blogosphere!!

UPDATE: The CAPTCHA Image rendering now has a low distorsion, so the image seems more readable on every browsers.

Print | posted on Thursday, January 13, 2005 1:06 AM

Comments on this post

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
eh eh eh, you are playing with about two condoms? ;-)
Left by Andrea Boschin on Jan 13, 2005 6:39 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
but you're right, the image distorsion is really too heavy. I've to work for changing some parameters about it...
Left by Andrea Boschin on Jan 13, 2005 6:40 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Yes, the image distorsion is too much... I hope that it will be possible to control it because some images are really unreadable.
Left by Stefano Demiliani on Jan 13, 2005 6:56 AM

# Hip, Hip, Hurra!

Requesting Gravatar...
Left by Di .NET e di altre amenita' on Jan 13, 2005 1:07 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Prova... ;-)
Left by Lorenzo Barbieri on Jan 13, 2005 7:24 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Instead of "Invaild Human Proof" you can use "Invalid Human!" :-D
Left by Lorenzo Barbieri on Jan 13, 2005 7:26 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Too much... no I needed 3 retries to find a readable image... ;-)
Left by Lorenzo Barbieri on Jan 13, 2005 7:27 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Yes Lorenzo, you're right... too much distorsion on the images. It must be undoubtely reduced.
Left by Stefano Demiliani on Jan 13, 2005 7:35 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Which CAPTCH .Text solution are you using? Miguels? I see your works better that mine.
Left by David on Jan 17, 2005 10:00 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
No David, it's a custom control developed on our user group. I've tryed Miguel's solution some months ago but I wasn't satisfied.
Left by Stefano Demiliani on Jan 17, 2005 11:32 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
I'm using Miguel solutions and I am not 100% satisfied either. Is your control public? Can one get it and use it?
Left by David on Jan 19, 2005 6:07 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Yes the control is public (thanks to Andrea Boschin on our user group). If you want it just contact me via email and I'll sent it.
Left by Stefano Demiliani on Jan 19, 2005 6:53 AM

# re: Blog Spamming Fight - Attempt II

Requesting Gravatar...
Thanks!
Left by David on Jan 19, 2005 8:34 PM

Your comment:

 (will show your gravatar)
 
Please add 6 and 2 and type the answer here: