• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

    Why I try convert from h2 to mysql is unsuccessful?

    User help
    3
    7
    1.7k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • E
      edmond
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by

        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.

        1 Reply Last reply Reply Quote 0
        • E
          edmond
          last edited by

          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?

          1 Reply Last reply Reply Quote 0
          • JoelHaggarJ
            JoelHaggar
            last edited by

            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.

            1 Reply Last reply Reply Quote 0
            • E
              edmond
              last edited by

              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)? :)

              1 Reply Last reply Reply Quote 0
              • JoelHaggarJ
                JoelHaggar
                last edited by

                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

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post