Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
pschneider1968 opened this issue Dec 20, 2022 · 3 comments · Fixed by #4
Closed

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

pschneider1968 opened this issue Dec 20, 2022 · 3 comments · Fixed by #4
Assignees
Labels
enhancement New feature or request

Comments

@pschneider1968
Copy link
Owner

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 pschneider1968 added the enhancement New feature or request label Dec 20, 2022
@pschneider1968 pschneider1968 self-assigned this Dec 20, 2022
@pschneider1968 pschneider1968 pinned this issue Dec 20, 2022
@pschneider1968
Copy link
Owner Author

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
Copy link
Owner Author

pschneider1968 commented Dec 20, 2022

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

@pschneider1968
Copy link
Owner Author

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

  • do we disable lists that are not in the new import?
  • or do we only add new list entries?

@pschneider1968 pschneider1968 linked a pull request Dec 22, 2022 that will close this issue
@pschneider1968 pschneider1968 unpinned this issue Dec 22, 2022
@pschneider1968 pschneider1968 pinned this issue Dec 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant