Red Hat has released an additional security advisory and updated packages to address the Ruby on Rails active record SQL command execution vulnerability.
Ruby on Rails contains a vulnerability that could allow an unauthenticated, remote attacker to execute limited SQL commands on a targeted system.
The vulnerability is due to insufficient sanitization of user-supplied input by the affected software. An unauthenticated, remote attacker could exploit this vulnerability by sending malicious requests to the affected software. If successful, the attacker could execute SQL queries on the system.
Ruby on Rails has confirmed the vulnerability and released updated software.
Ruby on Rails versions prior to 3.2.6, prior to 3.1.6, and prior to 3.0.14 are vulnerable.
To exploit this vulnerability, the attacker would need to identify an application that uses Active Record to accept user input and issue SQL commands to an underlying database. By submitting malicious input to the vulnerable application, the attacker could cause the application to issue SQL queries to the targeted system. If successful, the attacker could cause the database to return confidential records, possibly resulting in information disclosure.
Depending on the targeted system, the attacker would need to have access to trusted, internal networks. This access requirement decreases the likelihood of a successful exploit.
Ruby on Rails has issued a release summary at the following link: CVE-2012-2694
An unauthenticated, remote attacker could exploit the vulnerability to execute limited SQL commands against the underlying database to gain access to sensitive information.
The vulnerability is due to insufficient sanitization of user-supplied input by the Active Record component. Active Record fails to properly check parameters within requests that contain IS NULL values.
An unauthenticated, remote attacker could exploit this vulnerability by submitting malicious SQL queries with "IS NULL" where clauses through an affected application that uses Ruby to a database underlying the application. The processing of such queries could allow the attacker to bypass authentication and issue limited SQL queries to the underlying database.
Administrators are advised to apply the appropriate updates.
Administrators may consider using IP-based access control lists (ACLs) to allow only trusted systems to access the affected systems.
Administrators are advised to monitor affected systems.
Ruby on Rails has released updated software at the following links: 3.2.6 , 3.1.6 , and 3.0.14
Red Hat has released updated software for registered subscribers at the following link: Red Hat Network. Red Hat packages can be updated on Red Hat Enterprise Linux versions 5 and later using the yum tool.
Version 3, January 11, 2013, 8:16 AM: Red Hat has released an additional security advisory and updated packages to address the Ruby on Rails active record SQL command execution vulnerability.
Version 2, December 5, 2012,7:35 AM: Red Hat has released a security advisory and updated packages to address the Ruby on Rails active record SQL command execution vulnerability.
Version 1, June 15, 2012, 6:31 AM: Ruby on Rails contains a vulnerability that could allow an unauthenticated, remote attacker to execute limited SQL commands on a targeted system. Updates are available.
Alerts and bulletins on the Cisco Security Intelligence Operations Portal are highlighted by analysts in the
Cisco Threat Operations Center and represent a subset of the comprehensive content that is available through Cisco Security IntelliShield Alert Manager Service.
This customizable threat and vulnerability alert service provides security staff with access to timely, accurate, and credible information about threats and vulnerabilities that may affect their environment.
The urgency and severity ratings of this alert are not tailored to individual users; users may value alerts differently based upon their network configurations and circumstances. THE ALERT, AND INFORMATION CONTAINED THEREIN, ARE PROVIDED ON AN "AS IS" BASIS AND DO NOT IMPLY ANY KIND OF GUARANTEE OR WARRANTY, INCLUDING THE WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR USE. YOUR USE OF THE ALERT, AND INFORMATION CONTAINED THEREIN, OR MATERIALS LINKED FROM THE ALERT, IS AT YOUR OWN RISK. INFORMATION IN THIS ALERT AND ANY RELATED COMMUNICATIONS IS BASED ON OUR KNOWLEDGE AT THE TIME OF PUBLICATION AND IS SUBJECT TO CHANGE WITHOUT NOTICE. CISCO RESERVES THE RIGHT TO CHANGE OR UPDATE ALERTS AT ANY TIME.