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.

We're running about 200 points on a Virtual machine with 1 CPU and 4GB of RAM. Normal system usage is about 1.5-2% CPU and 1.5GB RAM.

Once again you come to my rescue! You are quite correct. It appears that the iStat automatically assumes holding registers and so if you want an address of 40023, you need to put 23 in the modbus address for the data block. That information is not available in the documentation =( Then when reading from Mango, the offset needs to be -1, so you'd be pulling with offset 22 to get the right data point. So far so good!

Hi Thomas, I tested the three functions you mention to confirm they work (I thought they were standard functions since... ever) on java 7 and they do. Currently, there are no restrictions on the free version of the module. I am not aware of any plans to change that. Your next question is naturally, "why?" Think of it as a "wikipedia" style module. If you buy it, you help support the product and help us work toward our ultimate goals, which will include more things for free, not less.

OK I have fair idea what you're getting at, I'll try it with the meta data source and see if I can pick out the required values. Thanks for that. Cheers Dan

Hi Pikey, Are these charts on Mango pages like the Point Details page, Watch List page or do you have a custom dashboard with charts? Does the page have other components that do load ok but just the charts don't load? If you are using Chrome it would be good if you fire up Developer Tools and see if you see any error in the console. Here's an overview for Chrome Developer Tools that is helpful https://developer.chrome.com/devtools

We get great joy in seeing what you guys create with Mango. Keep up the good work Desmond!

The Image is sort of in the database. The HTTP Image source will save your images into Mango/web/WEB-INF/filedata/ and save file information into the database as a string. You certainly can use an HTML component to load a remote image for your graphical view, as well.

Hi Stefan, I assume you're talking about DGLux 2.5 (the one based on flash). Unfortunately, the answer is no, it does not backup for you. I've faced that problem a few times, and got more than a little frustrated. My various solutions are: Is the DGML existent? If so, it may be salvageable! You can find the DGML in the Export item in the menu within DGLux. If you get a really large block of markup on your dashboard that won't render, there is one or more issues somewhere in the DGML. I usually found it via binary search: find the main container and elements and cut out half, import, see if it worked, If not try the other portion, if so replace it and try to halve that section. It's important to make sure you only cut out complete tags and their contents. It's kind of a pain. It'll end up being a malformed property of a tag, like some weird connector string but no actual value (sorry I can't be more specific, I haven't done this in a long while). Or it will all be empty, and you're out of luck. Go ahead and check it on the disk too, if it is empty in DGLux. It may still have all the markup in your Mango/web/modules/dglux/web/dgml (or other directories in dglux/web). Which brings us to... Vigilance. Save to your computer (via export in menu, I believe)! Save to server! Save everywhere. Shift + s I got so aggravated when I was doing lots of DGLux work with this issue that I actually did all my development of new dashboards in a sandbox designed specifically to avoid this stuff. I had a timer element that counted to 300, and triggered a script, which increased a counter X and saved the dashboard (saving the dashboard is a behavior you can trigger) under a name like "autosaveX-dashboardName.dgml" It was irritating to have DGLux freeze for 4 seconds every five minutes, but it saved me three or four headaches over many months, so I accepted it. It's definitely part of the reason we moved toward our angular dashboards and embracing standard web technologies.

Hi Tobias! It is certainly possible! Unfortunately, it's not as easy as a click and drag. There is not a direct way to query our statistics engine from DGLux for binary points. To do this, you'll want to use a Meta point in Mango to generate the information you're interested in. The meta point would look something like this, with p being the varName of the Door point in the script's context, running every minute (you can use the cron selector, or enter "0 * * * * ?": statistics = p.past(MINUTE); if(statistics.data[0].value == true) return statistics.data[0].proportion; if(statistics.data.length < 2) return 0; return statistics.data[1].proportion; Now we've got a data point giving us minute resolution (finer resolutions can be achieved in modifying the cron and call to past()) for the binary point. This data point will have the meaning "Proportion of minute open" and will be numeric. From DGLux, you can query this point to get the values into a table. Then, you can bind the value column to a binding column on another sheet. You'll want to use the Sum rollup. Create another binding column on that table bind the value column again, and use the Count rollup. Create a formula column and have its formula be "return countColumnName - sumColumnName". Now you can bind these columns (sum and the forumla columns, click and drag the column headers) to a pie chart to get minutes in each state. If you wanted it to be a proportion, you could make formula columns and divide by the count. If you do not see anything in the sheet with the binding columns after binding (first step on the second sheet), click the add row button. You can use the meta point's history generation function to get this to work even for your past point values.

Sorry I meant to say I change the data source to MODBUS IP because I could not get the COM to to work

^ You cannot configure it such that anyone may register a user. Only admins may create users, and this includes through the API. So, while you could have a portal to create a user built on the API, that portal would have to have admin permissions.

@phildunlap Very useful information. I searched and found exactly what I needed to know in this answer. Thanks.

It sounds like the websockets are not working which could likely be caused if you are using a proxy that's not configured for it. Can you share how you have the URL being directed to Mango. We use Apache with a virtual site to act as a proxy and had issues getting the websockets to work. Here are some general instructions we put together that might be helpful: Login to VPN server and enable Websocket proxy module in Apache (just has to be done once, don’t need to do it every time): a2enmod proxy_wstunnel Go to Apache websites configuration directory: cd /etc/apache2/sites-available Backup the website config file you want to set for Websocket proxy: cp -pr <yourwebsite>.conf{,.bak} Where <yourwebsite> - is the name of config file, usually the same with website name. Edit the file <yourwebsite>.conf in your favourite editor and add below text: RewriteEngine On RewriteCond %{HTTP:Upgrade} =websocket RewriteRule /(.) ws://<Mango_IP>/$1 [P,L] RewriteCond %{HTTP:Upgrade} !=websocket RewriteRule /(.) http://<Mango_IP>/$1 [P,L] Where <Mango_IP> - is the IP address of a Mango device to which you configured ProxyPass. Reload Apache configuration: service apache2 reload

Hi Paolo, It looks to me like you should uncheck 'configuration is in hex'. If you are translating a 30 into a 0 and 33 into a 3, you are not transporting in hex, you are transporting in UTF-8 or ASCII or some such. And '0x0a' is \n You may be able to get this to work via regex like... DATA SOURCE: Use terminator: Yes Terminator: \n Message Regex: (\d+;)*([0-9]{4})[0-9]{4}.* Point Identifier Group: 1 Configuration in Hex: No DATA POINT: Data Type: Alphanumeric Point Identifier: 0103 Value Group: 1 Value Regex .*0103([0-9]{4});.*

Also, If you are trying to access historical data via MySQL you would need to also uninstall the Mango NoSQL modules. On the MangoES and Enterprise Mango the historical data is stored in the NoSQL database which is separate. Here is a follow up video that explains more: https://help.infiniteautomation.com/support/solutions/articles/14000022517-enterprise-nosql-database Note that by removing the NoSQL module you will not have access to your existing history. Also the MangoES will lose performance because MySQL is not as efficient at storing and retrieving time series data.

That was the issue and I have found the right path now.

When each will need to complete a poll durring intilization so it sounds like it's taking a long time for your slave devices to respond and for the poll to complete. If you edit the data source you can see the last 10 poll time and will look like this: [image: p8UV5Un.png] This would be useful information to know. As Phillip mentioned using the new options for a multi threaded start up should speed it up but ultimately the issue is your slave device response time. Once you have a license installed for Enterprise Demo which includes the NoSQL module it will no longer be a Demo and will be a fully working system.

Hi Mebius, I looked at your logs, and a few things were interesting. Some of your polls, especially for your SQL data source, are extremely long. Even some of the PLC polls were up to twenty minutes it looked like, which is way too long. Do you have long timeouts with many retries? The SQL source has a poll that looks like it lasts 4 hours, which is also much too long. What kind of query is it running? Do you have data in Mango during the times in which DGLux seems unresponsive?

Nice! Thanks for sharing what resolved it for you!

Glad to hear it!