Unix 24

This exercise is one of our challenges to help you learn more about Unix/Linux

PRO
Tier
Easy
< 1 Hr.
13637
Unix Badge

Course


This challenge involves accessing an SQLite3 database file located in the /tmp directory. Unlike MySQL or PostgreSQL, SQLite3 operates as a simple file that you can access through its API or command line tool. By navigating the database, you will need to identify the tables present and extract the data within them using SQL queries. The ultimate objective is to find the password for the 'admin' user stored in one of the tables, which is the key to completing the challenge.

To begin, confirm the database file type using the 'file' command and then access it with the 'sqlite3' command followed by the filename. Once inside the database, use the '.tables' command to list all available tables and the 'SELECT' statement to query specific tables. By following these steps, you can successfully retrieve the necessary credentials to solve the exercise.

Want to learn more? Get started with PentesterLab Pro! GO PRO