Cookies & DB Browser

User Help for Mozilla Firefox
Post Reply
Hans L
Posts: 664
Joined: November 3rd, 2003, 9:51 pm

Cookies & DB Browser

Post by Hans L »

Ultimate goal is to protect some cookies from deletion while deleting all others when FF closes.

So, I wanted to be able to see which cookies Google, for instance, had opened (25!). Realized FF did not allow me to see that , so I downloaded and installed DB Browser (SQLCipher and SQLIte). Run immediately, and clicked Open database and opened Cookies.sqlite. Under heading Host, I could see what I needed.

Restarted the computer somewhat later and run DB Browser again. Now, I do not get the same information out of Cookies.sqlite. (At some point, Cookies.sqlite modified date stopped updating.) In any event, I realize that I have no idea shat I am doing.

For instance, where persistent cookies are stored. Where non-persistent cookies are stored. (I guess those are the files I want to open to see what cookies websites put on my computer.) Also, not sure I am using DB Browser correctly, although the first time, it seemed to work fine. Now, the most I get is moz_cookies, and under a row of "Filter", nothing!

Maybe someone can give me a few pointers so that I can continue my quest. Thanks!

Hans L
morat
Posts: 6421
Joined: February 3rd, 2009, 6:29 pm

Re: Cookies & DB Browser

Post by morat »

Are you using any cookie addons?

Search for Cookie
http://addons.mozilla.org/firefox/search/?q=Cookie

Cookie Quick Manager
http://addons.mozilla.org/firefox/addon/905349

An addon to manage cookies (view, search, create, edit, remove, backup, restore, protect from deletion and much more).

...

I use the Storage Inspector to view cookies.

Tools > Browser Tools > Web Developer Tools > Storage > Cookies

Storage Inspector
http://developer.mozilla.org/docs/Tools ... _Inspector

Here is an example.

Google Search Settings
https://www.google.com/preferences

The "NID" cookie stores the "Results per page" value.
User avatar
jscher2000
Posts: 11762
Joined: December 19th, 2004, 12:26 am
Location: Silicon Valley, CA USA
Contact:

Re: Cookies & DB Browser

Post by jscher2000 »

Hans L wrote:Ultimate goal is to protect some cookies from deletion while deleting all others when FF closes.
This is how I do that, but it's on a per-site basis, not a per-cookie basis:

On the Settings page, Privacy & Security tab, Cookies and Site Data section:

* Check the box for "Delete cookies and site data when Firefox is closed". After that, all new cookies will have their expiration set to "Session" instead of the future date requested by the site. Therefore, when you shut down Firefox, the session cookies will be deleted. Note that restoring tabs can bring back session cookies for those tabs, but it isn't guaranteed.

* For sites you want to allow to set persistent cookies, you can use the "Manage Permissions" button to create "Allow" exceptions.

* Do not use the "Clear history when Firefox closes" option in the History section. Or, if you use it, click the Settings button and do NOT clear cookies here. This function does not honor your exceptions set in the Cookies and Site Data section. (There is a bug on file for that.)
Hans L
Posts: 664
Joined: November 3rd, 2003, 9:51 pm

Re: Cookies & DB Browser

Post by Hans L »

[quote="morat"]Are you using any cookie addons? Etc. [quote]

morat, I will check this out. Thanks!

Hans L
Hans L
Posts: 664
Joined: November 3rd, 2003, 9:51 pm

Re: Cookies & DB Browser

Post by Hans L »

jscher2000 wrote: For sites you want to allow to set persistent cookies, you can use the "Manage Permissions" button to create "Allow" exceptions.
But I can no longer see what cookies are open, so I do not know what cookies to set as persistent. that's why I wanted to use DB Browser.

Hans L
morat
Posts: 6421
Joined: February 3rd, 2009, 6:29 pm

Re: Cookies & DB Browser

Post by morat »

I believe a cookie is a session cookie when the "Expires" attribute is set to "Session" instead of a date string.

Storage Inspector screenshot
http://jonathanmh.com/wp-content/upload ... ookies.png
Hans L
Posts: 664
Joined: November 3rd, 2003, 9:51 pm

Re: Cookies & DB Browser

Post by Hans L »

I am not using any cookie addons, instead using Manage Exceptions, and it works currently.

Thanks for you help.

Hans L
Post Reply