How to use SQLite to read data from a Firefox cookie?

Question

My Firefox profile profile has a cookies.sqlite that contains data for Firefox cookies. I grabbed the Firefox SQLite Manager extension and downloaded this file, which works, but how can I use simple query commands to read cookies from this file?

This is what I have tried so far:

 $ sqlite3 cookies.sqlite sqlite> SELECT * FROM dbname.sqlite_master WHERE type='table'; SQL error: file is encrypted or is not a database 

I can’t even list the tables, so I can’t try to list the cookies yet. If I can connect, I would like to read and write data there, but I'm new to SQLite.

Answer 1

I had the same problem while trying to read cookies.sqlite on Mac OS 10.6.8 (Snow Leopard). I downloaded SQLite 3.7.10 from http://www.sqlite.org/download.html and then was able to open the file.

Here is a walkthrough of what I did ...

• Download SQLite 3, go to the downloads folder and unzip the file so that you now have the new SQLite 3 located in the downloads folder.
• Open a new search window, press CMD + Shift + G, in the "Go To" dialog box that appears, type ~ / Library / Application Support / Firefox / Profiles and then press return.
• Assuming you have only one Firefox profile, you should see a folder called XXXXXXXX.default here (where line XXX will consist of several random characters). Open this folder or, if you have more than one profile, open the folder of the desired profile.
• Inside you will find the cookie.sqlite database file, you can use it directly here, but you can make a copy elsewhere so as not to spoil the one that uses Firefox. If you want to use Firefox directly, I think you need to exit Firefox first, otherwise it is locked to the file.
• Open a new terminal window and drag the sqlite3 binary from the downloads folder to the terminal window. At the command prompt, enter the path to sqlite3 .
• Now drag the cookie.sqlite3 database (the original or your copy) into the terminal and press return in the terminal.

If everything goes well, you should get the sqlite> command line. If you enter .tables, you will see the moz_cookies table, which you can then query and examine.

The following commands may help:

 .mode column .headers on select * from moz_cookies where domain = '.stackoverflow.com'; 

You should see all the values ​​stored in your cookie for this site.

If you want to upgrade existing sqlite3 on your Mac, I did sudo mv /usr/bin/sqlite3 /usr/bin/sqlite3.old (just in case there are future problems, I can move it again) and then sudo mv ~/downloads/sqlite3 /usr/bin/sqlite3 .

Answer 2

Use sqlite3

 sqlite3 file.sqlite 

Then use the command below to view the tables

 .tables 

Answer 3

I was able to open it with DBeaver, a universal open source database manager.