$ cat writeup.md…
$ cat writeup.md…
sunshinectf2026
Task: web app with planet lookup returning boolean signal (carrier/null), injectable SQL WHERE clause on PostgreSQL. Solution: blind boolean SQLi confirms PostgreSQL with stacked queries; probe user has pg_execute_server_program role enabling COPY TO PROGRAM for OS command execution; exfiltrate /flag.txt via OOB curl to webhook.
$ cat /etc/rate-limit
Rate limit reached (20 reads/hour per IP). Showing preview only — full content returns at the next hour roll-over.
The Galactic Federation has opened public access to its Planetary Probe Directory, a database of known planets and their telemetry signatures. Your mission is to interface with the probe console and uncover hidden data the Federation would rather keep secret.
The console seems… minimal. No verbose errors, no detailed output — just "signal detected" or "no signal". Can you find a way to communicate with the system, bypass its limited responses, and recover the hidden flag?
English summary: A web application presents a retro-styled "Planetary Directory" console with a single input field for planet names. The GET /probe?planet=<input> endpoint returns a boolean response — either "Signal detected" (carrier) or "No signal" (null). The goal is to exploit the input to recover a hidden flag from the server.
The app has a form at /probe accepting a planet GET parameter. The response indicates one of two states via a CSS class on the <body> element:
is-carrier + "Signal detected" → TRUE (valid planet or true condition)is-null + "No signal" → FALSE (invalid planet, false condition, or SQL error)This is a pure boolean oracle with no error messages or verbose output.
The input is placed directly into a SQL WHERE clause in a single-quote string context:
| Input | Response | Interpretation |
|---|---|---|
MARS | carrier | Valid planet exists |
xyz123 | null | No such planet |
MARS' | null | SQL syntax error (unbalanced quote) |
xyz' OR '1'='1 | carrier | Tautology → TRUE → confirms injection |
xyz' OR 'a'='b | null | False condition → confirms boolean control |
...
$ grep --similar