webProeasy

MetricFlow

hackadvisor

Task: Analytics dashboard with DuckDB-powered SQL Data Explorer that passes user queries without restricting callable functions. Solution: Used DuckDB's read_csv_auto() table function to read /root/flag.txt from the server filesystem.

sql_injection flask file_read nginx arbitrary_file_read decoy_flag analytics duckdb read_csv_auto

decoy_flag_avoidanceduckdb_file_read_via_read_csv_autounrestricted_sql_function_access

$ ls tags/ techniques/

sql_injection flask file_read nginx arbitrary_file_read decoy_flag analytics duckdb read_csv_auto

decoy_flag_avoidanceduckdb_file_read_via_read_csv_autounrestricted_sql_function_access

Analysis

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.

$ python3 exploit.py --target 192.168.1.1 --port 8080
[*] Connecting to target...
[+] Shell obtained!

Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Permission denied (requires tier.pro)

Sign in to access full writeups

$sign in

$ cat writeup.md…

Sign in to access full writeups

Sign in to access full writeups

Similar writeups