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.

hi,
I wish to know how Mango is saving the data in database when data is received by "HttpDataSourceServlet" upon sending request as "http://192.168.1.1/Mango/httpds?__device=20&__valuepoint1=111&__timepoint1=12092010&__pointpoint1=mykey&__valuepoint2=222&__timepoint2=18072011&__pointpoint2=mykey" and can it be ploted on graph.

There's always Serotonin Professional Services... :)

Ok. My bad. I always sand-boxed myself in the data source world. I never used publisher and saw it. No brainer now.

That did it. Left overs from something.

thx

You want to receive data in your custom view? You can't update point values with the data, but you could use the values in the rendering of the page (although that doesn't really achieve a lot).

If you want to get data into points via POST, you should use the HTTP Receiver data source.

No, that's not going to work. Here's what to do, assuming that you want to set the coil to "true" for 5 seconds.

Create a point event detector on the point that fires when the point has been "true" for 5 seconds. Create an event handler for the event in 1) that sets the point to false when it activates, and does nothing when it deactivates.

This a great solution to the problem of my kids and/or wife closing the Tomcat window. Grrrrrr. Of course no one ever owns up to it!

I'd like to change Mango mails body for a custom format. Are there templates for this or they are hardcoded in the soruce code?

index.htm is a virtual page. It doesn't physically exist.

Try going to http://localhost:8080/mango/login.htm instead. I.e. no "war".

Seems I cant capture traffic in the loopbak interface http://wiki.wireshark.org/CaptureSetup/Loopback

I have connection to the DB!

I'm using this statement:

select id, ea1, timestamp from valores;

But seems not to work. I get an error refearing an excesive package size.

If I use this statement:

select id, ea1, timestamp from valores limite 1;

I do get a value.

As explained in the on line doc, id is a row id, ea1 a value and timestamp the time the value was recorded.

Someone asked recently how they could control the values of multiple points from a single click. Kind of like a "broadcast" of a set point. Today I got around to testing the idea that came to mind, but didn't want to suggest without being sure of it. Turns out it works nicely...

Point linking is the key. In my test i created a new virtual data source with three binary points. The first is the "master" point, and the other two are "slave" points. All three are settable (with the "no change" setting so that they don't change on their own). I then enabled everything: points and data source.

Next, i simply created two point links using the master as the source and the slaves as the targets. Creating a watchlist confirms that whenever i set the value of the master, the values of the slaves are also set. Individual set points failures will not kill the "broadcast"; individual failure alarms will be raised as appropriate. Also, if, say, one of the points needed to be the opposite value of the master, i can use the point link script to do the transformation.

Hi Walid,

If your Mango is running op port 8080 (you access it on your localhost with http://localhost:8080), then you could configure your router under NAT/portforwarding/application_sharing (depends on your router) like this: set it to forward public TCP port 8080 of your router (or perhaps 80 if you like) to the LAN IP address and TCP port 8080 of the machine on your LAN (for example 192.168.0.1).

Perhaps stating the obvious, but ofcourse you should use a static LAN address for you server as well, or alternatively configure your router to always assign the same IP address to the paricular ethernet MAC address of your server.

I'd like to share here how to get Mango datapoints published on pachube.com. You could want to do so if you want to share some data feed with the world on this common datastream excange platform, or maybe you would like to be able to view datapoint charts in the pachube iPhone/Android app.

You can create a free account at pachube. You will get an API key after creating your account.

The pachube api normally works with http PUT to update data feeds and requires the api key to be put in a custom http header; that won't work with the Mango publisher. Luckily it is still possible to do it differently, but it is a bit hard to derive that from the documentation. Here's how to do it.

In the Mango publisher:
-choose the POST method.
-For feed number 0 in your stream number 1234, choose URL:

http://www.pachube.com/api/feeds/1234/datastreams/0.csv?_method=put&key=57<bla>7e

-Add the Mango point that you'd like to publish. Use parameter name "data". Don't add the timestamp.

That's it.

hello mango users :)
actually i have posted this thread searching for help in completing a
M2M application that i wanted to have

i want to create a node that is able to receive control commands(AT commands)
and transmit data to my computer ( data is video,image,voice, or any type of data)

the controlling device is my computer(where mango is installed)
and the controlled device is a camera that is able to connect to the internet
(to the mango page)

the application(Camera in this example) will access my mango page.
:idea:
what protocol should i use in setting-up the data source and what are the requirements to complete this :?: :?: :wink: :!:

sorry for disturbance
fast reply is greatly appreciated

yours, :wink:
Hisham

Both cases are my interests... But where should I copy my applets and classes to get those found by mango's graphical views HTML insert. I only get errors: Can't find class.xxx etc. etc. when I have tried

Ensure that there is no other SNMP Trap service running on the Mango server except Mango SNMP Trap.

You can see this on a Linux system by executing the following command.

netstat -unatp |grep udp

udp 0 0 :::162 :::* 18938/java

There should be a UDP port listening on 162 and should be bound to java

Create a SNMP Data Source

Download TrapGen.exe from http://www.wtcs.org/informant/free_snmp_tools.htm

Create Trap Gen Command and note down the OID (-v .1.3.1.4.1.2854.1.2)

TrapGen.exe -d x.x.x.x -o .1.3.1.4.1.2854 -v .1.3.1.4.1.2854.1.2 INTEGER 20

Note : x.x.x.x ( Mango server IP Address)

Configure a Data Point with a SNMP Trap OID (.1.3.1.4.1.2854.1.2)

Execute the TrapGen command

TrapGen.exe -d x.x.x.x -o .1.3.1.4.1.2854 -v .1.3.1.4.1.2854.1.2 INTEGER 20

You should see the Trap received in Watchlist.

Note : Incase if the SNMP OID is not configured as in the trapgen command check the mango log file and you should see a warning like the one below.

/mango/apache-tomcat-6.0.20/logs/mango.log:WARN 2009-10-08 09:31:24,070 (com.serotonin.mango.rt.dataSource.snmp.SnmpDataSourceRT.receivedTrap:236) - Trap not handled: 1.3.1.4.1.2854.2.2 = 200