IMPORTANT:AttackDefense Labs is included with a Pentester Academy subscription! Upgrade Now to access over 1800+ Labs.

Already a Pentester Academy student? Your access will continue uninterrupted. Please use the same Google account to login here.

Not a Pentester Academy student? Try our Free Communitiy Labs

SQLite Recon: Basics

recon-sqldb | Level: Easy  | Total Lab Runs: 0 | Premium Lab

Lab Scoreboard

Lab Walkthrough Video:


In this challenge we will look at the basics of SQLite reconnaissance. Please start the lab and answer the following questions:

    Questions

    1. What is the version of Sqlite?
    2. List the name of tables present inside “data.db”.
    3. List the column names of table “app” present in “data.db”.
    4. Fetch the flag from “FLAG” table present in “data.db”.
    5. How many records are stored in “employees” table in “chinook.db”?
    6. How many artists have their name start with “The” in “artists” table in “chinook.db”?
    7. What is the title of the 6th album in “albums” table sorted alphabetically in “chinook.db”?
    8. How many records have “total” between 2 and 6 in “invoices” table in “chinook.db”?


    Instructions: 

    • This lab is dedicated to you! No other users are on this network :) 
    • Once you start the lab, you will have access to a terminal of an Ubuntu instance
    • There is only one machine in the lab i.e. attacker's machine
    • The SQLite database files are provided in the home directory of the user.


    Verify:
    1. Fetch the flag from “FLAG” table present in “data.db”:
     

    The following activities are strictly prohibited on this website unless otherwise explicitly stated as allowed in the mission statement:

    • Using automated scanners
    • Using brute force attacks
    • Denial of Service attacks
    • Attacking other student machines in challenges where you might achieve a shell on the vulnerable system
    • Attacking the lab infrastructure

    Users violating the above will be either temporarily or permanently banned from the website. 

    If you are unsure about an activity, then please contact support to confirm that it is allowed on our website.

    Technical Support for this Lab:

    There is a reason we provide unlimited lab time: you can take as much time as you need to solve a lab. However, we realize that sometimes hints might be necessary to keep you motivated!

    We currently provide technical support limited to:

    • Giving hints for a lab exercise
    • In rare circumstances, if you have totally given up (NO!!!) then tell you how to solve it. This will be limited to sharing the solution video or lab report
    • A lab exercise fails to load or has errors in it

    If you need technical support, please email  attackdefense@pentesteracademy.com  clearly mention the name and link of the lab exercise and other essential details. The more descriptive you are, the faster we can help you. We will get back to you within 24 hours or less. 

    For adminitrative queries, billing, enterprise accounts etc. please email feedback@binarysecuritysolutions.com