SQL Injection through HTTP Headers
During vulnerability assessment or penetration testing, identifying the input vectors of the target application is a primordial step. Sometimes, when dealing with Web application testing, verification routines related to SQL injection flaws discovery are restricted to the GET and POST variables as the unique inputs vectors ever. What about other HTTP header parameters? Aren’t they potential input vectors for SQL injection attacks? How can one test all these HTTP parameters and which vulnerability scanners to use in order to avoid leaving vulnerabilities undiscovered in parts of the application?
Input Parameter Coverage in Security Web Application Scanners
result of a comparison of 60 commercial and open-source black box web
application vulnerability scanners was released and titled: « The Scanning Legion: Web Application Scanners Accuracy Assessment & Feature Comparison ».
This benchmark, realized by the security researcher Shay Chen in 2011,
focused on testing commercial and open source tools that are able to
detect (and not necessarily exploit) security vulnerabilities on a wide
range of URLs.
We have concluded the chart below which shows input parameter’s coverage supported by tested web application scanners. These inputs are basically:
- HTTP Query String Parameters (GET): input parameters sent in the URL.
- HTTP Body Parameters (POST): input parameters sent in the HTTP body.
- HTTP Cookie Parameters: input parameters sent in the HTTP cookie.
- HTTP Headers: HTTP request headers used by the application.
This chart shows obviously that 75% of Web application scanners couldn’t discover HTTP Headers parameters related flaws. Furthermore, 70% of these scanners failed inspecting HTTP Cookies vulnerabilities else. These rates refer exactly to the ability of the scanners to scan the input vector, not simply to interpret it. Comparing to the reasonable score made for GET and POST, some automated testing tools may lead to unsatisfied results when dealing with HTTP header as an SQL injection input vector.
As a matter of fact, HTTP Headers and Cookies should not be underestimated. Therefore, these two vectors should be taken into consideration during testing plan. Yet, when the vulnerability scanners used are not supporting these features, we should think about testing these parameters manually.
Potential HTTP Headers for SQL injections
HTTP Header fields
HTTP header fields are components of the message header of requests and responses in the Hypertext Transfer Protocol (HTTP). They define the operating parameters of an HTTP transaction.
Example: Request HTTP
We can consider the HTTP Cookies, when are stored in databases for sessions identification, as the first potential HTTP variables which should be tested. We will see next in an example of Cookie based SQL injection. There are also other HTTP headers related to the application.
X-Forwarded-For is an HTTP header field considered as a de facto standard for identifying the originating IP address of a client connecting to a web server through an HTTP proxy or load balancer.
We will see an example of this flaw basing of a form submission.
The variable login is correctly controlled due to the sanitize() method.
Let us inspect the ip variable. It is allocating the output of the ip_addr() method.
Obviously, the IP address is retrieved from the HTTP header X_FORWARDED_FOR. This later is controlled by the preg_match which verifies if this parameter does hold at least one IP address. As a matter of fact, the environment variable HTTP_X_FORWARDED_FOR is not properly sanitized before its value being used in the SQL query. This can lead to run any SQL query by injecting arbitrary SQL code into this field.
The simple modification of this header field to something like:
will lead to bypass the authentication control.
User agent is an HTTP header field gives the software program used by the original client. This is for statistical purposes and the tracing of protocol violations. It should be included. The first white space delimited word must be the software product name, with an optional slash and version designator.
Not all applications are written to capture the user-agent data, but sometimes applications are designed to store such information (ex: shopping cart providers) to make use of it. In this case, it’s worth investigating the user-agent header for possible issues.
HTTP query example:
Referer is another HTTP header which can be vulnerable to SQL injection once the application is storing it in database without sanitizing it. It’s an optional header field that allows the client to specify, for the server’s benefit, the address ( URI ) of the document (or element within the document) from which the URI in the request was obtained. This allows a server to generate lists of back-links to documents, for interest, logging, etc. It allows bad links to be traced for maintenance.
As we all know, injection flaws are ranked the first in The OWASP Top 10 Web Application Security Risks. Attackers are increasingly seeking for injection points to get full access of your databases. No matter the injection input vector’s type, whether it’s a GET, POST, Cookie or other HTTP headers; the important for intruders is always to have at least one injection point which let them start the exploitation phase.
Manually testing Cookie based SQL injections
In this section, we will introduce some methods of inspecting HTTP Cookie variables.
Using a Browsers Add-on
Cookie Manager+ allows view, edit and create new cookies. It also allows show extra information about cookies and allows edit multiple cookies at once, as well as backup/restore them.
After installing it, from the Tools menu, select Cookies Manager+.We select a Cookie variable related to the target application.
We will edit the language_id variable. To figure out the SQL injection flaw, we will add a quote “‘” in the field
content of the variable language_id.
After refreshing the page, or clicking on other internal link of the application, the application submits the request using the edited HTTP cookie. The result is triggered an SQL error:
This database error is alerting us for a susceptible SQL injection flaw.
The advantage of using Cookies Manager+ is that it’s simple to use, act directly on the cookie and saves the previous edited value of the cookie.
We will try to determine the number of column using another Firefox plug-in.
Tamper Data is a powerful Firefox add-on to view and modify HTTP/HTTPS headers and post parameters.
After installing it, from the Tools menu, select Tamper Data. Start tampering HTTP request by clicking the button Start Tamper.
When launching any request from the target application, Tamper Data pops up a box and asks if we want to tamper the current HTTP request just sent.
After clicking on Tamper,we got the full Tamper popup:
We add: order by 4 into the HTTP cookie variable as shown in the previous screenshot. The response is normal from the application.
We increment the number and add this time: order by 5. The response to this injection is as follows:
So we can conclude that the number of columns is 4.
Now, we will try to figure out the affected columns in order to inject in it more SQL queries. So, we will add the following query into the language_id HTTP cookie variable:
The exploitation may need sometimes advanced SQL injection techniques.
Using automated penetration testing scanner
Sqlmap as example
Sqlmap is a popular open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers.
Sqlmap supports the HTTP cookie features so it can be useful in two ways:
- Authentication based upon cookies when the web application requires that.
- Detection and exploitation of SQL injection on such header values.
By default sqlmap tests all GET parameters and POST parameters. When the value of –level is set to 2 or above it tests also HTTP Cookie header values. When this value is set to 3 or above, it tests also HTTP User-Agent and HTTP Referer header value for SQL injections. It is however possible to manually specify a comma-separated list of parameter(s) that you want sqlmap to test. This will bypass the dependence on the value of –level too.
|Tested HTTP parameter||Level in sqlmap|
|HTTP Cookie||2 ≥|
|HTTP User-Agent||3 ≥|
|HTTP Referer||3 ≥|
For instance, to test for GET parameter id and for HTTP User-Agent only, provide -p id,user-agent.
This is an example of how we can test the parameter named security of an HTTP Cookie of the DVWA (Damn Vulnerable Web Application).
The flag –string compare between the valid pages and the invalid one (due to the injection). In the other hand, the flag –dbs is used to enumerate the database management systems. Finally, the flag –p force the testing of the PHPSESSID variable.
Tools for testing SQL injection: choose by its detection accuracy or by its input vector coverage?
order to answer this question, we have exploited the results of the
benchmark provided by sectoolmarket.com. We have take in hypothesis that
the detection accuracy of the candidate scanners has the same
importance as input vectors coverage and support. We have considered
GET, POST, HTTP Cookie and HTTP Headers as the input vectors that should
be supported. When all these parameters are supported, the scanners
make a rate 100% of coverage (4/4).
We suggest the equation below of arithmetic mean to adapt a balancing score for vulnerability scanners.
After balancing the obtained rates with the percentage of detection
accuracy, we stopped by this result below for the first 14 scanners:
|Rank||Vulnerability Scanner||Vendor||Detection Rate||Input Vector Coverage||Average Score|
Burp Suite Pro
can show a chart representing the vulnerability scanners by their
balanced score which defined both their detection accuracy for SQL
injection flaws and their input vector coverage.
Cookies and other stored HTTP headers should be treated by developers as another form of user input and be subjected to the same validation routines.
The manipulation of HTTP header information on page requests (especially the REFERER and USER-AGENT fields) is important to identify whether the application is vulnerable to SQL Injection vectors or even to other standard vulnerabilities (XSS). It’s a good practice to define and describe every way that a user may manipulate data which is used by the application. These data may be stored, fetched and processed from Cookies, HTTP-headers (like HTTP_USER_AGENT ), form-variables (visible and hidden), Ajax-, JQuery-, XML-requests. x
Penetration Testing with Improved Input Vector Identification, William G.J. Halfond, Shauvik Roy Choudhary, and Alessandro Orso College of Computing Georgia Institute of Technology
Security Tools Benchmarking – A blog dedicated to aiding pen-testers in choosing tools that make a difference. By Shay-Chen http://sectooladdict.blogspot.com/2011/08/commercial-web-application-scanner.html
A guy is working on some bug while he is riding a bike. He gets off the bike and stay aside the road and start to debug some production issue. So now you know how hard a programmer is working?