Lecture Notes in Computer Science, 2010, Volume 5965/2010, 192-200, DOI: 10.1007/978-3-642-11747-3_15

Idea: Using System Level Testing for Revealing SQL Injection-Related Error Message Information Leaks

Ben Smith, Laurie Williams and Andrew Austin

View Related Documents

Abstract

Completely handling SQL injection consists of two activities: properly protecting the system from malicious input, and preventing any resultant error messages caused by SQL injection from revealing sensitive information. The goal of this research is to assess the relative effectiveness of unit and system level testing of web applications to reveal both error message information leak and SQL injection vulnerabilities. To produce 100% test coverage of 176 SQL statements in four open source web applications, we augmented the original automated unit test cases with our own system level tests that use both normal input and 132 forms of malicious input. Although we discovered no SQL injection vulnerabilities, we exposed 17 error message information leak vulnerabilities associated with SQL statements using system level testing. Our results suggest that security testers who use an iterative, test-driven development process should compose system level rather than unit level tests.

Keywords  SQL - Exception - Tomcat - Java - web application - system level - unit testing - database - SQL injection attacks - coverage - error message

Fulltext Preview

Image of the first page of the fulltext document