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

Do you need accurate and reliable IDS / IPS / AV detection rules?

Get in-depth vulnerability details:
http://secunia.com/binary_analysis/sample_analysis/

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

TITLE:
Ruby on Rails ":offset" and ":limit" SQL Injection Vulnerabilities

SECUNIA ADVISORY ID:
SA31875

VERIFY ADVISORY:
http://secunia.com/advisories/31875/

CRITICAL:
Moderately critical

IMPACT:
Manipulation of data

WHERE:
>From remote

SOFTWARE:
Ruby on Rails 2.1.x
http://secunia.com/advisories/product/19827/

DESCRIPTION:
Some vulnerabilities have been reported in Ruby on Rails, which can
be exploited by malicious people to conduct SQL injection attacks.

The vulnerabilities are caused due to Active Record not properly
sanitising the ":offset" and ":limit" parameters before using them in
SQL queries. This can be exploited to manipulate SQL queries by
injecting SQL code.

The vulnerabilities are reported in versions prior to 2.1.1.

SOLUTION:
Update to version 2.1.1.

PROVIDED AND/OR DISCOVERED BY:
Tobias Schlottke, additional research by Jonathan Weiss and Steven
Bristol.

ORIGINAL ADVISORY:
Jonathan Weiss:
http://blog.innerewut.de/2008/6/16/why-you-should-upgrade-to-rails-2-1

Ruby on Rails Ticker #288:
http://rails.lighthouseapp.com/projects/8994/tickets/288

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

About:
This Advisory was delivered by Secunia as a free service to help
everybody 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.

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