Places.sqlite enrypted

[Grega Loboda]

My application, PrettyRun (http://delphistep.cis.si) can also search
through Firefox bookmarks. In Firefox version 3 I copied places.sqlite
to another location and I did my searches there. Recently I upgraded
to Firefox 4. Places.sqlite seams to be coded. Is that true? Is there
any option how to read it or Mozzila is preventing access? That's not
a very good thing as PrettyRun is able to search trough IE favorites
and Chrome bookmarks so beeing unable to search trough Firefox
bookmarks only does a bad thing to our favorite browser.

[Fox on the run]

If you are trying to run it against places.sqlite while FF is running,
it won't work as FF locks the file. That's been the case since 3.5 I
believe. Is that the issue you are talking about?

JB

[Grega Loboda]

No, I can live with that. I copied places.sqlite to another location
and I was reading from this new location. But in FF 4 I belive
places.sqlite is encrypted so even if I copy this file to some other
location I can't open it.

[Fox on the run]

But did you shut down Firefox first? Even if you copy it, you are
copying a locked file which I am pretty certain still won't work.
Make sure Firefox is completely shut down (not even the downloads
window accidentally still open).

JB

[Fox on the run]

I should point out that with FF4RC1 I was using sqlite manager no
problem to view all of its databases and didn't note any changes
insofar as use of encryption vs FF3.

JB

[Grega Loboda]

Hm, perhaps you are right. I copy file which is in use and perhaps
that is the problem. Thanks for the idea.

[Fox on the run]

Interesting, I tried to read places.sqlite using sqlite browser from
Sourceforge. It opened, but was blank (not even the tables were
visible). Yet FF4 was properly shut down (not even a lingering
process). But when I created a second profile in FF and installed
Sqlite Manager it was able to properly read places.sqlite from the
first profile (but Sqlite Manager still was unable to read it).

I wonder if you are experiencing that type of anomaly as well. The
file header is still showing sqlite 3 so it should open with any
sqlite browsing tool. sqlite manager can properly open some of the
other .sqlite files from FF4, just not places.sqlite (at least it
wasn't working when I tried it several times).

JB

[Dave Royal]

Fox on the run wrote:
>
> Interesting, I tried to read places.sqlite using sqlite browser from
> Sourceforge. It opened, but was blank (not even the tables were
> visible). Yet FF4 was properly shut down (not even a lingering
> process). But when I created a second profile in FF and installed
> Sqlite Manager it was able to properly read places.sqlite from the
> first profile (but Sqlite Manager still was unable to read it).
>
> I wonder if you are experiencing that type of anomaly as well. The
> file header is still showing sqlite 3 so it should open with any
> sqlite browsing tool. sqlite manager can properly open some of the
> other .sqlite files from FF4, just not places.sqlite (at least it
> wasn't working when I tried it several times).
>
> JB

I was wondering about this too. After closing Fx4:

sqlite3 /home/dave/.mozilla/firefox/kps55cle.default/places.sqlite
SQLite version 3.6.23
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite> .databases
Error: file is encrypted or is not a database
sqlite>
--
(Remove any numerics from my email address.)

[Fox on the run]

I noticed an error in my earlier post. I meant to say that sqlite
browser could not open places.sqlite but it could open other sqlite
files with FF shut down. However I was only able to open
places.sqlite using sqlite manager (in a second FF profile for the
moment - haven't yet tested with sqlite manager running as a
standalone app). And in confirming that I could open places.sqlite
with sqlite manager I exited sqlite manager and tried it immediately
with sqlite browser with no luck. You seem to be having that problem
as well in Linux using sqlite at the command line. Makes no sense
that one sqlite browing app can open it but not another one.

JB

[Dave Royal]

I installed the SQLite Manager addon (thanks for the tip) and I can
browse places. I can't do so with sqlite3, with Fx shut down or the
file copied elsewhere. A bit of googling doesn't reveal why.

Doesn't matter - just idle curiosity on my part. I have been using
sqlite3 fine on webbappstore.sqlite, which I use in a userscript.

[Grega Loboda]

I was able to solve my problem after I downloaded the last
sqlite3.dll. Using the old one I was able to open places.sqlite but
couldn't find any table in it even though I'm sure there were. After
executing query against that kind of a database I was notified it is
perhaps encrypted. Perhaps that message pointed me into wrong
direction.

[Fox on the run]

Thanks for the update. You seem to have discovered the problem. I
downloaded another sqlite freeware tool (Sqlite2009Pro) that I found
via a list on sqlite.org and it works. There was a note on the site
that it was updated in 2010 whereas sqlite browser seems to have not
been updated since 2009. So it seems that older sqlite tools are not
capable of reading the sqlite files in FF4 that have been updated.

JB

[Grega Loboda]

> Thanks for the update.  You seem to have discovered the problem.  I
> downloaded another sqlite freeware tool (Sqlite2009Pro) that I found
> via a list on sqlite.org and it works.  There was a note on the site
> that it was updated in 2010 whereas sqlite browser seems to have not
> been updated since 2009.  So it seems that older sqlite tools are not
> capable of reading the sqlite files in FF4 that have been updated.
>
> JB

If you prefer the old one I think you only change sqlite3.dll and it
should work. But as we are already speaking of DB tools, check my
Pretty Database Explorer (http://delphistep.cis.si). It knows how to
open sqlite and other databases as well. Remembers opened tabs and
queries, etc.

Grega

[Fox on the run]

I'll check that out, thanks. I've enjoyed using Sqlite Manager as a
standalone app so far (vs running it as an add-on, although I've done
that as well). I prefer the interface for Sqlite Manager vs the one
for Sqlite Browser. In looking at the screenshots of your
application, it has a similar look/feel to Sqlite Manager. And where
you have printing as well I may look at switching to yours.

[Dave Royal]

updated sqlite3 version 3.7.5 works in Linux

[deepakka...@gmail.com]

hello,

i am getting the same error...


can u pls explain how to use sqlite3.dll in .net

thanks...

[»Q«]

On Fri, 8 Mar 2013 03:43:03 -0800 (PST)
deepakka...@gmail.com wrote:

> i am getting the same error...

You have replied to a two-year-old message without quoting any of it,
so most people reading your post will have no idea what you're talking
about.

You should start a new thread and fully describe the error.

[go...@primap.org]

> You have replied to a two-year-old message without quoting any of it,
>
> so most people reading your post will have no idea what you're talking
>
> about.

Well, that's not true. It is very obvious that the deepakka... has the same problem as discussed in this thread (not able to read places.sqlite) an that he aims to fix that by getting a new version of sqlite.dll which has claimed to be a proper way of fixing that issue. He just did not know where to get and copy that .dll -- and so do I. So, regardless of the age of this thread it could still be helpful to get an answer to this question.

> You should start a new thread and fully describe the error.

I don't agree on this.

[WaltS]

Let's see.

Deepakka says "hello,

i am getting the same error...

can u pls explain how to use sqlite3.dll in .net

thanks... "

I don't think explaining how to use sqlite3.dll in .net is within the
scope of user to user Firefox support.

Perusing the thread back. The error discussed in this thread is the
PrettyRun application can't read places.sqlite in Firefox 4.0. Since
they both no longer exist, try installing Firefox 22.0, and this extension.

<https://addons.mozilla.org/en-us/firefox/addon/sqlite-manager/>

Works just fine in Firefox 22.0.

--
openSUSE 12.3 (64-bit) KDE 4.10.2
Thunderbird Earlybird 24.0a2 with Lightning 2.6a2

[WaltS]

On 06/28/2013 10:21 AM, go...@primap.org wrote:

Why not? Not everyone uses that crappy Google Groups.

Some subscribe to the support mailing list, others this group on
news.mozilla.org, and do not keep posts indefinetely, so quoting the
post, or starting a new thread is proper etiquitte.

[Mark Filipak]

Dear WaltS. Are you a Homeland Security cop or a Baptist minister?

If a post gets you hot, don't spew your noise all over the Internet. Simply
delete the offending post. We will all appreciate that.

> _______________________________________________
> support-firefox mailing list
> support...@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-firefox
> To unsubscribe, send an email to
> support-fir...@lists.mozilla.org?subject=unsubscribe
>


--
I tried godaddy.com & domainsbyproxy.com ...and I'm sorry I did!

[goodwin]

On 06/28/2013 09:13 AM, Mark Filipak wrote:

> We will all appreciate that.

TINW

And if there was, you certainly don't speak for them.

And Walt's post was spot on. Its apparent you don't feel obliged to
follow etiquette since you top post.

Its much easier to ignore your post than the ill informed poster of this
thread.

[go...@primap.org]

> Why not? Not everyone uses that crappy Google Groups.

Can you explain what you mean by that?

[go...@primap.org]

> Perusing the thread back. The error discussed in this thread is the
>
> PrettyRun application can't read places.sqlite in Firefox 4.0. Since
>
> they both no longer exist, try installing Firefox 22.0, and this extension.

Thanks for your answer. At the moment this is unfortunately not an option for me. But thanks for the answer.