Remko Weijnen's Blog (Remko's Blog)

About Virtualization, VDI, SBC, Application Compatibility and anything else I feel like

Archive for the ‘iPhone’ Category

Timestamp column in iOS SQLite database

I was researching a database from an iOS app called <appname>.sqlite. From the filename it was obvious that we were dealing with an SQLite database.

I opened the database with SQLite Database Browser and the table I looked at has datetime values which are expressed in the TIMESTAMP data format in SQLite:

SNAGHTMLb5e026b

SQLite documentation indicates that the TIMESTAMP format is based on unix time: the number of seconds elapsed since 01-01-1970 in UTC time.

(more…)

  • 2 Comments
  • Filed under: iPhone
  • From Jailbreak to Jailbreak part 2

    imageIn this post, which is a followup on my From JailBreak to Jailbreak post, I will describe the same procedure for A5 devices (iPhone 4S and iPad 2).

    imageA lot of the stuff is really the same so I will not describe that again, this includes the actual update to iOs 5.01, xBackup, SHSH signatures and backup using iTunes.

    Currently the Jailbreak for A5 devices with iOS 5 is only for iOS 5.01. Since Apple is expected to release iOS 5.1 very soon it’s highly recommended to update to iOS 5.01 NOW. Especially because it’s not yet possible to downgrade to iOS 5.01 using Tiny Umbrella.

    (more…)

  • 0 Comments
  • Filed under: iPhone
  • From Jailbreak to Jailbreak

    Cydia IconA few days ago I decided to update my iPhone which was still running iOS 4.3.1 to iOS 5.0.1. I delayed this update for a while because I had Jailbreaked my iPhone. Unfortunately an update is much more work when you have Jailbreaked because you also have to restore Cydia settings such as the repositories and Cydia installed Apps.

    This blog post is not a guide on how to Jailbreak but more a collections of tips to go from a Jailbreak iOS 4.x to iOS 5.01.

    If you notice any extra steps while doing your update please send them to me so I can add them to this post.

    (more…)

  • 4 Comments
  • Filed under: Apple, iPhone
  • I wanted to save the SHSH signatures from my iPhone before updating to iOS 5.01. I started Tiny Umbrella but it showed an error indicating that there’s already a process listening on port 80:

    Cannot Start TSS Service | DO NOT TRY RESTORING YOUR DEVICE!!! | System(PID:4) must be killed!!

    I verified this using netstat (netstat -aon | find /I “LISTENING” | find /I “:80”):

    netstat -aon | find /i "LISTENING" | find /i ":80"

     

    (more…)

    I started using the i-Clickr PowerPoint Remote iPhone App for my presentations recently. I like this app as it shows me the current (or next slide), annations and previous/next buttons:

    IMG_0118

     

    (more…)

  • 0 Comments
  • Filed under: iPhone
  • Blogroll


    Categories


    Archives