X
Tap here to go to the mobile version of the site.

Support Forum

How can I unloc k all the sqlite db's in my profile.

Posted

Firefox is crashing my X windows every time I try to start it. Actually so is Thunderbird, but right now I don't have time to try to reinstalll the packages, move my profile., or any of the standard moves.

All  I want to do is fetch a few bookmarks from my Toolbar. I've searched for them in the backfiles -- text of course -- and had not luck.  So I tried python to read the sqlite db's.  

On all the databases, I get the error: "file is encrypted or is not a database."

It'd be one thing if it were just a single db file, but it's all of them: cookies, places, permissions, etc.

Firefox is crashing my X windows every time I try to start it. Actually so is Thunderbird, but right now I don't have time to try to reinstalll the packages, move my profile., or any of the standard moves. All I want to do is fetch a few bookmarks from my Toolbar. I've searched for them in the backfiles -- text of course -- and had not luck. So I tried python to read the sqlite db's. On all the databases, I get the error: "file is encrypted or is not a database." It'd be one thing if it were just a single db file, but it's all of them: cookies, places, permissions, etc.

Chosen solution

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.

Read this answer in context 0

Additional System Details

Application

  • User Agent: Opera/9.80 (X11; Linux x86_64; U; en) Presto/2.10.229 Version/11.64

More Information

Sayantan 1 solutions 4 answers

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
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
the-edmeister
  • Top 25 Contributor
  • Moderator
5406 solutions 40233 answers

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.

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.

Question owner

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.

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.

Question owner

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.

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.
FredMcD
  • Top 10 Contributor
4257 solutions 59606 answers

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.

'''[https://support.mozilla.org/en-US/kb/troubleshoot-firefox-issues-using-safe-mode 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.

Question owner

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.

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.
cor-el
  • Top 10 Contributor
  • Moderator
17533 solutions 158534 answers

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

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

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/

Question owner

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.

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.
FredMcD
  • Top 10 Contributor
4257 solutions 59606 answers

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

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

Question owner

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?

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?
FredMcD
  • Top 10 Contributor
4257 solutions 59606 answers
http://www.ehow.com/how_12007339_read-sqlite-file.html http://file.org/extension/sqlite http://en.wikipedia.org/wiki/SQLite

Helpful Reply

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

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

Chosen Solution

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 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.
FredMcD
  • Top 10 Contributor
4257 solutions 59606 answers

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

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