MQTT delete unused Payload

[Br3Ak3R (Herbert)]

I have played around with MQTT using MQTTExplorer and i added a payload to a item and dont know how to remove it.

• MQTT broker used : Mosquitto
• MQTT Explorer for view and publish
• Item edited : Müller Licht Tint RGBW GU10 Bulb
• item tested: Color type XY, tried with converting XY to HSB, HSV
• Item connection: Zigbee2Mqtt
• Issue: Item cant be controlled to change color, only brightness and temperature because OpenHAB uses HSB/HSV values

Payload now:

{"state":"ON","brightness":1,"color":{"hsv":"360,100,100","hsb":"300,50,50","h":20,"s":20,"b":100,"x":0.409284485354692,"y":0.392669907163558},"color_temp":291,"linkquality":63}

Payload should be:

{"state":"ON","brightness":1,"color":{"x":0.409284485354692,"y":0.392669907163558},"color_temp":291,"linkquality":63}

How can i remove:

"hsv":"360,100,100","hsb":"300,50,50","h":20,"s":20,"b":100

from payload?

i tried with deleting mosquitto.db

 sudo rm /var/lib/mosquitto/mosquitto.db

[rossko57]

Is the question “how do I remove a retained payload from my broker” ?

Clearing MQTT retained messages

Clearing retained messages in mosquitto Purpose The purpose of this tutorial is to present solutions to clear retained messages in the Eclipse Mosquitto MQTT Broker. Retained messages can be troublesome and/or unwanted. Many mosquitto tutorials included a retain option in the configuration and setup of mosquitto. This is likely to create problems in the future. This tutorial is created for Linux users with a package installation on mosquitto. Other users will have to find the files and paths r…

[Br3Ak3R (Herbert)]

i tried solution from there…and none working. Payload back after switching the bulb

sudo mosquitto_pub -h <IP> -t "zigbee2mqtt/Büro - Müller Licht Tint LED bulb GU10" -u <USERNAME> -P <PASSWORD> -n -r -d

[opus (Jürgen Baginski)]

If the device does send such state messages, openHAB has no way thechange that.
It sounds to me like a device-specific question and not directly related to openHAB.

[Br3Ak3R (Herbert)]

I didn’t say that it was an Openhab Issue, i’m looking for a solution with MQTT Payload. In the actual state of the device OpenHAB uses the Payload for color as HSB (because its there in the payload) and not the X & Y payloads.

Again … the payloads with HSB values were added by me using MQTTExplorer for trying to convert Color XY to HSB. But now they are more blocking the use of the item to change the color.

[rossko57]

@Br3Ak3R

the payloads with HSB values were added by me using MQTTExplorer

Added how? By publishing to that topic?

@Br3Ak3R

i tried solution from there…and none working

Okay, so you published an empty payload to that topic with retain set? And checked that the old unwanted payload was gone?

@Br3Ak3R

Payload back after switching the bulb

Alright, so who published that?

[Br3Ak3R (Herbert)]

State actual

after publishing i get

after pushing my remote or just sending brightness payload

i hope this helps understanding, dont know why the HSB payload pops back. By sending payload with RETAIN checked all looks ok till i make a change of state or value from the bulb.

Sorry if i eventually misunderstand something, my english is a bit rusty

[Thedannymullen (Danny mullen)]

@Br3Ak3R

i tried with deleting mosquitto.db

 sudo rm /var/lib/mosquitto/mosquitto.

If you do this you have to stop the mosquito service first.

[Br3Ak3R (Herbert)]

Of course I’ve done it before and started after.