No firefox 11 web history support

[GoogleCodeExporter]

What steps will reproduce the problem?
1. firefox 11 places.sqlite files cannot be parsed
2.
3.

What is the expected output? What do you see instead?
Instead of History, the following occurs:
DBD::SQLite::db prepare failed: file is encrypted or is not a database at 
/usr/local/share/perl/5.10.1/Log2t/input/firefox3.pm line 717.
File places.sqlite not VALID (Log2t::input::firefox3): Database error ocurred, 
making verification not possible.  The error message is: Can't call method 
"execute" on an undefined value at 
/usr/local/share/perl/5.10.1/Log2t/input/firefox3.pm line 721.

What version of the product are you using? On what operating system?
Version 0.62, Ubuntu 10.04 32-bit

Please provide any additional information below.

Original issue reported on code.google.com by mtrei...@gmail.com on 13 Apr 2012 at 2:34

[GoogleCodeExporter]

This is not actually a problem with the tool.

Full support for Firefox history is there, and nothing has changed in the 
SQLite schema that causes the tool not be able to parse those history files.

THE problem is that with each new version of Firefox they seem to update their 
SQLite driver, and those updates change the actual structure of the SQLite 
file, and the Perl driver is not updated as frequently to solve those issue.

You can download the latest version of sqlite3 to parse those history files for 
you, but you need to compile them from source since no distro can keep up with 
this pace.

So this is really an issue that has to be taken to the author of the SQLite 
Perl driver, 
http://search.cpan.org/~adamk/DBD-SQLite-1.35/lib/DBD/SQLite.pm

According to CPAN they are:

Matt Sergeant <matt@sergeant.org>
Francis J. Lacoste <flacoste@logreport.org>
Wolfgang Sourdeau <wolfgang@logreport.org>
Adam Kennedy <adamk@cpan.org>
Max Maischein <corion@cpan.org>
Laurent Dami <dami@cpan.org>
Kenichi Ishigaki <ishigaki@cpan.org>

If you read the changelog for the project you can see:
Changes for Perl extension DBD-SQLite

1.35 Tue 29 Nov 2011
    - Updated to SQLite 3.7.9 (ISHIGAKI)
    - One small potential break case if you are using FTS4 and ^

And if you look at the source code they are using SQLite 3.7.10

README.MOZILLA inside db/sqlite3:

This is sqlite 3.7.10

-- Ryan VanderMeulen <ryanvm@gmail.com>, 01/2012

This is the reason this doesn't work... I can send an e-mail to the Perl 
module's authors, otherwise there is not much I can do except to bail Perl's 
mechanism completely... 

Original comment by ki...@kiddaland.net on 27 Apr 2012 at 8:35

• Added labels: Priority-Low
• Removed labels: Priority-Medium

[GoogleCodeExporter]

I sent an e-mail to DBD::SQlite authors to see if they have any answers/update 
on when support for version 3.7.10 could be expected.

Original comment by ki...@kiddaland.net on 14 May 2012 at 12:05

[GoogleCodeExporter]

Got a response from the authors on how to upgrade the module, did so and tested 
it.

So it works from my computer, and I'm submitting a patch to the DBD::SQlite 
module so that it can be updated.

This issue should then be "done" when an update to the module gets through the 
Debian distro (and my patch has been merged into the project).

Original comment by ki...@kiddaland.net on 14 May 2012 at 12:25

[GoogleCodeExporter]

forgot to update the status

Original comment by ki...@kiddaland.net on 14 May 2012 at 12:25

• Changed state: Started

[GoogleCodeExporter]

awesome news, thanks!

Original comment by mtrei...@gmail.com on 14 May 2012 at 12:54

[GoogleCodeExporter]

Talked to the developers of DBD::SQLite, they've updated the version to the 
latest one and released version 1.36_03, which can now be downloaded using CPAN.

That means that I just need to contact the author of the Debian package to 
update his, so this can get into the Debian repository, and FF history should 
work again ;)

Original comment by ki...@kiddaland.net on 14 May 2012 at 3:58

[GoogleCodeExporter]

This is fixed.

There is a fix on the way from the DBD::SQlite developers, it's going through 
testing, the quick fix is to do this yourself:

That is download the tar.gz from CPAN (update version information), download 
the SQLite driver from the sqlite site, and copy sqlite.c/h to the CPAN module, 
compile that again and install.

The authors of the SQLite module will release the new version soon, so it 
should make it's way up the chain, until then the quick solution can be applied.

I can throw together a more detailed instructions on how to update the module 
until then if anyone is interested, otherwise I consider this to be fixed.

Original comment by ki...@kiddaland.net on 24 May 2012 at 6:11

• Changed state: Done