Version 1.13.2 of Mango has not yet been released, but some users have already expressed concern with regard to how long the database update may take. The update this time is particularly onerous, making some significant changes to the pointValues and pointValueAnnotations tables. If your instance uses MySQL and contains upwards of millions of records (a configuration that was specifically tested), you might expect a conversion time of hours.

If this downtime is unacceptable, below is an alternative conversion method. This procedure is intended for MySQL, but can be adapted for other databases. Note that it includes two restarts of Mango. During the uptime between restarts, the accumulated history will not be available.

Shut down Mango, and apply the 1.13.2 upgrade.

Access your MySQL database using the mysql console, or a tool like the MySQL Workbench, and execute the following statements.

rename table pointValues to pointValuesSave; rename table pointValueAnnotations to pointValueAnnotationsSave; create table pointValues ( id bigint not null auto_increment, dataPointId int not null, dataType int not null, pointValue double, ts bigint not null, primary key (id) ) engine=MyISAM; create index pointValuesTempIdx1 on pointValues (dataPointId, ts); create table pointValueAnnotations ( pointValueId bigint not null, textPointValueShort varchar(128), textPointValueLong longtext, sourceType smallint, sourceId int, primary key (pointValueId) ) engine=MyISAM; update systemSettings set settingValue='1.13.1' where settingName='databaseSchemaVersion';

This will copy your pointValues tables to new names, and create proxies in their place. These statements should execute quickly.

Restart Mango. All history will appear to be gone, but new samples will be stored.

Run the following statements:

alter table pointValueAnnotationsSave drop foreign key pointValueAnnotationsFk1; alter table pointValueAnnotationsSave ENGINE = MyISAM; alter table pointValueAnnotationsSave add primary key (pointValueId); alter table pointValuesSave drop foreign key pointValuesFk1; drop index pointValuesIdx1 on pointValuesSave; drop index pointValuesIdx2 on pointValuesSave; alter table pointValuesSave ENGINE = MyISAM; create index pointValuesIdx1 on pointValuesSave (dataPointId, ts);

These statements will convert the pointValues tables to MyISAM, remove FKs, and keep only necessary indices. They may take a very long time to run.

Shut down Mango, and execute the following statements: insert into pointValuesSave (id,dataPointId,dataType,pointValue,ts) select id,dataPointId,dataType,pointValue,ts from pointValues; insert into pointValueAnnotationsSave (pointValueId,textPointValueShort,textPointValueLong,sourceType,sourceId) select pointValueId,textPointValueShort,textPointValueLong,sourceType,sourceId from pointValueAnnotations; drop table pointValues; drop table pointValueAnnotations; rename table pointValuesSave to pointValues; rename table pointValueAnnotationsSave to pointValueAnnotations;

These statements will copy all of the newly collected data into the old tables, and then rename the tables back to their original names. These should run quickly, depending on how much new data has been collected into the proxy tables.

Restart Mango. The database upgrade is now complete. All history should again be available.

Note that application features that depend upon history data should be disabled, such as the PTCP publisher data sync.

We can only take it as an annoying type of flattery, but the amount of spam that this forum is getting has passed our tolerance. We don't want to go as far as moderating messages, so for now we've only made recaptcha a registration requirement. This is of course no guarantee that the spam will stop, so we'll cross our fingers and apologize in advance for the nuisance, should it continue.

The official production release of Mango M2M2 is now available. Download version 1.0.1 of the core now. Make sure you get the associated module versions as well. Look for module versions marked as "1.x - #.#.#".

Ok, server trouble should all be fixed now. To boot, the Mango site and these forums should also be a bit quicker. (Thanks to a better data center.) The only thing remaining is the "example" view, which is probably still out.

Moved to new topic at General Discussion

it works good.

We're going to make this a pluggable feature of Mango V2 (aka M2M2). The thinking is that a template module could be written that would allow users to customize to their exact needs. Not sure how this will work exactly at the moment though.

To all real life Mango users. Our apologies for the spam that is occasionally sent via these forums. We are currently considering replacing this forum software in our long overdue but hopefully soon full site redesign. In the meantime we are mopping up spam messages as quickly as we can. Please bear with us.

A new version of Mango has been released: 1.10.0. Great new functionality is available. See the release notes page for more information.

Special note: for all users who have been patiently waiting, an OPC DA data source will be available in the next release.

The license for BACnet4J has been updated from LGPL to GPL v3.0. Users of BACnet4J that use the product for commercial purposes may purchase a license from Serotonin that permits them to continue to use it as such. Please use the Contact Us page to inquiry of the details.

The license for Modbus4J has been updated from LGPL to GPL v3.0. Users of Modbus4J that use the product for commercial purposes may purchase a license from Serotonin that permits them to continue to use it as such. Please use the Contact Us page to inquiry of the details.

I found that:

this step is not needed for Ubuntu Desktop 10.04 it is required for a simple installation of Ubuntu server 10.04

Someone asked recently how they could control the values of multiple points from a single click. Kind of like a "broadcast" of a set point. Today I got around to testing the idea that came to mind, but didn't want to suggest without being sure of it. Turns out it works nicely...

Point linking is the key. In my test i created a new virtual data source with three binary points. The first is the "master" point, and the other two are "slave" points. All three are settable (with the "no change" setting so that they don't change on their own). I then enabled everything: points and data source.

Next, i simply created two point links using the master as the source and the slaves as the targets. Creating a watchlist confirms that whenever i set the value of the master, the values of the slaves are also set. Individual set points failures will not kill the "broadcast"; individual failure alarms will be raised as appropriate. Also, if, say, one of the points needed to be the opposite value of the master, i can use the point link script to do the transformation.

Do you find Mango useful? Do you want it to get better? Do you want to help?

The easiest way you can help out Mango is to let others know what you think! Please link to Mango from your web site. (Use logos and such if you like too, and link to http://mango.serotoninsoftware.com.) Or, write a short description of how you use Mango to put on our home page.

The more people there are who use Mango, the more it will be developed and improved.

Thanks!

hello all.
I get below messages when I convert derby to mysql, mango 2.2
INFO 2014-05-28 11:22:10,698 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.0.5 by Infinite Automation Software
INFO 2014-05-28 11:22:10,744 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.1 by Infinite Automation
INFO 2014-05-28 11:22:10,760 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.1 by Infinite Automation Software
INFO 2014-05-28 11:22:10,760 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.8 by Infinite Automation Software
INFO 2014-05-28 11:22:10,760 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,760 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,760 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.5 by Infinite Automation Software
INFO 2014-05-28 11:22:10,791 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,791 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,807 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,807 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.1 by Infinite Automation Software
INFO 2014-05-28 11:22:10,823 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.4 by Infinite Automation Software
INFO 2014-05-28 11:22:10,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.1 by Infinite Automation Software
INFO 2014-05-28 11:22:10,854 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.5 by Infinite Automation Software
INFO 2014-05-28 11:22:10,854 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbusPublisher', v1.2.1 by Infinite Automation Software
INFO 2014-05-28 11:22:10,869 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,869 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,869 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.5 by Infinite Automation Software
INFO 2014-05-28 11:22:10,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,901 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.3 by (unknown vendor)
INFO 2014-05-28 11:22:10,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.4 by Infinite Automation Software
INFO 2014-05-28 11:22:10,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.0 by Infinite Automation
INFO 2014-05-28 11:22:10,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,932 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,932 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,948 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,948 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,948 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,963 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,963 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.2 by Infinite Automation Software
INFO 2014-05-28 11:22:10,963 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.3 by Infinite Automation Software
INFO 2014-05-28 11:22:10,979 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.3 by Infinite Automation Software
INFO 2014-05-28 11:22:12,213 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-05-28 11:22:12,213 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-05-28 11:22:12,854 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-05-28 11:22:12,885 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-05-28 11:22:12,994 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-05-28 11:22:13,057 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-05-28 11:22:13,057 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-05-28 11:22:13,088 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-05-28 11:22:13,088 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-05-28 11:22:13,119 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-05-28 11:22:13,135 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-05-28 11:22:13,135 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-05-28 11:22:13,166 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-05-28 11:22:13,182 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-05-28 11:22:13,182 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-05-28 11:22:13,244 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-05-28 11:22:13,244 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-05-28 11:22:13,244 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-05-28 11:22:13,869 (com.serotonin.m2m2.Lifecycle.lic:400) - Checking license...
INFO 2014-05-28 11:22:13,869 (com.serotonin.m2m2.Lifecycle.loadLic:514) - License file not found
INFO 2014-05-28 11:22:13,963 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
INFO 2014-05-28 11:22:14,682 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:36) - Starting instance with core version 2.2.2, db 9
INFO 2014-05-28 11:22:15,635 (com.serotonin.m2m2.Lifecycle.configureDwr:813) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr
INFO 2014-05-28 11:22:15,651 (com.serotonin.m2m2.Lifecycle.configureDwr:813) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.modbus.dwr.ModbusEditDwr
INFO 2014-05-28 11:22:15,651 (com.serotonin.m2m2.Lifecycle.configureDwr:813) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr
INFO 2014-05-28 11:22:15,682 (com.serotonin.m2m2.Lifecycle.configureDwr:813) - Duplicate definition of DWR class ignored: com.serotonin.m2m2.http.dwr.HttpDataSourceDwr
INFO 2014-05-28 11:22:15,682 (com.serotonin.m2m2.Lifecycle.configureDwr:813) - Duplicate definition of DWR class ignored: br.org.scadabr.dnp3.dwr.DnpEditDwr
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_details.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/pending_alarms.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/event_handlers.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_sources.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/point_hierarchy.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mailing_lists.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publishers.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/system_settings.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/modules.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/emport.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/upload.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/download.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile_data_point_details.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/templateConfig.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/dataImport.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/dglux.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,744 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/dglux/login.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/views.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/public_view.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/view_edit.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/maintenance_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/point_links.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/reportChart.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/reports.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,760 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/scheduled_events.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/sqlConsole.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/globalScripts.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/login.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/watch_list.shtm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]
INFO 2014-05-28 11:22:15,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/logout.htm] onto handler of type [class com.serotonin.m2m2.web.mvc.UrlHandlerController]

it looks there is no error, but it stops here everytime I start mango.
I checked mysql database, all the tables were created, but not all of the datas converted into mysql.

This post has been superseded by this one: http://mango.serotoninsoftware.com/forum/posts/list/185.page.

A quick description of some of the cool features included in Modbus4J

ModbusFactory for easily creating master and slave instances ProcessImageListener: a callback mechanism that makes the handling of slave write events very simple Pluggable exception listeners: no more setting debug=true or dumping errors to System.out. Handle exceptions like you want in client code. Controllable slaves: as i recall the jamod slave implementation starts on VM startup and only stops when the VM is killed. In Modbus4J they are completely controllable. Node scanning: you can ask the Modbus master to scan for probable active nodes either as a blocking thread or a progressive (and cancel-able) task. Simple polling with batch reads that 1) are very intuitive to create, 2) have their responses automatically deconstructed and referenced according to client code, and 3) automatically optimize by making a mimimal number of contiguous requests. Simple write commands that will attempt to use optimal requests (such as WriteMaskRegisterRequest) but will failover to more typical requests if the node appears to not support. (This result is also automatically remembered so that it doesn't try the unsupported request again.)

Thanks for reporting this. There was a problem in the Who-Has deserialization. A fix has been checked into the CVS repo. Note that the constructor API has changed slightly for this class as well.

In response to the requests for information from developers, we are adding this forum for information about Modbus4J. It is a general purposes Modbus implementation that is used by Mango, but can be used for other purposes as well. So go ahead... everything you wanted to know, ask away!

Serotonin makes more revenue on requests for enhancements than on licenses. The thinking is that if more people will use it when it is free, then consulting revenues will increase accordingly. At least that's the running theory. If true, you can be sure that the product will continue being developed and supported.