How to block domains for a group from CLI

Can someone help me please with the proper command to enable/disable domainblocking for a certain group.
For example, how to block 'minecraft.net' (wildcard) for group 'mykid' from the commandline.
I managed to enable/disable groups from the commandline but I rather block domains for all my kids IP's.

Thanks in advance.

nanopi@nanopi:~$ sudo sqlite3 /etc/pihole/gravity.db "Insert into 'group' (enabled, name) values (1, 'mykid');"
nanopi@nanopi:~$ sqlite3 /etc/pihole/gravity.db "Select id from 'group' where name='mykid';"
1
nanopi@nanopi:~$ sudo sqlite3 /etc/pihole/gravity.db "Insert into domainlist (type, domain, enabled) values (3,'(\.|^)minecraft\.net$',1);"
nanopi@nanopi:~$ sqlite3 /etc/pihole/gravity.db "Select id from 'domainlist' where domain='(\.|^)minecraft\.net$';"
209
nanopi@nanopi:~$ sqlite3 /etc/pihole/gravity.db "Select group_id from domainlist_by_group where domainlist_id=209;"
0
nanopi@nanopi:~$ sudo sqlite3 /etc/pihole/gravity.db "update domainlist_by_group set group_id=1 where domainlist_id=209;"

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.