Ruby on Rails ActiveRecord SQL injection

rubyonrails-activerecord-sql-injection (45109) The risk level is classified as MediumMedium Risk

Description:

Ruby on Rails is vulnerable to SQL injection. A remote attacker could send specially-crafted SQL statements to ActiveRecord using the ":offset" or ":limit" parameter, which could allow the attacker to view, add, modify or delete information in the back-end database.

*CVSS:

Base Score: 7.5
  Access Vector: Network
  Access Complexity: Low
  Authentication: None
  Confidentiality Impact: Partial
  Integrity Impact: Partial
  Availability Impact: Partial
 
Temporal Score: 6.5
  Exploitability: High
  Remediation Level: Official-Fix
  Report Confidence: Confirmed

Consequences:

Data Manipulation

Remedy:

Upgrade to the latest version of Ruby on Rails (2.1.1 or later), available from the Ruby on Rails Web site. See References.

References:

  • BlogFish, 2008/6/16: Why you should upgrade to Rails 2.1.
  • Ruby on Rails Ticket #288: [patch] - SQL Injection for :limit and :offset .
  • Ruby on Rails Ticket #964: Fix for SQL injection on :limit and :offset should be backported .
  • Ruby on Rails Web site: Ruby on Rails.
  • BID-31176: Ruby on Rails ':offset' And ':limit' Parameters SQL Injection Vulnerabilities
  • CVE-2008-4094: Multiple SQL injection vulnerabilities in Ruby on Rails before 2.1.1 allow remote attackers to execute arbitrary SQL commands via the (1) :limit and (2) :offset parameters, related to ActiveRecord, ActiveSupport, ActiveResource, ActionPack, and ActionMailer.
  • GLSA-200912-02: Ruby on Rails: Multiple vulnerabilities
  • OSVDB ID: 48150: Ruby on Rails Active Record :offset / :limit Parameter SQL Injection
  • SA31875: Ruby on Rails ":offset" and ":limit" SQL Injection Vulnerabilities
  • SA31909: Ruby on Rails ":offset" and ":limit" SQL Injection Vulnerabilities
  • SA31910: Ruby on Rails ":offset" and ":limit" SQL Injection Vulnerabilities
  • SECTRACK ID: 1020871: Ruby on Rails Input Validation Flaw in ':limit' and ':offset' Parameters Lets Remote Users Inject SQL Commands
  • SUSE-SR:2008:027: SUSE Security Summary Report

Platforms Affected:

  • Gentoo Linux
  • Ruby on Rails Ruby on Rails 1.1.0
  • Ruby on Rails Ruby on Rails 1.1.1
  • Ruby on Rails Ruby on Rails 1.1.2
  • Ruby on Rails Ruby on Rails 1.1.4
  • Ruby on Rails Ruby on Rails 1.1.5
  • Ruby on Rails Ruby on Rails 1.2.3
  • Ruby on Rails Ruby on Rails 1.2.4
  • Ruby on Rails Ruby on Rails 1.2.5
  • Ruby on Rails Ruby on Rails 1.2.6
  • Ruby on Rails Ruby on Rails 2.0.0 rc1
  • Ruby on Rails Ruby on Rails 2.0.0 rc2
  • Ruby on Rails Ruby on Rails 2.0.0
  • Ruby on Rails Ruby on Rails 2.0.2
  • Ruby on Rails Ruby on Rails 2.0.4
  • Ruby on Rails Ruby on Rails 2.1

Reported:

Jun 16, 2008

The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall the author/distributor (IBM Internet Security Systems X-Force) be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.

For corrections or additions please email ignore thisxforceignore this@ignore thisus.ignore thisibm.comignore this

Return to the main page

* According to the Forum of Incident Response and Security Teams (FIRST), the Common Vulnerability Scoring System (CVSS) is an "industry open standard designed to convey vulnerability severity and help to determine urgency and priority of response." IBM PROVIDES THE CVSS SCORES "AS IS" WITHOUT WARRANTY OF ANY KIND, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. CUSTOMERS ARE RESPONSIBLE FOR ASSESSING THE IMPACT OF ANY ACTUAL OR POTENTIAL SECURITY VULNERABILITY.
The information within this database may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties, implied or otherwise, with regard to this information or its use. Any use of this information is at the user's risk. In no event shall IBM be held liable for any damages whatsoever arising out of or in connection with the use or spread of this information.

About IBM Security Systems

IBM Security Systems include an extensive portfolio of hardware, software solutions, professional and managed services offerings covering the spectrum of IT and business security risks: people and identity, data and information, application and process, network, server and endpoint and physical infrastructure, empowering clients to innovate and operate their businesses on the most secure infrastructure platforms. Through world-class solutions that address risk across the enterprise, IBM helps organizations build a strong security posture that helps reduce costs, improve service, and manage risk. IBM X-Force(R) Research and Development is one of the most renowned commercial security research and development groups in the world. For more information on how to address today's biggest risks, please visit us at ibm.com/security.