Dot Net Tricks

Articles about .NET, ASP.NET, C#, Object Oriented Programming and Agile Methodolgies
Welcome to Dot Net Tricks Sign in | Join | Help
in Search

Software Theosophy

Warn3d By CrueLSaw

Today I got a very interesting request from my boss.  There was one of our sites that had suddenly been defaced with the following text:

"Warn3d By CrueLSaw"

After some research by one of our Senior Developers (Thanks Pete) he found that this CrueLSaw guy was very busy hacking into and defacing classic asp and even a few PHP websites. 

It was our old friend sql injection--the guy had found the admin part of our site, and plopped in some sql into the password text box like this:

' OR 0=0 --

Of course the long gone developer of this code didn't parameterize their sql or use a stored procedure.  This effectively let him into our site to deface it.  We're lucky that CrueLSaw only warns people and didn't truncate our tables. 

To be fair, this site was a Classic ASP website done around 6 years ago and the developer back then probably didn't know a thing about sql injection, because few people did at the time. But some lessons are painfully learned.  The solution was simple--just use a stored proc or a ADO provider that allows paratmeterized SQL.

If you're company's website is having this problem, then fire me an email here and I can fix it for a small fee:

http://www.craigbowes.com/Contact.aspx

Thanks for the warning CrueLSaw.

Published Monday, March 10, 2008 5:37 PM by Fregas
Filed Under: , ,

Comments

No Comments
Anonymous comments are disabled

About Fregas

Craig is currently the Lead Developer in Fort Worth, Texas for Enilon Group, a web development firm. He has been programming since 3rd grade (using the Commodoore PET) and professionally for the past 7 years. He has written several articles for ASPToday.com and co-authored the book "Beginning Web Programming using VB.NET and Visual Studio .NET" Currently, his favorite programming language is C#, but he has programmed in Visual Basic, T-SQL, Ruby, ColdFusion, ASP 3.0/VBScript, ASP.NET, Javascript, Java and even Pascal. Besides programming, Craig is best known for his cooking and his somewhat offbeat sense of humor.

This Blog

Post Calendar

<March 2008>
SuMoTuWeThFrSa
2425262728291
2345678
9101112131415
16171819202122
23242526272829
303112345

Syndication

Powered by Community Server, by Telligent Systems