Multiselect in Groupmanagement

[blacksun]

Hello,

until today, I have only the group "default". Now, today I created a new group "group2".
The existing domains (group management --> Domains) are assigned only to group "default".
At the moment, i think there is no muliselect possible to edit more thant one entry at the same time, right?

How can edit all entries in group management --> Domains to be assigned to both groups, default and group2?

Thanks for your help.

Regards

[yubiuser]

@blacksun

At the moment, i think there is no muliselect possible to edit more thant one entry at the same time, right?

Right.

You could try to create a SQL command to edit all at the same time. How many domains do you have configured?

Add:
You can modify this bash script to archive what you want:

Add all whitelist items to all groups

#!/bin/bash # Adds all whitelist exact to all groups # define path to pihole's databases and temporary database GRAVITY="/home/chrko/sonstiges/Netzwerk/Pi-Hole/pihole_all_groups/gravity.db" #define and initialize variables declare -a domain_ids declare -a group_ids group_ids=(`sqlite3 $GRAVITY "select id from 'group'"`) domain_ids=(`sqlite3 $GRAVITY "select id from domainlist where type=0"`) for domain in "${domain_ids[@]}"; do for group in "${group_ids[@]}"; do sqlite3 $GRAVI…

[blacksun]

@yubiuser

How many domains do you have configured?

You can modify this bash script to archive what you want:

Add all whitelist items to all groups - #2 by yubiuser

Thanks for the script.
We are talking about 1000 whitelist/blacklist-entries.

Is /etc/pihole/gravity.db
the correct db?

Do I have to stop / restart pihole or the Database when performing the script? (how?)
Do I have to stop / restart pihole or the db-system when I make a backup of the file?

You wrote whitelist.
I think this is "type=0", right?
Is type=1 for blacklist?

[yubiuser]

@blacksun

Is /etc/pihole/gravity.db
the correct db?

Yes.

@blacksun

Do I have to stop / restart pihole or the Database when performing the script? (how?)
Do I have to stop / restart pihole or the db-system when I make a backup of the file?

Better to do so

sudo service pihole-FTL stop
sudo service pihole-FTL start

@blacksun

You wrote whitelist.
I think this is "type=0", right?
Is type=1 for blacklist?

0 = exact whitelist,
1 = exact blacklist,
2 = regex whitelist,
3 = regex blacklist

from
https://docs.pi-hole.net/database/gravity/#domain-tables-domainlist