Expected Behaviour: I have allow listed various microsoft.com domains, including regex match on microsoft.com, as well as regex + exact matches on various sub domains. I have added them both via the webUI, as well as the CLI. Neither works properly at all for any URL I add to the allow list if it is…

All your clients are assigned to groups 4, 6, 7 (Infrastructure, Servers and DNS). You have adlists assigned to groups 0, 1, 2, 3 & 7. All your domain blocks (both whitelist and blacklist entries) are assigned to group 0 only. Since there are no clients in this group, none of these entries have a…

I think we must have had a misunderstanding of what the "All" group is then, we thought that was a "catch-all" for all devices. What you've said makes complete sense though. Is there a way to quickly change the group assignment for all allowlist/blocklist entries instead of doing them one by one? W…

There is no Pi-hole command line entry for this. SQL is the way to go. Here is an example command to assign group ID's. You may need to modify it for your specific needs - the database structure is discussed in the link below: sqlite3 /etc/pihole/gravity.db "update domainlist_by_group set group_…

Also, what about clients that are not specified in the client list, what bucket do they automatically fall into? I think this is where we got confused, we thought if a device isn't specified, it'll join the "All" group by default, hence why our allow/block lists had only the "All" category selected. …

[image] BinaryDichotomy: what about clients that are not specified in the client list, what bucket do they automatically fall into? The default group. This is also the group to which new adlists and domains are assigned. You have to manually re-assign any new entries to the desired groups.

[image] BinaryDichotomy: we thought if a device isn't specified, it'll join the "All" group by default, There is an option to assign an adlist or domain to "All" groups, but that is a manual action.

Ok, we're on the same page now, this is huge for us, thank you. There should be an option to assign "default groups" to allow/block/ad lists though IMO, so that when they are created, they are automatically assigned to the groups of your choosing, otherwise the manual process is time consuming. I kn…

[image] BinaryDichotomy: for MSFT Sql Server a quick hack would be putting a trigger on a table (not ideal, but it would work)...is this possible for the db PH uses? I don't know, but give it a try and see if it works for you.

[image] BinaryDichotomy: I know for MSFT Sql Server a quick hack would be putting a trigger on a table (not ideal, but it would work)...is this possible for the db PH uses? Yes. For an inspiration: [image] Group Management question Help You could add a…

UPDATE: Deleting allowList entries to get the page size back to 23 fixed the issue. As soon as there are enough entries to make a 24th page, that column disappears. I can reliably reproduce the issue on my instance, so this appears to be a bug related to the number of allowList entries you can have. …

[image] BinaryDichotomy: The group selector has disappeared altogether from the allowList for It is intentionally not displayed in "blacklist" or "whitelist" but in "Group management /domains"

Whitelisting not working as expected

Help

yubiuser September 3, 2020, 7:33pm 11

Yes.
For an inspiration: