THM - OWASP Sensitive Data Exposure
Dec 16, 2021
Aldrin Navarro
2 minute read

Exploring the website

alt Target website

The target website “Sense and Sensitivity” is a simple static website with a home page and the login page. Here I tried the common admin:password credentials but that didn’t work.

alt Homepage

Sensitive files

Moving around the site, we get to the /assets/ page for the directory listing of publicly accessible assets (images, css, js, and others). Here we see that a webapp.db is also present.

alt Assets directory showing a webapp.db file

It also shows us the service that is running Apache/2.3.29 (Ubuntu) Server and the port 80.


We explore the database by generally following these steps:

  1. Interact with the database
  2. Enumerate tables
  3. Enumerate columns and showing the data

Interacting with the database

This is a flat file database SQLite. GUI applications for exploring SQLite databases exists, but I’d like to stick to the traditional command line interface at least for a quick glance on a small target.

alt SQLite

Enumerate tables

alt Showing the users and sessions table

Here we can see that there are two tables in the database — sessions and users.

Enumerate columns

alt The users data

The users table has four columns: userID, username, password, and admin. Then we can show every record in the users table. Users admin and Bob seems to be interesting as they show admin = 1 which indicates that theses could be administrator accounts with administrator privileges.

alt The sessions data

Meanwhile, the sessions table have the columns: sessionId, userID, and expiry. Since this is empty, we only limit our knowledge gathering to the users database.


alt Cracking the passwords

We exploit this knowledge of the database exposed to the public assets directory, extract the passwords and try to crack them to see if any one of them is useful. There are encrypted passwords that Crackstation has. successfully cracked. Luckily we also have two of them belonging to admin users. Using this knowledge, try to login with the page.


And … we are in!

alt Logging in as admin

I tried adding another user with a somewhat similar username as admin,

" admin"

(notice the space), and the form just accepted it. To confirm how this actually is saved in the database, just download the webapp.db again. The records clearly show, on the screenshot below, that there is no input sanitation. This weakness may potentially lead to broken authentication.

alt Broken authentication


  1. OWASP Top 10
  2. TryHackMe OWASP Top 10

🐋 hello there! If you enjoy this, a "Thank you" is enough.

Or you can also ...

Buy me a teaBuy me a tea

comments powered by Disqus