Is Firefox closed when you try to open the database file?

You can use this extension in Firefox:

   SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/ 

 hope it will solve your problem

If you can't open Firefox, that addon won't do anything for you. You can use an external Sqlite Manager application like this. http://www.sqlabs.com/sqlitemanager.php

You're probably going to have a problem trying to figure out how to use it, along with figuring out the "queries" to use to view the data types; it's not easy to use.

A better alternative might be to open the bookmarks.html file in your Profile folder to view and copy some bookmarks. bookmarks.html can be opened in any web browser.

Yes, Firefox was closed. I couldn't get it started. Besides not opening, it crashed my X windows. Therefore, I cannot use any extensions or adds on. But since Firefox did not quit cleanly, something might have happened. As I said, I cannot open any of the sqlite dbs in my profile, either within python or in the sqlite3 interactive.

I don't have a clue why all the db's would be corrupted/locked/whatever. If they are recoverable, I'd like to do so. (the error msg is consistent: "file is encrypted or is not a database.") I don't know sqlite very well, so there may be something I can do.

I'll try to figure out what is happening with Firefox crashing X later. This is a Redhat flavor and there's a dependency on the xulrunner package, accounting for the crashing of both F.F. and Thunderbird.

Thanks. I will try sqlitemanager.php.

As far as the backups, I searched through them but could find the many, most used links that I keep in the Bookmarks toolbar. I can see the other links that were in my Bookmarks menu.

Start Firefox in Safe Mode {web link} While you are in safe mode;

Type about:preferences<Enter> in the address bar

Select Advanced > General. Look for and turn off Use Hardware Acceleration.

Poke around safe web sites. Are there any problems?

Then restart.

Firefox was crashing the X session in safe-mode, too, so I cannot use any Firefox functionality to repair whatever's wrong. For now I'm not using Firefox on that machine, but I would like to get at some of my bookmarks to use in another browser, like the one I'm using now, Opera, or in Firefox on another machine.

Did you check if you meet the System Requirements (GTK+ and GLib) for the current Firefox version?

• https://www.mozilla.org/en-US/firefox/33.0/system-requirements/

You can try to install an older Firefox version like the 31.2.0 ESR version to see if that version works.

• https://www.mozilla.org/en-US/firefox/organizations/all.html

• https://www.mozilla.org/en-US/firefox/31.2.0/releasenotes/
• https://www.mozilla.org/en-US/firefox/organizations/system-requirements/

Thanks, but there's no explanation in the versions. I have a Centos 5.11 system that is completely up-to-date for the distro and the version. That includes Firefox 31.2, and anyway all the dependencies would be satisfied by the distro.

Start your Computer in safe mode. Then start Firefox. Try Safe web sites.

I have a Centos system -- like Red Hat and Fedora -- and I have no safe mode as such. Rescue mode gives me a minimal console -- not a gui that would run Firefox.

I think Ubuntu may have something closer to Windows/Mac safe mode, but that doesn't apply.

I simply trying to open the sqlite file *outside* of Firefox.

I once wrote a python script that read the Firefox cookies.sqlite, and it worked. That was a while ago. Are the databases encrypted or otherwise locked now? How can I deal with that?

http://www.ehow.com/how_12007339_read-sqlite-file.html

http://file.org/extension/sqlite

http://en.wikipedia.org/wiki/SQLite

Dear Fred,

1. I know what sqlite is and I use it frequently in my program for my computer science work.

2. If you read my original question, you will see that the sqlite db's in my mozilla profile do not open:

  On all the databases, I get the error: "file is encrypted or is not a database."
  (I'll paste in the outcome from the python intepreter at the end here)

3. If you read my original question, you will also see that I ask about this because Thunderbird and Firefox both crash my X-session (which gives me the graphical user interface in Linux). So I have two problems: there is a library conflict between Mozilla's sqlite library and some shared code in Gnome -- the Window Manager I use, or in my configuration of Gnome and my video driver.

So if you or anyone else has an idea of where that conflict might be, I'd be grateful. Meanwhile, after poking around, I realized I can recover the bookmarks I want from the json files in my bookmarkbackups directory.

Meanwhile, I cannot open my Firefox on this machine so I cannot use any F.F. mode, add-on, or extension.

p.s. :

$ python Python 2.7.3 (default, May 16 2012, 11:52:19) [GCC 4.1.2 20080704 (Red Hat 4.1.2-51)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> con = sqlite3.connect("places.sqlite") >>> cur = con.cursor() >>> cur.execute ('select * from sqlite_master where type="table"') Traceback (most recent call last):

 File "<stdin>", line 1, in <module>

sqlite3.DatabaseError: file is encrypted or is not a database

I solved the sqlite reading problem.

Mozilla software uses its own sqlite library, and when I wrote a tiny C program linking to that library, instead of the library that comes with my linux distribution (Centos), everything works fine.

I thought of this only because I tried installing Mozilla's Firefox, rather Centos's. And there I saw it: libmozsqlite3.so.

I still have no clue about what kind of conflict/problem prevents me from using FF and Thunderbird on this machine. Both run fine on all six of my other machines.

I called for the big guys to help. Maybe one of them knows. Good luck.