reddot-sql.txt

`RedDot CMS SQL injection vulnerability (CVE Number: CVE-2008-1613)  
  
http://www.irmplc.com/index.php/167-Advisory-026  
  
  
Vulnerability Type/Importance: SQL injection/Critical  
  
Problem Discovered: 12 February 2008  
Vendor Contacted: 19 February 2008  
Advisory Published: 21 April 2008  
  
  
Abstract:  
The RedDot CMS Product (http://www.reddot.com) is vulnerable to a pre-authentication SQL injection vulnerability which, when exploited, allows enumeration of all SQL database content.  
  
Description:  
The 'LngId' Parameter passed to IoRD.asp is responsible for assigning the language context for the CMS application. The vulnerability exists as a result of inadequate validation of user-supplied input within this parameter.  
  
  
Technical Details:  
Normal input for the 'LngId' parameter contains a code such as ENG, DEU, JP, denoting the language type. This parameter is not properly validated and the injection of SQL statements within it allows attackers unrestricted access to enumerate information from the database. For example:  
  
https://vulnerablehost.com:443/cms/ioRD.asp?Action=ShowMessage&LngId=ENG.DGC0 FROM IO_DGC_ENG UNION SELECT min(name) FROM SYSOBJECTS where xtype=char(85) and name> '' ORDER BY 1;-- &DisableAutoLogin=1  
  
Proof of Concept:  
A Proof of Concept (RDdbenum.py) has been developed to automate enumeration of entire database content available from http://www.irmplc.com/Tools/RDdbenum.py  
  
  
Workaround / Solutions:  
There are no known workarounds for this vulnerability  
The Vendor has released a patch for this vulnerability, Release 7.5.1.86, available from normal Red Dot customer support contacts.  
  
  
Tested / Affected Versions:  
IRM confirmed the presence of this vulnerability in RedDot CMS version 7.5 Build 7.5.0.48, tested with Microsoft SQL Server 2005 database.  
It is believed that this issue exists in RedDot CMS versions 6.5 and 7.0; however this has not been fully verified.  
  
  
Credits:  
Research and Advisory: Mark Crowther and Rodrigo Marcos  
  
  
Disclaimer:  
All information in this advisory is provided on an 'as is' basis in the hope that it will be useful. Information Risk Management Plc is not responsible for any risks or occurrences caused by the application of this information.  
  
`