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

  • Nice!
    try

    sudo /opt/mango/bin/ma.sh start
    

    Let's see what you get!


  • sudo /opt/mango/bin/ma.sh start
    MA_HOME is /opt/mango
    /opt/mango/bin/ma-init.sh: line 29: unexpected EOF while looking for matching `"'
    /opt/mango/bin/ma-init.sh: line 34: syntax error: unexpected end of file
    /opt/mango/bin/ma.sh: line 28: /opt/mango/bin/ma-start.sh: Permission denied


  • INFO 2019-08-26 18:07:08,020 (com.serotonin.m2m2.Lifecycle.loadLic:411) - Checking license...
    INFO 2019-08-26 18:07:08,479 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42) - Initializing H2 connection manager
    FATAL 2019-08-26 18:07:10,603 (com.serotonin.m2m2.db.DatabaseProxy.initialize:173) - Unable to connect to database of type H2
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
    at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
    at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
    at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
    at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:187)
    at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:103)
    at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:542)
    at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:246)
    at com.serotonin.m2m2.Main.main(Main.java:104)
    Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.store.PageStore.getPage(PageStore.java:813)
    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:233)
    at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
    at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
    at org.h2.index.PageDataIndex.removeAllRows(PageDataIndex.java:397)
    at org.h2.index.PageDataIndex.truncate(PageDataIndex.java:382)
    at org.h2.store.PageStore.removeOldTempIndexes(PageStore.java:397)
    at org.h2.store.PageStore.openExisting(PageStore.java:373)
    at org.h2.store.PageStore.open(PageStore.java:288)
    at org.h2.engine.Database.getPageStore(Database.java:2386)
    at org.h2.engine.Database.open(Database.java:666)
    at org.h2.engine.Database.openDatabase(Database.java:266)
    at org.h2.engine.Database.<init>(Database.java:260)
    at org.h2.engine.Engine.openSession(Engine.java:60)
    at org.h2.engine.Engine.openSession(Engine.java:167)
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
    at org.h2.engine.Engine.createSession(Engine.java:128)
    at org.h2.engine.Engine.createSession(Engine.java:26)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
    at org.h2.Driver.connect(Driver.java:72)
    at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
    at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
    at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
    at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
    at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    ... 12 more
    ERROR 2019-08-26 18:07:10,650 (com.serotonin.m2m2.Main.main:109) - Error during initialization
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
    at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
    at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:63)
    at com.serotonin.m2m2.db.H2Proxy.tableExists(H2Proxy.java:244)
    at com.serotonin.m2m2.db.DatabaseProxy.newDatabaseCheck(DatabaseProxy.java:187)
    at com.serotonin.m2m2.db.DatabaseProxy.initialize(DatabaseProxy.java:103)
    at com.serotonin.m2m2.Lifecycle.databaseInitialize(Lifecycle.java:542)
    at com.serotonin.m2m2.Lifecycle.initialize(Lifecycle.java:246)
    at com.serotonin.m2m2.Main.main(Main.java:104)
    Caused by: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "index not found 93". Possible solution: use the recovery tool [90030-181]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.store.PageStore.getPage(PageStore.java:813)
    at org.h2.index.PageDataIndex.getPage(PageDataIndex.java:233)
    at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
    at org.h2.index.PageDataNode.freeRecursive(PageDataNode.java:272)
    at org.h2.index.PageDataIndex.removeAllRows(PageDataIndex.java:397)
    at org.h2.index.PageDataIndex.truncate(PageDataIndex.java:382)
    at org.h2.store.PageStore.removeOldTempIndexes(PageStore.java:397)
    at org.h2.store.PageStore.openExisting(PageStore.java:373)
    at org.h2.store.PageStore.open(PageStore.java:288)
    at org.h2.engine.Database.getPageStore(Database.java:2386)
    at org.h2.engine.Database.open(Database.java:666)
    at org.h2.engine.Database.openDatabase(Database.java:266)
    at org.h2.engine.Database.<init>(Database.java:260)
    at org.h2.engine.Engine.openSession(Engine.java:60)
    at org.h2.engine.Engine.openSession(Engine.java:167)
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
    at org.h2.engine.Engine.createSession(Engine.java:128)
    at org.h2.engine.Engine.createSession(Engine.java:26)
    at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)
    at org.h2.Driver.connect(Driver.java:72)
    at org.h2.jdbcx.JdbcDataSource.getJdbcConnection(JdbcDataSource.java:190)
    at org.h2.jdbcx.JdbcDataSource.getXAConnection(JdbcDataSource.java:353)
    at org.h2.jdbcx.JdbcDataSource.getPooledConnection(JdbcDataSource.java:385)
    at org.h2.jdbcx.JdbcConnectionPool.getConnectionNow(JdbcConnectionPool.java:227)
    at org.h2.jdbcx.JdbcConnectionPool.getConnection(JdbcConnectionPool.java:199)
    at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    ... 12 more
    /opt/mango/bin/ma-start.sh: line 83: /opt/mango/bin/ext-enabled/*.sh: No such file or directory


  • That still looks like the H2 database is corrupt and needs to be restored from a backup, as I linked in my first response.

    I'm not sure why you'd have problems executing the shell scripts. Probably part of that has to do with running Mango 2.5 instead of at least 2.8, as i already mentioned. You can download the 2.8 core from https://store.infiniteautomation.com/core

    You could still try moving your Mango/databases/ directory while Mango is not running, so that it starts on a new database. That would also get past the corruption in the H2 database.


  • Finally deleted the old databse. what is the default user id password for login?


  • Got the default password. and thanks Phil and Mattfox for supporting. I am bad in linux, but it was a good learning.


  • I am unable to add new Data Sources. There is no drop down list and even the ADD button doesn't work. I had installed some modbus module and some other module. Is there any other modules need to be installed for the data sources to work properly?


  • 0_1566888566429_resa1.JPG


  • I am stuck here. Couldn't move forward. Installed all modules


  • I responded in this thread: https://forum.infiniteautomation.com/topic/4425/data-sources-does-not-appear

    You do not need to make another thread, and certainly not if you're going to provide less information there than here.