----------------------------------------------------------------------

Become a PSI 3.0 beta tester!
Test-drive the new beta version and tell us what you think about its extended automatic update function and significantly enhanced user-interface.
Download it here!
http://secunia.com/psi_30_beta_launch

----------------------------------------------------------------------

TITLE:
Ruby on Rails Nested Query Parameters SQL Injection Vulnerability

SECUNIA ADVISORY ID:
SA49457

VERIFY ADVISORY:
Secunia.com
http://secunia.com/advisories/49457/
Customer Area (Credentials Required)
https://ca.secunia.com/?page=viewadvisory&vuln_id=49457

RELEASE DATE:
2012-06-13

DISCUSS ADVISORY:
http://secunia.com/advisories/49457/#comments

AVAILABLE ON SITE AND IN CUSTOMER AREA:
 * Last Update
 * Popularity
 * Comments
 * Criticality Level
 * Impact
 * Where
 * Solution Status
 * Operating System / Software
 * CVE Reference(s)

http://secunia.com/advisories/49457/

ONLY AVAILABLE IN CUSTOMER AREA:
 * Authentication Level
 * Report Reliability
 * Secunia PoC
 * Secunia Analysis
 * Systems Affected
 * Approve Distribution
 * Remediation Status
 * Secunia CVSS Score
 * CVSS

https://ca.secunia.com/?page=viewadvisory&vuln_id=49457

ONLY AVAILABLE WITH SECUNIA CSI AND SECUNIA PSI:
 * AUTOMATED SCANNING

http://secunia.com/vulnerability_scanning/personal/
http://secunia.com/vulnerability_scanning/corporate/wsus_sccm_3rd_third_party_patching/

DESCRIPTION:
A vulnerability has been reported in Ruby on Rails, which can be
exploited by malicious people to conduct SQL injection attacks.

Input passed to the Active Record interface via nested query
parameters is not properly sanitised before being used in SQL
queries. This can be exploited to manipulate SQL queries by injecting
arbitrary SQL code.

NOTE: A weakness also exists in the parameter parsing of Rack when
using ActionPack and may allow the insertion of "IS NULL" where
clauses into SQL queries.

This is related to:
SA49297

SOLUTION:
Update to version 3.2.6, 3.1.6, or 3.0.14 or apply patch.

PROVIDED AND/OR DISCOVERED BY:
The vendor credits Ernie Miller, Gabriel Quadros, Takeshi Terada of
Mitsui Bussan Secure Directions, and Tomás D'Stefano.

ORIGINAL ADVISORY:
http://groups.google.com/group/rubyonrails-security/browse_thread/thread/9782f44c4540cf59
http://groups.google.com/group/rubyonrails-security/browse_thread/thread/8c82d9df8b401c5e

OTHER REFERENCES:
Further details available in Customer Area:
http://secunia.com/vulnerability_intelligence/

DEEP LINKS:
Further details available in Customer Area:
http://secunia.com/vulnerability_intelligence/

EXTENDED DESCRIPTION:
Further details available in Customer Area:
http://secunia.com/vulnerability_intelligence/

EXTENDED SOLUTION:
Further details available in Customer Area:
http://secunia.com/vulnerability_intelligence/

EXPLOIT:
Further details available in Customer Area:
http://secunia.com/vulnerability_intelligence/

----------------------------------------------------------------------

About:
This Advisory was delivered by Secunia as a free service to help
private users keeping their systems up to date against the latest
vulnerabilities.

Subscribe:
http://secunia.com/advisories/secunia_security_advisories/

Definitions: (Criticality, Where etc.)
http://secunia.com/advisories/about_secunia_advisories/


Please Note:
Secunia recommends that you verify all advisories you receive by
clicking the link.
Secunia NEVER sends attached files with advisories.
Secunia does not advise people to install third party patches, only
use those supplied by the vendor.

----------------------------------------------------------------------