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
334 stars 25 forks source link

[Bug] Initial database was missing #294

Closed xxLexanixx closed 2 months ago

xxLexanixx commented 2 months ago

There are no devices from my network in the list. The log file shows the following error

Pi.Alert v2024-04-14

Executing user: root

Scan Devices Timestamp: 2024-04-15 09:00:00

Prepare Scan... Force file permissions on Pi.Alert db... DB permission mask: 775 DB Owner and Group: root:www-data Traceback (most recent call last): File "/root/pialert/back/pialert.py", line 3088, in sys.exit(main())
^^^^^^ File "/root/pialert/back/pialert.py", line 95, in main res = scan_network() ^^^^^^^^^^^^^^ File "/root/pialert/back/pialert.py", line 668, in scan_network scanCycle_data = query_ScanCycle_Data (True) ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/root/pialert/back/pialert.py", line 784, in query_ScanCycle_Data sql.execute ("""SELECT cic_arpscanCycles, cic_EveryXmin sqlite3.OperationalError: no such table: ScanCycles

leiweibau commented 2 months ago

Hello,

Update or new install?

xxLexanixx commented 2 months ago

new install the premission on the db is correctly image

leiweibau commented 2 months ago

I have just realized with horror that the database folder is empty, because the database should be larger than 4kb. I will fix this in the next 1-2 hours.

xxLexanixx commented 2 months ago

Thanks!

leiweibau commented 2 months ago

Can you try it again? I mean a new installation

leiweibau commented 2 months ago

I have just done a new installation. The problem should be solved.