Thanks Joel,

I'll keep that in mind!

Cheers!

Hi Joel,

That sounds good... I can create a data source per logical 'group' to query values - this will probably speed up templating the whole thing, and spreading the queries across multiple connections will help things scale too I think..

The number of results can vary depending on the query... we can change the query to return a single data point "current value" or a list of variables/values relevent to the device we are querying data for.

The queries would probably run once per minute, and there could be up to 1000 data points, so that'd be ~17 data points updated per second as a ballpark guess.

This would grow over time and in its final state (after a few years of growth) could be about 4x this.

Hi,

I'm writing up a proposal for a client... they have a Kepware OPC server that has a MS-SQL database back end that is fed data from their Siemens control system...

The client has said that he would like us to look at querying the MS-SQL database directly for all the values for the system... His intention is to replicate the SQL DB from their secure network to a DMZ for us to talk to - providing better isolation given this system will be exposed to the internet.

1. Is there any limitations or scalability issues with query for thousands of values via a database connection?
2. Does Mango keep a connection alive per data source and issue all the defined queries across that link, or does it connect, authenticate, query, disconnect?

Is there a better way to query an OPC server for this kind of data?

Cheers!
-Shaun

Hi @JoelHaggar, @phildunlap
Thanks for the help...

Joel, we'd be looking to implement as soon as the feature was available :)
If its not too much trouble, please let me know when this is ready for testing - I'd be happy to test this ahead of a production release!

As for permissions, if you did have the ability to permit changes to event detectors separate to data points, that would give some extra security and protection from users, but it would probably be fine to give them edit permission to the data point.

Phil, this sounds like it might be an option for us in the event that our customer requires us to have this implemented before the work Joel talks about is ready.

Thanks
Shaun

Hi,

I need to give a customer access to edit event detector threshold values via a dashboard.

Is there a way I can do this?

Is there something in the API I can use for this, or even an example I could look at?

Ideally it'd need to be dynamic so something like, for a given device, list all the event detectors that exist so you can select one and edit it.

Thanks
Shaun

Thanks @Jared-Wiltshire :)

Hi All,

I have a project with a requirement for many users (potentially several hundred) to access dashboards, where each user might receive a different view based on a set of rights (group membership?).

I know I can create many user accounts and groups within Mango, but given there could be several hundred users to manage, I'd like to use an external system for authentication and possibly group membership/rights management such as Active Directory, Google, Facebook etc.

Alternately, if we do use Mango's internal user/group management system, what are the practical limits? Is there access via the API to manage user accounts so I can author a management system that would ideally also include 'ooops, I forgot my password' functionality?

Cheers!
-Shaun

If you're running any software on a computer that others have access to login to or to the file system, you're already at a disadvantage if you're trying to minimise or control access.

Ultimately, if you have R/W access to files on the disk or the memory of the computer/server running any software, you can reset passwords, or use other methods to break in - like reading passwords out of active memory, stack tracing, or other available "debugging" methods.

A vendor can bake in some kind of 'protection' so you can lock a system down (like non-resettable admin passwords), but ultimately these are just a deterrent - with some effort, this kind of thing can often be overcome. As an example, Mitsubishi Alpha PLC passwords are easily discovered if you know what area of memory to read from their config tool when it 'tests' the password you enter. Ask me how I know ;p

The best approach to protect your work is to deploy as a 'black box' type system. You run on a MangoES, Separate physical server, or Virtual Machine, where you give your client only the minimum access required to use the system such as a less privileged user to login via web browser only to a dashboard. This also gives you the opportunity to sell them 'support' on either per-incident or subscription basis for the deployment.

Hope this helps!

Cheers!
-Shaun

Oh! @phildunlap I didn't realise thats what that button was for.. haha!

Thanks again, and thanks very much for the script too!

Cheers!
-Shaun

Thanks for the details guys...

I'm familiar with the CSV export from the data points/sources page, but that doesn't give you the event detectors that I can get from the config export.

When I build a reusable template based on json config I usually include the data source, data points, event detectors, event handlers, and the point hierarchy... I try to make it as complete as possible.

Most of the deployments I work on have many of the same device, so fast duplication with just changes of names, IPs, modbus IDs etc makes life easy.

I'll have to explore the API and scripting as you both suggest soon!

Cheers!
-Shaun

Hi Guys,

I find myself more and more exporting configuration from mango and hand/bulk editing JSON, then re-importing it to make additions to the system.

Normally I would use the UI to create a data source, and then a set of data points that I would then iterate over in a text editor to make more similar points or duplicate devices. I use this like a template.

As the configuration grows this process takes longer cull data out of tens-of-thousands of lines of export.

Feature request: Can we get an additional feature on the configuration export tool to filter by a few fields? eg: parent device, XID, text pattern match/regex match on a field?

Something really simple here is probably all we need to make this method of template-export-edit-bulk add easier to manage.

Unless there is already an easier way to bulk add that I'm not aware of?

Cheers!
-Shaun

@phildunlap

Thanks Phil, 'Do No Log' sounds like exactly what I need... thanks!

Cheers!
-Shaun

Hi All,

I have some data points with event detectors of the "Change" type configured.

These then have an event handler to send an email notification to notify of the change of state.

This is just to notify the supervisor of the system that an automated event has occurred. It does not require an acknowledgement.

How can I get the event to auto-resolve either immediately or perhaps one minute after the event fires?

In this particular case its simply notifying of change of duty/standby state in a Data Centre air conditioning system where multiple units are load sharing in a group and the standby unit is rotated so they all have even run hours.

Cheers!
-Shaun

@phildunlap

Thanks Phil, I'll see what I can come up with!

In the short term, Its probably going to be easier to just capture the values from the static OIDs and do checks within mango for out of range with an event detector.

Cheers!
-Shaun

@phildunlap
Try this URL for the mib:
https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwiKosKUy93VAhWFy7wKHfsQBOAQFggoMAA&url=http%3A%2F%2Fpqlit.eaton.com%2Fll_download_bylitcode.asp%3Fdoc_id%3D29400&usg=AFQjCNFxtuKksQdwY-6tszPc-HOZmTn7_A

The file upload thing doesn't seem to be working for some reason...

Dynamic table was probably the wrong wording for it.. but the content of the table is variable.. if you have a look at the screenshot attached to this post, i did a walk on the 'activealarmstable' and you can see the alarmSequenceIndex.N results where N is a unique ID for the alarm. That index is then used as a suffix with the description, value, level and time to form what could be interpreted as a table. I called i dynamic (in error?) because the content and index numbers are totally variable.

Cheers!
-Shaun

Hi All,

I have an Eaton UPS where the alarms are presented in what looks like a dynamic SNMP table.

I need to be able to get the alarms from this device to pass up and get an event handler to fire.

I've uploaded the MIB as an attachment (EATON-PXG-MIB) as well as a screenshot from my mib browser showing some sample results.

Other devices I've configured in the past have a static table of true/false OIDs for different alarms, but this one is a bit different.

Cheers!
-Shaun
[0_1502947011173_EATON-PXG-MIB.txt](Uploading 100%)

Hi Jared,

Still trying to get the admin template going... I'm not sure if I'm doing something wrong...

What I've developed previously doesn't work still so I thought I'd try the adminTemplate as if it were 'new'...

I've got the latest mango 3 updated thismorning.

I copied from mango/web/modules/mangoUI/web/adminTemplate to:
mango/overrides/web/modules/mangoUI/web/test

I then renamed as instructed in index.html the paths replacing 'adminTemplate' with 'test'.

I then tried to hit http://localhost:8080/user-ui/test/ and I'm greeted with a spinning gear forever.

Am I missing something?

Cheers!
-Shaun

Hi @Jared-Wiltshire

I think we might have a few customisations, yes. If its Wednesday 31st, I can wait until then. If I have any dramas after the update I'll let you know.

Cheers!
-Shaun

Hi All,

I've got an existing dashboard based on the adminTemplate in Mango 2.8 and would like to use it as the basis for a new but very similar project using mango 3.0. As much as I'd love to re-do it all with the new dashboard system, its not really an option time wise.

I've been looking to see how best to migrate this, but it seems there have been significant changes under the hood with Mango that means this is not a trivial thing to do.

I notice there is another thread saying that the adminTemplate is broken right now in Mango 3.0, so I can't even use that as a good reference to start from.

Is there any guide or documentation on how to migrate?

Cheers!
-Shaun

Thanks guys!

As always, appreciate your help!

Cheers!