Monday, March 4, 2024

How to Perform Manual SQL Injection With Double Quotes Error-Based String Method

If you are trying to hack the databases with methods like single quotes error-based Manual SQL Injection, Integer based injection but the databases are not vulnerable to those methods injection will fail and you cannot connect with the database.

In short, the error-based SQL injection will use a single quote to break the query and join the query, and Integer based injection will be joining the query without the single quote.

So Today we are about to learn another method which is double-quote injection in the MySQL database.

SQL Injection ONLINE LAB:

  • Beginners can use this website to practice skills for SQL injection
  • To Access the LAB Click Here.

STEP 1: Breaking the Query

  • Let me try out with error based single quote injection method http://leettime.net/sqlninja.com/tasks/basic_ch3.php?id=1′ 
  • The above figure shows the single quote error based on not working.
  • The above figure shows integer based method is also not working.
  • The above figure shows double quotes are breaking the database so it’s vulnerable to SQL injection

STEP 2: Copying the Error Statement

  • Copy and Paste the SQL Error statement into Notepad.
  • The above figure shows that Highlighted double quotes are breaking the backend database
  • When we add double quotes which are mismatching the query like this Select username, Password from the table where id =”1″”
  • Now you can find out this is a Double quote error-based string injection.

STEP 3: Joining the Query

  • Let us add  –+  to join the query http://leettime.net/sqlninja.com/tasks/basic_ch3.php?id=1″ –+
  • The above figure illustrates SQL errors are fixed with –+
  • Whatever malicious code is placed will talk with the database and as of now you have successfully broken the query, joined the query, and finally found out it is a Double quote error-based string injection.

STEP 4: Finding the Backend Columns

  • It is time to have a conversation with the database to find the number of columns. To enumerate columns we can use order by command.
  • The above Figure shows the Database with the error statement Unknown column ‘6’ in ‘the order clause and this error statement says as “There are only 5 columns in the database”.

STEP 5: Finding the Backend Tables

  • SQL backend may contain more Tables names with empty data also. Therefore You should first be able to find out which table names are present in these 5 columns.
  • Now we can select all 5 columns with union all select to existing URL
  • The above Illustrated Figure shows Username is: 2 as the value which represents table names is present in the 2nd column of the database. Now we have successfully found out the table location in Database

STEP 6: Finding the Backend Table Names

  • We already knew the location of the table path, so will directly ask database name, version, etc
  • The above figures show the database name as leettime_761wHole
  • The above figures show the database version as 5.6.36-cll-lve

STEP 7: Dumping Database Tables

  • Group_concat() is the function that returns a string with the concatenated non-NULL value from a group.
  • So we can use this Function to list all Tables from the database.
  • In Addition, we can use Information_Schema to view metadata about the objects within a database.
  • The Above Figure shows the dump of all tables as testtable1, userlogs, users.

STEP 8: Dumping all Data in Columns of Tables

  • We can dump userlogs
SQL Injection
  • The Above Figure shows the dump of all columns of tables containing id, username, action, date

STEP 9: Dumping all Usernames

  • Here we can dump all usernames in the database.
SQL Injection
  • The Above Figure shows the dump of all usernames Zen, Inj3ct0r, Zenodermus, decompiler

STEP 10: Dumping all Date

  • Now we can dump all date
SQL Injection
SQL Injection
  • The Above Figure shows the dump of all user-created dates in the database. HAPPY HACKING !!!
Website

Latest articles

US Court Orders NSO Group to Handover Code for Spyware, Pegasus to WhatsApp

Meta, the company that owns WhatsApp, filed a lawsuit against NSO Group in 2019....

New SSO-Based Phishing Attack Trick Users into Sharing Login Credentials  

Threat actors employ phishing scams to trick individuals into giving away important details like...

U.S. Charged Iranian Hacker, Rewards up to $10 Million

The United States Department of Justice (DoJ) has charged an Iranian national, Alireza Shafie...

Huge Surge in Ransomware-as-a-Service Attacks targeting Middle East & Africa

The Middle East and Africa (MEA) region has witnessed a surge in ransomware-as-a-service (RaaS)...

New Silver SAML Attack Let Attackers Forge Any SAML Response To Entra ID

SolarWinds cyberattack was one of the largest attacks of the century in which attackers...

AI Worm Developed by Researchers Spreads Automatically Between AI Agents

Researchers have developed what they claim to be one of the first generative AI...

20 Million+ Cutout.Pro User Records Leaked On Hacking Forums

CutOut.Pro, an AI-powered photo and video editing platform, has reportedly suffered a data breach,...

Live Account Takeover Attack Simulation

Live Account Take Over Attack

Live Webinar on How do hackers bypass 2FA ,Detecting ATO attacks, A demo of credential stuffing, brute force and session jacking-based ATO attacks, Identifying attacks with behaviour-based analysis and Building custom protection for applications and APIs.

Related Articles