@jkandasa said:
@Blank You cannot run MyController source as is. You should compile it via maven. Clone the repo and execute
mvn packgaefrommycontroller/directory. You can find binay bundle onmycontroller/dist/target/.
I guess you mean mvn package
Because that works for me!
Super awesome, thank you very much, will give it a spin and contribute as good as I can! Thanks!!
Makes sense, will do that. Thanks 
You too, keep up the support and good work everybody!
I think the bad version of the library from the other topic might be the problem here, as I think the device-code is presenting some vars that are newer posted values to. Will check this and return.
Ouch, that was the problem! Thanks @jkandasa we are back online. Downgrading to 1.5.0 of the espressif stuff from this list https://github.com/platformio/platform-espressif8266/releases , and it seems to work.
Do you know what the core problem is with newer versions of the framework?
After some closer inspection it looks to me as the controller device is receiving messages that it cannot parse, here is new one:
MC[D]: Message arrived on topic[in_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_HEARTBEAT/0]
MC[D]: Message arrived withpayload[6306.000Lys resistorityure5.0;gatewayIP=192.168.0.1;macAddress=5C:CF:7F:2D:5A:26;ssid=sniffer;hostname=ESP_2D5A26;bssid=18:31:BF:45:CE:B0;rssi=-64 dBm;rssiAsQuality=72]
MC[D]: Message arrived with length[0]
MC[D]: Startin to parse message
MC[T]: Iterating part: i:0, str:in_esp
MC[T]: String topicsub:in_esp
MC[T]: String feedid:esp
MC[D]: The i is 0
MC[D]: Checking topic!
MC[T]: Iterating part: i:1, str:ESP_2D5A26
MC[T]: String topicsub:in_esp
MC[T]: String feedid:esp
MC[D]: The i is 1
Exception (0):
epc1=0x7373723e epc2=0x00000000 epc3=0x00000000 excvaddr=0x00000000 depc=0x00000000
ctx: cont
sp: 3fff12c0 end: 3fff1780 offset: 01a0
Where might they come from?
In relation to weird log-messages on the server I am also seeing some weird stuff by the serial monitor from the device, I have added more debug and trace info, but the logic should be there: Any clue is appreciated...
MC[I]: Booting ESP8266 device...
MC[T]: MQTT mDNS status:[0]
MC[I]: WIFI not connected, trying connection...
MC[D]: Searching BSSID for ssid:[sniffer]
MC[D]: Found BSSID[18:31:BF:45:CE:B0] for ssid:[sniffer], RSSI:[-59 -dBm, 82 ]
MC[D]: Selected bssid:[18:31:BF:45:CE:B0]
MC[I]: Connecting to WiFi with ssid[sniffer] and with password...........OK
MC[I]: WiFi BSSID:[18:31:BF:45:CE:B0], RSSI:[-66 dBm, 68 ], IP:[192.168.0.112], StatusCode:[3]
MC[D]: WiFi connection status: Connected
MC[I]: Configuration(NodeEUI:[ESP_2D5A26], Mqtt{mDNS-status:[0], Server:[192.168.0.44], Port:[1883], FeedId:[esp], User:[]})
MC[D]: Attempting MQTT connection...
MC[I]: MQTT settings(Broker:[192.168.0.44], Port:[1883])
MC[I]: MQTT authenticating as anonymous
MC[I]: MQTT connected :)
MC[I]: MQTT topic subscribed:[in_esp/ESP_2D5A26/#]
Core: The before() has completed...MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_RSSI/0], Payload:[-67 dBm]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_PROPERTIES/0], Payload:[freeHeap=32272;chipId=2972198;flashChipSize=4194304;flashChipRealSize=4194304;flashChipSpeed=40000000;cycleCount=681337642;localIP=192.168.0.112;vcc=3154 mV]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_PROPERTIES/0], Payload:[subnetMask=255.255.255.0;gatewayIP=192.168.0.1;macAddress=5C:CF:7F:2D:5A:26;ssid=sniffer;hostname=ESP_2D5A26;bssid=18:31:BF:45:CE:B0;rssi=-67 dBm;rssiAsQuality=66]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_PRESENTATION/S_ARDUINO_NODE/0], Payload:[1.0.0]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_SKETCH_NAME/0], Payload:[McNode04d]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/SENSOR_BC/C_INTERNAL/I_SKETCH_VERSION/0], Payload:[1.1.0]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/temp-4-1/C_PRESENTATION/S_TEMP/0], Payload:[Bosch Sensor Temperature]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/temp-4-1/C_REQ/V_TEMP/0], Payload:[]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/humid-4-1/C_PRESENTATION/S_HUM/0], Payload:[Bosch Sensor Humidity]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/humid-4-1/C_REQ/V_HUM/0], Payload:[]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/light-4/C_PRESENTATION/S_LIGHT_LEVEL/0], Payload:[Lys resistor]
MC[D]: About to publish a topic:[out_esp/ESP_2D5A26/light-4/C_REQ/V_LIGHT_LEVEL/0], Payload:[]
dress=5C:CF:7F:2D:5A:26;ssid=sniffer;hostname=ESP_2D5A26;bssid=18:31:BF:45:CE:B0;rssi=-67 dBm;rssiAsQuality=66Core: Custom_init starting...
Core: Custom_init now init of Bosch sensor...
Locating Dallas devices...Found 2 devices.
Parasite power is: OFF
Device 0 Address: 28FF13A001170318
Device 1 Address: 28FF3B1B711603F0
Device 0 Resolution: 12
Device 1 Resolution: 12
MC[D]: Message arrived on topic[in_esp/ESP_2D5A26/temp-4-1/C_SET/V_TEMP/0]
MC[D]: Message arrived withpayload[24_LEVEL/0T_LEVEL/0Lys resistorityure5.0;gatewayIP=192.168.0.1;macAddress=5C:CF:7F:2D:5A:26;ssid=sniffer;hostname=ESP_2D5A26;bssid=18:31:BF:45:CE:B0;rssi=-67 dBm;rssiAsQuality=66]
MC[D]: Message arrived with length[2]
MC[D]: Startin to parse message
MC[T]: Iterating part: i:0, str:in_esp
MC[T]: String topicsub:in_esp
MC[T]: String feedid:esp
MC[D]: The i is 0
MC[D]: Checking topic!
MC[T]: Iterating part: i:1, str:ESP_2D5A26
MC[T]: String topicsub:in_esp
MC[T]: String feedid:esp
MC[D]: The i is 1
Exception (0):
epc1=0x7373723e epc2=0x00000000 epc3=0x00000000 excvaddr=0x00000000 depc=0x00000000
ctx: cont
sp: 3fff12f0 end: 3fff17a0 offset: 01a0
>>>stack>>>
3fff1490: 3fff06b0 00000001 3fff15d0 40206e71
3fff14a0: 3ffeaeb0 00000000 00000000 40101da6
3fff14b0: 00000017 0090455d 401021e6 00000100
3fff14c0: 7fffffff 3ffeaeb0 3ffeaeb0 00000001
3fff14d0: 00000001 00004208 00000000 00000001
3fff14e0: 3fff19bc 00000008 3fff06b0 402120c0
3fff14f0: 3fff15a0 0000001f 3fff153f 4020f390
3fff1500: 3ffeaed4 00006208 3fffc200 00000020
3fff1510: 3fff06b0 00000008 3fff1520 40208f3c <
3fff1520: 445b434d 53203a5d 74726174 74206e69
3fff1530: 6170206f 20657372 7373656d 0a656761
3fff1540: 325b6800 45000a5d 2f4c4556 4c5f5430
3fff1550: 4c455645 794c302f 65722073 00736973
3fff1560: 3fff15a0 3fff1570 00000008 00000000
3fff1570: 00000002 3fff0150 60000000 655f6e69
3fff1580: 60007073 00000026 3fff1712 00000030
3fff1590: 3fff0469 00000002 3fff1570 3fff15a0
3fff15a0: 4021423c 3fff16a0 3fff29fc 00000002
3fff15b0: 3fff1700 3fff0469 3fff06b0 40207dfe
3fff15c0: 40106644 3ffeffdc 00000004 00000030
3fff15d0: 00000000 00000000 00000000 000061a2
3fff15e0: 00000000 00000000 00000000 00000000
3fff15f0: 00000000 00000000 00000000 00000000
3fff1600: 00000000 00000000 00000000 00000000
3fff1610: 00000000 00000000 00000000 00000000
3fff1620: 00000000 00000000 00000000 00000000
3fff1630: 00000000 00000000 00000000 00000000
3fff1640: 00000000 00000000 00000000 00000000
3fff1650: 00000000 00000000 00000000 00000000
3fff1660: 00000000 00000000 00000000 00000000
3fff1670: 00000000 00000000 00000000 00000000
3fff1680: 00000000 00000000 00000000 00000000
3fff1690: 00000000 00000000 00000000 00000000
3fff16a0: 00000000 00000000 00000000 00000000
3fff16b0: 00000000 00000000 00000000 4020bf00
3fff16c0: 00000005 0000000e 3fff0438 4020e684
3fff16d0: 3fff043c 00000003 3fff16f0 3fff1730
3fff16e0: 3fff1730 00002505 3fff0438 4020f25c
3fff16f0: 3f34002f 00030010 3fff00c8 4020ed99
3fff1700: 655f6e69 45007073 325f5053 32413544
3fff1710: 65740036 342d706d 432f312d 5445535f
3fff1720: 545f562f 2f504d45 3fff0030 4020ecac
3fff1730: 3fff3501 3ffefef8 3ffeffdc 40201104
3fff1740: 40202abe 3ffefef8 3ffeffdc 40204a6e
3fff1750: 00000000 00000000 00000000 3fff0770
3fff1760: 3fffdad0 3fff0438 3fff0084 402087ab
3fff1770: 00000000 00000000 3fff0768 402053f0
3fff1780: 3fffdad0 00000000 3fff0768 4020a578
3fff1790: feefeffe feefeffe 3fff0780 40100700
<<<stack<<<
ets Jan 8 2013,rst cause:2, boot mode:(3,6)
load 0x4010f000, len 1384, room 16
tail 8
chksum 0x2d
csum 0x2d
v614f7c32
~ld```Hi all, I am trying to add a new board with some new sensors, but the board is crashing and I am getting this error in the server log. Can anyone point to a possible problem??
2018-12-25 20:23:58,538 ERROR [mc-th-pool-6] [org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl:248] unable to add new item:[MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=97, sensor=Sensor(id=93, sensorId=humid-4-1, type=S_HUM, name=Bosch Sensor Humidity, lastSeen=1545765829635, node=Node(id=10, eui=ESP_2D5A26, gatewayTable=GatewayTable(id=1, enabled=true, name=ESP devices gateway, networkType=MY_CONTROLLER, timestamp=1486111527969, state=UP, statusMessage=Connected Successfully, statusSince=1545761094427, type=MQTT, properties={p=, qos=0, u=, bh=tcp://localhost:1883, txDelay=0, tp=in_esp, cid=esp_client, ts=out_esp}), name=McNode04d, version=1.1.0, type=S_ARDUINO_NODE, libVersion=1.0.0, batteryLevel=null, eraseConfig=null, firmware=null, state=UP, lastSeen=1545765838524, rssi=-68 dBm, properties={rssi=-68 dBm, rssiAsQuality=64, bssid=18:31:BF:45:CE:B0, gatewayIP=192.168.0.1, subnetMask=255.255.255.0, ssid=sniffer, hbTx=1545764104527, freeHeap=32304, macAddress=5C:CF:7F:2D:5A:26, hostname=ESP_2D5A26, flashChipSize=4194304, flashChipSpeed=40000000, vcc=3032 mV, flashChipRealSize=4194304, localIP=192.168.0.112, cycleCount=-1470310702, chipId=2972198}, parentNodeEui=null, registrationState=REGISTERED, smartSleepEnabled=false), room=null, variableTypes=[Humidity]), variableType=V_HUM, metricType=DOUBLE, timestamp=1545765838519, value=null, previousValue=null, unitType=U_HUMIDITY, readOnly=false, offset=0.0, priority=100, properties={marginRight=20, color=#ff7f0e, interpolate=linear, subType=line, marginBottom=60, useGlobal=true, type=lineChart, marginTop=5, marginLeft=65}), timestamp=1545765838519, samples=1, min=null, max=null, avg=null, aggregationType=RAW, start=null, end=null)]
java.sql.SQLException: Unable to run insert stmt on object MetricsDoubleTypeDevice(sensorVariable=SensorVariable(id=97, sensor=Sensor(id=93, sensorId=humid-4-1, type=S_HUM, name=Bosch Sensor Humidity, lastSeen=1545765829635, node=Node(id=10, eui=ESP_2D5A26, gatewayTable=GatewayTable(id=1, enabled=true, name=ESP devices gateway, networkType=MY_CONTROLLER, timestamp=1486111527969, state=UP, statusMessage=Connected Successfully, statusSince=1545761094427, type=MQTT, properties={p=, qos=0, u=, bh=tcp://localhost:1883, txDelay=0, tp=in_esp, cid=esp_client, ts=out_esp}), name=McNode04d, version=1.1.0, type=S_ARDUINO_NODE, libVersion=1.0.0, batteryLevel=null, eraseConfig=null, firmware=null, state=UP, lastSeen=1545765838524, rssi=-68 dBm, properties={rssi=-68 dBm, rssiAsQuality=64, bssid=18:31:BF:45:CE:B0, gatewayIP=192.168.0.1, subnetMask=255.255.255.0, ssid=sniffer, hbTx=1545764104527, freeHeap=32304, macAddress=5C:CF:7F:2D:5A:26, hostname=ESP_2D5A26, flashChipSize=4194304, flashChipSpeed=40000000, vcc=3032 mV, flashChipRealSize=4194304, localIP=192.168.0.112, cycleCount=-1470310702, chipId=2972198}, parentNodeEui=null, registrationState=REGISTERED, smartSleepEnabled=false), room=null, variableTypes=[Humidity]), variableType=V_HUM, metricType=DOUBLE, timestamp=1545765838519, value=null, previousValue=null, unitType=U_HUMIDITY, readOnly=false, offset=0.0, priority=100, properties={marginRight=20, color=#ff7f0e, interpolate=linear, subType=line, marginBottom=60, useGlobal=true, type=lineChart, marginTop=5, marginLeft=65}), timestamp=1545765838519, samples=1, min=null, max=null, avg=null, aggregationType=RAW, start=null, end=null): INSERT INTO `metrics_double_type_device` (`sensorVariableId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?)
at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25)
at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:137)
at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:458)
at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:328)
at org.mycontroller.standalone.db.dao.BaseAbstractDaoImpl.create(BaseAbstractDaoImpl.java:245)
at org.mycontroller.standalone.metrics.engine.MetricEngineMyController.post(MetricEngineMyController.java:87)
at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.executeDependentTask(ExecuteMessageDependentTask.java:60)
at org.mycontroller.standalone.provider.ExecuteMessageDependentTask.run(ExecuteMessageDependentTask.java:84)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "AVG"; SQL statement:
INSERT INTO `metrics_double_type_device` (`sensorVariableId` ,`timestamp` ,`samples` ,`min` ,`max` ,`avg` ,`aggregationType` ) VALUES (?,?,?,?,?,?,?) [23502-194]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:311)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:793)
at org.h2.command.dml.Insert.insertRows(Insert.java:151)
at org.h2.command.dml.Insert.update(Insert.java:114)
at org.h2.command.CommandContainer.update(CommandContainer.java:101)
at org.h2.command.Command.executeUpdate(Command.java:258)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:183)
at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:91)
... 9 common frames omitted
```You too, keep up the support and good work everybody!
Hi again, was looking at upgrading a few devices and stumpled on some annoying dependencies in the mycontroller.cpp code for the device - esp8266wifi and more.
Does anyone know of easy ways to port to ESP32 for mycontrollerdevice code`?
Ok, downgraded the java version by using the
JAVA_HOME="/usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java"
line in /etc/environment - AND NOW IT WORKS FINE!
Thanks again!
@jkandasa No, the fix just make the server start, as the version check is in the start.sh file. But when the server starts, it only works partially, the logs above are from a 1.3-Final running with errors.