Nmap http-sql-injection NSE Script


This page contains detailed information about how to use the http-sql-injection NSE script. For list of all NSE scripts, visit the Nmap NSE Library.

Select:
Overview
Error Messages

Script Overview

Script source code: https://github.com/nmap/nmap/tree/master/scripts/http-sql-injection.nse
Script categories: intrusive, vuln
Target service / protocol: http, https
Target network port(s): 80, 443
List of CVEs: -

Script Description

The http-sql-injection.nse script spiders an HTTP server looking for URLs containing queries vulnerable to an SQL injection attack. It also extracts forms from found websites and tries to identify fields that are vulnerable.

The script spiders an HTTP server looking for URLs containing queries. It then proceeds to combine crafted SQL commands with susceptible URLs in order to obtain errors. The errors are analysed to see if the URL is vulnerable to attack. This uses the most basic form of SQL injection but anything more complicated is better suited to a standalone tool.

We may not have access to the target web server's true hostname, which can prevent access to virtually hosted sites.

Http-sql-injection NSE Script Arguments

This is a full list of arguments supported by the http-sql-injection.nse script:

http-sql-injection.errorstrings

A path to a file containing the error strings to search for (one per line, lines started with # are treated as comments). The default file is nselib/data/http-sql-errors.lst which was taken from fuzzdb project, for more info, see http://code.google.com/p/fuzzdb/. If someone detects some strings in that file causing a lot of false positives, then please report them to [email protected].

http-sql-injection.maxpagecount

The maximum amount of pages to visit. A negative value disables the limit (default: 20)

http-sql-injection.url

The url to start spidering. This is a URL relative to the scanned host eg. /default.html (default: /)

http-sql-injection.withindomain

Only spider URLs within the same domain. This widens the scope from withinhost and can not be used in combination. (default: false)

http-sql-injection.withinhost

Only spider URLs within the same host. (default: true)

smbdomain

The domain to log in with. If you aren't in a domain environment, then anything will (should?) be accepted by the server.

smbhash

A password hash to use when logging in. This is given as a single hex string (32 characters) or a pair of hex strings (both 32 characters, optionally separated by a single character). These hashes are the LanMan or NTLM hash of the user's password, and are stored on disk or in memory. They can be retrieved from memory using the fgdump or pwdump tools.

smbnoguest

Use to disable usage of the 'guest' account.

smbpassword

The password to connect with. Be cautious with this, since some servers will lock accounts if the incorrect password is given. Although it's rare that the Administrator account can be locked out, in the off chance that it can, you could get yourself in trouble. To use a blank password, leave this parameter off altogether.

smbtype

The type of SMB authentication to use. These are the possible options:

  • v1: Sends LMv1 and NTLMv1.
  • LMv1: Sends LMv1 only.
  • NTLMv1: Sends NTLMv1 only (default).
  • v2: Sends LMv2 and NTLMv2.
  • LMv2: Sends LMv2 only.
  • NTLMv2: Doesn't exist; the protocol doesn't support NTLMv2 alone. The default, NTLMv1, is a pretty decent compromise between security and compatibility. If you are paranoid, you might want to use v2 or lmv2 for this. (Actually, if you're paranoid, you should be avoiding this protocol altogether!). If you're using an extremely old system, you might need to set this to v1 or lm, which are less secure but more compatible. For information, see smbauth.lua.

smbusername

The SMB username to log in with. The forms "DOMAIN\username" and "username@DOMAIN" are not understood. To set a domain, use the smbdomain argument.

slaxml.debug

Debug level at which default callbacks will print detailed parsing info. Default: 3

http.host

The value to use in the Host header of all requests unless otherwise set. By default, the Host header uses the output of stdnse.get_hostname().

http.max-body-size

Limit the received body to specific number of bytes. An oversized body results in an error unless script argument http.truncated-ok or request option truncated_ok is set to true. The default is 2097152 (2MB). Use value -1 to disable the limit altogether. This argument can be overridden case-by-case with request option max_body_size.

http.max-cache-size

The maximum memory size (in bytes) of the cache.

http.max-pipeline

If set, it represents the number of outstanding HTTP requests that should be sent together in a single burst. Defaults to http.pipeline (if set), or to what function get_pipeline_limit returns.

http.pipeline

If set, it represents the number of HTTP requests that'll be sent on one connection. This can be set low to make debugging easier, or it can be set high to test how a server reacts (its chosen max is ignored).

http.truncated-ok

Do not treat oversized body as error. (Use response object flag truncated to check if the returned body has been truncated.) This argument can be overridden case-by-case with request option truncated_ok.

http.useragent

The value of the User-Agent header field sent with requests. By default it is "Mozilla/5.0 (compatible; Nmap Scripting Engine; https://nmap.org/book/nse.html)". A value of the empty string disables sending the User-Agent header field.

- - -
To use these script arguments, add them to the Nmap command line using the --script-args arg1=value,[arg2=value,..] syntax. For example:

nmap --script=http-sql-injection --script-args http-sql-injection.errorstrings=value,http-sql-injection.maxpagecount=value <target>

Http-sql-injection NSE Script Example Usage

Here's an example of how to use the http-sql-injection.nse script:

nmap --script=http-sql-injection <target>

Http-sql-injection NSE Script Example Output

Here's a sample output from the http-sql-injection.nse script:

PORT   STATE SERVICE
80/tcp open  http    syn-ack
| http-sql-injection:
|   Possible sqli for queries:
|     http://foo.pl/forms/page.php?param=13'%20OR%20sqlspider
|   Possible sqli for forms:
|     Form at path: /forms/f1.html, form's action: a1/check1.php. Fields that might be vulnerable:
|       f1text
|     Form at path: /forms/a1/../f2.html, form's action: a1/check2.php. Fields that might be vulnerable:
|_      f2text

Http-sql-injection NSE Script Example XML Output

There is no sample XML output for this module. However, by providing the -oX <file> option, Nmap will produce a XML output and save it in the file.xml file.

Authors

  • Eddie Bell
  • Piotr Olma

References

See Also

Visit Nmap NSE Library for more scripts.

The http-sql-injection.nse script may fail with the following error messages. Check for the possible causes by using the code snippets highlighted below found in the script source code. This can often times help in identifying the root cause of the problem.

error string matched: %s

Here is a relevant code snippet related to the "error string matched: %s" error message:

78:	  end
79:	
80:	  if errorstrings then
81:	    for _,e in ipairs(errorstrings) do
82:	      if string.find(body, e) then
83:	        stdnse.debug2("error string matched: %s", e)
84:	        return true
85:	      end
86:	    end
87:	  end
88:	  return false

invalid query", "sql syntax", "odbc drivers error

Here is a relevant code snippet related to the "invalid query", "sql syntax", "odbc drivers error" error message:

219:	    end
220:	  end
221:	  -- check if we loaded something
222:	  if #errorstrings == 0 then
223:	    -- if not, then load some default values
224:	    errorstrings = {"invalid query", "sql syntax", "odbc drivers error"}
225:	  end
226:	end
227:	
228:	action = function(host, port)
229:	  local error_strings_path = stdnse.get_script_args('http-sql-injection.errorstrings') or 'nselib/data/http-sql-errors.lst'

http-sql-injection.errorstrings') or 'nselib/data/http-sql-errors.lst

Here is a relevant code snippet related to the "http-sql-injection.errorstrings') or 'nselib/data/http-sql-errors.lst" error message:

224:	    errorstrings = {"invalid query", "sql syntax", "odbc drivers error"}
225:	  end
226:	end
227:	
228:	action = function(host, port)
229:	  local error_strings_path = stdnse.get_script_args('http-sql-injection.errorstrings') or 'nselib/data/http-sql-errors.lst'
230:	  get_error_strings(error_strings_path)
231:	  -- crawl to find injectable urls
232:	  local crawler = httpspider.Crawler:new(host, port, nil, {scriptname = SCRIPT_NAME})
233:	  local injectable = {}
234:	  local results_forms = {name="Possible sqli for forms:"}

Version

This page has been created based on Nmap version 7.92.

Go back to menu.