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.

I'm not able to replicate this issue with the BACnet IP devices I have on my test bench, but based on the error message I think you may need to install the fontconfig package. Log into the unit locally or via SSH (port 2222) and run the following command: sudo apt-get install fontconfig

Thanks for the confirmation, I appreciate it.

Hi @Envari Have you tried clearing your cache? Seems like mango is booting up with out any issue.

Still no better

@Nurr I just confirmed this and it is a bug in the Mango Core. Only superadmin can currently create comments. This is an oversight and will be rectified for Mango 4.0 release: https://github.com/infiniteautomation/ma-core-public/issues/1651 Thanks for bringing this to our attention.

I purged the work directory, and the 302 error went away. Turns out the fact that it was the last message didn't connect it to the cause of the crash. I have sent the database and log files separately. Hopefully we can learn what's going on. Aldo

@Nurr You can just leave mango running on port 8080 and let the load balancer forward to that port.

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