Powered by RealTown Blogs
Alert for Web Programmers and Managers: SQL Injection : Matt's Real Estate Technology Blog
Clareity ConsultingReal Estate Information Technology Consultants
Home PageAbout ClareityServicesClientsPublicationsEventsContact

Matt's Real Estate Technology Blog

Jul. 21, 2008 - Alert for Web Programmers and Managers: SQL Injection

This is for my readers who are, or who manage, web application programmers. I sent this update to my security assessment clients about a month ago but the urgency has continued to increase as attack rates are rising ...

I've been seeing a lot more injection attacks on industry sites - some automated, some manual. If you have web applications and haven't been testing for SQL and XSS injections - get on that PRONTO!

Even if you think your input validation is under control be careful - attackers are getting a LOT sneakier:

* Using HTML entities instead of the characters, encodings like UTF-8, long UTF-8, UTF-7, Unicode, US-ASCII and even HEX. Watch out for 'declare' and 'cast' in inputs ... not your friend.

* Not using special characters - leaving off the single quotes, using 'fromCharCode' to create them, or even use a grave accents as a replacement.

* Messing up regular expressions looking for SCRIPT by embedding tabs, spaces, carriage returns - or encoded versions of the same!

* Sending you naughty content not just through traditional inputs and URL strings, but through cookie manipulation.

* Leveraging your platform - such as SSI (if installed), renaming JS files to image extensions for upload, even using your application platform to create the script.

* Going beyond JavaScript and using VBscript.

* Injecting into image tags - including dynsrc and lowsrc attributes, in BODY onloads, in CSS calls, in titles, meta tags, iframes, TD backgrounds, DIV styles, BASE tags, OBJECT tags, XML, Flash actionscript and more!
 

I think my "favorite" workaround for XSS validation is where the validator gets rid of script tags in inputs but doesn't search recursively, so the hacker inputs [SCR[SCRIPT]IPT]" it gets rid of the middle "[SCRIPT]", leaving.... [SCRIPT]!

And they're using every combination of the above that you can think of!!!
 
Are you validating for all of these situations?

Be careful out there!
 

Comments (0) :: Post A Comment! :: Permanent Link
View more entries tagged with: , ,


Write a Comment

Your Name:  RealTown Members: Click here to login
Your E-Mail: 
Your Website: 
Subject: 
Your Comment: 
Notifications: 
Privacy: 
Verification: 
To verify that you are a human and not a script, please enter the verification word from the image into the box on the right.
 


Matt Cohen is Clareity Consulting's Chief Technologist. Matt consults to MLSs, Associations, brokerages, and many real estate industry software companies and has spoken at conferences, workshops and leadership retreats around the country on a wide variety of MLS-related topics. Matt is a well-regarded real estate industry expert on industry trends, software design, product management, project management, and information security. Clareity Consulting was founded in 1996 to provide information technology consulting to the real estate industry and its related businesses.

Links

Home
View my profile
Archives
Email Me
Blog Manager

Disclaimer: The opinions expressed on this blog are the responsibility of the author and do not necessarily reflect the opinion of Clareity Consulting

Home Page | About Clareity | Services | Clients | Publications | Events | Contact

©1996-2008 Clareity Consulting. All Rights Reserved.