ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' active_time = 1518931228, active_ip = '54.227.48.147', act' at line 2
---
REPLACE INTO it_active SET active_id = , active_time = 1518931228, active_ip = '54.227.48.147', active_user_agent = 'CCBot/2.0 (http://commoncrawl.org/faq/)', active_session = 'akpscfi9b1i55dchh66mdsdm86'
---
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' view_date = NOW(), view_user_ag' at line 3
---
INSERT INTO en_articleviews SET view_ip = INET_ATON('54.227.48.147'), view_user_id = , view_date = NOW(), view_user_agent = 'CCBot/2.0 (http://commoncrawl.org/faq/)', view_referer = '', view_article_id = 201554
---
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY comment_date ASC' at line 3
---
SELECT * FROM en_comments, it_users WHERE user_id = comment_author_id AND comment_topic = 201554 AND comment_type = 'articles' AND (comment_state = 1 OR comment_author_id = ) ORDER BY comment_date ASC
---
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY comment_date ASC' at line 3 Extracting Unread Notifications from iOS Backups . Extracting Unread Notifications from iOS Backups . - Article Marketing

Article Marketing

Free Articles, reviews and news releases

Extracting Unread Notifications from iOS Backups .

By: Vladimir Katalov | Total views: 28 | Word Count: 795 | Date: Mon, 15 Jan 2018 - 12:22 PM

In the world of no jailbreak, acquisition opportunities are limited. Experts are struggling to access more information from those sources that are still available. Every little bit counts. In Elcomsoft Phone Viewer, we've added what might appear like a small bit: the ability to view undismissed iOS notifications. Unexciting? Hardly. Read along to discover how extracting notifications from iOS backups can make all the difference in an investigation!
As you may already know, Elcomsoft Phone Viewer has a useful feature: support for iOS notifications extracted from cloud and local backups. It can show several years' worth of undismissed iOS notifications, which can account for hundreds or thousands of messages.
Why notifications? Because they may contain sensitive information that won't be available anywhere else. Several months ago, a French man filed a lawsuit after his wife learned of his affair from Uber app notifications. According to BBC, "The man says he once requested an Uber driver from his wife's phone. Despite logging off, the application continued to send notifications to her iPhone afterwards, revealing his travel history and arousing her suspicions."
Notifications are an essential part of iOS. Notifications are pushed by pretty much every app that has any forensic significance. Email clients and instant messengers are easy to spot, but that's not all. Notifications are pushed by Uber and taxi apps, booking and travel services, online shopping and delivery services, social networks and banking apps. Unless read or dismissed, these notifications are stored in local and cloud backups. This is where Elcomsoft Phone Viewer extracts them from.
Why "undismissed" notifications only? If the user reads, dismisses or otherwise interacts with a notification (by e.g. replying to an email or instant message), the corresponding file is deleted from the system and is therefore not included into a backup. One more thing. Unlike calls or browsing history, notifications are not shared between iOS devices. There is no real-time sync for them. As a result, analyzing backups (local or iCloud) is the only way to extract notifications.
When using an iOS device, you'll be only able to access notifications going up to one week back - regardless of the actual number of notifications. If you read or dismiss a notification, you won't be able to go back to it. Inside, iOS keeps each notification in a separate file. Reading or dismissing a notification deletes that file, so there's no way to access it afterwards. The good thing, however, is that iOS backs up all unread/undismissed notifications even if they are older than one week. The reason for this is not exactly clear (there is no way to access those notifications when using an iOS device), but we can definitely benefit from this behavior.
For each individual application up to 100 notifications are stored. Older notifications are automatically deleted by the system.
Elcomsoft Phone Viewer allows filtering notifications by application; the default view places apps with most notifications to the top.
Finally, you can export all or select notifications into a CSV file for further analysis or reporting.
What can you expect to see when viewing undismissed notifications? We checked several accounts, and discovered as many as 1200 individual messages going back all the way to 2012. Here's what we've got:
  1. Online banking updates. Our banking app pushes account updates, statement availability, daily balance and transaction alerts as notifications as opposed to sending insecure emails or text messages.

  2. A slew of social network updates including Facebook, Twitter, LinkedIn and Pinterest. This included likes, retweets, friend requests, comments and updates.

  3. Instant messages. We've been able to view complete messages for Skype, WhatsApp and Viber (the only three messengers installed on that device).

  4. Uber: lots of "you've got a car" notifications.

  5. Amazon: delivery notifications and order updates.

  6. eBay: messages, order updates.

  7. DHL: tracking updates.

  8. Home security app: engaging and disengaging alarms.

  9. Email: subject and a few lines of message body.

  10. A bunch of Google Maps and Google Trips updates.

Is this enough to profile a user? Not quite, but it can help a lot. Is there a chance to get all of that data elsewhere? Not if you jailbreak the device and perform physical acquisition. Downloaded mail, banking updates, instant messaging and pretty much everything else on our list is excluded from iOS backups except for notifications, and can only be obtained via physical acquisition or by analyzing notifications with Elcomsoft Phone Viewer.
Learn more about Elcomsoft Phone Viewer and download free trial version at https://www.elcomsoft.com/epv.html (www.elcomsoft.com)

About the Author

Vladimir Katalov is CEO, co-founder and co-owner of ElcomSoft. Vladimir manages all technical researches and product developments in the company. He regularly presents on various events and regularly runs security and computer forensics trainings.

Comments

No comments posted.

Add Comment

You do not have permission to comment. If you log in, you may be able to comment.
Copyright © 2018 en.article-marketing.eu - Tutti i diritti riservati - Powered by link UP Europe! P.IVA 09257531005
Associazione Culturale per l'uso didattico ed etico dell'informatica
Sede legale: Via Pietro Rovetti, 190 - 00177 - ROMA