Magnet Weekly CTF Challenge Week 2 Writeup

Magnet recently rolled out the very first Magnet Weekly CTF Challenge. From Oct 5, 2020, a new challenge would be provided for the CTF participants to solve on every Monday at 11 AM ET until the end of 2020. 

In fact, I only found out this CTF event on week 2, therefore missed week 1's challenge. To be honest, it is a bit of pity for me. Regardless, I still found fulfilment from cracking the new challenges and learning from other people's write-ups😀. If you were still reading this blog entry in Oct 2020, I suppose it would not be too late to join the CTF and have fun from it.

For all challenges on Oct 2020, an Android image would be used for analysis.

And the challenge of week 2 looked like this:


Seeing the "What domain was most recently viewed via an app" part made me wonder if I needed to look into web browsing history on the Android image first. Just in case you don't know about the "picture-in-picture" (PIP) capability from Android, Android Developers documentation gave a short, comprehensive explanation: "Android 8.0 (API level 26) allows activities to launch in picture-in-picture (PIP) mode. PIP is a special type of multi-window mode mostly used for video playback. It lets the user watch a video in a small window pinned to a corner of the screen while navigating between apps or browsing content on the main screen."

From the screenshot below, you could see a music video of Rick Astley's "Never Gonna Give You Up" playing in PIP mode.

It is noteworthy that the mainstream web browsers (Google Chrome, Mozilla Firefox, Microsoft Edge and Opera) all offered PIP support:


Back on the Android image, the only web browser appeared to be Google Chrome. Thus, it would be necessary to locate the Chrome History SQLite Database (which can be located at "/data/data/com.android.chrome/app_chrome/Default/History".



Afterwards, a SQLite Database Viewer (I used DB Browser for SQLite here) could be used to examine its contents. Our answer should be inside the "
urls" table and a descending sort could be done on the "last_visit_time" column to locate the most recent visited domain:


Now the most recent visited URL was "http://malliesae.com/investor-page/". However, the challenge only asked of the domain. Therefore, "malliesae.com" is the correct answer for this challenge.

I hope you enjoyed reading my write-up of Magnet Weekly CTF Challenge week 2 challenge. Stay tuned and I will keep presenting new write-ups every week!

Comments

Popular posts from this blog

Dumpster Diving in Google Photos Android App: "local_trash.db"

Hexordia Weekly CTF Challenge 2024 - Week 1 Writeup

Hexordia Weekly CTF Challenge 2024 - Week 2 Writeup