• 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

    Converting from Derby to MySQL

    User help
    11
    21
    32.3k
    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.
    • T
      Thitiwat
      last edited by

      Dear sir,

      I try change databse from Derby to Mysql error message:

      INFO 2010-01-07 15:26:17,921 (org.springframework.web.context.ContextLoader.initWebApplicationContext:189) - Root WebApplicationContext: initialization started
      INFO 2010-01-07 15:26:17,968 (org.springframework.context.support.AbstractApplicationContext.prepareRefresh:412) - Refreshing org.springframework.web.context.support.XmlWebApplicationContext@e0a386: display name [Root WebApplicationContext]; startup date [Thu Jan 07 15:26:17 ICT 2010]; root of context hierarchy
      INFO 2010-01-07 15:26:18,046 (org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
      INFO 2010-01-07 15:26:18,093 (org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory:427) - Bean factory for application context [org.springframework.web.context.support.XmlWebApplicationContext@e0a386]: org.springframework.beans.factory.support.DefaultListableBeanFactory@609959
      INFO 2010-01-07 15:26:18,203 (org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons:414) - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@609959: defining beans [CompoundEventsDwr,CustomViewDwr,DataPointDetailsDwr,DataPointEditDwr,DataSourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingListsDwr,MiscDwr,PointHierarchyDwr,PointLinksDwr,PublisherEditDwr,PublisherListDwr,ReportsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,localeResolver,messageSource]; root of factory hierarchy
      INFO 2010-01-07 15:26:18,343 (org.springframework.web.context.ContextLoader.initWebApplicationContext:209) - Root WebApplicationContext: initialization completed in 406 ms
      INFO 2010-01-07 15:26:18,343 (com.serotonin.mango.MangoContextListener.contextInitialized:73) - Mango context starting
      INFO 2010-01-07 15:26:18,656 (com.serotonin.mango.db.BasePooledAccess.initializeImpl:54) - Initializing pooled connection manager
      WARN 2010-01-07 15:26:19,046 (com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade:81) - Upgrading instance from 0.7.0 to 0.8.0
      INFO 2010-01-07 15:26:19,062 (org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions:323) - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
      INFO 2010-01-07 15:26:19,109 (org.springframework.jdbc.support.SQLErrorCodesFactory.<init>:128) - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
      INFO 2010-01-07 15:26:19,125 (com.serotonin.mango.MangoContextListener.contextDestroyed:101) - Mango context terminating
      INFO 2010-01-07 15:26:19,125 (com.serotonin.mango.db.BasePooledAccess.terminate:123) - Stopping database
      INFO 2010-01-07 15:26:19,125 (com.serotonin.mango.MangoContextListener.contextDestroyed:121) - Mango context terminated
      INFO 2010-01-07 15:26:19,125 (org.springframework.context.support.AbstractApplicationContext.doClose:816) - Closing org.springframework.web.context.support.XmlWebApplicationContext@e0a386: display name [Root WebApplicationContext]; startup date [Thu Jan 07 15:26:17 ICT 2010]; root of context hierarchy
      INFO 2010-01-07 15:26:19,125 (org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons:392) - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@609959: defining beans [CompoundEventsDwr,CustomViewDwr,DataPointDetailsDwr,DataPointEditDwr,DataSourceEditDwr,DataSourceListDwr,EmportDwr,EventHandlersDwr,EventsDwr,MailingListsDwr,MiscDwr,PointHierarchyDwr,PointLinksDwr,PublisherEditDwr,PublisherListDwr,ReportsDwr,ScheduledEventsDwr,SystemSettingsDwr,UsersDwr,ViewDwr,WatchListDwr,localeResolver,messageSource]; root of factory hierarchy

      How to solve is problem?

      1 Reply Last reply Reply Quote 0
      • M
        mlohbihler
        last edited by

        Did you manually create the mysql tables? If so, drop them all and start again. You only need to create the database. Mango need to create the tables itself.

        Best regards,
        Matthew

        1 Reply Last reply Reply Quote 0
        • J
          jjconti
          last edited by

          I followed the spteps but after restarting Mango, the tables were created in the MySQL schema but there was no data on them bt the admin/amdin user/password.

          1 Reply Last reply Reply Quote 0
          • J
            jjconti
            last edited by

            Done. I also needed to comment the following lines:

            #convert.db.type=
            #convert.db.url=
            #convert.db.username=
            #convert.db.password=

            1 Reply Last reply Reply Quote 0
            • S
              SteveE
              last edited by

              I'm running Mango 1.9.0 and recently converted my derby db to mysql version 5.5.8. I ran into a couple of issues which I was able figure out and fix. Note: these issues may have already been addressed in the newer versions of Mango.

              1. There is a new version of the mysql java connector jar available from the mysql website. Download mysql-connector-java-5.1.14.tar.gz, unzip it, and place mysql-connector-java-5.1.14-bin.jar in WEB-INF/lib directory.

              2. Several sql scripts and db upgrade source files used a deprecated mysql keyword in 'create table' statements. Search for 'type=InnoDB' and replace with 'engine=InnoDB'.

              1 Reply Last reply Reply Quote 0
              • M
                mlohbihler
                last edited by

                You should also delete any previous versions of the connector jar file.

                Best regards,
                Matthew

                1 Reply Last reply Reply Quote 0
                • G
                  gus
                  last edited by

                  Hello, I am having trouble converting to MySQL - I have tried all the above and no success - I am running version 1.12.4. Logs as follows:

                  un 9, 2011 2:05:30 PM org.apache.catalina.core.ApplicationContext log
                  INFO: Initializing Spring root WebApplicationContext
                  Jun 9, 2011 2:05:30 PM org.apache.catalina.core.StandardContext listenerStart
                  SEVERE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
                  java.lang.IllegalArgumentException: No enum const class com.serotonin.mango.db.DatabaseAccess$DatabaseType.MYSQL
                  at java.lang.Enum.valueOf(Enum.java:214)
                  at com.serotonin.mango.db.DatabaseAccess$DatabaseType.valueOf(DatabaseAccess.java:48)
                  at com.serotonin.mango.db.DatabaseAccess.createDatabaseAccess(DatabaseAccess.java:73)
                  at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:253)
                  at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:94)
                  at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
                  at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
                  at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
                  at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
                  at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
                  at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
                  at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
                  at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
                  at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
                  at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
                  at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
                  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
                  at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
                  at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
                  at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
                  at org.apache.catalina.core.StandardService.start(StandardService.java:516)
                  at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
                  at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                  at java.lang.reflect.Method.invoke(Method.java:616)
                  at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
                  at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
                  Jun 9, 2011 2:05:30 PM org.apache.catalina.core.ApplicationContext log
                  INFO: Closing Spring root WebApplicationContext

                  env.properties

                  convert.db.type=derby
                  convert.db.url=~/../../bin/mangoDB
                  convert.db.username=admin
                  convert.db.password=admin

                  db.type=mysql
                  db.url=jdbc:mysql://localhost/mangodb
                  db.username=mango
                  db.password=mango
                  db.pool.maxActive=10
                  db.pool.maxIdle=10

                  Any help much appreciated.

                  I have also tried with a fresh copy of Mango with just the MySQL settings but no success..

                  Thanks Gus

                  1 Reply Last reply Reply Quote 0
                  • C
                    cora
                    last edited by

                    I have the same problem that gus mentioned before. Is there a solution? anyone has a suggestion?

                    1 Reply Last reply Reply Quote 0
                    • R
                      rcopeland
                      last edited by

                      Hi I'm having trouble with this conversion. I've performed the steps listed on the first page, but when I go to localhost:8080 I get a HTTP Status 404 Error: The requested resource is not available.

                      On the Tomcat console, the errors appear to start around here:> SEVERE: Error listenerStart
                      Jan 24, 2012 9:35:40 AM org.apache.catalina.core.StandardContext start
                      SEVERE: Context [] startup failed due to previous errors
                      INFO 2012-01-24 09:35:40,093 (com.serotonin.mango.MangoContextListener.contextD
                      estroyed:124) - Mango context terminating
                      INFO 2012-01-24 09:35:40,093 (com.serotonin.mango.db.BasePooledAccess.terminate
                      :123) - Stopping database Anyone have any idea why this happens? My Information for the MySQL connection is correct, as when I put in a wrong password on purpose I get different and more errors.

                      Additionally, does anyone know the user/password login information to log into the derby database? I would like to browse the database with a program I have, but havent been able to make the connection as I havent found where the user/password is kept.

                      Thanks!

                      1 Reply Last reply Reply Quote 0
                      • M
                        mlohbihler
                        last edited by

                        Richard, check the <tomcat>/logs/localhost<date>.log file for error messages.

                        Best regards,
                        Matthew

                        1 Reply Last reply Reply Quote 0
                        • A
                          Antsu
                          last edited by

                          Hi,

                          I'm tried to setup Mango on my new computer. OS is Ubuntu 12.04 LTS and then Mysql version is 5.5.24-0ubuntu0.12.04.1 and Mango 1.13.0.

                          When I try to start Mango, browser says:

                                      *  HTTP Status 404 -*

                          Localhost.log says:

                          *Jun 19, 2012 7:03:10 PM org.apache.catalina.core.ApplicationContext log

                          INFO: Initializing Spring root WebApplicationContext

                          Jun 19, 2012 7:03:13 PM org.apache.catalina.core.StandardContext listenerStart

                          SEVERE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener

                          org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ create table systemSettings ( settingName varchar(32) not null, settingValue longtext, primary key (settingName) ) engine=InnoDB; ]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.systemSettings' already exists

                          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.mango.db.BasePooledAccess.runScript(BasePooledAccess.java:89)

                          at com.serotonin.mango.db.BasePooledAccess.createSchema(BasePooledAccess.java:106)

                          at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:79)

                          at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:102)

                          at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:259)

                          at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:98)

                          at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)

                          at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)

                          at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)

                          at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)

                          at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)

                          at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)

                          at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)

                          at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)

                          at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)

                          at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)

                          at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)

                          at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)

                          at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)

                          at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)

                          at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)

                          at org.apache.catalina.core.StandardService.start(StandardService.java:525)

                          at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)

                          at org.apache.catalina.startup.Catalina.start(Catalina.java:595)

                          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                          at java.lang.reflect.Method.invoke(Method.java:616)

                          at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)

                          at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

                          Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.systemSettings' already exists

                          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

                          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

                          at java.lang.reflect.Constructor.newInstance(Constructor.java:532)

                          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)

                          ... 31 more

                          Jun 19, 2012 7:03:13 PM org.apache.catalina.core.ApplicationContext log

                          INFO: Closing Spring root WebApplicationContext
                          *
                          What went wrong?

                          BR

                          Antsu

                          1 Reply Last reply Reply Quote 0
                          • M
                            mlohbihler
                            last edited by

                            Can you post your db.* and db.convert.* properties?

                            Best regards,
                            Matthew

                            1 Reply Last reply Reply Quote 0
                            • A
                              Antsu
                              last edited by

                              Did you mean that env.properties?

                              db.type=mysql
                              db.url=jdbc:mysql://localhost/mango
                              db.username=mangoUser
                              db.password=mangoPass
                              db.pool.maxActive=10
                              db.pool.maxIdle=10
                              db.update.log.dir=${catalina.base}/logs/

                              convert.db.type=derby
                              convert.db.url=~/../..mangoDB
                              convert.db.username=
                              convert.db.password=

                              1 Reply Last reply Reply Quote 0
                              • M
                                mlohbihler
                                last edited by

                                Yes. The properties look ok. But you seem to have existing tables in your mysql schema. You'll need to drop those first, and then try starting up again.

                                Best regards,
                                Matthew

                                1 Reply Last reply Reply Quote 0
                                • R
                                  Rgantwer
                                  last edited by

                                  Hey friends,

                                  I did this using Squirrel SQL, this software bring a plugin that let you copy a table from a derby database and paste that table on MYSql database, so you can export/import copying the tables from one database to another. its helpful .

                                  1 Reply Last reply Reply Quote 0
                                  • M
                                    mlohbihler
                                    last edited by

                                    Maybe not as helpful as you think. Mango will do all of that for you. You just need to create a schema for it to use, and Mango will copy over everything from Derby to MySQL for you.

                                    Best regards,
                                    Matthew

                                    1 Reply Last reply Reply Quote 0
                                    • M
                                      mrblue106
                                      last edited by

                                      @gus said:

                                      Hello, I am having trouble converting to MySQL - I have tried all the above and no success - I am running version 1.12.4. Logs as follows:

                                      un 9, 2011 2:05:30 PM org.apache.catalina.core.ApplicationContext log
                                      INFO: Initializing Spring root WebApplicationContext
                                      Jun 9, 2011 2:05:30 PM org.apache.catalina.core.StandardContext listenerStart
                                      SEVERE: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener
                                      java.lang.IllegalArgumentException: No enum const class com.serotonin.mango.db.DatabaseAccess$DatabaseType.MYSQL
                                      at java.lang.Enum.valueOf(Enum.java:214)

                                      I had the same problem: I solved this removing the trailing spaces at every lines of env.properties

                                      in my file (probably after a cut&paste from somewhere) I noticed that:
                                      my db.type=mysql was ->> db.type=mysql[space][space]

                                      after deleting the trailing spaces from every lines (I noticed the same problem on username/password and host)the conversion process worked like a charme!
                                      I hope this could help someone else.

                                      Regards

                                      1 Reply Last reply Reply Quote 0
                                      • L
                                        lansoul80
                                        last edited by

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

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

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