Nmap mysql-enum NSE Script


This page contains detailed information about how to use the mysql-enum 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/mysql-enum.nse
Script categories: intrusive, brute
Target service / protocol: mysql
Target network port(s): 3306
List of CVEs: -

Script Description

The mysql-enum.nse script performs valid-user enumeration against MySQL server using a bug discovered and published by Kingcope (http://seclists.org/fulldisclosure/2012/Dec/9).

Server version 5.x are susceptible to an user enumeration attack due to different messages during login when using old authentication mechanism from versions 4.x and earlier.

Mysql-enum NSE Script Arguments

This is a full list of arguments supported by the mysql-enum.nse script:

mysql-enum.timeout

Socket timeout for connecting to MySQL (default 5s)

creds.global

Credentials to be returned by Credentials.getCredentials regardless of the service.

creds.[service]

Credentials to be returned by Credentials.getCredentials for [service]. E.g. creds.http=admin:password

passdb

The filename of an alternate password database. Default: nselib/data/passwords.lst

unpwdb.passlimit

The maximum number of passwords passwords will return (default unlimited).

unpwdb.timelimit

The maximum amount of time that any iterator will run before stopping. The value is in seconds by default and you can follow it with ms, s, m, or h for milliseconds, seconds, minutes, or hours. For example, unpwdb.timelimit=30m or unpwdb.timelimit=.5h for 30 minutes. The default depends on the timing template level (see the module description). Use the value 0 to disable the time limit.

unpwdb.userlimit

The maximum number of usernames usernames will return (default unlimited).

userdb

The filename of an alternate username database. Default: nselib/data/usernames.lst

brute.credfile

A file containing username and password pairs delimited by '/'

brute.delay

The number of seconds to wait between guesses (default: 0)

brute.emptypass

Guess an empty password for each user (default: false)

brute.firstonly

Stop guessing after first password is found (default: false)

brute.guesses

The number of guesses to perform against each account. (default: 0 (unlimited)). The argument can be used to prevent account lockouts.

brute.mode

Can be user, pass or creds and determines what mode to run the engine in.

  • user - the unpwdb library is used to guess passwords, every password Password is tried for each user. (The user iterator is in the outer loop)
  • pass - the unpwdb library is used to guess passwords, each password Is tried for every user. (The password iterator is in the outer loop)
  • creds - a set of credentials (username and password pairs) are Guessed against the service. This allows for lists of known or common username and password combinations to be tested. If no mode is specified and the script has not added any custom iterator the pass mode will be enabled.

brute.passonly

Iterate over passwords only for services that provide only a password for authentication. (default: false)

brute.retries

The number of times to retry if recoverable failures occur. (default: 2)

brute.start

The number of threads the engine will start with. (default: 5).

brute.threads

The number of initial worker threads, the number of active threads will be automatically adjusted.

brute.unique

Make sure that each password is only guessed once (default: true)

brute.useraspass

Guess the username as password for each user (default: true)

creds.[service]

Credentials to be returned by Credentials.getCredentials for [service]. E.g. creds.http=admin:password

- - -
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=mysql-enum --script-args mysql-enum.timeout=value,creds.global=value <target>

Mysql-enum NSE Script Example Usage

Here's an example of how to use the mysql-enum.nse script:

nmap --script=mysql-enum <target>

Mysql-enum NSE Script Example Output

Here's a sample output from the mysql-enum.nse script:

PORT     STATE SERVICE REASON
3306/tcp open  mysql   syn-ack
| mysql-enum:
|   Accounts
|     admin:<empty> - Valid credentials
|     test:<empty> - Valid credentials
|     test_mysql:<empty> - Valid credentials
|   Statistics
|_    Performed 11 guesses in 1 seconds, average tps: 11

Mysql-enum 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.

Author

  • Aleksandar Nikolic

References

See Also

Related NSE scripts to the mysql-enum.nse script:

Visit Nmap NSE Library for more scripts.

The mysql-enum.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.

Couldn't connect to host:

Here is a relevant code snippet related to the "Couldn't connect to host: " error message:

59:	  connect = function( self )
60:	    self.socket = nmap.new_socket()
61:	    local status, err = self.socket:connect(self.host, self.port)
62:	    self.socket:set_timeout(arg_timeout)
63:	    if(not(status)) then
64:	      return false, brute.Error:new( "Couldn't connect to host: " .. err )
65:	    end
66:	    return true
67:	  end,
68:	
69:	  login = function (self, user, pass) -- pass is actually the username we want to try

Incorrect username

Here is a relevant code snippet related to the "Incorrect username" error message:

80:	    local auth_string = stdnse.fromhex("0000018d00000000") .. pass .. stdnse.fromhex("00504e5f5155454d4500"); -- old authentication method
81:	    local err
82:	    status, err = self.socket:send(string.pack("b",#auth_string-3) .. auth_string) --send initial auth
83:	    status, response = self.socket:receive_bytes(0)
84:	    if not status then
85:	      return false,brute.Error:new( "Incorrect username" )
86:	    end
87:	    if string.find(response,"Access denied for user") == nil then
88:	      -- found it
89:	      return true, creds.Account:new( pass, nil, creds.State.VALID)
90:	    else

Incorrect username

Here is a relevant code snippet related to the "Incorrect username" error message:

86:	    end
87:	    if string.find(response,"Access denied for user") == nil then
88:	      -- found it
89:	      return true, creds.Account:new( pass, nil, creds.State.VALID)
90:	    else
91:	      return false,brute.Error:new( "Incorrect username" )
92:	    end
93:	  end,
94:	
95:	  disconnect = function( self )
96:	    self.socket:close()

Version

This page has been created based on Nmap version 7.92.

Go back to menu.