############################################################################
# You are planning to update Pi.Alert. Please make sure that no scan takes #
# place during the update to avoid possible database errors afterwards!!! #
# #
# This can be done by pausing Pi.Alert (at least 10min) via the settings #
# page. If the script does not correctly recognize that a scan is no #
# longer running, the update can be forced with “f”. Scans that are #
# already running will be terminated, which could lead to database errors. #
############################################################################
Press enter to retry or press 'F' to force the update
############################################################
Pi.Alert Update
############################################################
Sat Aug 15 03:03:27 BST 2026
Logfile: pialert_update_2026-08-15_03-03.log
- Checking Python...
Python 3 is installed on your system
- mac-vendor-lookup is already installed
- fritzconnection is already installed
- routeros_api is already installed
- pyunifi is already installed
- openwrt-luci-rpc is already installed
- asusrouter is already installed
- paho-mqtt is already installed
- Stopping Pi.Alert...
No timeout is set. Pi.Alert restarts itself with the next scan after 10min.
arp-scan: no process found
Pi.Alert v2026-05-07
---------------------------------------------------------
Executing user: root
Test Reporting...
Skip mail...
Skip PUSHSAFER...
Skip PUSHOVER...
Skip Telegram...
Sending report by NTFY...
Skip Discord...
Save report to file...
DONE!!!
Configured Pi.Alert scans are disabled
- Reset permissions...
- Deleting previous Pi.Alert backups...
- Creating new Pi.Alert backup...
...........................................................................................
- Cleaning previous version...
- Checking packages...
- Checking package integrity...
- 'arp-scan' seems to be installed correctly
- Downloading update file...
/opt/pialert_latest.tar 100%[=================================================>] 68.42M 35.6MB/s in 1.9s
- Uncompressing tar file
.....................................................................
- Deleting downloaded tar file...
- Generate autocomplete file...
- Copy autocomplete file...
- Config backup...
- Updating config file...
- Create user_vendors.txt if not exists...
- 'user_vendors.txt' already exists
- Updating DB permissions...
- Installing sqlite3...
- Set Permissions...
- Create Logfiles...
- Set sudoers...
- Patch DB...
################################################################################
# You are planning to update the Pi.Alert DB. Please make sure that no scan #
# takes place during the update to avoid possible database errors afterwards! #
# #
# This can be done by pausing the Arp scan via the settings page. However, #
# scans that are already running will not be terminated. For more information, #
# check the Help/FAQ section in Pi.Alert #
# #
# Press STRG+C to Abort #
################################################################################
Press enter to continue
Update DB /opt/pialert/back/../db/pialert.db
Purge old db backup
...Create backup before insert new table
...Insert new table 'Fritzbox_Network' to DB
...Insert new table 'Mikrotik_Network' to DB
...Insert new table 'Unifi_Network' to DB
...Insert new table 'Nmap_DHCP_Server' to DB
...Insert new table 'pialert_journal' to DB
...Insert new column 'dev_Model' to table 'Devices' to DB
Column 'dev_Model' already exists in the 'Devices' table.
...Insert new column 'dev_Serialnumber' to table 'Devices' to DB
Column 'dev_Serialnumber' already exists in the 'Devices' table.
...Insert new column 'dev_ConnectionType' to table 'Devices' to DB
Column 'dev_ConnectionType' already exists in the 'Devices' table.
...Insert new table 'ICMP_Mon' to DB
...Insert new table 'ICMP_Mon_CurrentScan' to DB
...Insert new table 'ICMP_Mon_Events' to DB
...Insert new column 'mon_ssl_subject' to table 'Services' to DB
Column 'mon_ssl_subject' already exists in the 'Services' table.
...Insert new column 'mon_ssl_issuer' to table 'Services' to DB
Column 'mon_ssl_issuer' already exists in the 'Services' table.
...Insert new column 'mon_ssl_valid_from' to table 'Services' to DB
Column 'mon_ssl_valid_from' already exists in the 'Services' table.
...Insert new column 'mon_ssl_valid_to' to table 'Services' to DB
Column 'mon_ssl_valid_to' already exists in the 'Services' table.
...Insert new column 'mon_ssl_fc' to table 'Services' to DB
Column 'mon_ssl_fc' already exists in the 'Services' table.
...Insert new column 'cur_ssl_subject' to table 'Services_CurrentScan' to DB
Column 'cur_ssl_subject' already exists in the 'Services_CurrentScan' table.
...Insert new column 'cur_ssl_issuer' to table 'Services_CurrentScan' to DB
Column 'cur_ssl_issuer' already exists in the 'Services_CurrentScan' table.
...Insert new column 'cur_ssl_valid_from' to table 'Services_CurrentScan' to DB
Column 'cur_ssl_valid_from' already exists in the 'Services_CurrentScan' table.
...Insert new column 'cur_ssl_valid_to' to table 'Services_CurrentScan' to DB
Column 'cur_ssl_valid_to' already exists in the 'Services_CurrentScan' table.
...Insert new column 'cur_ssl_fc' to table 'Services_CurrentScan' to DB
Column 'cur_ssl_fc' already exists in the 'Services_CurrentScan' table.
...Insert new column 'moneve_ssl_fc' to table 'Services_Events' to DB
Column 'moneve_ssl_fc' already exists in the 'Services_Events' table.
...Insert new column 'Data_Source' to table 'Online_History' to DB
Column 'Data_Source' already exists in the 'Online_History' table.
...Insert new column 'icmp_Archived' to table 'ICMP_Mon' to DB
Column 'icmp_Archived' already exists in the 'ICMP_Mon' table.
...Insert new column 'dev_LinkSpeed' to table 'Devices' to DB
Column 'dev_LinkSpeed' already exists in the 'Devices' table.
...Insert new column 'cur_ScanSource' to table 'CurrentScan' to DB
Column 'cur_ScanSource' already exists in the 'CurrentScan' table.
...Insert new table 'Satellites' to DB
...Insert new column 'dev_ScanSource' to table 'Devices' to DB
Column 'dev_ScanSource' already exists in the 'Devices' table.
...Insert new table 'Satellites_Network' to DB
...Insert new column 'sat_remote_version' to table 'Satellites' to DB
Column 'sat_remote_version' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_arp' to table 'Satellites' to DB
Column 'sat_conf_scan_arp' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_fritzbox' to table 'Satellites' to DB
Column 'sat_conf_scan_fritzbox' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_mikrotik' to table 'Satellites' to DB
Column 'sat_conf_scan_mikrotik' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_unifi' to table 'Satellites' to DB
Column 'sat_conf_scan_unifi' already exists in the 'Satellites' table.
...Insert new column 'sat_host_data' to table 'Satellites' to DB
Column 'sat_host_data' already exists in the 'Satellites' table.
...Insert new column 'dev_PresencePage' to table 'Devices' to DB
Column 'dev_PresencePage' already exists in the 'Devices' table.
...Insert new column 'par_Long_Value' to table 'Parameters' to DB
Column 'par_Long_Value' already exists in the 'Parameters' table.
...Insert new column 'sat_conf_scan_openwrt' to table 'Satellites' to DB
Column 'sat_conf_scan_openwrt' already exists in the 'Satellites' table.
...Insert new column 'net_networkname' to table 'network_infrastructure' to DB
Column 'net_networkname' already exists in the 'network_infrastructure' table.
...Insert new table 'ICMP_Mon_Connections' to DB
...Insert new column 'dev_Scan_Validation' to table 'Devices' to DB
Column 'dev_Scan_Validation' already exists in the 'Devices' table.
...Insert new column 'dev_Scan_Validation_State' to table 'Devices' to DB
Column 'dev_Scan_Validation_State' already exists in the 'Devices' table.
...Insert new column 'icmp_Scan_Validation' to table 'ICMP_Mon' to DB
Column 'icmp_Scan_Validation' already exists in the 'ICMP_Mon' table.
...Insert new column 'icmp_Scan_Validation_State' to table 'ICMP_Mon' to DB
Column 'icmp_Scan_Validation_State' already exists in the 'ICMP_Mon' table.
...Insert new column 'sat_conf_scan_pihole_net' to table 'Satellites' to DB
Column 'sat_conf_scan_pihole_net' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_pihole_dhcp' to table 'Satellites' to DB
Column 'sat_conf_scan_pihole_dhcp' already exists in the 'Satellites' table.
...Insert new table 'Openwrt_Network' to DB
...Insert new table 'Asuswrt_Network' to DB
...Insert new column 'sat_conf_scan_asuswrt' to table 'Satellites' to DB
Column 'sat_conf_scan_asuswrt' already exists in the 'Satellites' table.
...Insert new column 'icmp_vendor' to table 'ICMP_Mon' to DB
Column 'icmp_vendor' already exists in the 'ICMP_Mon' table.
...Insert new column 'icmp_model' to table 'ICMP_Mon' to DB
Column 'icmp_model' already exists in the 'ICMP_Mon' table.
...Insert new column 'icmp_serial' to table 'ICMP_Mon' to DB
Column 'icmp_serial' already exists in the 'ICMP_Mon' table.
...Insert new column 'mon_AlertUp' to table 'Services' to DB
Column 'mon_AlertUp' already exists in the 'Services' table.
...Insert new column 'cur_AlertUp' to table 'Services_CurrentScan' to DB
Column 'cur_AlertUp' already exists in the 'Services_CurrentScan' table.
...Insert new table 'pfsense_Network' to DB
...Insert new table 'opnsense_Network' to DB
...Insert new table 'AdGuard_Network' to DB
...Insert new table 'AdGuard_Activity' to DB
...Insert new column 'sat_conf_scan_pfsense' to table 'Satellites' to DB
Column 'sat_conf_scan_pfsense' already exists in the 'Satellites' table.
...Insert new table 'Log_History_Cleanup' to DB-Tools
...Insert new table 'Log_History_InternetIP' to DB-Tools
...Insert new table 'Log_History_Nmap' to DB-Tools
...Insert new table 'Log_History_Scan' to DB-Tools
...Insert new table 'Log_History_Speedtest' to DB-Tools
...Insert new table 'Log_History_Vendors' to DB-Tools
...Insert new table 'Log_History_WebServices' to DB-Tools
...Insert new table 'Tools_Nmap_ManScan' to DB
...Insert new table 'Tools_Nmap_Queue' to DB-Tools
...Insert new table 'Tools_Nmap_Schedule' to DB-Tools
...Insert new table 'Tools_Speedtest_History' to DB
...Create index on Services_Events (DateTime)
...Insert new table 'Services_Events_Journal' to DB
...Create index on Services_Events_Journal (URL + DateTime)
...Insert new column 'dev_MQTTDevice' to table 'Devices' to DB
Column 'dev_MQTTDevice' already exists in the 'Devices' table.
...Insert new column 'dev_MQTTDevice_cleanup' to table 'Devices' to DB
Column 'dev_MQTTDevice_cleanup' already exists in the 'Devices' table.
...Insert new column 'icmp_MQTTDevice' to table 'ICMP_Mon' to DB
Column 'icmp_MQTTDevice' already exists in the 'ICMP_Mon' table.
...Insert new column 'icmp_MQTTDevice_cleanup' to table 'ICMP_Mon' to DB
Column 'icmp_MQTTDevice_cleanup' already exists in the 'ICMP_Mon' table.
...Insert new column 'sat_conf_scan_opnsense' to table 'Satellites' to DB
Column 'sat_conf_scan_opnsense' already exists in the 'Satellites' table.
...Insert new column 'sat_conf_scan_adguard' to table 'Satellites' to DB
Column 'sat_conf_scan_adguard' already exists in the 'Satellites' table.
Update finished!
- Starting Pi.Alert...
[Config] Invalid configuration: REPORT_FROM contains a disallowed expression
Configured Pi.Alert scans are enabled
- Testing Pi.Alert HW vendors database update process...
*** PLEASE WAIT A COUPLE OF MINUTES...
[Config] Invalid configuration: REPORT_FROM contains a disallowed expression
- Testing Pi.Alert Internet IP Lookup...
[Config] Invalid configuration: REPORT_FROM contains a disallowed expression
- Testing Pi.Alert Network scan...
*** PLEASE WAIT A COUPLE OF MINUTES...
[Config] Invalid configuration: REPORT_FROM contains a disallowed expression
------------------------------------------------------------
Update process finished
------------------------------------------------------------
Trying to update to the latest version: