• Home
• Blog
• Downloads
• Info
• Reviews
• Virus Warnings
• Search Site

Note: this procedure was written for Firefox 3.6, but may apply to other versions as well.

1. Open Firefox.
2. Click on Tools and select Options.
3. Click on Privacy.
4. There will be a "remove individual cookies" link in the middle of the Options window; click on it.

   

5. Search or scroll through the list until you find the relevant website. You can search on a domain name, e.g., example.com.
6. If you want to delete all cookies for a particular website, highlight its entry by clicking on it, then click on the Remove Cookies button. If yo wish to remove only certain cookies for a website, click on the rightward pointing triangle next to it or double-click on the entry to reveal the individual cookies associated with the website. Click on one you want removed to highlight it, then click on the Remove Cookie button.
7. Click on the Close button when you have removed all the cookies you wish to remove.
8. Click on the OK button to close the Options window.

[/network/web/browser/firefox] permanent link

She was using Firefox 8.0. I had her try accessing the site with Internet Explorer. She was able to access the site via Internet Explorer, so I then deleted all of the cookies stored for paypal.com by Firefox.

The following procedure will allow you to delete all of the cookies for a particular site, such as PayPal, in Firefox.

1. Click on Tools.
2. Click on Options.
3. Select Privacy.
4. Click on "remove individual cookies"
5. Cick on "paypal.com" or whatever site for which you wish to remove all cookies.
6. Click on the Remove Cookies button
7. Click on Close
8. Click on OK

[/network/web/browser/firefox] permanent link

[ More Info ]

[/network/web/browser/firefox/addons] permanent link

[ More Info ]

[/network/web/browser/firefox/addons] permanent link

Places.sqlite is used in Firefox 3 instead of the older bookmarks.html and history.dat files (the older files are left in the profile folder for backward compatibility).

I opened a places.sqlite file with SQLite. Note: Firefox must be closed when you try opening the file or you will get the error message "Error: database is locked".

C:\Users\Administrator\Downloads>sqlite3 C:\Users\Administrator\AppData\Roaming\
Mozilla\Firefox\Profiles\q3wdrb9w.default\places.sqlite
SQLite version 3.6.23
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

I then used .tables to see what tables were in it.

sqlite> .tables
moz_anno_attributes  moz_favicons         moz_keywords
moz_annos            moz_historyvisits    moz_places
moz_bookmarks        moz_inputhistory
moz_bookmarks_roots  moz_items_annos

The places.sqlite file contains the following tables:

• moz_anno_attributes - Annotation Attributes
• moz_annos - Annotations
• moz_bookmarks - Bookmarks
• moz_bookmarks_roots - Bookmark roots i.e. places, menu, toolbar, tags, unfiled
• moz_favicons - Favourite icons - including URL of icon
• moz_historyvisits - A history of the number of times a site has been visited
• moz_inputhistory - A history of URLS typed by the user
• moz_items_annos - Item annotations
• moz_keywords - Keywords
• moz_places - Places/Sites visited - referenced by moz_historyvisits

You can see what the columns are in a table using the .schema command, so I can use .schema moz_bookmarks for further information about the "bookmarks" table.

sqlite> .schema moz_bookmarks
CREATE TABLE moz_bookmarks (  id INTEGER PRIMARY KEY, type INTEGER, fk INTEGER D
EFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INT
EGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER);
CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type);
CREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModif
ied);
CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position);
CREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger BEFORE DELETE ON moz_bookma
rks FOR EACH ROW WHEN OLD.keyword_id NOT NULL BEGIN DELETE FROM moz_keywords WHE
RE id = OLD.keyword_id AND NOT EXISTS ( SELECT id FROM moz_bookmarks WHERE keywo
rd_id = OLD.keyword_id AND id <> OLD.id LIMIT 1 );END;

A diagram of the layout of the tables provides further information as does the The Places database.

I can see that there is a column named "title". So I can view the value for "title" for all entries in the table with select title from moz_bookmarks. Note: you may see a lot of what may appear to be extraneous bookmarks, i.e. webpages not bookmarked by the user. That's because you also see what you would see if you clicked on Bookmarks, Bookmarks Toolbar, Latest Headlines.

You can exit from sqlite with .exit, .quit, or Ctrl-C.

If you prefer a GUI to browse SQLite databases, you can use SQLite Database Browser, which can provide a graphical interface for browsing the databases on a Windows system.

To install the program, just unzip the files in the .zip file, once you've downloaded it, to the directory you want to use for it.

References:

1. SQLite
2. Locked or damaged places.sqlite
   MozillaZine Knowledge Base
3. Places.sqlite
   MozillaZine Knowledge Base
4. The Places database
   Mozilla Developer Center
5. SQLite Database Browser
   SourceForge
6. Improving Iceweasel Performance
   April 3, 2009
   Zenwalk Support

[/network/web/browser/firefox] permanent link

You can install the extension by simply clicking on the link for it. When it is installed, you will be notified you should restart Firefox to complete your changes.

The extension provides the capability for one to easily view the headers or CSS information for a page, check for Section 508 compliance, display the dimentions of images on the page, and many other capabilities useful to web developers.

[ More Info ]

[/network/web/browser/firefox] permanent link