Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

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.

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?

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.

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

cuihe

@craigweb thank you !
this problem solved!

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.)

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? ^_^

cuihe

thank you！

I think I need to improve myself for some time.
It's simpler to use Mango.

cuihe

I think I understand. Thank you very much!

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

cuihe

@cuihe

Latest posts made by cuihe