Bug #75494 for DBD-SQLite: file is encrypted or is not a database on iPhone4

Fri Mar 02 19:29:54 2012 pause.perl.org_ [...] t_jeremykister.com - Ticket created

Subject:

file is encrypted or is not a database on iPhone4

Using coredev.nl's perl on iphone 3gs or iphone 4 on iOS 5.0.1, I try to open /var/mobile/Library/AddressBook/AddressBook.sqlite, but I get an error: DBD::SQLite::db prepare failed: file is encrypted or is not a database at g.pl line 8. the sqlite3 command works just fine: # echo "SELECT value FROM ABMultiValue WHERE label = 1;" | sqlite3 /var/mobile/Library/AddressBook/AddressBook.sqlitedb (267) 555-6888 (267) 555-6999 2675550669 When copied over to a debian box, dbd::sqlite reads AddressBook.sqlite just fine. dbd::sqlite works fine on several other databases on the iphone; the only one I've found that it's confused about is AddressBook. if anyone is interested in helping fix this problem, i'd gladly let you ssh into my iphone for dev/testing.

Subject:

g.pl

#!perl use DBI; use strict; my $dsn = 'DBI:SQLite:dbname=/var/mobile/Library/AddressBook/AddressBook.sqlitedb'; my $dbh = DBI->connect($dsn); my $sql = "SELECT value FROM ABMultiValue WHERE label = 1"; my $sth = $dbh->prepare($sql); $sth->execute;

Fri Mar 02 19:58:22 2012 pause.perl.org_ [...] t_jeremykister.com - Correspondence added

a (hopefully) empty AddressBook.sqlitedb that illustrates the problem.

Subject:

AddressBook.sqlitedb

Download AddressBook.sqlitedb
application/octet-stream 368k

Message body not shown because it is not plain text.

Sat Mar 03 01:26:11 2012 ishigaki [...] cpan.org - Correspondence added

This is simply because the database is encrypted to protect privacy, and decrypting is out of this module's scope. Please refer to other resources to learn how to decrypt (via iTunes, or via some other ways). I close this ticket as rejected for now. Thanks. On Sat Mar 03 09:29:54 2012, JKISTER wrote: Show quoted text

> Using coredev.nl's perl on iphone 3gs or iphone 4 on iOS 5.0.1, I try

to Show quoted text

> open /var/mobile/Library/AddressBook/AddressBook.sqlite, but I get an

error: Show quoted text

> > DBD::SQLite::db prepare failed: file is encrypted or is not a

database Show quoted text

> at g.pl line 8. > > the sqlite3 command works just fine: > # echo "SELECT value FROM ABMultiValue WHERE label = 1;" | sqlite3 > /var/mobile/Library/AddressBook/AddressBook.sqlitedb > (267) 555-6888 > (267) 555-6999 > 2675550669 > > When copied over to a debian box, dbd::sqlite reads AddressBook.sqlite > just fine. > > dbd::sqlite works fine on several other databases on the iphone; the > only one I've found that it's confused about is AddressBook. > > if anyone is interested in helping fix this problem, i'd gladly let

you Show quoted text

> ssh into my iphone for dev/testing.

Sat Mar 03 01:26:12 2012 The RT System itself - Status changed from 'new' to 'open'

Sat Mar 03 01:26:12 2012 ishigaki [...] cpan.org - Status changed from 'open' to 'rejected'

Sat Mar 03 13:16:33 2012 pause.perl.org_ [...] t_jeremykister.com - Correspondence added

On Sat Mar 03 01:26:11 2012, ISHIGAKI wrote: Show quoted text

> This is simply because the database is encrypted to protect privacy, > and decrypting is out of this module's scope. Please refer to other > resources to learn how to decrypt (via iTunes, or via some other ways).

so you're saying the sqlite3 binary is automatically decrypting it? how is that possible? how in the world would dbd::sqlite on a debian box automatically decrypt it? i don't think you read/understood my comments. Show quoted text

> I close this ticket as rejected for now. Thanks.

ya, that was kinda rude.

Sat Mar 03 13:16:34 2012 The RT System itself - Status changed from 'rejected' to 'open'

Fri Jul 26 02:37:17 2013 pause.perl.org_ [...] t_jeremykister.com - Correspondence added

On Fri Mar 02 19:29:54 2012, JKISTER wrote: Show quoted text

> Using coredev.nl's perl on iphone 3gs or iphone 4 on iOS 5.0.1, I try to > open /var/mobile/Library/AddressBook/AddressBook.sqlite, but I get an error: > > DBD::SQLite::db prepare failed: file is encrypted or is not a database > at g.pl line 8.

ends up the problem is either fixed in DBD::SQLite 1.39 or else the issue is the way DBD::SQLite 1.26 is compiled on the coredev.nl perl repository. I compiled DBD::SQLite 1.39 myself on iphone5/ios6.1 and it is working just fine. no funny "encrypted" errors on sms.db nor AddressBook.sqlite.

Fri Jul 26 02:37:51 2013 pause.perl.org_ [...] t_jeremykister.com - Status changed from 'open' to 'rejected'

Fri Jul 26 04:15:32 2013 ishigaki [...] cpan.org - Correspondence added

Thanks for the update. On Fri Jul 26 15:37:17 2013, JKISTER wrote: Show quoted text

> On Fri Mar 02 19:29:54 2012, JKISTER wrote:

> > Using coredev.nl's perl on iphone 3gs or iphone 4 on iOS 5.0.1, I try > > to > > open /var/mobile/Library/AddressBook/AddressBook.sqlite, but I get an > > error: > > > > DBD::SQLite::db prepare failed: file is encrypted or is not a > > database > > at g.pl line 8.

> > ends up the problem is either fixed in DBD::SQLite 1.39 or else the > issue is the way DBD::SQLite 1.26 is compiled on the coredev.nl perl > repository. > > I compiled DBD::SQLite 1.39 myself on iphone5/ios6.1 and it is working > just fine. no funny "encrypted" errors on sms.db nor > AddressBook.sqlite.

Thu Aug 01 15:41:59 2013 pause.perl.org_ [...] t_jeremykister.com - Correspondence added

On Fri Jul 26 02:37:17 2013, JKISTER wrote: Show quoted text

> I compiled DBD::SQLite 1.39 myself on iphone5/ios6.1 and it is working > just fine. no funny "encrypted" errors on sms.db nor > AddressBook.sqlite.

For Google: I have put my DBD::Sybase fixup for iOS in my Cydia repo @ http://kister.net/cydia. CoreDev.nl may include the change in the future.

Thu Aug 01 15:43:04 2013 pause.perl.org_ [...] t_jeremykister.com - Correspondence added

On Thu Aug 01 15:41:59 2013, JKISTER wrote: Show quoted text

> For Google: > I have put my DBD::Sybase fixup for iOS in my Cydia repo @ > http://kister.net/cydia. CoreDev.nl may include the change in the > future.

DBD::SQLite, of course.