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

CockroachDB Recon: UI Access

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

Lab Scoreboard

Lab Walkthrough Video:


CockroachDB is an open source database system. A CockroachDB server is installed in the lab environment. The objective of this challenge is to interact with the CockroachDB server and answer the following:

Questions:

  1. How many nodes are active on the CockroachDB server?
  2. Identify the version of CockroachDB running on node with ID 'n1'.
  3. List all databases present on the CockroachDB server.
  4. How many tables are present in the database "secret"?
  5. Does the "user" table stored in "secret" have a foreign key?
  6. List all the users who have the privilege to access "secret" database.
  7. One of the CockroachDB nodes is being queried at regular intervals. Identify the node.
  8. Identify the table in the "upload" database which is being queried at regular intervals.


Verify:
1. Identify the table in the 'uploads' database which is being queried at regular intervals.
 

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