Ushahidi 2.0.1 (range param) SQL Injection Vulnerability (post-auth) 2011-06-03 11:15:03

Ushahidi 2.0.1 (range param) SQL Injection Vulnerability (post-auth)

Vendor: Ushahidi, Inc.
Product web page: http://www.ushahidi.com
Affected version: 2.0.1 (Tunis)

Summary: The Ushahidi Platform is a platform for information
collection, visualization and interactive mapping.

Desc: Input passed via the 'range' parameter to dashboard.php is
not properly sanitised in application/controllers/admin/dashboard.php
before being used in SQL queries. This can be exploited to manipulate
SQL queries by injecting arbitrary SQL code.


Lines: 103-112:
// Set the date range (how many days in the past from today?)
// default to one year
$range = (isset($_GET['range'])) ? $_GET['range'] : 365;

if(isset($_GET['range']) AND $_GET['range'] == 0)
$range = NULL;

$this->template->content->range = $range;

Tested on: Tested on: Microsoft Windows XP Professional SP3 (EN)
Apache 2.2.14 (Win32)
PHP 5.3.1
MySQL 5.1.41

Vulnerability discovered by Gjoko 'LiquidWorm' Krstic
liquidworm gmail com

Advisory ID: ZSL-2011-5016
Advisory URL: http://www.zeroscience.mk/en/vulnerabilities/ZSL-2011-5016.php

Vendor Advisory: http://dev.ushahidi.com/issues/show/2195