Radexscript CMS 2.2.0 SQL Injection

`#Vulnerability title: Radexscript CMS 2.2.0 - SQL Injection vulnerability  
#Vendor: http://redaxscript.com/  
#Product: Radexscript CMS  
#Software link: http://redaxscript.com/download/releases  
#Affected version: Redaxscript 2.2.0  
#Fixed version: Redaxscript 2.3.0  
#CVE ID: CVE-2015-1518  
#Author: Pham Kien Cuong ([email protected]) & ITAS Team (www.itas.vn)  
  
  
  
:: PROOF OF CONCEPT ::  
  
POST /redaxscript/ HTTP/1.1  
Host: target.local  
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101  
Firefox/34.0  
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8  
Accept-Language: en-US,en;q=0.5  
Accept-Encoding: gzip, deflate  
Cookie: PHPSESSID=khtnnm1tvvk3s12if0no367872;  
GEAR=local-5422433b500446ead50002d4  
Connection: keep-alive  
Content-Type: application/x-www-form-urlencoded  
Content-Length: 96  
  
search_terms=[SQL INJECTION  
HERE]&search_post=&token=24bcb285bc6f5c93203e4f95d9f2008331faf294&search_pos  
t=Search  
  
  
  
- Vulnerable parameter: $search_terms  
- Vulnerable file: redaxscript/includes/search.php  
- Vulnerable function: search_post()  
  
- Vulnerable code:  
function search_post()  
{  
/* clean post */  
  
if (ATTACK_BLOCKED < 10)  
{  
$search_terms = clean($_POST['search_terms'], 5);  
}  
  
/* validate post */  
  
if (strlen($search_terms) < 3 || $search_terms == l('search_terms'))  
{  
$error = l('input_incorrect');  
}  
  
/* query results */  
  
else  
{  
$search = array_filter(explode(' ', $search_terms));  
$search_keys = array_keys($search);  
$last = end($search_keys);  
  
/* query search */  
  
$query = 'SELECT id, title, alias, description, date,  
category, access FROM ' . PREFIX . 'articles WHERE (language = \'' .  
Redaxscript\Registry::get('language') . '\' || language = \'\') && status =  
1';  
if ($search)  
{  
$query .= ' && (';  
foreach ($search as $key => $value)  
{  
  
$query .= 'title LIKE \'%' . $value . '%\'  
|| description LIKE \'%' . $value . '%\' || keywords LIKE \'%' . $value .  
'%\' || text LIKE \'%' . $value . '%\'';  
if ($last != $key)  
{  
$query .= ' || ';  
}  
}  
$query .= ')';  
}  
$query .= ' ORDER BY date DESC LIMIT 50';  
$result =  
Redaxscript\Db::forTablePrefix('articles')->rawQuery($query)->findArray();  
$num_rows = count($result);  
if ($result == '' || $num_rows == '')  
{  
$error = l('search_no');  
}  
  
/* collect output */  
  
else if ($result)  
{  
$accessValidator = new  
Redaxscript\Validator\Access();  
$output = '<h2 class="title_content  
title_search_result">' . l('search') . '</h2>';  
$output .= form_element('fieldset', '',  
'set_search_result', '', '', '<span class="title_content_sub  
title_search_result_sub">' . l('articles') . '</span>') . '<ol  
class="list_search_result">';  
foreach ($result as $r)  
{  
$access = $r['access'];  
  
/* if access granted */  
  
if ($accessValidator->validate($access,  
MY_GROUPS) === Redaxscript\Validator\Validator::PASSED)  
{  
if ($r)  
{  
foreach ($r as $key =>  
$value)  
{  
$$key =  
stripslashes($value);  
}  
}  
  
/* prepare metadata */  
  
if ($description == '')  
{  
$description = $title;  
}  
$date = date(s('date'),  
strtotime($date));  
  
/* build route */  
  
if ($category == 0)  
{  
$route = $alias;  
}  
else  
{  
$route =  
build_route('articles', $id);  
}  
  
/* collect item output */  
  
$output .= '<li  
class="item_search_result">' . anchor_element('internal', '',  
'link_search_result', $title, $route, $description) . '<span  
class="date_search_result">' . $date . '</span></li>';  
}  
else  
{  
$counter++;  
}  
}  
$output .= '</ol></fieldset>';  
  
/* handle access */  
  
if ($num_rows == $counter)  
{  
$error = l('access_no');  
}  
}  
}  
  
/* handle error */  
  
if ($error)  
{  
notification(l('something_wrong'), $error);  
}  
else  
{  
echo $output;  
}  
}  
  
  
:: SOLUTION ::  
Update to Redaxscript 2.3.0  
  
:: INFORMATION DISCLOSURE ::  
- 11/27/2014: Inform the vendor  
- 11/28/2014: Vendor confirmed  
- 01/29/2015: Vendor releases patch  
- 01/05/2015: ITAS Team publishes information  
  
  
:: REFERENCE ::  
-  
http://www.itas.vn/news/itas-team-found-out-a-sql-injection-vulnerability-in  
-redaxscript-2-2-0-cms-75.html  
  
::COPYRIGHT::  
Copyright (c) ITAS CORP 2014, All rights reserved worldwide. Permission is  
hereby granted for the electronic redistribution of this information. It is  
not to be edited or altered in any way without the express written consent  
of ITAS CORP (www.itas.vn).  
  
:: DISCLAIMER ::  
THE INFORMATION PRESENTED HEREIN ARE PROVIDED ?AS IS? WITHOUT WARRANTY OF  
ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO, ANY  
IMPLIED WARRANTIES AND MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE  
OR WARRANTIES OF QUALITY OR COMPLETENESS. THE INFORMATION PRESENTED HERE IS  
A SERVICE TO THE SECURITY COMMUNITY AND THE PRODUCT VENDORS. ANY APPLICATION  
OR DISTRIBUTION OF THIS INFORMATION CONSTITUTES ACCEPTANCE ACCEPTANCE AS IS,  
AND AT THE USER'S OWN RISK.  
  
  
  
Best Regards,  
----------------------------------------------------------------------------  
----------------  
ITAS Team (www.itas.vn)  
`