buiの雑記帳:buimemo

permissions.sqlite

Mac OS X Caminoで確認、FireFox3でも多分、同じ

• 現在の設定をout.txtへ書き出す

cd 〜/Library/Application Support/Camino
% sqlite3 permissions.sqlite
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .output out.txt
sqlite> .dump
sqlite> .exit

• 修正

 out.txt修正は最後のINSERTの次番号から設定
INSERT INTO "moz_hosts" VALUES(135,'www.example.jp','cookie',8);
 の次に追加
INSERT INTO "moz_hosts" VALUES(136,'adv.livedoor.com','script',2);
INSERT INTO "moz_hosts" VALUES(137,'adv.livedoor.com','document',2);
INSERT INTO "moz_hosts" VALUES(138,'adv.livedoor.com','image',2);
INSERT INTO "moz_hosts" VALUES(139,'adv.livedoor.com','object',2);
INSERT INTO "moz_hosts" VALUES(140,'ard.yahoo.co.jp','script',2);
INSERT INTO "moz_hosts" VALUES(141,'ard.yahoo.co.jp','document',2);
INSERT INTO "moz_hosts" VALUES(142,'ard.yahoo.co.jp','image',2);
INSERT INTO "moz_hosts" VALUES(143,'ard.yahoo.co.jp','object',2);
INSERT INTO "moz_hosts" VALUES(144,'counter1.fc2.com','script',2);
INSERT INTO "moz_hosts" VALUES(145,'counter1.fc2.com','document',2);
INSERT INTO "moz_hosts" VALUES(146,'counter1.fc2.com','image',2);
INSERT INTO "moz_hosts" VALUES(147,'counter1.fc2.com','object',2);
INSERT INTO "moz_hosts" VALUES(148,'rd.yahoo.co.jp','script',2);
INSERT INTO "moz_hosts" VALUES(149,'rd.yahoo.co.jp','document',2);
INSERT INTO "moz_hosts" VALUES(150,'rd.yahoo.co.jp','image',2);
INSERT INTO "moz_hosts" VALUES(151,'rd.yahoo.co.jp','object',2);
INSERT INTO "moz_hosts" VALUES(152,'doubleclick.net','script',2);
INSERT INTO "moz_hosts" VALUES(153,'doubleclick.net','document',2);
INSERT INTO "moz_hosts" VALUES(154,'doubleclick.net','image',2);
INSERT INTO "moz_hosts" VALUES(155,'doubleclick.net','object',2);
INSERT INTO "moz_hosts" VALUES(156,'doubleclick.net','script',2);
INSERT INTO "moz_hosts" VALUES(157,'doubleclick.net','document',2);
INSERT INTO "moz_hosts" VALUES(158,'doubleclick.net','image',2);
INSERT INTO "moz_hosts" VALUES(159,'doubleclick.net','object',2);
INSERT INTO "moz_hosts" VALUES(160,'google-analytics.com','script',2);
INSERT INTO "moz_hosts" VALUES(161,'google-analytics.com','document',2);
INSERT INTO "moz_hosts" VALUES(162,'google-analytics.com','image',2);
INSERT INTO "moz_hosts" VALUES(163,'google-analytics.com','object',2);
INSERT INTO "moz_hosts" VALUES(164,'tracer.jp','script',2);
INSERT INTO "moz_hosts" VALUES(165,'tracer.jp','document',2);
INSERT INTO "moz_hosts" VALUES(166,'tracer.jp','image',2);
INSERT INTO "moz_hosts" VALUES(167,'tracer.jp','object',2);

• バックアップ

$ mv  permissions.sqlite permissions.sqlite.backup

• 書き込み

$ sqlite3 permissions.sqlite
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .read out.txt
sqlite> vacuum;
sqlite> .exit

• 確認

$ sqlite3 permissions.sqlite
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .header on
sqlite> select * from moz_hosts;
内容が表示される
sqlite>.exit

• 影響を確認中

参考:

Hostperm.1 - MozillaZine Knowledge Base

SQLite入門