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.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

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=123

    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=freetextpassword

    System 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=freetextpassword

    System 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