OpenEMR 3.2.x Virtual Appl. - SQL Injection Vulnerabilities

Document Title:
===============
OpenEMR 3.2.x Virtual Appl. - SQL Injection Vulnerabilities



Release Date:
=============
2011-07-27


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


Product & Service Introduction:
===============================
OpenEMR is a free medical practice management, electronic medical records, prescription writing, and medical billing application. 
These programs are also referred to as electronic health records. OpenEMR is licensed under the General Gnu Public License (General GPL). 
It is a free open source replacement for medical applications such as Medical Manager, Health Pro, and Misys. It features support for EDI 
billing to clearing houses such as Availity, MD-Online, MedAvant and ZirMED using ANSI X12.


Medical claim and accounts receivable can also be managed through SQL-Ledger, which has been customized. Calendar features include categories 
for appointment types, colors associated with appointment types, repeating appointments, and the ability to restrict appointments based on type. 
There are customizable medical encounter forms, support for voice recognition software, and electronic or scanned digital document management for 
records. The community is dedicated to guarding OpenEMR\\\\\\\'s status as a free, open source software solution for medical practices. Its members are 
comprised of software developers, as well as physicians and those with extensive medical and billing knowledge, all with the common goal of making 
OpenEMR a viable alternative to its proprietary counterparts. Our mission - Built on a tradition of continuously sharing, changing and improving, 
the OpenEMR community strives to work together to create a high-quality electronic medical record and practice management system. Through open 
collaboration, the community is molding a stable, yet continuously improving product, thanks to the efforts of developers across the globe, brought 
together by their tenacity and the connectivity of the Internet. Open Source Medical Software (OSMS) is an all volunteer organization that 
supports OpenEMR.

(Copy of the Vendor Homepage: http://www.oemr.org/)


Abstract Advisory Information:
==============================
The Vulnerability-Lab Team discovered multiple SQL Injection Vulnerabilities on OpenEMR 3.2.0 Virtual Appliance.


Vulnerability Disclosure Timeline:
==================================
2011-07-29:	Public or Non-Public Disclosure


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


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

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


Severity Level:
===============
Critical


Technical Details & Description:
================================
Multiple SQL Injection Vulnerabilities are detected on different modules of the web-application.
Attackers can compromise the application by injection own statements over not secure parsed modules.

Vulnerable Module(s):

			[+] Add/Edit Events
			[+] Immunizations - Patiens_File
			[+] Demographics
			[+] Calender ID
			[+] AddUrlShield



Pcitures:
			../sql1.png
			../sql2.png
			../sql3.png
			../sql4.png
			../sql5.png


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

Path:			*.com:2096/openemr/interface/main/calendar/
File:			add_edit_event.php
Param:			?date=20100406&eid=

Path:			.com:2096/openemr/interface/patient_file/summary/
File:			immunizations.php
Param:			?mode=edit&id=

Path:			.com:2096/openemr/interface/patient_file/summary/
File:			demographics.php
Param:			?set_pid=

Path:			.com:2090/openemr/interface/main/calendar/
File:			add_edit_event.php
Param:			?startampm=1&starttimeh=8&starttimem=0&date=20100406&userid=[x]&catid=2

Path:			.com:2096/openemr/interface/patient_file/summary/
File:			pnotes_full.php
Param:			?offset=



References: 
http://xxx.com:2096/openemr/interface/main/calendar/add_edit_event.php?date=20100406&eid=[x]
http://xxx.com:2096/openemr/interface/patient_file/summary/immunizations.php?mode=edit&id=[x]
http://xxx.com:2096/openemr/interface/patient_file/summary/demographics.php?set_pid=[x]
http://xxx.com:2090/openemr/interface/patient_file/summary/pnotes_full.php?offset=[x]
http://xxx.com:2090/openemr/interface/main/calendar/add_edit_event.php?startampm=1&starttimeh=8&starttimem=0&date=20100406&userid=[x]&catid=2


Security Risk:
==============
The security risk of the multiple sql injection vulnerabilities are estimated as critical.


Credits & Authors:
==================
Vulnerability Research Laboratory


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