Mango 3.3.0

Version 3.3.0

• Ability to import a point hierarchy path for data points in the data point JSON via "path" : "new path"
• Improved accuracy of Rollups
• Modified statistics according to
• Analog Statistics minimum value with no values in period changed from null to NaN
• Analog Statistics maximum value with no values in period changed from null to NaN
• Analog Statistics average value no values in period changed from null to NaN
• Analog Statistics integral value with no values in period changed from null to NaN
• Analog Statistics delta value with no values in period changed from null to NaN
• Gracefully skip loading data sources and data points for modules that are missing, but log occurances
• Better feedback on Core and Module upgrade/update errors
• Better dependency checking for modules during upgrade/update
• Adding tags for data points to arbitrarily store information against a data point, name and device name are default tags
• Adding websocket to notify when a data point tag is changed
• Allow accessing tags for a data point from Mango javascript
• Update Apache commons-lang3 library to 3.7
• Update Apache commons-logging to 1.2
• Improved Audit change tracking
• No longer exporting Event Detector array within Data Point JSON export
• Adding 'authorization' header to default CORS headers in env.properties
• Adding indexes to events SQL table for improved performance
• Improved database upgrade logging to db upgrade logs
• Adding Unique constraint to username's in database, delete users with higher ids and same username
• Adding env property to compact H2 database during shutdown db.h2.shutdownCompact (default is false)
• Fixes for setting thread pool sizes accurately
• Redirect user on Expired HTTP Session
• Events websocket fixed to return correct 'return to normal' timestamp
• Create new user session when logging in instead of re-using existing session
• Adding password reset option to login page, email must be configured for this to work
• Allow admin to invalidate a user's session
• Add index to user comment SQL table for performance
• Data Point WebSocket now broadcasts 'unreliable' attribute
• Fix to prevent mutliple users restarting a datapoint at the same time
• Implement User cache to improve performance
• Add NONE publish type for publishers
• Fix getting a point value after a given time which previously could have returned a wrong value from the cache
• Performance enhancements for data point cache to merge the cache on reset rather than completely discard it
• Test framework created to allow testing all Mango sub-systems independently during development
• Adding Jackson CSV support to allow better CSV rendering via REST
• Changing name of data points to variable name map from VARIABLE to CONTEXT_POINTS in Mango javascript
• Improved performance of point value queries
• Update Jackson libraray to 2.9.2
• Improved REST exception handling and error messages
• Runtime Manager synchronization changes for performance improvement
• Point Hierarchy synchronization changes for performance improvement and to prevent mangled hierarchies
• Added SQL indexes for permissions columns for better performance
• Improved data point query infrastructure for better RQL query support via REST
• Improved performance to stop/start/restart data points
• Tracking delete operations in Audit table
• Improved validation of Event Detectors
• Fixed bug where directing to HTTPS was not working from startup page
• Signing Mango Core to indicate it was downloaded from the Mango Store
• Expose point heirarhcy path for data point in Mango javascript.
• Prevent deleting any module's dependency
• Improved Access Denied logging
• Better file name when downloading CSV of data sources
• Permissions performance enhancement for admin users
• Added ID to DataPointWrapper for script environments
• Added ability to purge between times
• Fix NoUpdateEventDetectorModel and NoChangeEventDetectorModel to save duration
• Added validation to alphanumeric regex state detector's regex
• Fixed validation in many event detectors to avoid NaN being validated.
• Added descriptions to system info endpoints
• Added startValue as a rollup type
• Event handler permission is determined by all the event types it serves
• Added dataTypeId column to dataPoints table
• Upgraded H2 to 1.4.196 to finally fix the LOB not found exceptions

Mango 3.1.0 Release

** Version 3.1.0

• Better view into task scheduling system and tracking of rejected tasks
• Reduced system overhead when tasks are being rejected
• Made medium priority tasks ordered based on the type of task to ensure they run in the correct order
• Improved system settings validation
• Improved saving system settings performance
• Fixed bug with system settings import where sometimes bad values could be saved
• Finer grained version control for Module dependencies
• Fixed bug in point hierarchy when deleting folders
• Publishers REST core features fully implemented
• Event Detectors REST core features fully implemented
• Event Handlers REST core features fully implemented
• Fix bug in Audit tracking for event detectors
• Added wide query support for point values, improves efficiency for chart queries
• Upgraded GZip compression for pages/resources
• More stable startup and shutdown in situations where failures may occur
• Increased priority of shutdown task to highest possible
• Adding validation when saving/modifying event detectors
• Added 'System Action Definitions' to allow exposing various system tasks to be started via REST
• Fixed bug in MySQL create table statement for userComments table
• Validating virtual serial ports to not be able to have system port names or existing virtual port names
• Virtual serial port REST core features fully implemented

Mango 2.8.4

• Fixing bug in publisher saving
• Adding validation to publisher snapshot period type
• Added templates, virtual serial ports and jsonData to json backups
• Touched up UI for templates on edit data point page
• Fix for json import task importing new core components depending on new module components

Mango 2.8.2

• Adding 'cancel' button for upgrades.
• Bugfix for failing first database backup on Windows machines
• Fix to allow deleting empty Point Hierarchy folders whilst editing
• Upgrade advanced settings are displayed by default now

Mango 2.8.0

New Features

Testing/Analysis

• Metrics for javascript execution timing
• Query times for REST RQL database queries
• Aborted poll events are now only raised the first time a data source aborts a poll, messages are logged if the data source continues to abort polls and only every 5 minutes
• Better description for aborted task events/messages.

Event/Alarm System

• In previous versions of Mango there was no way to totally disregard an Alarm so that Mango had to do no extra work, this is now possible via the Ignore level.
• None level events can now be handled and are viewable, previously this level of alarm was being logged but was not easily viewable.
• Audit trail has been implemented and tracks changes to your configuration, this is in preparation for a new feature that will allow restoring configurations for Mango settings to a specific date/time and seeing what user made the changes.

Publisher Improvements

• The new type of publish event Logged can be used to publish only those values that are saved to the database, this is useful when publishing values for points that are interval logged.
• Alarm levels are now configurable.

Performance Improvements

• Improved count query speeds for all tables.
• Data Points database table has been optimized for query performance in large systems.
• Shutdown time now configurable to speed up shutdown at the cost of potential data loss.

Modularization of Event Handlers and Detectors

• This paves the way to create modules that will expand the current event handling and detection available in Mango.

REST

• Faster permissions filtering data points
• Adding Not Like to RQL grammar i.e. like(^pattern)
• Websocket notifications for most configuration changes are now available (tying into Dasbhoards module soon)
• CORS is now a core feature and configurable via env.properties

Misc

• Mango is now using ETag HTTP headers to improve caching in web browsers which will remove the need for users to clear there cache on future upgrades.
• MySQL Scheduled Backups are now possible.
• User passwords more secure, using BCRYPT encryption

Mango 2.7.12

Minor release for Mango 2.7

• ETag Support for caching pages
• Fixes to improve keeping Realtime Cache Up-to-date with Mango Point States
• Change H2 web console startup script to use same location as Mango's H2 database
• Added robots.txt to stop web crawling
• Changed data point permissions editing area to support more complex queries and null vs empty permissions
• Added support for Apache Cassandra point value storage (CassandraDB module required)
• Improved startup times on some databases with provisions made for improving all databases
• Adding a Serial Server socket bridge to accept incoming sockets and forward to serial ports
• Retrieve running data sources more efficiently
• Fix for aborted polls on polling data sources in systems with large amounts of alarms
• Bugfix to allow migration of JSON data SQL table
• Bugfix to prevent importing databaseSchemaVersion in JSON, causing database upgrade errors

Mango 2.7.8 Release

Version 2.7.8

• NoSQL Database env.property to change file access type for improved performance on various systems.
• Fixed bug in multi-threaded startup that would fail to initialze some data sources if the number of threads used was greater than the number of running data sources.
• Added JSON Data for custom data storage
• Replacing Spline plot type renderer on for JFree Image Chart to reduce artifacts on plots, Spline type lines are now rendered as Lines.

Mango 2.7.6

Mango 2.7.6 Release

• Adding db.nosql env properties to allow setting the location of the NoSQL data store
• Fixed bug where HTML5 pages didn't save URL parameters on a User's home URL
• Fixed bug where OSX could have problems with XHR requests from the UI
• Added tooltips to all icons on HTML5 page toolbar
• Adding Angular support for new Mango Angular Directives
• Startup script change to create logs directory on first run to capture script output
• Fixed charting for Safari and iOS via AmCharts

Mango 2.7.4

Mango 2.7.4 Release

Please report any issues with this release here

New Features Included

• Adding multi-threading to data source initialization
• Change to allow i-frame embedding of Mango hosted pages on Mango Hosted pages
• Change to ensure NONE level events do not make it into the User's Live events list
• Added latest poll times and durations to data sources edit page under the 'Runtime status' area
• Added env property runtime.datasources.logStartupMetrics to allow output of startup times for data source groups
• Added device name to event messages for data points
• Added env property runtime.realTimeTimer.defaultTaskQueueSize to allow optionally queuing up tasks of the same type
• Added env property runtime.realTimeTimer.flushTaskQueueOnReject to optionally flush the stale tasks from the queue
• Raising events for High priority thread pool's rejected tasks
• Fixed bug where copying a running data source would result in the points not actually being running
• Fixed bug where the PlainRenderer would fail to render some units
• Improved performance of the UserEventCache that caches events for the logged in Users
• Improved performance of the EventManager's active events list
• Added system settings to allow Site Analytics code to be added into the HTML of all pages
• Fixed bug where deleting a user linked to an email event handler would break the event handler
• Adding support for HTML5 Audio to play Alarm sounds on all pages
• Performance enhancements to improve maximum poll rates for data sources

Mango 2.7.2

Mango 2.7.0 Release

Please report any issues with this release here

New Features Included

• Fixed bug where uploading point values was being reject as a security breach
• Fixed bug where failures during stopping a datasource could cause it to become out of sync with the UI
• Fixed bug where adding points via the Data Source discovery tools could cause a spurious pop up that would not allow saving the point
• Now able to toggle mute via HTML5 pages, still cannot play sounds though
• Fixes to Linux startup scripts for installations with spaces in the path