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

Install Nessus from docker

Docker installation. Give the below commands one by one. apt install docker-cli or apt install docker.io After the installation is complete, if you are inside wsl then give this command to start docker, because inside wsl systemd (systemctl) does not work: service docker start WSL troubleshooting : If the above command " service docker start " does not work then use below command: dockerd (It may not work if any previous docker process is running. It will show you pid of that process. Use this command to kill that process " kill -9 pid " and run dockerd command again) If " docker ps -a " giving error like " Cannot connect to the Docker daemon at unix:///run/podman/podman.sock. Is the docker daemon running? " This is because you may installed podman-docker package. If you remove the package still you will get this error but you should remove the package. Then issue this command: env | grep -i docker DOCKER_HOST=unix:///run/podman/podman.sock   --...
Post a Comment
Read more

Installing kansa incident response tool

 Kansa is an IR framework. https://github.com/davehull/Kansa For enterprise data collection, you need to do this first from the admin system: Set-NetConnectionProfile -NetworkCategory Private (In private network) Enable-PSRemoting  from powershell on the system where you want to run this tool. This will enable winrm service with port 5985 and 5986. Check: netstat -naob | findstr "5985"   Also allow tcp port 5985 and 5986 for winrm through the network. You can use  GPO. Though winrm is communicating over http and https but authentication will be happened using kerberos in domain environment.  After downloading it  from the github and unzip it, you need to unlock it using powershell. Need powershell v3 or later. ls -r *.ps1 | Unblock-File Powershell policy bypass: Set-ExecutionPolicy AllSigned | RemoteSigned | Unrestricted From FOR508 course: .\kansa.ps1 -OutputPath .\Output\ -TargetList .\hostlist -TargetCount 250 -Verbose -Pushbin -Pushbin is requir...
Post a Comment
Read more