Notification Filter not working since todays update

[ghc88uk]

Is there an existing issue for this?

• I have searched the existing open and closed issues and I checked the docs https://jokob-sk.github.io/NetAlertX/

The issue occurs in the following browsers. Select at least 2.

• Firefox
• Chrome
• Edge
• Safari (unsupported) - PRs welcome
• N/A - This is an issue with the backend

Current Behavior

I've been using NetAlertX for a long time, way before it changed names. I haven't changed my config for several months and everything was working fine until todays update.

I am now getting pushover notifications through for lots of devices that should be filtered out as per my configuration. In the log I can see this and assume it's related to the issue:

22:23:20 [SafeConditionBuilder] Error parsing condition: Unsupported condition pattern: AND devLastIP NOT LIKE '192.168.50.%' AND devLastIP NOT LIKE '192.168.60.%' AND devLastIP NOT LIKE '192.168.70.2' AND devLastIP NOT LIKE '192.168.70.5' AND devLastIP NOT LIKE '192.168.70.3' AND devLastIP NOT LIKE '192.168.70.4'
22:23:20 [SafeConditionBuilder] Unsafe condition rejected: AND devLastIP NOT LIKE {s-quote}192.168.50.%{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.60.%{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.2{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.5{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.3{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.4{s-quote}, Error: Invalid condition format: AND devLastIP NOT LIKE '192.168.50.%' AND devLastIP NOT LIKE '192.168.60.%' AND devLastIP NOT LIKE '192.168.70.2' AND devLastIP NOT LIKE '192.168.70.5' AND devLastIP NOT LIKE '192.168.70.3' AND devLastIP NOT LIKE '192.168.70.4'

Expected Behavior

I shouldn't be receiving notifications for these events as per my configuration.

Steps To Reproduce

Events filter setting:

AND devLastIP NOT LIKE '192.168.50.%' AND devLastIP NOT LIKE '192.168.60.%' AND devLastIP NOT LIKE '192.168.70.2' AND devLastIP NOT LIKE '192.168.70.5' AND devLastIP NOT LIKE '192.168.70.3' AND devLastIP NOT LIKE '192.168.70.4'

app.conf

docker-compose.yml

version: "3"
services:
  pialert:
    container_name: netalertx
    image: "jokobsk/netalertx:latest"
    network_mode: "host"
    restart: unless-stopped
    volumes:
      - /data/compose/3/data/config:/app/config
      - /data/compose/3/data/db:/app/db
      - /data/compose/3/data/logs:/app/front/log
    environment:
      - TZ=Europe/London
      - PORT=20211

What installation are you running?

Production (netalertx)

app.log

22:23:20 [SafeConditionBuilder] Error parsing condition: Unsupported condition pattern: AND devLastIP NOT LIKE '192.168.50.%' AND devLastIP NOT LIKE '192.168.60.%' AND devLastIP NOT LIKE '192.168.70.2' AND devLastIP NOT LIKE '192.168.70.5' AND devLastIP NOT LIKE '192.168.70.3' AND devLastIP NOT LIKE '192.168.70.4'
22:23:20 [SafeConditionBuilder] Unsafe condition rejected: AND devLastIP NOT LIKE {s-quote}192.168.50.%{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.60.%{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.2{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.5{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.3{s-quote} AND devLastIP NOT LIKE {s-quote}192.168.70.4{s-quote}, Error: Invalid condition format: AND devLastIP NOT LIKE '192.168.50.%' AND devLastIP NOT LIKE '192.168.60.%' AND devLastIP NOT LIKE '192.168.70.2' AND devLastIP NOT LIKE '192.168.70.5' AND devLastIP NOT LIKE '192.168.70.3' AND devLastIP NOT LIKE '192.168.70.4'

Debug enabled

• I have read and followed the steps in the wiki link above and provided the required debug logs and the log section covers the time when the issue occurs.

[jokob-sk]

Hi @ghc88uk , thanks for the report.

@PreistlyPython I think it's the sql hardening changes. Can you please have a look?

[jokob-sk]

@ghc88uk you might want to roll back for the time being, the DB and config should be compatible with the previous version.

[ghc88uk]

@ghc88uk you might want to roll back for the time being, the DB and config should be compatible with the previous version.

Thanks, I've pinned the image to v25.8.6 and all seems fine again - will keep an eye out for the fix and revert to latest when fixed. Thanks for all of the hard work that goes into this great project.

[jokob-sk]

Hi @PreistlyPython ,thanks a lot for the quick response and ongoing support 🙏

[jokob-sk]

Also no need to apologise, you are helping a lot already @PreistlyPython - the help you are providing hugely outweighs small bugs along the way 🙂

[jokob-sk]

Thank you @PreistlyPython for the super quick fix!
@ghc88uk you can try switching to the netalertx-dev container to see if it works now.

[adamoutler]

Unsure if related, but notifications are also sending multiple of the same device in batch, and using MAC as device name.

[ghc88uk]

Thank you @PreistlyPython for the super quick fix! @ghc88uk you can try switching to the netalertx-dev container to see if it works now.

Switched to the -dev image and all seems ok now. I've tested and confirm that notifications are being filtered correctly - those that shouldn't come through don't and those that do work fine :) Will report back if there's any more issues. Thank you.

[jokob-sk]

thanks for the update @ghc88uk
@adamoutler - I can't find the string "Detected by" (case sensitive) anywhere in the code base so not sure where those notifications are coming from. Please open a new issue if you think this is a bug and I'll try to have a look.