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.
Why I try convert from h2 to mysql is unsuccessful?
-
NOW I use mango2.4.0 .try convert database . configuration is below:
Copyright (C) 2014 Infinite Automation Systems Inc. All rights reserved.
@author Matthew Lohbihler
###############################################################################
TO OVERRIDE VALUES IN THIS FILE...
Do not change the values in this file, because when you upgrade your core
your changes will be overwritten. Instead, create a new file called
<MA_HOME>/overrides/properties/env.properties and override properties
there. The overrides directory will never be overwritten by an upgrade, so
your customizations will be safe.
###############################################################################
The port at which Mango Automation will listen for browser connections
web.port=8087
Should Mango Automation open (if possible) a browser window when it starts up?
web.openBrowserOnStartup=true
Default database settings.
convert.db.type= h2
convert.db.url=${ma.home}/databases/mah2
#db.username=
#db.password=#General Database Settings
db.pool.maxActive=10
db.pool.maxIdle=10
db.update.log.dir=${ma.home}/logs/setting to show query times in the logs as INFO
db.useMetrics=false
MySQL database settings. Your MySQL instance must already be running and configured before this can be used.
db.type=mysql
db.url=jdbc:mysql://localhost/abc
db.username=abc
db.password=123Database 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
#convert.db.type=
#convert.db.url=${convert.db.url}
#convert.db.username=${convert.db.username}
#convert.db.password=${convert.db.password}The location of the Mango Automation store from which to get license files.
store.url=http://store.infiniteautomation.com
SSL control
ssl.on=false
ssl.port=8443
ssl.keystore.location=/location/to/keystore/file.jks
ssl.keystore.password=freetextpasswordSystem time zone. Leave blank to use default VM time zone.
timezone=
distributor=IA
original database:
Copyright (C) 2014 Infinite Automation Systems Inc. All rights reserved.
@author Matthew Lohbihler
###############################################################################
TO OVERRIDE VALUES IN THIS FILE...
Do not change the values in this file, because when you upgrade your core
your changes will be overwritten. Instead, create a new file called
<MA_HOME>/overrides/properties/env.properties and override properties
there. The overrides directory will never be overwritten by an upgrade, so
your customizations will be safe.
###############################################################################
The port at which Mango Automation will listen for browser connections
web.port=8083
The host interface to which Mango Automation will bind and listen for new connections
0.0.0.0 is the special interface that will force a bind to all available interfaces
web.host=0.0.0.0
Should Mango Automation open (if possible) a browser window when it starts up?
web.openBrowserOnStartup=true
Default database settings.
db.type=h2
db.url=jdbc:h2:${ma.home}/databases/mah2
db.location=${ma.home}/databases/mah2
db.port=8081
db.username=mango
db.password=mango
#For web console
db.web.start=false
db.web.port=8091#db.type=derby
#db.url=${ma.home}/madb
#db.username=
#db.password=#General Database Settings
db.pool.maxActive=100
db.pool.maxIdle=10
db.update.log.dir=${ma.home}/logs/setting to show query times in the logs as INFO
db.useMetrics=false
MySQL database settings. Your MySQL instance must already be running and configured before this can be used.
#db.type=mysql
#db.url=jdbc:mysql://localhost/<your mysql schema name>
#db.username=<your mysql username>
#db.password=<your mysql password>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
convert.db.type=
convert.db.url=${convert.db.url}
convert.db.username=${convert.db.username}
convert.db.password=${convert.db.password}The location of the Mango Automation store from which to get license files.
store.url=http://store.infiniteautomation.com
SSL control
ssl.on=false
ssl.port=8443
ssl.keystore.location=/location/to/keystore/file.jks
ssl.keystore.password=freetextpasswordSystem time zone. Leave blank to use default VM time zone.
timezone=
distributor=IA
the ma.log is below:
INFO 2014-08-08 01:25:06,471 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-08 01:25:06,587 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-08 01:25:06,614 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-08 01:25:06,618 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.0 by Infinite Automation Software
INFO 2014-08-08 01:25:06,682 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'controlcore', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:25:06,688 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:25:06,737 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-08 01:25:06,743 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-08 01:25:06,765 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:06,790 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:06,794 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:25:07,004 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:07,083 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,256 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,273 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-08 01:25:07,521 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,525 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-08 01:25:07,526 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:25:07,546 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,560 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-08 01:25:07,585 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:25:07,624 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,652 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,655 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-08 01:25:07,687 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:25:07,698 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:07,725 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pid', v1.0.2 by Infinite Automation
INFO 2014-08-08 01:25:07,766 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,782 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,806 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.6 by Infinite Automation Software
INFO 2014-08-08 01:25:07,862 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-08 01:25:07,880 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-08 01:25:07,885 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-08 01:25:07,891 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,895 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,899 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,905 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,909 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,914 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:07,917 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,929 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-08 01:25:07,933 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:07,938 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:07,942 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-08 01:25:12,043 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-08 01:25:12,043 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-08 01:25:12,820 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:25:12,878 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-08 01:25:12,920 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-08 01:25:13,113 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-08 01:25:13,114 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-08 01:25:13,160 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-08 01:25:13,161 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-08 01:25:13,207 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-08 01:25:13,209 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-08 01:25:13,210 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-08 01:25:13,253 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-08 01:25:13,254 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-08 01:25:13,255 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:25:13,292 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-08 01:25:13,293 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-08 01:25:13,295 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-08 01:25:15,405 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-08 01:25:15,405 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-08 01:25:15,572 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-08 01:25:25,415 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-08 01:25:25,418 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to C:\opt\dcinsight\mango_automation_2.4.0_full_install\logs\com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-08 01:25:25,807 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-08 01:25:25,810 (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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
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-08 01:25:50,635 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-08 01:25:50,653 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-08 01:25:50,661 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-08 01:25:50,667 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.0 by Infinite Automation Software
INFO 2014-08-08 01:25:50,681 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'controlcore', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:25:50,691 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:25:50,705 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,710 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-08 01:25:50,712 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,719 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,729 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:25:50,774 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:50,785 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,790 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,806 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-08 01:25:50,841 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,844 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-08 01:25:50,845 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:25:50,851 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,855 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-08 01:25:50,861 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:25:50,866 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,873 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,878 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-08 01:25:50,882 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:25:50,899 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:50,906 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pid', v1.0.2 by Infinite Automation
INFO 2014-08-08 01:25:50,916 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,925 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,930 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.6 by Infinite Automation Software
INFO 2014-08-08 01:25:50,944 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-08 01:25:50,948 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-08 01:25:50,957 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-08 01:25:50,966 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,975 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,978 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,983 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,987 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,988 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:25:50,989 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:25:50,998 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-08 01:25:51,006 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:25:51,009 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:25:51,013 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-08 01:25:52,866 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-08 01:25:52,869 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-08 01:25:53,374 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:25:53,437 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-08 01:25:53,493 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-08 01:25:53,576 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-08 01:25:53,577 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-08 01:25:53,698 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-08 01:25:53,699 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-08 01:25:53,736 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-08 01:25:53,737 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-08 01:25:53,738 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-08 01:25:53,775 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-08 01:25:53,776 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-08 01:25:53,777 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:25:53,815 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-08 01:25:53,817 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-08 01:25:53,818 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-08 01:25:55,114 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-08 01:25:55,116 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-08 01:25:55,286 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:36) - Initializing pooled connection manager
WARN 2014-08-08 01:25:56,009 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:96) - Upgrading 'core' from 1 to 2
INFO 2014-08-08 01:25:56,013 (com.serotonin.m2m2.db.upgrade.DBUpgrade.createUpdateLogOutputStream:152) - Writing upgrade log to C:\opt\dcinsight\mango_automation_2.4.0_full_install\logs\com.serotonin.m2m2.db.upgrade.Upgrade1.log
INFO 2014-08-08 01:25:56,190 (com.serotonin.m2m2.db.BasePooledProxy.terminateImpl:110) - Stopping database
ERROR 2014-08-08 01:25:56,194 (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(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
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-08 01:27:02,802 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-08 01:27:02,813 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-08 01:27:02,817 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-08 01:27:02,824 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.0 by Infinite Automation Software
INFO 2014-08-08 01:27:02,834 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'controlcore', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:27:02,858 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:27:02,865 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-08 01:27:02,871 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-08 01:27:02,872 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:02,877 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:02,882 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:27:02,921 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:02,932 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:02,937 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:02,949 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-08 01:27:02,999 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,003 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-08 01:27:03,004 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:27:03,011 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:27:03,013 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-08 01:27:03,018 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:27:03,024 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,027 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,033 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-08 01:27:03,036 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:27:03,049 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:03,055 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pid', v1.0.2 by Infinite Automation
INFO 2014-08-08 01:27:03,064 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,068 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:03,072 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.6 by Infinite Automation Software
INFO 2014-08-08 01:27:03,078 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-08 01:27:03,082 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-08 01:27:03,090 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-08 01:27:03,095 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,098 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:03,104 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,108 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,112 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,114 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:03,115 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:27:03,118 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-08 01:27:03,123 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:03,128 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:03,133 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-08 01:27:05,030 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-08 01:27:05,033 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-08 01:27:05,532 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:27:05,588 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-08 01:27:05,637 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-08 01:27:05,727 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-08 01:27:05,729 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-08 01:27:05,826 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-08 01:27:05,828 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-08 01:27:05,875 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-08 01:27:05,877 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-08 01:27:05,878 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-08 01:27:05,929 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-08 01:27:05,931 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-08 01:27:05,931 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:27:05,987 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-08 01:27:05,988 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-08 01:27:05,989 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
ERROR 2014-08-08 01:27:06,598 (com.serotonin.m2m2.Lifecycle.terminate:360) - com.serotonin.provider.InputStreamEPollProvider
ERROR 2014-08-08 01:27:06,603 (com.serotonin.m2m2.Lifecycle.terminate:368) - com.serotonin.provider.ProcessEPollProvider
ERROR 2014-08-08 01:27:06,605 (com.serotonin.m2m2.Main.main:111) - Error during initialization
java.lang.RuntimeException: java.net.BindException: Address already in use: bind
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:738)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:177)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: java.net.BindException: Address already in use: bind
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
at org.eclipse.jetty.server.nio.SelectChannelConnector.open(SelectChannelConnector.java:161)
at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:297)
at org.eclipse.jetty.server.nio.SelectChannelConnector.doStart(SelectChannelConnector.java:239)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58)
at org.eclipse.jetty.server.Server.doStart(Server.java:269)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58)
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:735)
... 2 more
INFO 2014-08-08 01:27:19,719 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-08 01:27:19,730 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-08 01:27:19,766 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-08 01:27:19,771 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.0 by Infinite Automation Software
INFO 2014-08-08 01:27:19,778 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'controlcore', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:27:19,782 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:27:19,789 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,794 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-08 01:27:19,798 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:19,805 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,808 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:27:19,845 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:19,857 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,862 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,872 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-08 01:27:19,921 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:19,925 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-08 01:27:19,926 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:27:19,933 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,935 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-08 01:27:19,940 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:27:19,945 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:19,950 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:27:19,952 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-08 01:27:19,957 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:27:19,977 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:19,981 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pid', v1.0.2 by Infinite Automation
INFO 2014-08-08 01:27:19,986 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:19,991 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:19,995 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.6 by Infinite Automation Software
INFO 2014-08-08 01:27:20,014 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-08 01:27:20,019 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-08 01:27:20,025 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-08 01:27:20,030 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:20,036 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:20,040 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:27:20,044 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:27:20,049 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:20,051 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:27:20,053 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:27:20,057 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-08 01:27:20,061 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:27:20,065 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:27:20,069 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-08 01:27:21,815 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-08 01:27:21,817 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-08 01:27:22,317 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:27:22,414 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-08 01:27:22,462 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-08 01:27:22,668 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-08 01:27:22,671 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-08 01:27:22,720 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-08 01:27:22,721 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-08 01:27:22,772 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-08 01:27:22,774 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-08 01:27:22,775 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-08 01:27:22,817 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-08 01:27:22,819 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-08 01:27:22,821 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:27:22,855 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-08 01:27:22,856 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-08 01:27:22,858 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
ERROR 2014-08-08 01:27:23,474 (com.serotonin.m2m2.Lifecycle.terminate:360) - com.serotonin.provider.InputStreamEPollProvider
ERROR 2014-08-08 01:27:23,475 (com.serotonin.m2m2.Lifecycle.terminate:368) - com.serotonin.provider.ProcessEPollProvider
ERROR 2014-08-08 01:27:23,477 (com.serotonin.m2m2.Main.main:111) - Error during initialization
java.lang.RuntimeException: java.net.BindException: Address already in use: bind
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:738)
at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:177)
at com.serotonin.m2m2.Main.main(Main.java:106)
Caused by: java.net.BindException: Address already in use: bind
at sun.nio.ch.Net.bind0(Native Method)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.Net.bind(Unknown Source)
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
at org.eclipse.jetty.server.nio.SelectChannelConnector.open(SelectChannelConnector.java:161)
at org.eclipse.jetty.server.AbstractConnector.doStart(AbstractConnector.java:297)
at org.eclipse.jetty.server.nio.SelectChannelConnector.doStart(SelectChannelConnector.java:239)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58)
at org.eclipse.jetty.server.Server.doStart(Server.java:269)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:58)
at com.serotonin.m2m2.Lifecycle.webServerInitialize(Lifecycle.java:735)
... 2 more
INFO 2014-08-08 01:28:10,084 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abeip', v1.0.6 by Deltamation Software
INFO 2014-08-08 01:28:10,114 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'abpccc', v1.0.4 by Deltamation Software
INFO 2014-08-08 01:28:10,127 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'asciiFile', v1.1.3 by Infinite Automation
INFO 2014-08-08 01:28:10,134 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'BACnet', v2.1.0 by Infinite Automation Software
INFO 2014-08-08 01:28:10,141 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'controlcore', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:28:10,144 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataFile', v1.0.4 by Infinite Automation
INFO 2014-08-08 01:28:10,154 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dataImport', v1.3.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,158 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dglux', v1.0.11 by Infinite Automation Software
INFO 2014-08-08 01:28:10,160 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'dnp3', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,165 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'galil', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,173 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'graphicalViews', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:28:10,220 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'http', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:28:10,231 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'internal', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,235 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jmxds', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,244 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'jspViews', v2.0.3 by Infinite Automation Software
INFO 2014-08-08 01:28:10,304 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'log4JReset', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,308 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'loggingConsole', v1.0.1 by Infinite Automation
INFO 2014-08-08 01:28:10,309 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'maintenanceEvents', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:28:10,315 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'mbus', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,317 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'meta', v2.0.7 by Infinite Automation Software
INFO 2014-08-08 01:28:10,322 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'modbus', v1.4.8 by Infinite Automation Software
INFO 2014-08-08 01:28:10,327 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'onewire', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,332 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'opcda', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,335 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'openv4j', v1.0.4 by aploese
INFO 2014-08-08 01:28:10,337 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pachube', v1.4.7 by Infinite Automation Software
INFO 2014-08-08 01:28:10,353 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'persistent', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:28:10,360 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pid', v1.0.2 by Infinite Automation
INFO 2014-08-08 01:28:10,372 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pointLinks', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,375 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'pop3', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,379 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'reports', v2.0.6 by Infinite Automation Software
INFO 2014-08-08 01:28:10,386 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scheduledEvents', v1.4.6 by (unknown vendor)
INFO 2014-08-08 01:28:10,390 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'scripting', v1.0.7 by Infinite Automation Software
INFO 2014-08-08 01:28:10,397 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'serial', v1.1.2 by Infinite Automation
INFO 2014-08-08 01:28:10,402 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'snmp', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,409 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlConsole', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,415 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sqlds', v1.5.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,420 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGlobalScripts', v1.4.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,424 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstGraphics', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,425 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'sstTheme', v1.0.5 by Infinite Automation Software
INFO 2014-08-08 01:28:10,426 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'templateConfig', v1.0.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,428 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'twilio', v1.0.3 by (unknown vendor)
INFO 2014-08-08 01:28:10,433 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'virtualDS', v1.4.4 by Infinite Automation Software
INFO 2014-08-08 01:28:10,438 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'vmstat', v1.4.6 by Infinite Automation Software
INFO 2014-08-08 01:28:10,442 (com.serotonin.m2m2.Main.loadModules:399) - Loading module 'watchlists', v1.5.7 by Infinite Automation Software
INFO 2014-08-08 01:28:12,220 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:31) - Mango Automation context starting
INFO 2014-08-08 01:28:12,222 (com.serotonin.m2m2.web.M2M2ContextListener.contextInitialized:39) - Mango Automation context started
INFO 2014-08-08 01:28:12,734 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:28:12,787 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source.shtm] onto handler 'dataSourceController'
INFO 2014-08-08 01:28:12,832 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/publisher_edit.shtm] onto handler 'publisherEditController'
INFO 2014-08-08 01:28:12,936 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/login.htm] onto handler 'loginController'
INFO 2014-08-08 01:28:12,938 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/shutdown.htm] onto handler 'shutdownController'
INFO 2014-08-08 01:28:13,014 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties.shtm] onto handler 'dataSourcePropertiesController'
INFO 2014-08-08 01:28:13,015 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/startup.htm] onto handler 'startupController'
INFO 2014-08-08 01:28:13,059 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/webcam_live_feed.htm] onto handler 'webcamLiveFeedController'
INFO 2014-08-08 01:28:13,060 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/unauthorized.htm] onto handler 'unauthorizedController'
INFO 2014-08-08 01:28:13,063 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_point_edit.shtm] onto handler 'dataPointEditController'
INFO 2014-08-08 01:28:13,119 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_properties_error.shtm] onto handler 'dataSourceErrorController'
INFO 2014-08-08 01:28:13,122 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/data_source_edit.shtm] onto handler 'dataSourceEditController'
INFO 2014-08-08 01:28:13,123 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile/users.shtm] onto handler 'usersController'
INFO 2014-08-08 01:28:13,163 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/mobile.shtm] onto handler 'mobileController'
INFO 2014-08-08 01:28:13,164 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/help.shtm] onto handler 'helpController'
INFO 2014-08-08 01:28:13,166 (org.springframework.web.servlet.handler.AbstractUrlHandlerMapping.registerHandler:411) - Mapped URL path [/logout.htm] onto handler 'logoutController'
INFO 2014-08-08 01:28:14,086 (com.serotonin.m2m2.Lifecycle.lic:404) - Checking license...
INFO 2014-08-08 01:28:14,095 (com.serotonin.m2m2.Lifecycle.loadLic:519) - License file not found
INFO 2014-08-08 01:28:14,230 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:37) - Initializing H2 connection manager
INFO 2014-08-08 01:28:20,989 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:36) - Starting instance with core version 2.4.0, db 9
INFO 2014-08-08 01:28:21,945 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:290) - Data source 'test' initialized
INFO 2014-08-08 01:28:21,948 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:295) - Data source 'test' took 460.447298ms to start
INFO 2014-08-08 01:28:43,154 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:290) - Data source 'test_dp3' initialized
INFO 2014-08-08 01:28:43,155 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:295) - Data source 'test_dp3' took 21204.766261ms to start
INFO 2014-08-08 01:28:45,129 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:290) - Data source 'test_thermo scientific' initialized
INFO 2014-08-08 01:28:45,131 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:295) - Data source 'test_thermo scientific' took 1976.613866ms to start
INFO 2014-08-08 01:28:45,138 (com.serotonin.m2m2.rt.RuntimeManager.initializeDataSource:290) - Data source 'test_VMStat data source properties ' initialized
INFO 2014-08-08 01:28:45,139 (com.serotonin.m2m2.rt.RuntimeMa -
Are the versions of Mango the same? Converting database types and upgrading database schemas are separate operations and should be done in separate launches as a good practice.
-
yes .the mango version is same and 2.4.0 version . It is normal run before I covert database .I refer to http://forum.infiniteautomation.com/forum/posts/list/185.page.I copy c:\m2m2\mango_automation_2.4.0_full_install\classesclass folder env file to c:\m2m2\mango_automation_2.4.0_full_install\overrides\properties. and modify the file as above and saved. then I start to run the mango. The status is above.
Any suggestion?
-
Is the MySQL database that you are converting to a blank database? Mango will create the necessary tables so you want to make sure it's a blank database and the user you are using has full permissions.
Joel.
-
Thanks .joes!
yes ,you are right.because have no full permissions.
but I have received some period data time from equipment. how to conver h2(have received) data to mysql (new database)? :)
-
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