I have a new issue…
I have installed the MQTT binding to listen for inbound temperature reports from a couple of ESP8266’s I’ve built and configured with DHT22’s. The 8266’s work fine. And I can see the messages being published in my mosquito service. e.g.
539963042: Received PUBLISH from ESP8266Client (d0, q0, r0, m0, 'sensor/temperature', ... (58 bytes))
But although I see the MQTT connection from openhab
1539962577: New client connected from 192.168.254.115 as openhab (c1, k60, u'temps').
I don’t see any subscriptions being made in response to my configured items (e.g.
Switch MQTT_Test "Testing..." { mqtt="<[mosquitto:testing/mqtt/topic:state:default], >[broker:testing/mqtt/back-topic:command:*:default]" }
Number MasterBR_Temp "temp [%.1f]" {mqtt="<[mosquitto:sensor/temperature:state:REGEX(temp (\\d*.\\d*) ):000336da]" }
And the mqtt config is…
root@piman-301:/etc/openhab2# cat services/mqtt.cfg
pid:org.openhab.mqtt
mosquitto.url=tcp://mqtt.travellingkiwi.com:1883
mosquitto.clientId=openhab
mosquitto.user=temps
mosquitto.pwd=*****
mosquitto.qos=1
mosquitto.retain=true
mosquitto.async=false
root@piman-301:/etc/openhab2#
Meanwhile I can see the messages if I run mosquitto_sub to subscribe to the channel from the command line
In openhab.og I see the items being loaded…
2018-10-19 16:24:55.157 [INFO ] [el.core.internal.ModelRepositoryImpl] - Loading model 'mqtt.items'
2018-10-19 16:24:55.174 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'MQTT_Test'.
2018-10-19 16:24:55.182 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'MasterBR_Temp'.
2018-10-19 16:24:56.209 [INFO ] [el.core.internal.ModelRepositoryImpl] - Refreshing model 'mqtt.items'
including the complaints about the persistence not being there yet…
Have I done something wrong? I even added the testing config from MQTT Binding (v1.11) Getting Started 101 but no joy…