You can also look at the network table in the pihole-FTL.db, using this addon to pihole (customizing pihole - Browsing the FTL database).
- password: admin
- select the database: /etc/pihole/pihole-FTL.db
- select
network
edit
If you try to edit or delete a record, you get the following error message:
NOT a bug, it requires you to set the proper permissions on both the database (/etc/pihole/pihole-FTL.db) and the folder (/etc/pihole), reason: The database-file itself must be writable, and, to write into it, the containing directory needs to be writable as well. This is because SQLite puts temporary files in there for locking.
@DL6ER Question(s):
- How to find out witch user is actually accessing the file and folder.
- What is the best way to allow this user (web application) access to the file and folder
P.S. applying 777 to the folder and 666 to the file allows the web application to write to the database, but I assume this is NOT the proper way to do this, hence the questions.
Thanks for your time and effort.
/edit