New add-on History Block

Talk about internet security, computer security, personal security, your social security number...
Post Reply
morganism
Senior Member
Posts: 134
Joined: Tue Nov 26, 2013 9:44 pm

New add-on History Block

Post by morganism »

This is a nice tool. Hashes saved history links too.

https://addons.mozilla.org/en-US/firefo ... src=search

Can anyone tell me if it blocks history markup to the SQL database also ?

I have downloaded MySQL, but don't like the security holes in that.
Any easier way to clear the SQL database , i really don't need a list of everything i have ever downloaded, on my hardrive.
Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Firefox/24.0
barbaz
Senior Member
Posts: 10841
Joined: Sat Aug 03, 2013 5:45 pm

Re: New add-on History Block

Post by barbaz »

This?
https://addons.mozilla.org/seamonkey/ad ... e-manager/
I have it installed but atm I only use it as a sqlite file reader, so no idea if it can do what you want
*Always* check the changelogs BEFORE updating that important software!
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:25.0) Gecko/20100101 Firefox/25.0 SeaMonkey/2.22.1
User avatar
therube
Ambassador
Posts: 7924
Joined: Thu Mar 19, 2009 4:17 pm
Location: Maryland USA

Re: New add-on History Block

Post by therube »

> history markup

What is "history markup"?

> to the SQL database

That would be http://kb.mozillazine.org/Places.sqlite.

Would setting History to 0 days be sufficient?
Clearing History (Private Data) on browser shutdown?

Both can be done through the browser itself.
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.19) Gecko/20110420 SeaMonkey/2.0.14 Pinball NoScript FlashGot AdblockPlus
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0 SeaMonkey/2.23a2
morganism
Senior Member
Posts: 134
Joined: Tue Nov 26, 2013 9:44 pm

Re: New add-on History Block

Post by morganism »

Nope.

The SQL database is the complete download and visited histories for the computer.

Upgrades to browser version do not affect it, as it is in a different location than the installed browser file.
Local, or local low in the AppData folder.

Clear browser history does not affect it at all.
There is a bit of discussion in the developer forums about it, but not much.

i don't think this is it.

https://developer.mozilla.org/en-US/doc ... ry_service

http://sqlitebrowser.sourceforge.net/

here is the cleaner for the places sql database

PlacesCleaner extension v0.41

Prevent recently records within desire periods to be delete.
Compatible for Firefox 4.0 beta.

Installation

Open PlacesCleaner :: Add-ons for Firefox

I hate to paste this much, but don't have it bookmarked, just as saved page

there it is
http://forums.mozillazine.org/viewtopic ... 0e63fdf27

delete History traces from the Places.sqlite file

Hi,

I am a software developer and I need some information.

I want to delete History traces from the Places.sqlite file and I want to implement this in the following way:
- all tables obtained from sqlite_master, I will create them in the new database using the SQL command obtained from the sqlite_master too.
- I will proceed the same way with INDEX, and I will create them in the new database
- then I will also proceed the same way with TRIGGER, and I will create them in the new database
- after this, I will make an INSERT at each table, as below:

eg. for moz_places I will use:
INSERT INTO <New DataBase>.<Table> SELECT ALL * FROM <Table> WHERE moz_places.id IN (SELECT fk FROM moz_bookmarks)
I would like to make this because I want to copy all the entries from moz_places in moz_places from the new database, excluding those entries which are not connected to a bookmark. This way, obtaining a new database which this time does not contain the entries related with History, and the original file can be always erased beyond recovery and this way, the History will be erased without affecting any Bookmark.

The result I will obtain is identical (of course that it does not contain the entires "erased") with the original database, with the following problems:

1. The file size drops down suddenly from 150KB to 55 KB, but WHY? When doing a complete copying did not should be approx the same file size? I am doing a complete copying by creating tables, indexes, trigers and inserting the data into the tables, or I need to do something additionally?

2. The new file (the new database) is no more "compatible" with Firefox 3, what I want to explain is that when creating a new bookmark, this bookmark won't be saved in the database or at least, we see this from the Mozilla browser after the next browser restarting, it has disappeared from there.
Could this be a conflict, if yes, what kind of conflict or is there a solution so I can solve this?

What I noticed is: after opening Mozilla Firefox 3, the file modified by me in the way I described above is modified, the table moz_Bookmarks is re-ordered and new entries appear, and also some entries or data from it disappear . The same happens with the table moz_places. I don't understand WHY this table modification? What it's happening? I think that this modification affect Firefox because it it not able to work with the Bookmarks as before.

Thank you very much for all your help.

Post Posted August 6th, 2008, 5:58 am
Is there a particular reason you want to do this? It's easy enough to delete the history using the history browser or through Tools -> Clear Private Data

Second, why are you copying the database tables? It would be much simpler to do this in-place, directly in the origional database. If you want to make a backup, make a copy of the database file rather than recreating it.

Third. there re about 11 tables and numerous indexes that are all inter-related. There is more involved other than adding or removing entries from moz_places, moz_bookmarks, and moz_historyvisits. There are also things like annotations and favicons that may also need to be updated.

If you're writing a Firefox extension, I suggest trying to leverage as much existing Firefox code as possible (there is, of course, already code to add and remove bookmarks and clean up history).
There have always been ghosts in the machine... random segments of code that have grouped together to form unexpected protocols. Unanticipated, these free radicals engender questions of free will, creativity, and even the nature of what we might call the soul...
argh
Guest


Post Posted September 18th, 2008, 6:58 pm
It doesn't work in FF3. I can open places.sqlite in Emacs and see history and deleted bookmarks.
Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Firefox/24.0
morganism
Senior Member
Posts: 134
Joined: Tue Nov 26, 2013 9:44 pm

Re: New add-on History Block

Post by morganism »

i see i have this installed, but havn't tried to use it yet either.
I believe it is for the sql databse too.

https://addons.mozilla.org/en-US/firefo ... e/?src=api
Mozilla/5.0 (Windows NT 6.0; rv:24.0) Gecko/20100101 Firefox/24.0
morganism
Senior Member
Posts: 134
Joined: Tue Nov 26, 2013 9:44 pm

Re: New add-on History Block

Post by morganism »

Places maintenece doesn't clear the database.
Output of check


> Integrity check
+ The database is sane
> Coherence check
+ The database is coherent
> Orphans expiration
+ Database cleaned up
> Vacuum
Initial database size is 10240 KiB
+ The database has been vacuumed
Final database size is 10240 KiB
> Statistics
Database size is 10240 KiB
user_version is 23
page_size is 32768
cache_size is -2048
journal_mode is wal
synchronous is 1
History can store a maximum of 80483 unique pages
Table moz_places has 9165 records
Table moz_historyvisits has 0 records
Table moz_inputhistory has 32 records
Table moz_hosts has 6813 records
Table moz_bookmarks has 10879 records
Table moz_bookmarks_roots has 5 records
Table moz_keywords has 4 records
Table sqlite_sequence has 1 records
Table moz_favicons has 94 records
Table moz_anno_attributes has 7 records
Table moz_annos has 80 records
Table moz_items_annos has 4249 records
Table sqlite_stat1 has 12 records
Index sqlite_autoindex_moz_inputhistory_1
Index sqlite_autoindex_moz_hosts_1
Index sqlite_autoindex_moz_bookmarks_roots_1
Index sqlite_autoindex_moz_keywords_1
Index sqlite_autoindex_moz_favicons_1
Index sqlite_autoindex_moz_anno_attributes_1
Index moz_places_faviconindex
Index moz_places_hostindex
Index moz_places_visitcount
Index moz_places_frecencyindex
Index moz_places_lastvisitdateindex
Index moz_historyvisits_placedateindex
Index moz_historyvisits_fromindex
Index moz_historyvisits_dateindex
Index moz_bookmarks_itemindex
Index moz_bookmarks_parentindex
Index moz_bookmarks_itemlastmodifiedindex
Index moz_places_url_uniqueindex
Index moz_places_guid_uniqueindex
Index moz_bookmarks_guid_uniqueindex
Index moz_annos_placeattributeindex
Index moz_items_annos_itemattributeindex


Will try places cleaner again
Mozilla/5.0 (Windows NT 6.0; rv:23.0) Gecko/20100101 Firefox/23.0
morganism
Senior Member
Posts: 134
Joined: Tue Nov 26, 2013 9:44 pm

Re: New add-on History Block

Post by morganism »

this guy lists forensics software for pulling the SQL databases off external drives, can prob be used to access em too.
Have used some of his software before, most seemed to be nagware, but effective.

http://www.nirsoft.net/computer_forensic_software.html
Mozilla/5.0 (Windows NT 6.0; rv:26.0) Gecko/20100101 Firefox/26.0
Post Reply