MQTT error - last_result.log does not exist

[PyrokineticDarkElf]

Not sure if anyone can suggest what I've done wrong here? I've been trying to get this working with Mosquitto (container not in Home Assistant). Whenever I try the test button I seem to get the following error:

Traceback (most recent call last):
  File "/home/pi/pialert/front/plugins/_publisher_mqtt/mqtt.py", line 363, in <module>
    sys.exit(main())
             ^^^^^^
  File "/home/pi/pialert/front/plugins/_publisher_mqtt/mqtt.py", line 61, in main
    mqtt_start(db)
  File "/home/pi/pialert/front/plugins/_publisher_mqtt/mqtt.py", line 255, in mqtt_start
    client = mqtt_create_client()     
             ^^^^^^^^^^^^^^^^^^^^
  File "/home/pi/pialert/front/plugins/_publisher_mqtt/mqtt.py", line 239, in mqtt_create_client
    client = mqtt_client.Client('PiAlert')   # Set Connecting Client ID    
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/myenv/lib/python3.11/site-packages/paho/mqtt/client.py", line 766, in __init__
    raise ValueError(
ValueError: Unsupported callback API version: version 2.0 added a callback_api_version, see migrations.md for details

22:41:24 [Plugins] ⚠ ERROR - enable LOG_LEVEL=debug and check logs
22:41:24 [Plugins] The file /home/pi/pialert/front/plugins/_publisher_mqtt/last_result.log does not exist
22:41:24 [Plugins] No output received from the plugin MQTT - enable LOG_LEVEL=debug and check logs
22:41:24 [2024-02-17 22:41:24+00:00] END Run: MQTT
22:41:24 [Test] END Test: MQTT

Can I confirm the 'topic' I should be using in Home Assistant is 'homeassistant'?:

Am I meant to be using a specific username for MQTT? "PiAlert":
client = mqtt_client.Client('PiAlert') # Set Connecting Client ID

[jokob-sk]

Hi @Staples1010 ,

I haven't tested a stand-alone Mosquitto instance.

Can you please confirm you are using the correct details for Broker, Port, Username, Password?

https://github.com/jokob-sk/Pi.Alert/blob/main/docs/HOME_ASSISTANT.md

The below are the most important settings:

Please make sure they align with your Mosquito MQTT settings:

https://github.com/jokob-sk/Pi.Alert/tree/main/front/plugins/_publisher_mqtt

YOu can check the message, including topic, that is sent here:

https://github.com/jokob-sk/Pi.Alert/blob/34f56585161cffdb9a3a3ded76e9da6195e91af8/front/plugins/_publisher_mqtt/mqtt.py#L191

[PyrokineticDarkElf]

It looks like more is happening when running the test, but I'm still not seeing anything appear in MQTT Explorer :/

The execution queue seems to never clear, they just keep getting added:

It seems there's a new error related to a missing file /home/pi/pialert/front/api/table_plugins_objects.json:
*data obfuscated

11:37:50 [Plugin utils] ⚠ ERROR - JSONDecodeError or FileNotFoundError for file /home/pi/pialert/front/api/table_plugins_objects.json
11:37:50 [MQTT] New sensor entry mac          : ba:01:c9:80:8c:78
11:37:50 [MQTT] New sensor entry input_string : mac_ba_01_c9_80_8c_78Device Name Heresensoris_newbell-alert-outline
11:37:50 [MQTT] New sensor entry hash_value   : dcee5d9df23d1131606c1a6193d90852
11:37:50 [MQTT] Publishing sensor number 64
11:37:50 [MQTT] Sending MQTT topic: homeassistant/sensor/mac_ba_01_c9_80_8c_78/is_new/config
11:37:50 [MQTT] Sending MQTT message: {                 "name":"is_new",                 "state_topic":"system-sensors/sensor/mac_ba_01_c9_80_8c_78/state",                 "value_template":"{{value_json.is_new}}",                 "unique_id":"mac_ba_01_c9_80_8c_78_sensor_is_new",                 "device":                     {                         "identifiers": ["mac_ba_01_c9_80_8c_78_sensor"],                         "manufacturer": "PiAlert",                         "name":"Device Name Here"                     },                 "icon":"mdi:bell-alert-outline"                 }
11:37:52 [Plugin utils] ⚠ ERROR - JSONDecodeError or FileNotFoundError for file /home/pi/pialert/front/api/table_plugins_objects.json
11:37:52 [MQTT] New sensor entry mac          : ba:01:c9:80:8c:78
11:37:52 [MQTT] New sensor entry input_string : mac_ba_01_c9_80_8c_78Device Name Heresensorvendorcog
11:37:52 [MQTT] New sensor entry hash_value   : b85ad03bc952800de297b23ab4f36e1c
11:37:52 [MQTT] Publishing sensor number 65
11:37:52 [MQTT] Sending MQTT topic: homeassistant/sensor/mac_ba_01_c9_80_8c_78/vendor/config
11:37:52 [MQTT] Sending MQTT message: {                 "name":"vendor",                 "state_topic":"system-sensors/sensor/mac_ba_01_c9_80_8c_78/state",                 "value_template":"{{value_json.vendor}}",                 "unique_id":"mac_ba_01_c9_80_8c_78_sensor_vendor",                 "device":                     {                         "identifiers": ["mac_ba_01_c9_80_8c_78_sensor"],                         "manufacturer": "PiAlert",                         "name":"Device Name Here"                     },                 "icon":"mdi:cog"                 }

I've also noticed that when you attempt to update the settings it seems to hang on 'Importing settings and re-initializing...':

[PyrokineticDarkElf]

And somehow I missed this... The devices table is gone 👀

[jokob-sk]

Hi @Staples1010 ,

Can you have a look if there are errors in the JSON generated by the app?

https://github.com/jokob-sk/Pi.Alert/blob/main/docs/DEBUG_INVALID_JSON.md

Please access the following and run the JSON files thru a JSON validator to check if something isn't causing the data to break.

• http://<server>/api/table_settings.json
• http://<server>/api/table_devices.json

Please also try opening the app in a new browser or clearing the cache in case that's the issue.

Also, please make sure you wait long enough for the execution queue to finish. One MQTT sync can take up to 10-15 minutes depending on the number of devices (~3-10s per device).

Thanks in advance for the additional info,
j

[PyrokineticDarkElf]

Hi @jokob-sk 👋

Sorry for the radio silence, I've just had a chance to pick this up again and It looks like the MQTT notifications are working for me now!

I can see you've been making some updates (and a re-brand) so presumably, something's changed that has helped :D

Thanks for your help!

[jokob-sk]

Hey @Staples1010 ,

Thanks for checking in! Glad to hear the issue is resolved :)

Yes, changed the name just yesterday - hope it helps differentiate between the stale original project and other active forks and people stop asking me if it's only for the Raspberry Pi 😅

What do you think - would it be ok to also rename the MQTT sensor names?

[PyrokineticDarkElf]

@jokob-sk It would be okay with me, but If people already have automations in Home Assistant set up using the existing name, could this break their setups?

Having a toggle in the settings could be good, or maybe a textbox for a custom name?

[jokob-sk]

Sure, added these two settings for the next release:

[ingoratsdorf]

The above callback error was fixed in pull request #759.

The paho library is now v2.0 and will be dropping support for V1 callback.
If a user selected v1 as callback type, the callback in the plugin would fail due to the expected signature being wrong.
My pull requests solved this be eliminating v1 callbacks and offering to rather select the MQTT protocol 3 or 5.
Most modern MQTT brokers will support V5, have tested with EMQX and Mosquitto.