SQL injection is a technique used to take advantage of non-validated input vulnerabilities to pass SQL commands through a Web application for execution by a backend database.

learn more… | top users | synonyms

0
votes
0answers
21 views

Adding conditions after LIMIT in MySQL

Is there any way to add any condition after LIMIT for example the OR or AND? I am wondering if we can add any query after LIMIT which returns nothing. for example the query is: SELECT * FROM table ...
147
votes
14answers
26k views

SQL injection is 17 years old. Why is it still around?

I'm no techie and would like your expertise in understanding this. I recently read a detailed article on SQLi for a research paper. It strikes me as odd. Why do so many data breaches still happen ...
0
votes
2answers
115 views

Can an SQL injection attack happen if the input is only allowed to be hexadecimal characters?

I've set up a login system that works more or less like this: 1) The user enters the data 2) The data is hashed locally using SHA256 (To reduce the risk of someone stealing the password through a ...
13
votes
2answers
3k views

Is the injection in a NoSQL database architecture also called SQL injection?

Is the injection in a NoSQL database architecture also called SQL injection and is it still part of the OWASP 2013 Top 10, category A1 Injection? For example an injection in code that communicates ...
16
votes
5answers
9k views

Would removing spaces in a string protect against SQL injection?

I was curious if it's possible to protect against an SQL injection attack by removing all spaces from an String input? I have been reading up on SQL Injection at OWASP, but they don't mention ...
3
votes
1answer
60 views

Blind SQL Injection using OOB DNS Practical Sniffing Help

I was looking at Excellent Article from Defcon 15's which was Data retrieval over DNS during SQL Injection Attacks. (https://www.youtube.com/watch?v=iQDw0hK_eFw). In this the speaker demonstrated the ...
-1
votes
0answers
97 views

How can a WHERE clause with an SQLi vulnerability be exploited?

We will assume that we have an SQL injection relative to: http://mysite.com/?id=3 We could also assume that DB system is MySQL. The SQL request could look like this well known example: SELECT * ...
0
votes
0answers
21 views

Is there a way to check a CGI SQL Injection using sqlmap?

I got this finding from Nessus: 51973 - CGI Generic SQL Injection (Parameters Names) And the correspondent GET request: https://myhost/folder/b?'+convert(int,convert(varchar,0x7b5d))+'=1 As you ...
4
votes
1answer
119 views

Exploiting MD5/Salt Vulnerability in this PHP form?

I've been practicing security-related subjects and this challenge has befuddled me. Note: I can't access any PHP source code, nor can I edit it. I'm only able to view it. The following is given: I ...
5
votes
1answer
76 views

PHP SQL Injection Vulnerability In UPDATE Statements

Take the following SQL query as an example: UPDATE `sqlinjection2` SET `$vote`=`$vote`+1 Our goal is to increment the vote count by more than one, in one request. We cannot access the code itself. ...
4
votes
2answers
137 views

Is this PHP code vulnerable SQL injection?

Im given control over the $vote variable (in the "challenge" function) Is there any way to sql inject the query? (BTW I can see/read whatever the challenge function returns e.g. the sql errors. I ...
-4
votes
0answers
46 views

How do I report if I find a security exploit? [duplicate]

A while ago I found a pretty bad SQLi in a phpMyAdmin in a site and I dont know how to report it without risking my self. Any ideas?
0
votes
0answers
25 views

SQLite table discovery by injection

Background: Simple SQL Injection For an injection exercise i need to get the password of a person out of a database. I've got one input field which accepts most of the chars (expect from ',", OR, ...
1
vote
2answers
81 views

Simple SQL Injection

I'm training my SQLInjection knowledge on a training tool made by my university. In a certain lvl there is this simple product viewer which gets a row based on a id. So the query should me something ...
-4
votes
1answer
82 views

Safest SQL database [closed]

I am going to run a Tor Hidden Service on a Linux server. My site will have an SQL database. This DB contains user login, and a few other basic details. If it makes a difference depending on the ...
0
votes
0answers
68 views

SQL injection in find_by Active Record RoR 4

I was trying to understand the possibility of SQLi in a Rails Application, that I am currently auditing for a client, that uses Active Record 4.2.0. Now, I have limited experience with RoR so please ...
0
votes
1answer
58 views

Detecting datasets that were affected by SQL injection

Assuming that I know that one of my applications was attacked by an SQL injection, how can I identify edited or selected data sets? On obvious source are webserver logs. This should allow us to ...
0
votes
0answers
74 views

What does this injected query achieve?

On this very good link you can see some SQL injection expressions for MySQL. Quick Detection Error Based SQLi For integer inputs: (select 1 and row(1,1)>(select count(*),concat(...
6
votes
4answers
337 views

Why is using SQL injection to extract passwords or password hashes from a login database (that should never legitimately disclose them) even possible?

(Okay, so I'll confess upfront that while I'm trying to educate myself the current state of my knowledge on web applications security is still pretty shallow. So I appreciate your patience if the way ...
1
vote
1answer
44 views

SQLi with comment filter: dumping the database

The following SQLi (MySQL) filter is from SQLi-Labs: ... $reg = "/#/" $reg1 ="/--/" $replace ="" $id=preg_replace($reg,$replace,$id); $id=preg_replace($reg1,$replace,$id); .... $sql = "SELECT *...
6
votes
2answers
219 views

What's the best way to test for SQL Injection vulnerabilities? Manual or SQLMap?

As part of my job I test for web application vulnerabilities regularly. When it comes to SQL Injection, my methodology is to start by manually browsing the website and spidering it, then, sending the ...
2
votes
2answers
103 views

Explaining information leak to Lead dev

Our lead dev tells me that this information leak from our website is "no vulnerability. Just an ugly error UI." It looks to me that the leaked information could be used to aid an attack. Does it ...
0
votes
1answer
44 views

mySQL into outfile strange behaviour

I have sql-injection with file_priv=Y (root user) but I can only create file in /tmp and /var/tmp directories even when i have 777 permissions to destination folder - mysql server just won't create ...
0
votes
1answer
113 views

What SQL payloads can be injected for a numeric field?

I have a parameter (pi_apk_version_code) that seems to be vulnerable to SQL Injection (the team is divided on this). The database column corresponding to this parameter accepts only numeric values. ...
1
vote
1answer
60 views

Does fuzz testing produce different output compared to manual testing?

I am testing an API and one parameter is vulnerable to SQL injection. When I run OWASP ZAP's fuzzer on this parameter, the input "; or 1=1" results in a successful exploit of SQL injection. However, ...
1
vote
0answers
74 views

Dumping Large table using Sqlmap

I am learning/working on sqlmap and I was trying to dump a large table with 11K entries on my localhost. The command I used is: python sqlmap.py -u "http://localhost/searchre.php" --data="search=' ...
0
votes
1answer
53 views

sqlmap not finding a proven vulnerability

I'm testing a wordpress site with the jetpack plugin installed. According to: https://www.exploit-db.com/exploits/18126/ this plugin should be vulnerable to SQL injection (found with sqlmap) but when ...
0
votes
0answers
20 views

Can someone provide some examples of boolean based SQLi tests?

I've seen tests ' or 1=1-- or ' and '1'='1. I was looking for some more boolean based tests. One of the sites I'm testing has WAF blocking a lot of tests, but simple boolean tests, like above, have ...
0
votes
1answer
35 views

Getting Operating System Username using MySQL SQLi

Suppose I have a website which has SQL injection vulnerability and I got the database schema etc. Is there any means by which I can get the operating system username or the SSH username? Asking from ...
-6
votes
2answers
143 views

SQL injection using only Scala syntax?

Is there a way to perform an SQL injection using only Scala syntax (not importing any Java)? From what I've seen online all the examples (like this) were based on importing Java things and then using ...
2
votes
3answers
69 views

SQLMap deleted database items

While doing test on my website, SQLMap deleted data in my database tables. Everything is corrupt. What is a safe way of using this tool without touching other items on a live server? How do you use ...
0
votes
0answers
54 views

MySQL SQL Injection - Get User Password

I've used SQLMAP to check for SQL injection. I've managed to retrieve the name of just one database (dbInfo) However, using SQLMAP I can't enumerate anything else - where it is tables within the DB ...
6
votes
4answers
102 views

How can releasing the text of an SQL query compromise security?

I have asked a government agency, under Freedom of Information legislation, to release two SQL queries they ran to produce a table which they published in a report. That is, the agency published ...
0
votes
3answers
84 views

Is it a good idea to let a database do a password check?

Setup A server running a PostgreSQL database and an Apache with several php applications. Access to db is over the loopback interface. The db contains a table with the username and SHA-512-CRYPT ...
0
votes
1answer
118 views

Dumping custom query via SQL injection when output is in the die() function?

On my localhost I have a PHP link like this abc.com/index.php?q=XYZ where XYZ is a base64encoded parameter that I have verified is injectable. When I try abc.com/index.php?q=XYZ' it returns You ...
1
vote
1answer
36 views

How to extract data from hackyourself legal site with table and column information?

I am following the Pluralsight SQL injection tutorial. The instructor did not go over actually extracting the data. http://hackyourselffirst.troyhunt.com/CarsByCylinders?Cylinders=V12'AND 1=(SELECT ...
2
votes
1answer
137 views

SQL injection vulnerability when using prepared statements in PHP

I've been studying prepared statements and implemented it in my first login. I used a prepared statement for the SQL query and am wondering if this is enough to ward off most SQL injections? Since ...
0
votes
1answer
120 views

Can there still be SQL injection when storing the password as a hash?

Could there be any SQL injection vulnerability in the code below since it only queries the database for username and bcrypt hash? Would the vulnerability of this code be more on the bcrypt hashing ...
-5
votes
1answer
131 views

What is the most secure database? [closed]

I need to learn about database systems, but first I need to know which is the safest. For example, information like government data need to be protected, so what is the best database to handle this ...
1
vote
1answer
128 views

Bypassing login with SQL Injection

I'm learning about SQL Injection, and I'm playing around on my local machine with vulnerable web application, which has login form. How the login mechanism works is that it first searches whether ...
0
votes
0answers
37 views

Oracle PL/SQL SQL Injection Test from Unicode to Windows-1252

I have a DB using windows-1252 character encoding and dynamic SQL that does simple single quote escaping like this... l_str := REPLACE(TRIM(someUserInput),'''',''''''); Because the DB is windows-...
1
vote
0answers
28 views

Error based SQLi, i don't understand this SQL statement [duplicate]

I'm trying to validate a challenge on Error-based SQL injection: and there is this SQL statement in the documentation which procude an error, but i really don't see why (also i'm not sure to ...
1
vote
1answer
160 views

How make SQL select query without comma? [closed]

I am trying SQLi and comma was filtered there. How make SELECT SQL request without a comma?
3
votes
1answer
107 views

SQL injection: insert data from Get request

I am using the vulnerable web app mutillidae. There is a webpage where you can view information from a profile but you first need to provide a user and a password. Once you click send, it sends it to ...
0
votes
0answers
44 views

sqlmap receiving corrupt/garbage data for password column only

sqlmap is receiving corrupt/garbage data for the password column. The rest of the columns extract just fine. Example: Đ\x9eđ\x98Ú I did a bit of research and a few people have experienced the ...
1
vote
2answers
134 views

Is my code using mysqli_real_escape_string and quotes100% safe against SQL Injection?

My code is: SELECT * FROM tlb_members WHERE username="{mysqli_real_escape_string($_GET['test'])}" I'm searching and some people said using quotes in SQL statements is safe. Is this true?
0
votes
1answer
172 views

Sqlmap doesn't exploit verified SQL injection

Right now I'm tinkering with the Hackxor VM (a pentesting training enviroment) and I'm trying to use sqlmap to exploit a vulnerability which I can exploit manually. The vulnerability is in the ...
3
votes
1answer
86 views

Why is this SQL Injection attempt failing on DVWA?

I'm practicing SQL injection on DVWA (non-blind) with the lowest security settings. I want to list the tables in the current database. To do that, I attempt to enter 0'; show tables;-- in the User ID ...
0
votes
2answers
35 views

How to protect data of users in multi-user site?

I am working on a system where people can make their accounts with few things being stored in database like id (that will be auto increment), first name, last name, username etc. Now I am well aware ...
1
vote
0answers
53 views

Open source tool to test a WAF against OWASP Top 10? [closed]

Are there any open source tools to test a WAF against OWASP Top 10? Especially I am looking for a tool that tests a WAF against different types of attacks & reports test results.