There was a major heist at the local bank. Initial findings suggest that an intruder from within the bank, specifically someone from the bank's database maintenance team, aided in the robbery. This traitor granted access to an outsider, who orchestrated the generation of fake transactions and the depletion of our valuable customers' accounts. We have the phone number, '789-012-3456', from which the login was detected, which manipulated the bank's employee data. Additionally, it's noteworthy that this intruder attempted to add gibberish to the binlog and ultimately dropped the entire database at the end of the heist.
Your task is to identify the first name of the traitor, the last name of the outsider, and the time at which the outsider was added to the database.
Flag format : VishwaCTF{TraitorFirstName_OutsiderLastName_HH:MM:SS}
We received the DBlog-bin.000007 file as an attachment.
To retrieve the information, we used the strings command on the file, which provided us with the bank's database.
The challenge description instructed us to find the first name of the traitor with the phone number 789-012-3456.
Through a simple search, we identified the traitor as Matthew Williams.
Now, moving on to the outsider who is part of the maintenance team:
Within the database, we found a table of maintainers containing only one person, named John.
To proceed, we need to determine John's last name, so we performed a search for his name.
for timestamp you must convert it to IST (Indian Standard Time).
FLAG :
VishwaCTF{Matthew_Darwin_15:31:29}