-
C cuihe
@craigweb I think this protocol is important. And many hardware supports this protocol. Does Mango have a timetable to support this?
Or is there a way to indirectly support the hardware of this protocol?
Or is there a manual support method? Now I have passed c# to Read and Write my hardware.
-
C cuihe
I found an OPCDA protocol data-source. And I use Mango OPCDA to connect my OPCDAserver. Successed!
But I dont find OPCUA protocol data-source. Is there something I missed?
How to connect my OPCUAserver and read&write data? -
C cuihe
I was not so clear with this thing, but it do solved!
here is my solution:
"connectionUrl":"jdbc:mysql://localhost:3306/test",
"driverClassname":"com.mysql.jdbc.Driver",Note: replace "localhost" "3306" "test" if needed.
-
C cuihe
//your code here { "dataSources":[ { "xid":"DS_64b30a4f-d8c2-4b8a-9978-1b9c085893b6", "name":"test_SQL", "enabled":false, "type":"SQL", "alarmLevels":{ "POLL_ABORTED":"URGENT", "STATEMENT_EXCEPTION":"URGENT", "DATA_SOURCE_EXCEPTION":"URGENT" }, "purgeType":"YEARS", "updatePeriodType":"SECONDS", "connectionUrl":"192.168.61.191:3306", "driverClassname":"MySQL", "password":"1234", "rowBasedQuery":false, "selectStatement":"select * from biao;", "updatePeriods":5, "username":"root", "editPermission":"", "purgeOverride":false, "purgePeriod":1 } ] }
It's not clear what "driverClassname" means.
The database I use is MySQL, what should i type in ? "com.mysql.jdbc.Driver"(same error below)?when I click "SQL Statement Testing", It shows an error: class java.lang.ClassNotFoundException: MySQL
-
C cuihe
@craigweb thank you !
this problem solved! -
C cuihe
@craigweb thank you first!
I don't know if what I'm offering is what you want.
here is "dashboard code":<ma-point-value id="e76d6d6c-45f1-440c-90f3-c446aa6c87b6" enable-popup="hide" style="position: absolute; left: 399px; top: 75px; width: 25px; height: 25px;" point-xid="DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd"></ma-point-value> <ma-switch id="078c0795-8eba-4cc1-9166-f62c62de3af6" style="position: absolute; left: 394px; top: 220px; width: 50px; height: 50px; background-color: rgb(0, 46, 92);" point-xid="DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd"></ma-switch>
here is dataSource-dataPoint(SET_LIGHT):
(also, I use mango-publisher to publish this. In this way I control my light)
(<ma-switch> Connect with this){ "dataPoints":[ { "xid":"DP_da02f5a8-afc1-4ecb-ba8c-403ffe6345dd", "name":"Light01_print", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"BINARY", "changeType":{ "type":"NO_CHANGE", "startValue":"0" }, "settable":true }, "eventDetectors":[ ], "plotType":"STEP", "rollup":"NONE", "unit":"", "templateXid":"Light", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"TABLE", "limit":10 }, "dataSourceXid":"DS_afafb004-8328-49e6-8bbb-1e5520c377d8", "defaultCacheSize":1, "deviceName":"TEST2", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"BINARY", "oneColour":"#99ff99", "oneLabel":"", "zeroColour":"#c0c0ee", "zeroLabel":"" }, "tolerance":0.0 } ] }
here is dataSource-dataPoint(GET_LIGHT):
My light send HTTP message to Mango.{ "dataPoints":[ { "xid":"DP_c6eebfd0-d128-4ea2-8bf1-77f7cf355edd", "name":"light01", "enabled":true, "loggingType":"ON_CHANGE", "intervalLoggingPeriodType":"MINUTES", "intervalLoggingType":"INSTANT", "purgeType":"YEARS", "pointLocator":{ "dataType":"BINARY", "binary0Value":"false", "includeTimestamp":false, "parameterName":"light01", "setPointName":"", "settable":false }, "eventDetectors":[ ], "plotType":"STEP", "rollup":"NONE", "unit":"", "templateXid":"ReadLight", "simplifyType":"NONE", "chartColour":"", "chartRenderer":{ "type":"TABLE", "limit":10 }, "dataSourceXid":"DS_0638891e-846e-4413-a3d3-c5b5596f688a", "defaultCacheSize":1, "deviceName":"light_source", "discardExtremeValues":false, "discardHighLimit":1.7976931348623157E308, "discardLowLimit":-1.7976931348623157E308, "intervalLoggingPeriod":15, "intervalLoggingSampleWindowSize":0, "overrideIntervalLoggingSamples":false, "preventSetExtremeValues":false, "purgeOverride":false, "purgePeriod":1, "readPermission":"", "setExtremeHighLimit":1.7976931348623157E308, "setExtremeLowLimit":-1.7976931348623157E308, "setPermission":"", "tags":{ }, "textRenderer":{ "type":"BINARY", "oneColour":"#eeee00", "oneLabel":"亮", "zeroColour":"#c0c0ee", "zeroLabel":"灭" }, "tolerance":0.0 } ] }
[virtual data source] and [<ma-switch> control and show data] work well
[virtual data publisher] work well
[hard device (light)] work well
[<ma-point-value> receive HTTP msg and show value] work well
The problem is that when someone controls the light from other systems, <ma-point-value> displays normally and the <ma-switch> does not.
(Of course I know because the data is not connected. but how)
(Please let me know what else you need.) -
C cuihe
Sorry, my title is not very clear.
-
I have a dataSource from HTTP receiver. Here we set the datapoint's name GET_LIGHT.
I dessigned a dashboard. using "Point Value" to show GET_LIGHT's value. <- work well -
I have a dataSource from Virtual data source. Here we set the datapoint's name SET_LIGHT.
at the same dashboard. using "Binary Switch Button" to control SET_LIGHT's value. <- work well -
when they work together, Control the "Binary Switch Button" and "Point Value" changed(Although they are not directly connected). <- work well
-
BUT, when another controller change the light(such as using light_switch at scene). "Point Value" in dashboard can change. "Binary Switch Button" can NOT change(because the Virtual data source not change). <- problem here
I'm not very proficient in using Mango system.
is there a way when GET_LIGHT changed making the Virtual data source SET_LIGHT change as well?
Or I dont need a Virtual data source, another way to solve this problem?review this topic title, How can I describe this problem in one sentence? ^_^
-
-
C cuihe
thank you!
I think I need to improve myself for some time.
It's simpler to use Mango. -
C cuihe
I think I understand. Thank you very much!
-
C cuihe
Mango Public Code:https://github.com/infiniteautomation/ma-core-public
I don't know JAVA very well. Suppose I have studied JAVA for half a year.I want to know what architecture these codes use (or how I should start reading).
The Learning Route I Formulated is: java -> spring -> Mango Public Code. Do you have any suggestions for this?My editor (Idea) told me that some of the packages used in the code did not exist.
java: packages org.apache.commons.io did not exist java: packages org.apache.commons.io.comparator did not exist java: packages org.apache.commons.io.output did not exist
and there is a strange problem: (but i really find the class in project)
java: can not find symbol symbol: class CompiledCoreVersion position: packages com.infiniteautomation.mango