• V
    Vincent Chu

    Hi Phil,
    Thanks ! you are right !
    It seems that the new version (3.6) Script permissions does not automatically bring in the author's permissions. It stays blank.

    Vincent.

    posted in User help read more
  • V
    Vincent Chu

    Hi Phil,
    It's really weird!
    It only happens in the newly defined scripting, but the original defined scripting can be executed!

    Vincent.

    posted in User help read more
  • V
    Vincent Chu

    Hi Phil,
    Just now we upgraded to 3.6.2, and we found these call functions getDataPointValueByXID(xid) not function anymore !!

    Can you help us to check where the problem is?

    Thanks !

    Vincent.

    posted in User help read more
  • V
    Vincent Chu

    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.

    posted in MangoES Hardware read more
  • V
    Vincent Chu

    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$
    
    

    posted in MangoES Hardware read more
  • V
    Vincent Chu

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

    posted in MangoES Hardware read more
  • V
    Vincent Chu

    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
    
    

    posted in MangoES Hardware read more
  • V
    Vincent Chu

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

    posted in MangoES Hardware read more
  • V
    Vincent Chu

    @wingnut2-0
    I think you must know, although you have 2 network cards, you can only have one default gateway.
    You can SSH into MangoBox and use [ip route] to view the settings.

    If you need is, from which network card (eth0) the network packet comes in, need to go back from that network card(eth0). This is called policy routing.

    Is this the setting you need?

    posted in User help read more