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.

Awesome, thank you! I'll try this out.

Hi Cmason

This may be possible by using the Log4j data source.
Non-empty standard output from the process will be written to the Mango log at an "information" level. Non-empty error output will be written to the Mango log at an "error" level.
you could create a log4j point on both those levels with a regex matching your standard output. Then put an event handler on the point.

Hmm, then I would suggest setting it in the /etc/network/interfaces file. Download an SSH client like PuTTY and connect to:

mango@[currentIpAddress]
Port 2222

Your unique SSH password would have been included on a sticker in the MangoGT box. If you need us to look it up, please send the serial number of the MangoGT to support@infiniteautomation.com. Use the following command to edit the file:

sudo nano /etc/network/interfaces

Then change this line:

iface eth0 inet dhcp

To be like this:

iface eth0 inet static
address x.x.x.x
netmask x.x.x.x
gateway x.x.x.x
dns-nameservers x.x.x.x

Ctrl+x, y, Enter to save. Then sudo reboot to restart the unit with the new static network settings. Gateway and DNS servers are optional if you don't need them.

have solved by using NGINX to overwrite the headers and thus help force clear the cache

Make a filter to only pull between the historic timestamp and the latest pointvalue for that point. That will filter everything out after but it may mean your chart only displays up to the last value date, not the latest date set in your datetime bar.

Fox

Have learned that systemd uses a different set of rules from the OS itself. Despite all of my settings, systemd still loaded mango with the default of 4096 max open files.
Inside /etc/systemd/system/ I had to create the directory /etc/systemd/system/mango.service.d then inside that override.conf
In override conf I had to add

[Service] LimitNOFILE=65536

So now here is hoping I stop getting these errors... In the meantime I used prlimit -p [pid] -n4096:65536 to keep things going.

EDIT: still had to change to -n65536:65536 since even at the soft limit mango was throwing these errors...

Fox

@aosc98 there is not a utility like that. However it would be possible to do the same type of RQL query on the publisher's table but it would require understanding the java backing code and how to access it from the script environment. I don't have the resources to currently supply you with a fully working example but if you are proficient in Java and Javascript this shouldn't be too much of a stretch to look into our public code on GitHub and figure it out. This might jumpstart some thoughts out there, and could work in Mango 3.7.x:

//Get a reference to Common to be able to 'find' a Spring Bean var Common = Java.type('com.serotonin.m2m2.Common'); //Find the publisher dao var dao = Common.getBean(Java.type('com.serotonin.m2m2.db.dao.PublisherDao').class); var RQLUtils = Java.type('com.infiniteautomation.mango.util.RQLUtils'); //Parse RQL to ASTNode var astNode = RQLUtils.parseRQLtoAST('eq(name,Testing Publisher)'); //Query using RQL dao.rqlQuery(astNode, function(dp, row) { console.log(dp.name); });

If it's just configuration, use the json configuration export as a base template then amend your XIDs for each of the mango units and import that over the top.

Fox

The ways I showed you there is using mangoUI within the web interface. This can be implemented from the dashboard designer.
Assuming you are using a version 3 mango system.

Look at the API exanples which have to be turned on via the menu settings to see what I mean.
If you are still without a paddle give me the overall picture of what you want to achieve and I can take you through it.

Fox

If this is the case and you've done nothing then perhaps it would be good to investigate their networks... There may be an external influence.

Fox

Taking a different approach, this example works for copying the value. So it should get me what I need, but I'd still like to know if there is a way to get the count of rows for a given variable or named range if possible.

In this example my timestamp is the first column, and epoch is the second column. I have headers above the named ranges, so it starts at row 1. This also assumes that the 'Date__EPOCH' range is empty when post processing starts.

ExcelReportUtility.openNamedRange('Date__EPOCH', false); var timestamp = null; var i = 1; do { timestamp = ExcelReportUtility.getString(0, 0, i); if (timestamp == null) { break; } ExcelReportUtility.writeStringToNamedRange('Date__EPOCH', timestamp); i += 1; }while (timestamp != null);

Awesome!
They are not HTTP payloads.
I use let's encrypt and certbot to handle certificate renewals. There is a script in mango that can be run after the cert is renewed that will move the certificate into the keystore and replace the old cert. /mango/bin/certbot-deploy.sh
You may want to look at that.

@zaaphod said in JSON RETRIEVER: Error 400:

{"slot":0,"io":{"di":[
{"diIndex":0,"diMode":0,"diStatus":0},
{"diIndex":1,"diMode":0,"diStatus":0},
{"diIndex":2,"diMode":0,"diStatus":0},
{"diIndex":3,"diMode":0,"diStatus":0}
]}}

You're already 90% of the way there.
I'd argue your code will be something like this since there is no "result" property in your incoming data.

var data = JSON.parse(content); data = data.io.di; //lets get the info we want.

However, you still need to be able to have a means to link what diIndex is what point.
If you have the points configured with a specific XID or naming convention, we can use that to map it all together.

Fox

Cripes Id love to but we are talking five thousand plus points here. Thanks so much for digging deeper

Hii
You can also use https://onlinejsontools.org/ for json validator,beautify,minify,xml,yaml,CSV,bson,plain text,base64,tsv.
Do checkout this site!

@craigweb
Thanks Craig for your help, it worked :-)