• 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

    Update 3.5.6 to 3.6 failed

    Scheduled Pinned Locked Moved MangoES Hardware
    13 Posts 5 Posters 3.6k Views 5 Watching
    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.
    • R Offline
      Ralf
      last edited by phildunlap

      Hi,

      our MangoES update-process from 3.5.6 to 3.6 failed.

      It stops with 40% loading and the message: "RequestError: Unable to load /status/mango status: 0".

      How can I solve this?

      ma-log:

      INFO  2019-06-25T17:19:09,434 (com.serotonin.m2m2.Main.main:105) - Starting Mango 3.6.0 with Schema Version: 28 
WARN  2019-06-25T17:19:10,371 (com.serotonin.m2m2.Main.loadModules:424) - Module crowd: this module requires a core version of 2.8, which does not match the current core version of 3.6.0. Module not loaded. 
WARN  2019-06-25T17:19:10,393 (com.serotonin.m2m2.Main.loadModules:424) - Module jspViews: this module requires a core version of 2.8, which does not match the current core version of 3.6.0. Module not loaded. 
INFO  2019-06-25T17:19:10,831 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'sqlds', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,894 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'mqttClientDataSource', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,913 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'TCPIP', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,933 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'asciiFile', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,947 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'sqlConsole', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,960 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'sstGlobalScripts', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,975 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'log4jDS', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:10,989 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'persistent', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,006 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'mangoApi', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,025 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'pointLinks', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,039 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'log4JReset', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,044 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'sstTheme', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,051 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'twilio', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,067 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'mangoESConfiguration', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,083 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'meta', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,099 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'excelReports', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,126 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'lang_en', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,129 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'snmp', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,145 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'http', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,164 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'controlcore', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,178 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'advancedComponents', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,186 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/advancedComponents/web/dox/manifest.xml 
INFO  2019-06-25T17:19:11,203 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'jsonFileImport', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,224 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'graphicalViews', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,260 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'scripting', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,273 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'watchlists', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,297 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'dataPointDetailsView', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,314 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'modbus', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,339 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'virtualDS', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,359 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'dashboardDesigner', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,365 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/dashboardDesigner/web/dox/manifest.xml 
INFO  2019-06-25T17:19:11,370 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'dataFile', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,399 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'mangoUI', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,405 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/mangoUI/web/dox/manifest.xml 
INFO  2019-06-25T17:19:11,450 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'ssh', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,462 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'dataImport', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,473 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'pop3', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,484 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'cloudConnect', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,490 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/cloudConnect/web/dox/manifest.xml 
INFO  2019-06-25T17:19:11,493 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'deviceConfig', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,499 (com.serotonin.m2m2.util.DocumentationManifest.parseManifestFile:60) - Documentation manifest file not found: /opt/mango/web/modules/deviceConfig/web/dox/manifest.xml 
INFO  2019-06-25T17:19:11,506 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'templateConfig', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,519 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'opcda', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,523 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'openv4j', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,527 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'scheduledEvents', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,538 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'loggingConsole', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,549 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'sstGraphics', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,586 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'mangoNoSqlDatabase', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,600 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'reports', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,616 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'maintenanceEvents', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:11,628 (com.serotonin.m2m2.Main.loadModules:586) - Loading module 'internal', v3.6.0 by Infinite Automation Systems Inc. 
INFO  2019-06-25T17:19:19,430 (com.serotonin.m2m2.Lifecycle.loadLic:611) - Checking license... 
INFO  2019-06-25T17:19:20,641 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:61) - Initializing H2 connection manager 
INFO  2019-06-25T17:19:23,250 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:38) - Starting instance with core version 3.6.0, schema v28 
INFO  2019-06-25T17:19:23,251 (com.infiniteautomation.nosql.MangoNoSqlProxy.initialize:77) - Starting MangoNoSql Database 
INFO  2019-06-25T17:19:23,379 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:143) - Database at /opt/mango/databases/mangoTSDB started 
INFO  2019-06-25T17:19:25,439 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:172) - Empty dir delete for database at /opt/mango/databases/mangoTSDB took 2019ms 
INFO  2019-06-25T17:19:25,613 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:143) - Database at /opt/mango/databases/mangoTSDBAux started 
INFO  2019-06-25T17:19:25,640 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:172) - Empty dir delete for database at /opt/mango/databases/mangoTSDBAux took 0ms 
ERROR 2019-06-25T17:19:31,490 (com.serotonin.m2m2.Main.main:146) - Error during initialization 
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mangoJavaScriptService': Lookup method resolution failed; nested exception is java.lang.IllegalStateException: Failed to introspect Class [com.infiniteautomation.mango.spring.service.MangoJavaScriptService] from ClassLoader [sun.misc.Launcher$AppClassLoader@19f2327]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:265) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.determineConstructorsFromBeanPostProcessors(AbstractAutowireCapableBeanFactory.java:1269) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1184) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$59/24039117.getObject(Unknown Source) ~[?:?]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:843) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:877) ~[spring-context-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549) ~[spring-context-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at com.serotonin.m2m2.Lifecycle.springRuntimeContextInitialize(Lifecycle.java:412) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:315) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Main.main(Main.java:143) ~[ma-priv-3.6.0.jar:?]
Caused by: java.lang.IllegalStateException: Failed to introspect Class [com.infiniteautomation.mango.spring.service.MangoJavaScriptService] from ClassLoader [sun.misc.Launcher$AppClassLoader@19f2327]
	at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:507) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:404) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:389) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:248) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	... 15 more
Caused by: java.lang.NoClassDefFoundError: jdk/nashorn/api/scripting/ClassFilter
	at java.lang.Class.getDeclaredMethods0(Native Method) ~[?:1.8.0_33]
	at java.lang.Class.privateGetDeclaredMethods(Class.java:2693) ~[?:1.8.0_33]
	at java.lang.Class.getDeclaredMethods(Class.java:1967) ~[?:1.8.0_33]
	at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:489) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:404) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:389) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:248) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	... 15 more
Caused by: java.lang.ClassNotFoundException: jdk.nashorn.api.scripting.ClassFilter
	at java.net.URLClassLoader$1.run(URLClassLoader.java:372) ~[?:1.8.0_33]
	at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[?:1.8.0_33]
	at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_33]
	at java.net.URLClassLoader.findClass(URLClassLoader.java:360) ~[?:1.8.0_33]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_33]
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) ~[?:1.8.0_33]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_33]
	at java.lang.Class.getDeclaredMethods0(Native Method) ~[?:1.8.0_33]
	at java.lang.Class.privateGetDeclaredMethods(Class.java:2693) ~[?:1.8.0_33]
	at java.lang.Class.getDeclaredMethods(Class.java:1967) ~[?:1.8.0_33]
	at org.springframework.util.ReflectionUtils.getDeclaredMethods(ReflectionUtils.java:489) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:404) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.util.ReflectionUtils.doWithMethods(ReflectionUtils.java:389) ~[spring-core-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.determineCandidateConstructors(AutowiredAnnotationBeanPostProcessor.java:248) ~[spring-beans-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	... 15 more
INFO  2019-06-25T17:19:31,491 (com.serotonin.m2m2.Lifecycle.terminate:427) - Mango Lifecycle terminating... 
INFO  2019-06-25T17:19:31,523 (com.serotonin.m2m2.db.H2Proxy.terminateImpl:394) - Terminating database. 
INFO  2019-06-25T17:19:31,640 (com.infiniteautomation.nosql.MangoNoSqlProxy.shutdown:115) - Terminating NoSQL Batch Write Manager. 
INFO  2019-06-25T17:19:31,658 (com.infiniteautomation.nosql.MangoNoSqlProxy.shutdown:123) - Closing NoSQL Database: Point Values 
INFO  2019-06-25T17:19:31,925 (com.infiniteautomation.nosql.MangoNoSqlProxy.shutdown:131) - Closing NoSQL Database: Point Data 
INFO  2019-06-25T17:19:31,929 (com.serotonin.m2m2.Lifecycle.terminate:578) - Mango Lifecycle terminated.
      1 Reply Last reply Reply Quote 0
      • terrypackerT Offline
        terrypacker
        last edited by

        @Ralf it looks like you are using an outdated version of Java. I would suggest updating to the latest Java 8. To me it looks like you are on a version before 1.8u40. We require some classes that were added to Java after this upgrade and Mango will not run until you upgrade.

        1 Reply Last reply Reply Quote 0
        • V Offline
          Vincent Chu
          last edited by

          Hi,
          the MangoES update to 3.6 failed.
          java version is updated to Java(TM) SE Runtime Environment (build 1.8.0_212-b10).

          ma.log report is : Caused by: org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-199]

          ma.log:

          INFO  2019-06-26T14:09:17,910 (com.serotonin.m2m2.Lifecycle.loadLic:611) - Checking license... 
INFO  2019-06-26T14:09:18,332 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:61) - Initializing H2 connection manager 
FATAL 2019-06-26T14:09:21,552 (com.serotonin.m2m2.db.AbstractDatabaseProxy.initialize:163) - Unable to connect to database of type H2 
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-199]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:611) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:699) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:711) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39) ~[mango-3.6.0.jar:?]
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:405) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.AbstractDatabaseProxy.newDatabaseCheck(AbstractDatabaseProxy.java:181) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.AbstractDatabaseProxy.initialize(AbstractDatabaseProxy.java:82) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:760) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:312) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Main.main(Main.java:143) ~[ma-priv-3.6.0.jar:?]
Caused by: org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-199]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:459) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.message.DbException.get(DbException.java:205) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.message.DbException.get(DbException.java:181) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.message.DbException.get(DbException.java:170) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.engine.Engine.validateUserAndPassword(Engine.java:366) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.engine.Engine.createSessionAndValidate(Engine.java:186) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.engine.Engine.createSession(Engine.java:161) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.engine.Engine.createSession(Engine.java:31) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:336) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:169) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:148) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:189) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:352) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:384) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:234) ~[h2-1.4.199.jar:1.4.199]
	at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199) ~[h2-1.4.199.jar:1.4.199]
	at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	... 12 more
ERROR 2019-06-26T14:09:21,553 (com.serotonin.m2m2.Main.main:146) - Error during initialization 
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLInvalidAuthorizationSpecException: Wrong user name or password [28000-199]
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:611) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:699) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:711) ~[spring-jdbc-5.1.7.RELEASE.jar:5.1.7.RELEASE]
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39) ~[mango-3.6.0.jar:?]
	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:405) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.AbstractDatabaseProxy.newDatabaseCheck(AbstractDatabaseProxy.java:181) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.db.AbstractDatabaseProxy.initialize(AbstractDatabaseProxy.java:82) ~[mango-3.6.0.jar:?]
	at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:760) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:312) ~[ma-priv-3.6.0.jar:?]
	at com.serotonin.m2m2.Main.main(Main.java:143) ~[ma-priv-3.6.0.jar:?]
          1 Reply Last reply Reply Quote 0
          • CraigWebC Offline
            CraigWeb
            last edited by

            Hi Vincent

            Did anyone modify the env.properties file to change the h2 database password?

            db.type=h2
db.url=jdbc:h2:${ma.home}/databases/mah2
db.location=${ma.home}/databases/mah2
db.username=
db.password=
            1 Reply Last reply Reply Quote 0
            • V Offline
              Vincent Chu
              last edited by

              No. it;s Clean!!

              
# set max age of cached files in seconds, only if noStore=false
# versioned resources are those with ?v=xxx on the query string
web.cache.maxAge=0
web.cache.maxAge.rest=0
web.cache.maxAge.resources=86400
web.cache.maxAge.versionedResources=31536000

#Upload file size limit (bytes) -1 means no limit
web.fileUpload.maxSize=250000000

# Default database settings, NOTE that on windows this must be an absolute path
db.type=h2
db.url=jdbc:h2:${ma.home}/databases/mah2
db.location=${ma.home}/databases/mah2
db.username=
db.password=
#For web console
db.web.start=false
db.web.port=8091
#to compact the database size at shutdown (may take longer but will free up disk space)
db.h2.shutdownCompact=false
              1 Reply Last reply Reply Quote 0
              • V Offline
                Vincent Chu
                last edited by

                It’s really weird! There’s no problem with the enterprise version.

                1 Reply Last reply Reply Quote 0
                • CraigWebC Offline
                  CraigWeb
                  last edited by

                  yes, it would be clean because it got replaced with a new file during the upgrade. Is there any chance that someone edited it before the upgrade?

                  1 Reply Last reply Reply Quote 0
                  • V Offline
                    Vincent Chu
                    last edited by

                    I have confirmed all settings, the env.properties only one file in the /opt/mango/classes.

                    root@mangoES2204:/opt/mango$ ls
backup   databases  Getting Started.txt  logs                  overrides       work
bin      db         lib                  m2m2.license.old.xml  RELEASE-NOTES
boot     filestore  LICENSE              m2m2.license.xml      release.signed
classes  ftl        licenseTypes.xml     modules               web
root@mangoES2204:/opt/mango$ cd classes/
root@mangoES2204:/opt/mango/classes$ ls
debug-log4j2.xml  env.properties               i18n.properties  log4j.xml
debug-log4j.xml   high-performance-log4j2.xml  log4j2.xml       swagger.properties
root@mangoES2204:/opt/mango/classes$ locate env.properties
/opt/mango/classes/env.properties
root@mangoES2204:/opt/mango/classes$
                    1 Reply Last reply Reply Quote 0
                    • CraigWebC Offline
                      CraigWeb
                      last edited by

                      Hi Vincent

                      All files in your classes folder get replaced when you do an upgrade. So confirming this now is too late. The correct procedure is to copy the file into the overrides folder and then edit it. This way it will not get replaced during an upgrade. Is it possible that someone changed the H2 database on the MangoES ?

                      1 Reply Last reply Reply Quote 0
                      • V Offline
                        Vincent Chu
                        last edited by

                        Hi C,
                        Thank your support !!

                        It is our mistake, the early version of mangoES its H2 DataBase UserName and Password is mango, we have handled this matter!!

                        Thanks again !!

                        Vincent.

                        1 Reply Last reply Reply Quote 0
                        • CraigWebC Offline
                          CraigWeb
                          last edited by

                          Please copy your env.properties file that you have edited with the username and password into /opt/mango/overrides/classes
                          So that this does not happen again.

                          1 Reply Last reply Reply Quote 0
                          • R Offline
                            Ralf
                            last edited by

                            @terrypacker ja, that was the reason.

                            I installed a new java version "jdk-8u131-linux-arm32-vfp-hflt.tar.gz".

                            A installation in the old path usr/lib/jvm/java-8-oracle didn't work so I followed the manual here:

                            help.infiniteautomation.com/linux-installation and the MangoES is running again.

                            I recommend for the future that you specify which Java version is necessary for a mango update. That would be helpful....

                            You have made a big progress with version 3.6, thanks!

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

                              Thanks for sharing the resource that helped you!

                              This thread has some information on updating Java that could be useful if Mango is being run on a lower privileged user at port 80: https://forum.infiniteautomation.com/topic/2678/java-update-encouraged

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