"No new subdomains to added"

[jamescnj1]

After installing, I run service ytadsblocker status to ensure that the service is running. That returns

● ytadsblocker.service - Youtube ads blocker service for Pi-hole
     Loaded: loaded (/lib/systemd/system/ytadsblocker.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Fri 2022-09-16 22:22:09 EDT; 4min 10s ago
    Process: 11770 ExecStart=/home/pi/ytadsblocker/ytadsblocker.sh -a start (code=exited, status=1/FAILURE)
   Main PID: 11770 (code=exited, status=1/FAILURE)
        CPU: 221ms

Sep 16 22:22:08 raspberrypi systemd[1]: Started Youtube ads blocker service for Pi-hole.
Sep 16 22:22:09 raspberrypi ytadsblocker.sh[11770]: Youtube Ads Blocker Started
Sep 16 22:22:09 raspberrypi ytadsblocker.sh[11770]: Check the /var/log/ytadsblocker.log file to get further information.
Sep 16 22:22:09 raspberrypi ytadsblocker.sh[11770]: [✗] The YTADSBLOCKER group ID does not exists in the database.
Sep 16 22:22:09 raspberrypi systemd[1]: ytadsblocker.service: Main process exited, code=exited, status=1/FAILURE
Sep 16 22:22:09 raspberrypi systemd[1]: ytadsblocker.service: Failed with result 'exit-code'.

I checked /var/log/ytadsblocker.log, which says

./ytadsblocker.sh: line 96: sqlite3: command not found
[2022-09-16 18:50:55] Youtube Ads Blocker Started
./ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 18:52:00] Youtube Ads Blocker Started
./ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 20:24:04] Youtube Ads Blocker Started
./ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 20:29:20] Youtube Ads Blocker Started
/home/pi/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 20:29:59] Youtube Ads Blocker Started
/home/pi/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 20:41:31] Youtube Ads Blocker Started
/home/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
./ytadsblocker.sh: line 118: sqlite3: command not found
./ytadsblocker.sh: line 118: sqlite3: command not found
[2022-09-16 21:00:02] Youtube Ads Blocker Started
/home/scripts/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 21:44:17] Youtube Ads Blocker Started
/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 21:48:08] Youtube Ads Blocker Started
/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 21:52:26] Youtube Ads Blocker Started
/ytadsblocker/ytadsblocker.sh: line 112: sqlite3: command not found
[2022-09-16 21:59:39] Youtube Ads Blocker Started

To solve this problem, I went into the Pihole admin UI ([pihole IP]/admin/groups.php) and created a group with the ID "YTADSBLOCKER"
I restarted the service and got the following:

● ytadsblocker.service - Youtube ads blocker service for Pi-hole
     Loaded: loaded (/lib/systemd/system/ytadsblocker.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2022-09-16 22:30:56 EDT; 2s ago
   Main PID: 11896 (ytadsblocker.sh)
      Tasks: 6 (limit: 415)
        CPU: 2.322s
     CGroup: /system.slice/ytadsblocker.service
             ├─11896 /bin/bash /home/pi/ytadsblocker/ytadsblocker.sh -a start
             ├─11912 /bin/bash /home/pi/ytadsblocker/ytadsblocker.sh -a start
             ├─11913 cat /var/log/pihole.log
             ├─11914 grep -E --only-matching
             ├─11915 sort
             └─11916 uniq

Sep 16 22:30:56 raspberrypi systemd[1]: Started Youtube ads blocker service for Pi-hole.
Sep 16 22:30:57 raspberrypi ytadsblocker.sh[11896]: Youtube Ads Blocker Started
Sep 16 22:30:57 raspberrypi ytadsblocker.sh[11896]: Check the /var/log/ytadsblocker.log file to get further information.

/var/log/ytadsblocker.log returned the following:

[2022-09-16 22:30:57] Youtube Ads Blocker Started
[2022-09-16 22:30:57] Checking /var/log/pihole.log...
[2022-09-16 22:32:02] No new subdomains to added.
[2022-09-16 22:37:02] Checking /var/log/pihole.log...
[2022-09-16 22:38:06] No new subdomains to added.

This appeared to be normal behavior, but YT ads were not being blocked. So I added my device to the YTADSBLOCKER group through the Pihole admin interface. Ads were still being served, so I updated to the aggressive installation. Ads continue to be served, with ytadsblocker.log returning " No new subdomains to added."