STEP 1: Breaking The Query: Let Me Try Out With Error Based Single Quote Injection Method
STEP 1: Breaking The Query: Let Me Try Out With Error Based Single Quote Injection Method
STEP 1: Breaking The Query: Let Me Try Out With Error Based Single Quote Injection Method
Let me try out with error based single quote injection method
http://leettime.net/sqlninja.com/tasks/basic_ch3.php?id=1′
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 table where id =”1″”
Now you can found out this is Double quote error based string injection.
Whatever malicious code placed will talk with database and as of now you have
successfully broken the query, joined the query and finally found out it is Double quote
error based string injection.
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.
Above Figure shows Database with error statement Unknown column ‘6’ in ‘order
clause and this error statement says as “There are only 5 columns in database”.
SQL backend may contain more Tables names with empty data also.Therefore You
should first able to find out which table names are present in this 5 columns.
Now we can select all 5 columns with union all select to existing URL
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
We already knew the location of table path, so will directly ask database name, version
etc
Group_concat() is the function 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.
The Above Figure shows the dump of all columns of tables contains id, username,
action,date
The Above Figure shows the dump of all user created dates in the database.HAPPY
HACKING !!!