search

leiweibau / Pi.Alert

Scan the devices connected to your WIFI / LAN and alert you the connection of unknown devices. It also warns if a "always connected" device disconnects. In addition, it is possible to check web services for availability. For this purpose HTTP status codes and the response time of the service are evaluated.
https://leiweibau.net
GNU General Public License v3.0
406 stars 28 forks source link

[Documentation] Document changes to the way the "set_permissions" function works #197

Closed leiweibau closed 10 months ago

leiweibau commented 10 months ago

I have broken my previously working installation. I backed up my config and db and copied them off. I then did a clean install of Raspberry PiOs Bookworm on my pi 4B I reinstalled Pi-hole I reinstalled pi.Alert. Copied back pialert.conf and pialert.db. Permissions in pialert/db were: drwxrwxr-x 3 pi www-data 4096 Oct 14 09:07 . drwxr-xr-x 9 pi pi 4096 Oct 7 13:45 .. -rwxrwxr-x 1 pi pi 1974272 Oct 11 20:56 pialert.db -rw-r--r-- 1 www-data www-data 308090 Oct 12 09:10 pialertdb_20231012_081010.zip -rwxrwxr-x 1 pi www-data 253952 Oct 11 23:25 pialert.db.bak -rwxrwxr-x 1 www-data www-data 32768 Oct 14 08:15 pialert.db-shm -rwxrwxr-x 1 www-data www-data 0 Oct 11 23:28 pialert.db-wal -rw-r--r-- 1 www-data www-data 169 Oct 12 09:11 setting_devicelist -rw-r--r-- 1 www-data www-data 0 Oct 11 23:38 setting_noonlinehistorygraph -rw-r--r-- 1 pi pi 3 Oct 14 09:07 setting_stoppialert drwxrwxr-x 2 pi www-data 4096 Oct 12 09:10 temp

Changed (with no effect ) pialert.db to www-data:www-data Ran ./pialert-cli set_permissions in pialert/back with no effect My database in readonly. How do I fix it? On the settings page it say after a restore, make an integrity check on the database for safety. How?

Doh!! its pi:www-data not www-data:www-data on pialert.db

I can now update pialert but the question still stands. How do I make a recommended integrity check on the database. Found it. Disable scan and then: sqlite3 pialert.db "PRAGMA integrity_check" sqlite3 pialert.db "PRAGMA foreign_key_check"

Is it worth putting these steps in a document someplace. I am sure a lot of users will be going through this with the release of PiOs Bookworm.

Originally posted by @JYewdall in https://github.com/leiweibau/Pi.Alert/discussions/193

leiweibau commented 10 months ago

Points to address (Docs and Help/FAQ):

leiweibau commented 10 months ago

Update Released with https://github.com/leiweibau/Pi.Alert/commit/b1835a6dc7fd09c8b5759ff0995f2fd5d414cdeb