Deleting satellite mesh node IPs from database - did work, but not with FTL v5.14

[yubiuser]

@tristanc

I altered the script to be as below. The change is to delete the specific IP from the client_by_id table instead of the queries table.

While your script does delete the client from this table it does not delete the queries the client has made. Additionally, if the client makes the next query, it will be re-added, only with an increased id.

Have a look here how to really delete the queries with the new database schema:

Delete queries error

With the latest version the database schema has changed. The actual data is stored in the new table query_storage. The queries is a view only from which you can't delete queries anymore. Furthermore, the client information is not stored in query_storage as IP but rather an ID linked to the new client_by_id table. You need to do two things now: sqlite3 /etc/pihole/pihole-FTL.db "DELETE FROM query_storage WHERE client='192.168.10.51';" To delete the remaining queries for 192.168.10.51 before th…