Hey there!

Friendly reminder: Mothers day is around the corner 💐🌷

On completely unrelated news - a new version of NetAlertX is here! 🧑‍🚀🚀

You know who's amazing? YOU - the community - and that's the only way this app will become sustainable (unless suddenly I can quit my real job 😅). For example @ulrichwisser implemented a new way to clean device names, over in the Weblate online portal you contributed to 🌏 Chinese (@onebest1 🙏), Polish ( @IsuckPOTATO 🙏), Italian ( @mapi68, @SirAfino 🙏), & Portuguese (Brazil) language translations, and helped out in discussions and on various issues (thanks @fcschow for spotting bugs 🐛) . I also thought - Do you want a community portal?

Now to some feature highlights.

You can now use a new NMAP scan plugin 🚀 (@stevenengland, @vladaurosh 🙏 for helping). This one might be great to complement your ARPSCAN scanner if you have devices offline, that should be detected as online.

There are over a 100 settings to fine-tune the app, and that granularity is amazing, but sometimes it's hard to find what you are looking for. You can now filter the settings page 🔍 to find the one setting you are after faster.

Annoyed by changing lists in Settings - because there is a typo and no way to fix it inline? Not anymore - all list settings, such as Subnets, can be edited with single and double-click actions 1x 📝| 2x 🚮.

I tried also addressing various cache/loading issues so I hope this release improves on that as well. Still, you might need to refresh your browser cache - and click the 🔄 refresh button in the top right corner, but I hope this will be less required in the future.

And there is more - just check the details below ⤵️

Screenshots

💔 Breaking changes

Sometimes I have to introduce breaking changes

• pialert-cli was retired and passwords are managed via the Settings UI

🏘️ Community

• Help @aries223 to configure vlans #654
• Do you want a community portal?

📚Docs updates

• A new guide explaining Notifications (🆕)
• Enhancements to the MQTT plugin docs with payload examples (🚑)

⚙Settings

• Three new MQTT settings (MQTT_DEVICE_NAME, MQTT_DEVICE_ID, MQTT_PRESENCE_SENSOR_TYPE) to adjust the messages sent to the broker #572 #639 #664 (🚑, 🆕)
• I moved the SCAN_SUBNETS settings to the General section as most users will need to edit it and the setting is used across multiple plugins (🚑)
• A new NEWDEV_LESS_NAME_CLEANUP setting to leave discovered names more intact by @ulrichwisser 🙏 (🆕)

🔌Plugins

• New NMAPDEV device discovery plugin using NMAP for scanning which should more reliably detect the online/offline state #645 (🆕)
• Resetting the password is working again #634 (🚑)
• The DHCPLSS plugin now also supports the dnsmasq dhcp.leases files format #661 (🆕)
• The VNDRPDT plugin wasn't updating the vendor database since the Alpine re-base (🚑)

🖼 UI

• Edit/Delete 1x 📝| 2x 🚮 support on list items in Settings (🆕)
• Chinese, Polish & Portuguese (Brazil) language translation start > Help translating in Weblate online portal (🆕)
• Select all / Remove all devices in multi-edit (🆕)
• UI Settings refresh improvements (🚑)
• Special characters (e.g. #) in some device fields were causing issues #644 (🚑)
• Settings filter (🆕)
• Mass-edit icons could cause loading issues #660 (🚑)

Other Info

Previous releases:

https://github.com/jokob-sk/NetAlertX/releases

Full Changelog: v24.5.9...v24.5.9

New stuff arrived 🎁

I hope you like the new name and logo. 😅

After thinking for about a year about it I decided to rename the project to 🚀NetAlertX. This will help prevent confusion about which fork someone is using, and differentiate it from the now stale upstream project. With about 1800 or so commits over the stale project, I thought, this project deserved a new name. It will also remove the confusion about only supporting Raspberry Pi's 😵

On top of the rename, I implemented ✨unlimited icons - just find an SVG you like and use it 😄. Migrating existing icons and making the UI play nicely with the change took some effort, but it should be working smoothly now. There are also a couple of UI tweaking settings, so check out the changes below. 🔽

A shout-out to @vladaurosh for quickly helping as I'm sometimes blind and thanks to @wintergew for some UI tweaks. 🙏 There was also @zilvernet who reported a bunch of issues and tested the new icon functionality 👍 Oh and @YoSafeguard added a full Russian translation 🌍💪

Please read the below carefully, but in general, I hope the transition will be smooth and should be mostly fully automated.

Screenshots

💔 Breaking changes

Sometimes I have to introduce breaking changes

The rename from PiAlert to NetAlertX should be pretty straightforward and existing setups should work fine. Still, caution is recommended. On a high-level this is what has changed:

• Existing configuration, database and devices should automatically come over without issues.
• I will keep updating the pi.alert docker hub image for now, but aim to retire it by the end of the year
• device name & manufacturer in the MQTT messages and sensors (HomeAssistant) changed from PiAlert to NetAlertX
• app or netalertx (NetAlertX) prefixes and names are used instead of pialert
• If you mapped/mounted any other folders, make sure you change the base mounting location as per the Migration guide.

🏘️ Community

• What version of Raspberry PI is needed to run the bare-metal install?
• Can you help me develop an Asus router plugin or Mikrotik devices?
• Someone requested an Italian translation so if you speak it - help out if you can (Norwegian & French need also some help)(🧪)

📚Docs updates

• A new migration guide from PiAlert to NetAlertX (🆕)
• Re-written Icons documentation (🆕)

⚙Settings

• You can configure to hide some sections in the Devices page via the UI_DEV_SECTIONS setting #612 (🆕)
• Set the UI_REFRESH setting to auto-refresh the UI #614 (🆕)
• You can now specify a pre-defined list of icons via the UI_ICONS (🆕)

🔌Plugins

• Un-discoverable devices are now always marked as Online #617 (🆕)

🖼 UI

• Support of SVG icons (🆕)
• You can now set the UI to auto-reload if you are running NetAlert in a kiosk-like setup #614 (🆕)
• Further revamp of the navigation (🚑)
• A ticker is displayed if you are using old PiAlert mount locations (🚑)
• The < > arrows were not cycling thru the filtered results #627 (🚑)
• The Tools tab didn't use the correct IP address if you navigated via the < > on the device details #626 (🚑)
• Pro Font Awesome icons mounted into the container work again #594 (🚑)
• Russian translation by @YoSafeguard (🆕)

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• The container timezone was different from the app's timezone #599 (🚑)
• The detailed NMAP scan didn't work due to a missing package #623 (🚑)

Other Info

Previous releases:

https://github.com/jokob-sk/NetAlertX/releases

What's Changed

• Improve chmod in setup.sh by @vladaurosh in #600
• Removed duplicate manifest tag by @ameer1234567890 in #605
• Design improvements by @wintergew in #619
• Update Dockerfile with nmap-scripts by @vladaurosh in #625

New Contributors

• @ameer1234567890 made their first contribution in #605
• @wintergew made their first contribution in #619

Full Changelog: v24.3.19...v24.4.17

Hey everyone 👋, I have some updates to share!

@vladaurosh made a huge contribution with a rebase to Alpine💪🏔 This should make things run smoother and the image is over 70% smaller. I might need a bit of help ironing out any issues in the bare-metal scripts. If you are using those, please help out if you can.

I've spent time updating the UI with better navigation 🧭 and a simple multi-device edit ✏ function. I've beefed up the docs with backup tips 💾 and the community kicked off translations for Russian, Norwegian, and French 🌎. There are some handy new features for devs to play with, like a nifty docker environment variable for resetting instances or dropdowns populated with SQL queries.

Plus, I want your input! Head over here and let me know if you prefer network independence with self-hosting or if you're all about having options in the next icon pack. Voting closes in a week 🗳

There might be some 💔 Breaking changes depending on your setup, so check them out below.

Keep the feedback coming - I'm all ears!

Screenshots

💔 Breaking changes

Sometimes I have to introduce breaking changes - it breaks my heart, but we must move forward

• Due to the rebase to Alpine the bare-metal scripts may need some debugging and fixes. I did my best and the installation is running, but someone might need to help to make sure PHP/nginx is set up appropriately.
• There are now 2 NGINX files for PiAlert, one for the bare-metal Debian install (pialert.debian.conf), and one for the docker container (pialert.template.conf). Both can be found in the install folder. Map or use the one appropriate for your setup.
• This version has changed the behavior of how the ownership of the /config and /db folders is handled. There's no need to set owner and group for those directories, as the container will change it to 101:82 as that's needed by the nginx webserver running inside. Thus the HOST_USER_ID and HOST_USER_GID variables became obsolete.

🏘️ Community

• Do you prefer being independent in self-hosting or choice in the next icon pack selection? Vote here ✅🗳

📚Docs updates

• How to approach Backups of your configuration (🆕)
• The community started translation of the core UI for Russian, Norwegian, and French. Check the progress, and contribute in Weblate. (🆕)

⚙Settings

• For development and testing, to delete the database and config folders, you can now always reset your instance on container restart using the new ALWAYS_FRESH_INSTALL docker environment variable (🆕)

🔌Plugins

• The PAHO library used for MQTT changed how messages are sent and the publisher was not working #580 (🚑)
• Pushover has now a target device setting, implemented by #588 @Schlump (🚑)

🖼 UI

• Multi-edit of common fields #571 (🆕)
• Cache expiration improvements (🚑)
• Navigation improvements with nested menus (🆕)

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• Re-base to Alpine bringing the image size down by around 70% by @vladaurosh 🙏(🆕)
• Added options_params support to dynamically populate dropdowns with database queries (🆕)

Other Info

Previous releases:

https://github.com/jokob-sk/Pi.Alert/releases

Full Changelog: jokob-sk/Pi.Alert@v24.3.19...v24.3.19

I was a bit too quick to push a release yesterday - sorry guys! 🙏

🩹 Hotfix:

• The devices list didn't populate unless the network tab was previously fully set up #568 (🚑)

Another month, another release 🥳

Thank you to @Schlump for treating a Pushover plugin. I spend time creating an NSLOOKUP plugin for better name resolution, I started on Workflows 🦺 (Event capture only - feedback here) and integrated Weblate for easier translations. Help translate and suggest languages in the online portal of Weblate - no Git experience needed (French & Norwegian in the works) - Create an account and contribute right away. Check the below details for new settings and configuration options 👇

Screenshots

🏘️ Community content

The user @liability4400 noticed an unusual entry within PiAlert, with an IP address that changed to a different one after about 5 minutes. The user wonders "Am I in danger?" Help him solve this question. 🤔

Do you want another icon pack? Feedback here on which one you'd like to see supported: #550

📚Docs updates

• A short guide on setting up Reverse DNS on AdGuard for better name discovery on your network (🆕)

⚙Settings

• The NTFY plugin now has a priority selection #553 (🆕)
• The NEWDEV plugin comes with a MAC filter #539 (🆕)
• Renamed All Devices to My Devices and added a setting UI_MY_DEVICES to select which devices based on their status to show #548 (🆕)
• You can now exclude Mac addresses from being marked as random via the UI_NOT_RANDOM_MAC setting #566 (🆕)

🔌Plugins

• New NSLOOKUP plugin for better name discovery #543 - thanks to @uldtot for the tip (🆕)
• New native PUSHOVER plugin by @Schlump 🙏 (🆕)
• Vendors were not brought over in the UNFIMP plugin #567 (🚑)

🖼 UI

• The New status now takes precedence over the Online status as per request #549 (🚑)
• German translation improvements and fixes by @leiweibau 🙏(🚑)
• New columns for Port and Connections in the Devices list to show how many Devices are connected to a Network device #556 (🚑)
• Dark theme fixes (darker loading screen overlay) (🚑)
• Small Network page fixes to always display bottom tabs no matter the screen size (🚑)

Other Info

Happy 2024! 🥳

This release enhances user control with new settings, plugins, and UI improvements, making it easier to manage notifications and integrate seamlessly with Home Assistant. Plus, enjoy experimental ARMv6 support for Raspberry Pi Zero users!

Thank you @dtech77pl @demolishedman50 @sky4055, @jordantrizz, @kurfuer, @wial88, @cristiarcaleanu for the sponsorship 🙏 - this is sometimes the motivation boost I need 💪 My sponsorship goal is to dedicate one full workday a week to this project.

Screenshots

📚Docs updates

• Added a link to a Chinese community guide: 📄 网络入侵探测器Pi.Alert (Chinese) (May 2023)
• Plugin troubleshooting

⚙Settings

• A new NTFPRCS_alert_down_time setting to specify how long in minutes to wait before a device is reported as being down #242 (🆕)
• A new NTFPRCS_new_dev_condition setting to filter out New devices from reports (🆕)
• A new NTFPRCS_event_condition setting to filter out Events from reports (🆕)
• This version renames the PIHOLE_CMD setting to PIHOLE_CMD_OLD to re-initialize the correct SQL query value. #521 (🚑)
• Ad-hoc notification/publisher execution was not working (🚑)
• This version renames the settings:
  • INCLUDED_SECTIONS setting to NTFPRCS_INCLUDED_SECTIONS to clean up the General section of the settings a bit (🚑)
  • DIG_GET_IP_ARG to INTRNT_DIG_GET_IP_ARG as the setting is used by the INTRNT plugin (🚑)
• New MQTT settings (#364 (🆕))
  • MQTT_SEND_STATS to select if overall device stats are sent to the broker
  • MQTT_SEND_DEVICES to select if specific devices are sent to the broker

🔌Plugins

• A new Notifications processing plugin ( NTFPRCS) to fine-tune how notifications are handled (🆕)
• The PIHOLE plugin was only syncing the devices once after the app restart even with a schedule selected #513 (🚑)
• Partial IP v6 support added #523 (🆕, 🚑)
• Added the scheduling option to the MQTT publisher plugin if you want to update the MQTT state more often #522 (🆕)
• Added options to select what's sent to the broker in the MQTT plugin #364 (🆕)

🖼 UI

• The dashboard of enabled settings has now clickable links to take you to the relevant setting (🆕)

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• Experimental (community supported) ARMv6 support #527 (🆕, 🧪)

Other Info

Full Changelog: jokob-sk/Pi.Alert@v23.12.16...v24.01.18

This is a release focusing on stabilizing the application ⚓Previous releases introduced a lot of changes and this is now one to focus on bug fixes and the reliability of the application. I hope I'm not overpromising 😅 I also went through the flu 😷 and a pretty stressful period at work so taking things a bit slowly.

Thanks for the patience and support 🖤

Thank you @sky4055, @jordantrizz, @kurfuer, @wial88 for the sponsorship 🙏 - this is sometimes the motivation boost I need 💪 My sponsorship goal is to dedicate one whole workday a week to this project.

Screenshots

📚Docs updates

• Added a community guides section in the installation instructions
• More detailed on-server-hardware installation instructions by @lorki97🙏

🔌Plugins

• UNFIMP didn't handle empty IP addresses correctly #508 (🚑)
• Fixed a bug in the SNMP_DISCOVERY plugin #512 (🚑)
• The SMTP_PUBLISHER plugin wouldn't send notifications if the server used SSL #518 by @LouisOb 🙏(🚑)
• HomeAssistant required a change in the MQTT publisher in sensor names, otherwise, warnings are shown #514 (🚑)
• The DHCP_LEASES plugin now checks for MAC address validity #516 (🚑)

🖼 UI

• The cycling thru devices via the arrows in the top left corner is working again #509 (🚑)
• Custom Vendor names will not be overwritten anymore #509 (🚑)
• The Devices screen now shows a Refreshing... message until fresh data is populated #509 (🆕)

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• If the timezone (TZ) setting was specified the application would always report a new version - Fixed by @mscreations 🙏 #509 (🚑)
• The experimental on-server (CURL or WGET) installation approach fixes & better docs by @orki97 🙏 #495 (🧪)

Other Info

What's Changed

• fixed typos by @jasonehines in https://github.com/jokob-sk/Pi.Alert/pull/502
• fix: Hardware installation by @lorki97 in https://github.com/jokob-sk/Pi.Alert/pull/505
• Fix date parsing for release check by @mscreations in https://github.com/jokob-sk/Pi.Alert/pull/511
• FIX unable to send mail with publisher mail plugin by @LouisOb in https://github.com/jokob-sk/Pi.Alert/pull/518

New Contributors

• @mscreations made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/511
• @LouisOb made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/518

Full Changelog: jokob-sk/Pi.Alert@v23.11.11...v23.12.16

I wanted to keep this release small and here we are 😅 judge yourself based on the below changes:

I spent a lot of time converting publishers into plugins. This unlocks a granular log of event notifications in the Plugins section with links to the actual report notification via a notification GUID. I rewrote the installation process to make it easier and maintainable. I also fit in quite a few Settings page improvements. There is a new plugin to maintain the log file too.

Thank you @ameer1234567890 (and others) who tested the pi.alert_dev image, I usually am low on energy testing all use cases so this is appreciated 🙏

Thanks to all the contributors who submitted PRs in the past few weeks!

Grateful to @sky4055, @jordantrizz, @kurfuer for their sponsorship 🙏
Sponsorship Goal: Dedicate one full workday a week to this project.

Screenshots

💔 Breaking changes

Sometimes I have to introduce breaking changes - it breaks my heart, but we must move forward

• There shouldn't be any, however, I implemented a settings rewrite method where I'm rewriting old setting names to new ones generated by the new plugins.

📚Docs updates

• Traefik reverse proxy guide added to the Reverse proxy docs with help from @cvc90 & @Isegrimm 🙏 (🆕)

⚙Settings

• Added a new dashboard to give an overview of enabled plugins and most important settings (🆕)
• Added a warning if Device scanner schedules are not synchronized #462 (🆕,🚑)
• Updated the UI and added settings sections so you can find the setting you are looking for easier (🆕,🚑)
• Added icons indicating if a Plugin is enabled (🆕)
• Triggering ad-hoc actions via Settings is working again #472 (🚑)
• A new ARPSCAN_ARGS setting to change the parameters of the arp-scan to make it faster if needed #485 (🆕)
• LISTEN_ADDR docker variable to set a specific IP Address for the listener address for the nginx webserver (web interface). This could be useful when using multiple subnets to hide the web interface from all untrusted networks by @silverbios 🙏 (🆕)

🔌Plugins

• New Internet speedtest (INTRSPD) plugin (🆕)
• New maintenance tasks (MAINT) plugin currently including the cleanup of the pialert.log file (🆕)
• Core functionality rewritten into plugins (🚑):
  • MQTT publisher
  • SMTP (Email) publisher
  • Apprise publisher
  • NTFY publisher
  • Pushsafer publisher
  • Webhook publisher
• The PIHOLE plugin isn't crashing the app but failing gracefully if misconfigured #479 (🚑)
• A bugfix by @jhonderson where the DBCLNP plugin would delete all devices marked as new #498 (🚑)

🖼 UI

• Icon preview by @ScottRoach #476 🙏 (🆕)
• The 🏳Report section has now a Notification history and an option to show the JSON and Text format (🆕)
• If the network tree topology contained less than 35 devices the node content would overflow the node box #465 (🚑 )
• Network topology improvements by @ScottRoach #475 🙏 (🚑)
• More robust error and input handling so it's easier to configure the Network tree topology #467 (🚑)
• Showing the nginx/error.log file in Maintenance > Logs to debug server-side errors (such as error 500) #483 (🆕,🚑 )
• Slightly better optimized mobile experience (🚑 )

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• Rewrote the dockerfile and installation scripts so they are used by the on-HW install option as well as Docker-install option (e.g. for potential Proxmox support 🧪⚠)
• The devices listing page now uses the JSON API endpoint (causes a slight delay in reflecting DB changes, but minimizes SQL queries and DB load) (🚑,⚠)
• Pholus name resolution looks up IP matches now as well (name contains (IP match) suffix) (🆕)
• Boolean values were not initialized correctly (e.g. NEWDEV template initialized all values as True) (🚑)

What's Changed

• Fix device types not loading in device details page by @lorki97 in https://github.com/jokob-sk/Pi.Alert/pull/466
• Include device vendor in event notifications by @ScottRoach in https://github.com/jokob-sk/Pi.Alert/pull/468
• Network cleanup by @ScottRoach in https://github.com/jokob-sk/Pi.Alert/pull/475
• Show current device icon as it changes by @ScottRoach in https://github.com/jokob-sk/Pi.Alert/pull/476
• Add missing german translations by @lorki97 in https://github.com/jokob-sk/Pi.Alert/pull/470
• Add option to set IP Address for web interface in Docker env by @silverbios in https://github.com/jokob-sk/Pi.Alert/pull/490
• Update config.json by @jasonehines in https://github.com/jokob-sk/Pi.Alert/pull/497
• Fix DB Clean plugin new devices deletion bug by @jhonderson in https://github.com/jokob-sk/Pi.Alert/pull/498

New Contributors

• @lorki97 made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/466
• @ScottRoach made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/468
• @silverbios made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/490
• @jasonehines made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/497
• @jhonderson made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/498

Full Changelog: jokob-sk/Pi.Alert@v23.10.2...v23.11.11

This version is wrapping up the conversion of important scheduled events into 17(❗) Plugins. Now you can adjust schedules for database cleanup, vendor DB updates, or Internet IP scans. And you can configure network types. 🥳

I also managed to include a couple of docs, such as the GMX SMTP guide or the webhook signatures docs by @nimec01.

Lastly, I played around and drafted an experimental 🧪 on server HW install script.

I can now hopefully focus on some open feature requests and have a closer look at the notification system.

Super grateful to @sky4055 and @jordantrizz for their sponsorship 🙏

⏳ Current Sponsorship Goal: Dedicate one full workday a week to this project.

Screenshots

Full changelog

💔 Breaking changes

Sometimes I have to introduce breaking changes - it breaks my heart, but we must move forward

• Please remove the UNFIMP_CMD setting from your pialert.conf file to re-initialize it with the new value (🚑, ⚠)

📚Docs updates

• New GMX SMTP guide ( 🆕)
• Detailed webhook signatures docs by @nimec01 (🆕)

⚙Settings

• Setting (and amazing docs) to use webhook signatures to validate that the received webhook delivery was sent by Pi.Alert (and was not changed along the way) by @nimec01 🙏 (🆕)
• A new NETWORK_DEVICE_TYPES setting to add new device types representing network nodes that can be then displayed on the Network topology page (🆕)

🔌Plugins

• A new option to import all devices vs. only online ones by @tuhriel 🙏 (🆕)
• DHCPSRVS bugfix - didn't clean past entries (🚑)
• Created new plugins for more flexibility in scheduling and maintenance for existing, previously app-entangled functionality:
  • The vendor database update into the VNDRPDT plugin (🚑, 🆕)
  • The internet IP check into the INTRNT plugin (🚑, 🆕)
  • Database cleanup moved into the DBCLNP plugin (🚑, 🆕)
  • DDNS update tasks into the DDNS plugin (🚑, 🆕)

🖼 UI

• Better UI indicator that settings are being imported and a more granular status message (🆕)

💠Core app updates

Internal changes affecting the whole app and usually significant to developers 👩‍💻👨‍💻

• Faster and less DB locks during initialization time and config and Plugin re-load by bulk-inserting language strings (🚑)
• A new app_state.json endpoint to drive the status header in the front-end of the app and to reduce DB queries and DB locks (🆕)
  • Unified the new version check to prevent backend and UI inconsistencies in reporting new versions via the new app_state.json API endpoint #458 (🚑)

What's Changed

• Added functionality to perform a full import by @tuhriel in https://github.com/jokob-sk/Pi.Alert/pull/442
• Add webhook signatures by @nimec01 in https://github.com/jokob-sk/Pi.Alert/pull/459

New Contributors

• @nimec01 made their first contribution in https://github.com/jokob-sk/Pi.Alert/pull/459

Full Changelog: jokob-sk/Pi.Alert@v23.9.12...v23.10.2

• Network topology map not loading correctly #424
• Small styling issues in the Report page #433
• Fixed setting saving on reverse proxied setups by @cvc90 🙏
• Better null handling in the DHCPLSS plugin
• Fixed the new version email template
• Hopefully correct now by @cvc90 🙏: PiHole scan has incorrect SQL query (the below has to be only done if you saved your settings on the 23.9.10 or 23.9.11 version)
  • Fix: remove the PIHOLE_CMD setting from your pialert.conf file or replace the value in the Settings page with SELECT n.hwaddr AS Object_PrimaryID, {s-quote}null{s-quote} 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, {s-quote}null{s-quote} 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 {s-quote}ip-%{s-quote} AND n.hwaddr <> {s-quote}00:00:00:00:00:00{s-quote};

• Invalid de_de.json breaks German translation #419 fixed by 🙏@cvc90
• Incorrect API path in initDeviceListAll_JSON breaks proxied setups fixed by 🙏@cvc90
• PiHole dhcp.leases files were not processed #420
• PiHole scan has incorrect SQL query #418 (the below has to be only done if you saved your settings on the 23.9.10 version)
  • Fix: remove the PIHOLE_CMD setting from your pialert.conf file or replace the value in the Settings page with SELECT n.hwaddr AS Object_PrimaryID, {s-quote}null{s-quote} 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, {s-quote}null{s-quote} 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 {s-quote}ip-%{s-quote} AND n.hwaddr <> {s-quote}00:00:00:00:00:00{s-quote};