pschneider1968 / pihole-bl-msft-telemetry-bsi

Pi-Hole blocklist for hosts involved in Microsoft Windows telemetry, as documented by BSI Bund in Germany
MIT License
7 stars 0 forks source link

TODO: We should be able to import list_of_blocklists.txt via CLI #3

Closed pschneider1968 closed 1 year ago

pschneider1968 commented 1 year ago

Currently the big ad domain block list needs to be entered manually via Pi-Hole web interface.

This is cumbersome.

Need to figure out a way to make this work in a scriptable way, too, but without directly interacting with the Gravity SQLite DB via direct SQL commands, because that could too easily break or corrupt the DB.

pschneider1968 commented 1 year ago

It seems there really is no pihole command line interface to the Gravity DB yet. So the only solutions seems to be to use sqlite3 to directly access the DB and manipulate the adlist table.

pschneider1968 commented 1 year ago

Fixed in branch dev_v0.2 by commit eaf3548dd93fecba587ac622b00e615582b8e976 Still to be merged back to master.

pschneider1968 commented 1 year ago

Some more thought is required on how to merge changes to the list of blocklists: