Es läuft in einem Docker Container :
pialert:
container_name: pialert
# use the below line if you want to test the latest dev image
# image: "jokobsk/pi.alert_dev:latest"
image: "jokobsk/pi.alert:latest"
network_mode: "host"
restart: unless-stopped
volumes:
- /home/pi/smarthome/pialert/config:/home/pi/pialert/config
- /home/pi/smarthome/pialert/db:/home/pi/pialert/db
# (optional) useful for debugging if you have issues setting up the container
- /home/pi/smarthome/pialert/front/log:/home/pi/pialert/front/log
- /home/pi/smarthome/pihole/pihole-FTL.db:/etc/pihole/pihole-FTL.db
- /home/pi/smarthome/pialert/front/api:/home/pi/pialert/front/api
environment:
- TZ=Europe/Berlin
- HOST_USER_ID=1000
- HOST_USER_GID=1000
- PORT=20211
ions
mkdir: cannot create directory '/run/php': File exists
Starting nginx: nginx.
Traceback (most recent call last):
File "/usr/lib/python3.9/runpy.py", line 197, in _run_module_as_main
return _run_code(code, main_globals, None,
File "/usr/lib/python3.9/runpy.py", line 87, in _run_code
exec(code, run_globals)
File "/home/pi/pialert/pialert/__main__.py", line 179, in <module>
sys.exit(main())
File "/home/pi/pialert/pialert/__main__.py", line 98, in main
pluginsState = run_plugin_scripts(db, 'once')
File "/home/pi/pialert/pialert/plugin.py", line 136, in run_plugin_scripts
pluginsState = execute_plugin(db, plugin, pluginsState)
File "/home/pi/pialert/pialert/plugin.py", line 374, in execute_plugin
pluginsState = process_plugin_events(db, plugin, pluginsState, sqlParams)
File "/home/pi/pialert/pialert/plugin.py", line 588, in process_plugin_events
raise e
File "/home/pi/pialert/pialert/plugin.py", line 531, in process_plugin_events
sql.executemany(
sqlite3.IntegrityError: NOT NULL constraint failed: Plugins_Objects.Watched_Value1
19:26:42 [MAIN] Setting up ...
19:26:42 [conf.tz] Setting up ...
19:26:42 The container restarted (started). If this is unexpected check https://bit.ly/PiAlertDebug for troubleshooting tips.
19:26:42 Permissions check (All should be True)
19:26:42 ------------------------------------------------
19:26:42 /config/pialert.conf | READ | True
19:26:42 /config/pialert.conf | WRITE | True
19:26:42 /db/pialert.db | READ | True
19:26:42 /db/pialert.db | WRITE | True
19:26:42 ------------------------------------------------
19:26:42 [Setup] Attempting to fix permissions.
19:26:42 [Setup] Attempting to fix permissions.
19:26:42 [Database] Opening DB
19:26:42 [upgradeDB] Re-creating Settings table
19:26:42 [upgradeDB] Re-creating Pholus_Scan table
19:26:42 [upgradeDB] Re-creating Parameters table
19:26:42 [Config] reading config file
19:26:42 [Config] Plugins: Number of dynamically loaded plugins: 17
19:26:42 [Plugins] ---------------------------------------------
19:26:42 [Plugins] display_name: SNMP discovery
19:26:42 [Plugins] description: This plugin is used to discover devices via the arp table(s) of a RFC1213 compliant router or switch.
19:26:42 [Plugins] ---------------------------------------------
19:26:42 [Plugins] display_name: DB cleanup
19:26:42 [Plugins] description: A plugin to schedule database cleanup & upkeep tasks.
19:26:42 [Plugins] ---------------------------------------------
19:26:42 [Plugins] display_name: Vendor update
19:26:42 [Plugins] description: A plugin to schedule vendor database updates for mac based vendor resolution.
19:26:43 [Plugins] ---------------------------------------------
19:26:43 [Plugins] display_name: DHCP Leases (Device import)
19:26:43 [Plugins] description: This plugin is to import devices from dhcp.leases files.
19:26:43 [Plugins] ---------------------------------------------
19:26:43 [Plugins] display_name: Internet check
19:26:43 [Plugins] description: A plugin to check your internet connectivity and IP.
19:26:43 [Plugins] ---------------------------------------------
19:26:43 [Plugins] display_name: UniFi import
19:26:43 [Plugins] description: This plugin is used to import devices from an UNIFI controller.
19:26:43 [Plugins] ---------------------------------------------
19:26:43 [Plugins] display_name: DDNS update
19:26:43 [Plugins] description: A plugin update the DDNS record.
19:26:43 [Plugins] ---------------------------------------------
19:26:43 [Plugins] display_name: PiHole (Device sync)
19:26:43 [Plugins] description: This plugin syncs devices from the PiHole database
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Website monitor
19:26:44 [Plugins] description: This plugin is to monitor status changes of services or websites.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: New Devices
19:26:44 [Plugins] description: The template used for new devices.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Pholus-Scan (Name discovery)
19:26:44 [Plugins] description: This plugin is to execute a Pholus-scan (name discovery) on the local network
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Rogue DHCP
19:26:44 [Plugins] description: This plugin is to use NMAP to monitor for rogue DHCP servers.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: CSV backup
19:26:44 [Plugins] description: A plugin to auto-generate devices.csv backups.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Services & Ports (NMAP)
19:26:44 [Plugins] description: This plugin shows all services discovered by NMAP scans.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Un-Discoverable Devices
19:26:44 [Plugins] description: This plugin is to import undiscoverable devices from a file.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Set password
19:26:44 [Plugins] description: A simple plugin to set the web ui password on app start.
19:26:44 [Plugins] ---------------------------------------------
19:26:44 [Plugins] display_name: Arp-Scan (Network scan)
19:26:44 [Plugins] description: This plugin is to execute an arp-scan on the local network
19:26:45 [API] Updating table_settings.json file in /front/api
19:26:45 [Config] Imported new config
19:26:45 [Plugins] ---------------------------------------------
19:26:45 [Plugins] display_name: PiHole (Device sync)
19:26:45 [Plugins] Executing: SELECT n.hwaddr AS Object_PrimaryID, 'null' AS Object_SecondaryID, datetime() AS DateTime, na.ip AS Watched_Value1, n.lastQuery AS Watched_Value2, na.name AS Watched_Value3, n.macVendor AS Watched_Value4, 'null' AS Extra, n.hwaddr AS ForeignKey FROM EXTERNAL_PIHOLE.Network AS n LEFT JOIN EXTERNAL_PIHOLE.Network_Addresses AS na ON na.network_id = n.id WHERE n.hwaddr NOT LIKE 'ip-%' AND n.hwaddr <> '00:00:00:00:00:00';
19:26:45 [Plugins] SUCCESS, received 12 entries
19:26:45 [Plugins] Error: NOT NULL constraint failed: Plugins_Objects.Watched_Value1