[SOLVED] MQTT for SONOFF/TASMOTA this is difficult

[vzorglub (Vincent Regaud)]

Not in openhab
On the raspi console its self
sudo openhabian-config

See

[SOLVED] openHABian starting Mosquitto

Hi everyone, just a few days ago I installed openHABian on my pi 2 B. In the end I want to controll an RGB strip via ESP8266 and MQTT. My problem now is, I don´t have any Idea how to start/install Mosquitto on openHABian. I would be verry happy, if anybody could tell me how to set up a MQTT Broker on openHABian. Thanks, Lukas PS: It was a verry short night figuering out how to get started with this howl thing, so my writing skill might don´t be the best…

[boris03 (Boris)]

This sounds reasonable, but didn´t read this before…

I assume you mean this
MQTT Broker eclipse Mosquitto, right?

So just install and restart?

[vzorglub (Vincent Regaud)]

That’s the one install follow in the instructions and leave everything as default
then reboot

[boris03 (Boris)]

So done, but in the Openhab.log I am still getting this error and the sonoff console also showns not connected ( both restarted)

and this is the Openhab.log

[vzorglub (Vincent Regaud)]

Good.

There should now be a file in your conf/services folder called mqtt.cfg
Can you show me the contents of that file, please?

[boris03 (Boris)]

This is the broker

and this is the mqtt.cfg
I assume I need to replace “broker” with the broker ID but what is the broker ID?

[vzorglub (Vincent Regaud)]

What is the ip address of your raspberry pi?
In the tasmotta you need to chage the host to the ip address of your pi
In the mqtt.cfg you need to change the broker.url=tcp://xxx.xxx.xx.xxx to the ip address of your raspberry pi

[boris03 (Boris)]

don´t understand, I thought the broker is the sonoff tasmota?

OK but the pi IP is 192.168.1.3 and the sonoff is using the .4.
The PI password/user is still openhabian

[vzorglub (Vincent Regaud)]

No, your broker is mosquitto, tasmotta and OH are clients

[vzorglub (Vincent Regaud)]

So Tasmotta:

Host: 192.168.1.3
port: 1883
client sonoff1
Benutzer: doesn’t matter
Passwort: doesn’t matter

mqtt.cfg

broker.url=tcp://192.168.1.3:1883
#broker.user=
#broker.pwd=
broker.clientId=openhab

Restart tasmotta
Restart OH

[boris03 (Boris)]

Loooks better on tasmota but not on pi

this the cfg

this is pi

this is tasmota

[vzorglub (Vincent Regaud)]

Please show me the content of your mqtt.cfg files. ALL of it, please

Your tasmota is connected but OH has a problem.

I’ll be back n 1 hour

[boris03 (Boris)]

This is all standard just added the few lines:

Define your MQTT broker connections here for use in the MQTT Binding or MQTT

Persistence bundles. Replace with an ID you choose.

URL to the MQTT broker, e.g. tcp://localhost:1883 or ssl://localhost:8883

#.url=tcp://:1883

broker.url=tcp://192.168.1.3:1883
#broker.user=openhabian
#broker.pwd=openhabian
broker.clientId=openhab

Optional. Client id (max 23 chars) to use when connecting to the broker.

If not provided a random default is generated.

#.clientId=

Optional. True or false. If set to true, allows the use of clientId values

up to 65535 characters long. Defaults to false.

NOTE: clientId values longer than 23 characters may not be supported by all

MQTT servers. Check the server documentation.

#.allowLongerClientIds=false

Optional. User id to authenticate with the broker.

#.user=

Optional. Password to authenticate with the broker.

#.pwd=

Optional. Set the quality of service level for sending messages to this broker.

Possible values are 0 (Deliver at most once),1 (Deliver at least once) or 2

(Deliver exactly once). Defaults to 0.

#.qos=

Optional. True or false. Defines if the broker should retain the messages sent to

it. Defaults to false.

#.retain=

Optional. True or false. Defines if messages are published asynchronously or

synchronously. Defaults to true.

#.async=

Optional. Defines the last will and testament that is sent when this client goes offline

Format: topic:message:qos:retained

#.lwt=

[boris03 (Boris)]

of course they do all have the # was somehow dissappeared by copying

[boris03 (Boris)]

So this is now remaining for mqtt.cfg

[boris03 (Boris)]

still the same problem on the pi

[vzorglub (Vincent Regaud)]

Un comment the lines for user and password:

broker.user=openhabian
broker.pwd=openhabian

On the tasmota:

Benutzer: openhabian
Passwort: openhabian

Reboot both

[boris03 (Boris)]

restarted both

same error

[boris03 (Boris)]

Now I was adding mqtt: to the beginning of all the 4 lines in cfg file and I am getting a different result. Something was happening! I am confused that the log shows now some old test id´s used before - where is that comong from how does it remember the old not working id´s??

log
2018-05-09 18:45:29.283 [ERROR] [t.mqtt.internal.MqttBrokerConnection] - MQTT connection to broker was lost
org.eclipse.paho.client.mqttv3.MqttException: Connection lost
at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:146) [224:org.openhab.io.transport.mqtt:1.11.0]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.io.EOFException
at java.io.DataInputStream.readByte(DataInputStream.java:267) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.wire.MqttInputStream.readMqttWireMessage(MqttInputStream.java:65) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:107) ~[?:?]
… 1 more
2018-05-09 18:45:29.284 [ERROR] [t.mqtt.internal.MqttBrokerConnection] - MQTT connection to broker was lost
org.eclipse.paho.client.mqttv3.MqttException: Connection lost
at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:146) [224:org.openhab.io.transport.mqtt:1.11.0]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.io.EOFException
at java.io.DataInputStream.readByte(DataInputStream.java:267) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.wire.MqttInputStream.readMqttWireMessage(MqttInputStream.java:65) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.CommsReceiver.run(CommsReceiver.java:107) ~[?:?]
… 1 more
2018-05-09 18:45:29.303 [ERROR] [t.mqtt.internal.MqttBrokerConnection] - MQTT connection to ‘broker’ was lost: Connection lost : ReasonCode 32109 : Cause : null
2018-05-09 18:45:29.305 [ERROR] [t.mqtt.internal.MqttBrokerConnection] - MQTT connection to ‘oh2mqtt’ was lost: Connection lost : ReasonCode 32109 : Cause : null
2018-05-09 18:45:29.305 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting connection helper to periodically try restore connection to broker ‘broker’
2018-05-09 18:45:29.306 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting connection helper to periodically try restore connection to broker ‘oh2mqtt’
2018-05-09 18:45:31.614 [INFO ] [basic.internal.servlet.WebAppServlet] - Stopped Basic UI
2018-05-09 18:45:39.319 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘oh2mqtt’
2018-05-09 18:45:39.319 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘broker’
2018-05-09 18:45:45.213 [INFO ] [ing.zwave.handler.ZWaveSerialHandler] - Stopped ZWave serial handler
2018-05-09 18:45:45.488 [INFO ] [penhab.io.transport.mqtt.MqttService] - Stopping broker connection ‘oh2mqtt’
2018-05-09 18:45:45.491 [INFO ] [penhab.io.transport.mqtt.MqttService] - Stopping broker connection ‘domus1’
2018-05-09 18:45:45.492 [INFO ] [penhab.io.transport.mqtt.MqttService] - Stopping broker connection ‘broker’
2018-05-09 18:45:45.493 [INFO ] [penhab.io.transport.mqtt.MqttService] - Stopping broker connection ‘sonoff1’
2018-05-09 18:45:45.663 [INFO ] [ui.habmin.internal.servlet.HABminApp] - Stopped HABmin servlet
2018-05-09 18:45:46.111 [INFO ] [arthome.ui.paper.internal.PaperUIApp] - Stopped Paper UI
2018-05-09 18:45:46.133 [INFO ] [panel.internal.HABPanelDashboardTile] - Stopped HABPanel
2018-05-09 18:45:46.148 [INFO ] [er.internal.HomeBuilderDashboardTile] - Stopped Home Builder
2018-05-09 18:45:46.173 [INFO ] [.dashboard.internal.DashboardService] - Stopped dashboard
2018-05-09 18:46:17.106 [INFO ] [er.internal.HomeBuilderDashboardTile] - Started Home Builder at /homebuilder
2018-05-09 18:46:18.495 [INFO ] [.dashboard.internal.DashboardService] - Started dashboard at http://192.168.1.3:8080
2018-05-09 18:46:18.507 [INFO ] [.dashboard.internal.DashboardService] - Started dashboard at https://192.168.1.3:8443
2018-05-09 18:46:34.305 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘fs20.items’
2018-05-09 18:46:34.406 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘G11.items’
2018-05-09 18:46:35.057 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘mapdb.persist’
2018-05-09 18:46:41.785 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘G11.rules’
2018-05-09 18:46:42.076 [INFO ] [thome.model.lsp.internal.ModelServer] - Started Language Server Protocol (LSP) service on port 5007
2018-05-09 18:46:42.732 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model ‘G11.sitemap’
2018-05-09 18:46:46.101 [INFO ] [basic.internal.servlet.WebAppServlet] - Started Basic UI at /basicui/app
2018-05-09 18:46:46.371 [INFO ] [arthome.ui.paper.internal.PaperUIApp] - Started Paper UI at /paperui
2018-05-09 18:46:46.484 [INFO ] [panel.internal.HABPanelDashboardTile] - Started HABPanel at /habpanel
2018-05-09 18:46:47.179 [WARN ] [io.transport.cul.CULLifecycleManager] - CUL config is NULL, doing nothing
2018-05-09 18:46:47.488 [INFO ] [penhab.io.transport.mqtt.MqttService] - MQTT Service initialization completed.
2018-05-09 18:46:47.492 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘oh2mqtt’
2018-05-09 18:46:47.521 [INFO ] [b.core.service.AbstractActiveService] - FritzBox refresh Service has been started
2018-05-09 18:46:47.713 [INFO ] [ui.habmin.internal.servlet.HABminApp] - Started HABmin servlet at /habmin
2018-05-09 18:46:47.816 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘domus1’
2018-05-09 18:46:47.895 [ERROR] [penhab.io.transport.mqtt.MqttService] - Error starting broker connection
org.eclipse.paho.client.mqttv3.MqttException: Unable to connect to server
at org.eclipse.paho.client.mqttv3.internal.TCPNetworkModule.start(TCPNetworkModule.java:79) [224:org.openhab.io.transport.mqtt:1.11.0]
at org.eclipse.paho.client.mqttv3.internal.ClientComms$ConnectBG.run(ClientComms.java:650) [224:org.openhab.io.transport.mqtt:1.11.0]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:?]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:?]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:?]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:?]
at java.net.Socket.connect(Socket.java:589) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.TCPNetworkModule.start(TCPNetworkModule.java:70) ~[?:?]
… 2 more
2018-05-09 18:46:47.942 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘broker’
2018-05-09 18:46:48.005 [INFO ] [t.mqtt.internal.MqttBrokerConnection] - Starting MQTT broker connection ‘sonoff1’
2018-05-09 18:46:48.087 [ERROR] [penhab.io.transport.mqtt.MqttService] - Error starting broker connection
org.eclipse.paho.client.mqttv3.MqttException: Unable to connect to server
at org.eclipse.paho.client.mqttv3.internal.TCPNetworkModule.start(TCPNetworkModule.java:79) [224:org.openhab.io.transport.mqtt:1.11.0]
at org.eclipse.paho.client.mqttv3.internal.ClientComms$ConnectBG.run(ClientComms.java:650) [224:org.openhab.io.transport.mqtt:1.11.0]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:?]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:?]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:?]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:?]
at java.net.Socket.connect(Socket.java:589) ~[?:?]
at org.eclipse.paho.client.mqttv3.internal.TCPNetworkModule.start(TCPNetworkModule.java:70) ~[?:?]

[vzorglub (Vincent Regaud)]

You have old config files somewhere
You need to do a bit of a clean-up

Follow this:

Clear the Cache

Often when one encounters a problem with OH, particularly after an update, OH will refuse to run or certain parts of OH stop working. Some reported errors include: 500 or 404 errors when accessing the UIs lots of exceptions from Jetty or other core components in openhab.log OH refuses to start at all The first step in debugging the problem is to clear the tmp and cache. Installed OH If you are running an installed OH (openHABian, installed using apt or yum): openhab-cli stop openhab-cl…