Skype Forensics

Computer Forensics Boot Camp

Our students have the highest exam pass rate in the industry!

Skillset

Skype is an application that enables voice and video calls, instant messaging, file transfers, and screen sharing between users. Millions of people download and use Skype everyday for voice and video calling, messaging, sharing and low-cost local and international calls.

If you have a Microphone and Speakers, you can use Skype to call people that have Skype. Skype also has an Internet connection box, so that you can convert your regular telephone to use the internet for your telephone service.

As forensics perspective it can give us a lot of information which can be present as evidence in court of law.

Need of Computer Forensics in today’s world:

In this high-tech world variety of computer crimes that take place. There are various computer crimes took place on small scale as well as large scale. The loss caused is dependent upon the sensitivity of the computer data or the information for which the crime has been committed. So the computer forensics has become a vital part in the corporate world. There can be theft of the data from an organization in which case the organization may sustain heavy losses. For this purpose computer forensics are used as they help in tracking the criminal.

There are many tools that can be used in combination with the computer forensics to find out the geographical information and the hide outs of the criminals. The IP address plays an important role to find out the geographical position of the terrorists. The security personnel deploy the effective measures using the computer forensics. The Intrusion Detecting Systems are used for that purpose.

So In this article we are going to perform forensics analysis of Skype application.

We are in the Skype directory and we can see the four red box marked directories are: happysahoo2959, namita.nahak, sudhanshu251286, trmr_rohit_marines. These four directories are users directory who are using Skype in this system. As shown in the below figure:

As can we see in the below figure there is a XML file named shared. It is a configuration type file so first we will analyze this XML file.

We can open this file directly through any browser otherwise here we are using Notepad++ for opening shared.xml file and it will look like this shown in below figure

First thing what we will see in this file the timestamp which is showing a value 1384624184.32. This is a Unix style timestamp so we will convert it to readable format. Here we are using online conversion tools and see what we get after conversion.

We can see in above figure the output is Saturday 16th November, 2012 17:49:44 GMT.

Another important thing in this file is the HostCache tag. Hostcache is the IP node of the skype. The IP starts after 0400050041050200 it means D5C7B3AD9C51 is the IP address.

Now what we will do we convert this Hexadecimal value D5C7B3AD9C51 to decimal numbers for revealing the IP and port number. For this we are using here online conversion tool. So first I take D5 and convert it.

After converting in decimal value what can see the decimal value is 213 , now by this way we can get the whole IP address and Port number.

As can be seen in above figure after converting the whole value into decimal we get this 213.199.179.173:40017

Next in UI version tag we will get the current skype version 5.6.59.110 which is used by the users. Under the Language tag we can see the language used by the user which is en simply it means english.

Another information like Devices used in the system speakers and Mic can be seen under Devices tag.

Now we will move to user’s directory here we selected trmr_rohit_marines directory for further analysis.

As can be seen in above figure we are under trmr_rohit_marines directory. In this directory we can some files and folders there. Inside the user directory are mostly chat, call, and voicemail logs, all split across multiple files and combining data from multiple sessions and dates. The first folder is chatsync which contains history in dat format. Under this folder each file contains one or more chats between SKYPE-USER and one other user, the timestamp showing the time the last chat ended. The full chat history between those two users may be spread out over several *.dat files.

bistats.db, dc.db, griffin.db, keyval.db these files are skype metadata. config.xml contains the current configuration and contact list for the account holder. config.lck contains account creation date, If SKYPE-USER’s account was created on this computer, this will be the account creation date. Main.db is the main file which has juicy information.

First analysis we will start from the config.xml file, let us open this file. We can see another timestamp here under LastSync tag. So convert it in readable format as we did previously.

We have the output shown in above figure which is Thursday, 7 November, 2013 15:46:04 GMT.

Now just scroll the file for looking another information and see what we found under U tag the whole contact list of the user.

Another information like Last Ip Country, LastTime all we can see here.

Now we will move on to the main.db file which has important information. For opening the .db file we need SQLite Administrator tool we can download this tool from here http://sqliteadmin.orbmu2k.de/.

Now Goto Database and select Open and choose the main.db file from its location.

We can see here the whole table in main.db file.

We will review some of the tables which contained sensitive data. For displaying the table data result in right pane side of the SQLite Administrator first select the Result tab then right click and select Show Memo and we are done.

Now we will check some of the table which contained some information data. Here we selected CallMembers table and the tab info under this table are as follows:

identity – destination of the call

displayname – displayname of the called person

guid – unique identifier and shows source of call

start_timestamp – date/time converted from unix epoch time to local time

call_duration – number of seconds of the call

Screenshot blured

Next we selected here Calls table and the tab info under this table are as follows:

host_identity – source of call

current_video_audience – destination of call

begin_timestamp – date/time converted from unix epoch time to local time

duration – number of seconds of the call

Screenshot blured

Next we moved on to the Messages table the tab info under this table are as follows:

author – source of chat

chatname – unique identifier and shows source of chat

timestamp – date/time converted from unix epoch time to local time

body_xml – chat messages

Screenshot blured

Another important Table is Transfers table which contains the information of data transfer. So here we selected Transfers table and the tab info under this table are as follows:

partner_handle – the skype username of the person to whom data is transferred

partner_dispalyname – the display name of the person to whom data is transferred

filepath – location of the file in the user’s system who is sending to user

filename – name of the file which is being sent

Screenshot blured

Now we are done with the main.db file analysis and we will move on to the chatsync folder. We already described about this folder so we are going to use here a small tool named Skype Chatsync Reader which can be downloaded from here http://itsecuritylab.eu/index.php/tag/read-skype-chatsync-files/.

Ethical Hacking Training – Resources (InfoSec)

We can see in below figure the usage of the tool is very easy we have to just put the user’s profile directory name in Own ID field as we gave here trmr_rohit_marines and then in Read chatsync filed just give the whole path of chatsync folder. After that we can see the whole chat history here.

Warlock works as a Information Security Professional. He has quite a few global certifications to his name such as CEH, CHFI, OSCP and ISO 27001 Lead Implementer. He has experience in penetration testing, social engineering, password cracking and malware obfuscation. He is also involved with various organizations to help them in strengthening the security of their applications and infrastructure.

6 responses to “Skype Forensics”

Hi, if some one is using a Android Phone, how do we get access to main.db files of Skype? i tried copying all the files on a PC and could not find any .db files. They have skyperaider folder but its empty. please assist….

Yes, I’ve been having an issue finding actual Skype chat files on my Android when I connect it to my computer. It also gives me that skyperaider folder. I simply connect the phone to computer via charger cable and it will automatically ask me to mount my phone. Afterwards, new window will pop up on my desktop, and that is how I am able to access my files.

Nice information about skype and hoe to collect some aditional information. I also use skyperious as a tool to quickly present chats. Other tools like IEF also can present chats as threats for “normal” reading style. I think IEF have to do some more with those thread-reading style.

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

× = 21

About InfoSec

At Infosec, we believe knowledge is the most powerful tool in the fight against cybercrime. We provide the best certification and skills development training for IT and security professionals, as well as employee security awareness training and phishing simulations. Learn more at infosecinstitute.com.

Connect with us

Join our newsletter

File download

First Name

Last Name

Work Phone Number

Work Email Address

Job Title

Why Take This Training?

How will you fund your training?

What is your training budget?

InfoSec institute respects your privacy and will never use your personal information for anything other than to notify you of your requested course pricing. We will never sell your information to third parties. You will not be spammed.

Comments

What is Skillset?

Skillset

Practice tests & assessments.

Practice for certification success with the Skillset library of over 100,000 practice test questions. We analyze your responses and can determine when you are ready to sit for the test. Along your journey to exam readiness, we will:

1. Determine which required skills your knowledge is sufficient
2. Which required skills you need to work on
3. Recommend specific skills to practice on next
4. Track your progress towards a certification exam