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.

yes. I will purchase the mango later.

Hi I have a MangoES system with about a hundred points that I want to publish using persistent TCP. I plan to add more, too. Is there a way to bulk add all points on the system to the publisher rather than select them one by one? It would be nice too (feature suggestion!) if there were a checkbox to say 'automatically add new points created on this mango instance to publisher' or similar. Cheers

Hi, thanks for the information. We have identified some improvements in the serial data source. Take a look at this thread: http://forum.infiniteautomation.com/forum/posts/list/15/1813.page there is an updated serial module you can download and test at the bottom of the thread. If you could also send your scripts we can take a look at those but I think upgrading the serial data source would be a good first step. Thanks, Joel.

Hi, I am just starting out with Mango Automation. My hardware is Spark Core (spark.io). I am trying to use HTTP Retriever to get sensor values exposed through spark API. I am having similar trouble with parsing the html response with regex. I haven't been able to replicate the results that worked at regexpal.com. Any help with this would be very much appreciated. Thanks! My response looks like: { "cmd": "VarReturn", "name": "Outlet4State", "result": 0, "coreInfo": { "last_app": "", "last_heard": "2014-08-25T00:55:52.299Z", "connected": true, "deviceID": "xx" } } All I care about now is the binary output "result"

Good that you solved your issue and props to you for following up with how you solved it. Just so you know, 'localhost' (or its IP equivalent, 127.0.0.1) are special addresses that always refer to the loopback interface of the machine you're on. Typing 'localhost' into your mobile phone tells it to look for a website being served on.. itself!

now I install a new mango in new computer. I want to use mysql .and install mysql .but display below message .how to solve it ? 2014-08-22 14:47:33,288 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:47:33,293 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation INFO 2014-08-22 14:47:33,300 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software INFO 2014-08-22 14:47:33,307 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:47:33,310 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software INFO 2014-08-22 14:47:33,313 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese INFO 2014-08-22 14:47:33,315 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software INFO 2014-08-22 14:47:34,605 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting INFO 2014-08-22 14:47:34,607 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started INFO 2014-08-22 14:47:35,365 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:47:35,432 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController' INFO 2014-08-22 14:47:35,483 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' INFO 2014-08-22 14:47:35,542 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' INFO 2014-08-22 14:47:35,544 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController' INFO 2014-08-22 14:47:35,596 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController' INFO 2014-08-22 14:47:35,598 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController' INFO 2014-08-22 14:47:35,633 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' INFO 2014-08-22 14:47:35,635 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController' INFO 2014-08-22 14:47:35,636 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' INFO 2014-08-22 14:47:35,659 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController' INFO 2014-08-22 14:47:35,661 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' INFO 2014-08-22 14:47:35,663 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:47:35,679 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController' INFO 2014-08-22 14:47:35,681 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' INFO 2014-08-22 14:47:35,682 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' INFO 2014-08-22 14:47:36,363 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license... INFO 2014-08-22 14:47:36,365 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found INFO 2014-08-22 14:47:36,547 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager WARN 2014-08-22 14:47:39,917 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 INFO 2014-08-22 14:47:39,951 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log INFO 2014-08-22 14:47:40,048 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database ERROR 2014-08-22 14:47:40,054 (com.serotonin.m2m2.Main.main:111) - Error during initialization com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34) at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163) at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574) at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241) at com.serotonin.m2m2.Main.main(Main.java:106) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134) at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 12 more INFO 2014-08-22 14:52:06,653 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,668 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor) INFO 2014-08-22 14:52:06,688 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,700 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,713 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,716 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,720 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,723 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,750 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software INFO 2014-08-22 14:52:06,754 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,756 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,759 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software INFO 2014-08-22 14:52:06,765 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,771 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,774 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,777 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software INFO 2014-08-22 14:52:06,782 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,785 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software INFO 2014-08-22 14:52:06,790 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,796 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software INFO 2014-08-22 14:52:06,801 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software INFO 2014-08-22 14:52:06,811 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,815 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,820 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,823 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,829 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,832 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software INFO 2014-08-22 14:52:06,833 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation INFO 2014-08-22 14:52:06,836 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation INFO 2014-08-22 14:52:06,842 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor) INFO 2014-08-22 14:52:06,845 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software INFO 2014-08-22 14:52:06,848 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,850 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation INFO 2014-08-22 14:52:06,851 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software INFO 2014-08-22 14:52:06,855 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:52:06,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation INFO 2014-08-22 14:52:06,867 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software INFO 2014-08-22 14:52:06,872 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,875 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software INFO 2014-08-22 14:52:06,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese INFO 2014-08-22 14:52:06,881 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software INFO 2014-08-22 14:52:08,105 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting INFO 2014-08-22 14:52:08,106 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started INFO 2014-08-22 14:52:08,469 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:52:08,527 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController' INFO 2014-08-22 14:52:08,569 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' INFO 2014-08-22 14:52:08,629 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' INFO 2014-08-22 14:52:08,630 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController' INFO 2014-08-22 14:52:08,668 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController' INFO 2014-08-22 14:52:08,676 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController' INFO 2014-08-22 14:52:08,706 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' INFO 2014-08-22 14:52:08,712 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController' INFO 2014-08-22 14:52:08,713 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' INFO 2014-08-22 14:52:08,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController' INFO 2014-08-22 14:52:08,754 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' INFO 2014-08-22 14:52:08,755 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:52:08,801 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController' INFO 2014-08-22 14:52:08,803 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' INFO 2014-08-22 14:52:08,804 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' INFO 2014-08-22 14:52:09,365 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license... INFO 2014-08-22 14:52:09,367 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found INFO 2014-08-22 14:52:09,477 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager WARN 2014-08-22 14:52:09,875 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 INFO 2014-08-22 14:52:09,879 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log INFO 2014-08-22 14:52:10,010 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database ERROR 2014-08-22 14:52:10,015 (com.serotonin.m2m2.Main.main:111) - Error during initialization com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34) at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163) at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574) at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241) at com.serotonin.m2m2.Main.main(Main.java:106) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134) at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 12 more INFO 2014-08-22 14:56:35,980 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:35,996 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor) INFO 2014-08-22 14:56:36,009 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,021 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,041 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,044 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,050 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,053 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,085 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software INFO 2014-08-22 14:56:36,088 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,090 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,092 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software INFO 2014-08-22 14:56:36,098 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,105 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,108 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,111 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software INFO 2014-08-22 14:56:36,116 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,119 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software INFO 2014-08-22 14:56:36,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,127 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software INFO 2014-08-22 14:56:36,133 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software INFO 2014-08-22 14:56:36,144 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,147 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,153 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,156 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,159 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,162 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,166 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software INFO 2014-08-22 14:56:36,167 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation INFO 2014-08-22 14:56:36,169 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation INFO 2014-08-22 14:56:36,175 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor) INFO 2014-08-22 14:56:36,178 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software INFO 2014-08-22 14:56:36,181 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,182 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation INFO 2014-08-22 14:56:36,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software INFO 2014-08-22 14:56:36,189 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software INFO 2014-08-22 14:56:36,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation INFO 2014-08-22 14:56:36,200 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software INFO 2014-08-22 14:56:36,206 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,208 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software INFO 2014-08-22 14:56:36,211 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese INFO 2014-08-22 14:56:36,213 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software INFO 2014-08-22 14:56:37,456 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting INFO 2014-08-22 14:56:37,458 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started INFO 2014-08-22 14:56:37,820 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:56:37,887 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController' INFO 2014-08-22 14:56:37,933 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' INFO 2014-08-22 14:56:37,994 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' INFO 2014-08-22 14:56:37,995 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController' INFO 2014-08-22 14:56:38,032 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController' INFO 2014-08-22 14:56:38,041 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController' INFO 2014-08-22 14:56:38,065 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' INFO 2014-08-22 14:56:38,076 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController' INFO 2014-08-22 14:56:38,078 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' INFO 2014-08-22 14:56:38,113 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController' INFO 2014-08-22 14:56:38,120 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' INFO 2014-08-22 14:56:38,121 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController' INFO 2014-08-22 14:56:38,157 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController' INFO 2014-08-22 14:56:38,159 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' INFO 2014-08-22 14:56:38,160 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' INFO 2014-08-22 14:56:38,707 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license... INFO 2014-08-22 14:56:38,709 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found INFO 2014-08-22 14:56:38,819 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager WARN 2014-08-22 14:56:39,215 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 INFO 2014-08-22 14:56:39,218 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log INFO 2014-08-22 14:56:39,354 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database ERROR 2014-08-22 14:56:39,359 (com.serotonin.m2m2.Main.main:111) - Error during initialization com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34) at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163) at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574) at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241) at com.serotonin.m2m2.Main.main(Main.java:106) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134) at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 12 more INFO 2014-08-22 15:03:58,695 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,722 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor) INFO 2014-08-22 15:03:58,725 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,737 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,749 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,761 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,768 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,772 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,799 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software INFO 2014-08-22 15:03:58,802 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,804 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,806 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software INFO 2014-08-22 15:03:58,813 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,821 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,824 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,826 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software INFO 2014-08-22 15:03:58,831 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,834 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software INFO 2014-08-22 15:03:58,838 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,843 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software INFO 2014-08-22 15:03:58,849 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software INFO 2014-08-22 15:03:58,859 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,871 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,874 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,877 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,879 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,883 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software INFO 2014-08-22 15:03:58,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation INFO 2014-08-22 15:03:58,889 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation INFO 2014-08-22 15:03:58,895 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor) INFO 2014-08-22 15:03:58,898 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software INFO 2014-08-22 15:03:58,901 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,902 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation INFO 2014-08-22 15:03:58,904 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software INFO 2014-08-22 15:03:58,908 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:03:58,917 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation INFO 2014-08-22 15:03:58,923 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software INFO 2014-08-22 15:03:58,929 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,931 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software INFO 2014-08-22 15:03:58,934 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese INFO 2014-08-22 15:03:58,936 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software INFO 2014-08-22 15:04:00,176 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting INFO 2014-08-22 15:04:00,178 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started INFO 2014-08-22 15:04:00,548 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' INFO 2014-08-22 15:04:00,610 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController' INFO 2014-08-22 15:04:00,646 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' INFO 2014-08-22 15:04:00,714 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' INFO 2014-08-22 15:04:00,720 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController' INFO 2014-08-22 15:04:00,753 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController' INFO 2014-08-22 15:04:00,761 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController' INFO 2014-08-22 15:04:00,800 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' INFO 2014-08-22 15:04:00,809 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController' INFO 2014-08-22 15:04:00,811 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' INFO 2014-08-22 15:04:00,851 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController' INFO 2014-08-22 15:04:00,856 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' INFO 2014-08-22 15:04:00,857 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController' INFO 2014-08-22 15:04:00,898 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController' INFO 2014-08-22 15:04:00,900 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' INFO 2014-08-22 15:04:00,901 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' INFO 2014-08-22 15:04:01,453 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license... INFO 2014-08-22 15:04:01,455 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found INFO 2014-08-22 15:04:01,566 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager WARN 2014-08-22 15:04:01,983 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 INFO 2014-08-22 15:04:01,986 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log INFO 2014-08-22 15:04:02,121 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database ERROR 2014-08-22 15:04:02,134 (com.serotonin.m2m2.Main.main:111) - Error during initialization com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34) at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163) at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574) at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241) at com.serotonin.m2m2.Main.main(Main.java:106) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134) at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 12 more INFO 2014-08-22 15:04:49,049 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,064 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor) INFO 2014-08-22 15:04:49,076 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,093 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,106 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,113 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,120 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,151 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software INFO 2014-08-22 15:04:49,154 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,155 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,157 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software INFO 2014-08-22 15:04:49,165 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,172 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,174 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,179 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software INFO 2014-08-22 15:04:49,184 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,187 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software INFO 2014-08-22 15:04:49,191 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,197 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.9 by Infinite Automation Software INFO 2014-08-22 15:04:49,203 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.1 by Infinite Automation Software INFO 2014-08-22 15:04:49,212 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,218 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,224 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,227 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,229 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,232 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,235 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software INFO 2014-08-22 15:04:49,236 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation INFO 2014-08-22 15:04:49,240 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation INFO 2014-08-22 15:04:49,248 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor) INFO 2014-08-22 15:04:49,251 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software INFO 2014-08-22 15:04:49,253 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,255 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation INFO 2014-08-22 15:04:49,256 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software INFO 2014-08-22 15:04:49,260 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software INFO 2014-08-22 15:04:49,270 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation INFO 2014-08-22 15:04:49,275 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.12 by Infinite Automation Software INFO 2014-08-22 15:04:49,278 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,282 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software INFO 2014-08-22 15:04:49,284 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese INFO 2014-08-22 15:04:49,286 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software INFO 2014-08-22 15:04:50,530 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting INFO 2014-08-22 15:04:50,532 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started INFO 2014-08-22 15:04:50,914 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController' INFO 2014-08-22 15:04:50,979 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController' INFO 2014-08-22 15:04:51,019 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController' INFO 2014-08-22 15:04:51,090 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController' INFO 2014-08-22 15:04:51,096 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController' INFO 2014-08-22 15:04:51,137 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController' INFO 2014-08-22 15:04:51,145 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController' INFO 2014-08-22 15:04:51,178 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController' INFO 2014-08-22 15:04:51,185 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController' INFO 2014-08-22 15:04:51,191 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController' INFO 2014-08-22 15:04:51,232 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController' INFO 2014-08-22 15:04:51,234 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController' INFO 2014-08-22 15:04:51,235 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController' INFO 2014-08-22 15:04:51,281 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController' INFO 2014-08-22 15:04:51,284 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController' INFO 2014-08-22 15:04:51,287 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController' INFO 2014-08-22 15:04:51,868 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license... INFO 2014-08-22 15:04:51,869 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found INFO 2014-08-22 15:04:51,973 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager WARN 2014-08-22 15:04:52,368 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2 INFO 2014-08-22 15:04:52,371 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to /opt/aa1/logs/com.serotonin.m2m2.db.upgrade.Upgrade1.log INFO 2014-08-22 15:04:52,504 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database ERROR 2014-08-22 15:04:52,510 (com.serotonin.m2m2.Main.main:111) - Error during initialization com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:102) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:34) at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:163) at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:574) at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:241) at com.serotonin.m2m2.Main.main(Main.java:106) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table publishers add column rtdata longblob; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427) at com.serotonin.m2m2.db.BasePooledProxy.runScript(BasePooledProxy.java:73) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:129) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:143) at com.serotonin.m2m2.db.upgrade.DBUpgrade.runScript(DBUpgrade.java:134) at com.serotonin.m2m2.db.upgrade.Upgrade1.upgrade(Upgrade1.java:17) at com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:98) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'rtdata' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:526) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:266) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:420) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 12 more

What 's wrong with it please refer to attachment. BR Attachment: download link

As topic. how to undisplay "reports" icon and "help" icon and "DGLUX" icon when "user" log in ?

I unzip a new m2m2 and copy old database -----mah2.h2.db,mah2.lock.db,mah2.trace.db in mango_automation_2.4.0_full_install\databases (the old databases have store some days data.) But when I filter in data point and display like attachment. How to solve it ? Attachment: download link

Haha ,Very stranger ,Test many times and status is like before .finally I restart the computer it is ok!!!

Each time the scrip runs it will do the action that matches the conditions you create. So if the first if in your scrip is true each time it runs then it will do the sets each time. If they are modbus registers then it will send out new modbus set commands each time. You can get around this by putting additional conditions in the first if statement.

As topic How to setting can only display "urgent alarm" button and no need "information events","critical events alarm", "lifte safety Events" on top center alarm button for user? Thank for your help.

You could use the HTTP Retriever I think.

It's the same answer from another thread, but I would use meta points to define complex conditions.

Hi Terry, That last Data Source seems to have fixed the crashing. How do I remove the added debug messages from the logs? I have removed the line from the log4j configuration file and restarted Mango but the messages keep coming. I am getting daily logs over 650MB in size. Cheers, Matt.

Maybe it's covered in the [url=http://forum.infiniteautomation.com/forum/recentTopics/showTopicsByUser/11563.page]Mango Automation FAQ

Database settings for conversion. If the db.* settings point to a new database instance, and the convert type setting is set, Mango Automation will attempt to convert from the convert.db.* settings to the db.* settings

This is a known issue and has been resolved for the next release coming soon. In the mean time see this thread you started: http://forum.infiniteautomation.com/forum/posts/list/1796.page

Is the ^ part of the pattern? I don't see a $ so it sort of looks like it would be...

One thing you could theoretically do is put in an event for no update X minutes, and give that event a handler that sets the point to 0. But, this would mix the zeros in with your data and possibly cause other problems if someone mistakes it for real. In DGLux you can write a script that combs the source value table and transposes it into another table, interpolating however you like. For the current built-in charts, I don't believe there is a solution like the second.