• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular
    1. Home
    2. ricardo

    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
    • Profile
    • Following 2
    • Followers 0
    • Topics 28
    • Posts 84
    • Best 5
    • Controversial 0
    • Groups 0

    ricardo

    @ricardo

    5
    Reputation
    1011
    Profile views
    84
    Posts
    0
    Followers
    2
    Following
    Joined Last Online
    ricardo Unfollow Follow

    Best posts made by ricardo

    • RE: [SOLVED] Autologin or anonymous view access from kiosk for remote display

      @Jared-Wiltshire Sorry to re-open this thread, but with the anonymous user role introduced in v4, does it mean we should be able to define certain pages with anonymous "View Page" permission which allow access of these pages without the need of Mango login?

      BR,
      Ricardo

      posted in Dashboard Designer & Custom AngularJS Pages
      ricardo
      ricardo
    • RE: Mango 4.2 install-mango.sh script and mysql

      @jared-wiltshire Since I cannot do database conversion, I tried reinstalling mango via the script again and was successful after creating the .mylogin.cnf file for the root account.

      sudo -s
      mysql_config_editor set --host=...

      Thanks for your help!

      posted in User help
      ricardo
      ricardo
    • RE: Mango 4.2.0 Release

      @terrypacker said in Mango 4.2.0 Release:

      Any migration guide from V4b12?

      posted in Announcements
      ricardo
      ricardo
    • Mango v4.2 with mysql server 8 - Failed to validate connection

      I have a freshly installed Mango v4.2 using mysql server 8. It keeps getting a HikariPool-1 - Failed to validate connection warning. Any ideas?

      WARN 2021-10-09T05:04:03,568 (com.serotonin.m2m2.TimedLicenseRegistrar.checkLicenses:65) - Mango NoSQL database is running in free mode, Mango will shutdown at 1:04:03 9/10/2021.
      INFO 2021-10-09T05:04:03,750 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:28) - Initializing pooled connection manager
      INFO 2021-10-09T05:04:06,791 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:37) - Starting instance with core version 4.2.1, schema v42
      INFO 2021-10-09T05:04:06,936 (com.infiniteautomation.nosql.MangoNoSqlProxy.initialize:68) - Starting MangoNoSql Database
      INFO 2021-10-09T05:04:06,980 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:149) - Database at /opt/mango-data/databases/mangoTSDB started
      INFO 2021-10-09T05:04:07,015 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:178) - Empty dir delete for database at /opt/mango-data/databases/mangoTSDB took 7ms
      INFO 2021-10-09T05:04:07,030 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:149) - Database at /opt/mango-data/databases/mangoTSDBAux started
      INFO 2021-10-09T05:04:07,060 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:178) - Empty dir delete for database at /opt/mango-data/databases/mangoTSDBAux took 4ms
      INFO 2021-10-09T05:04:12,287 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'runtimeContext' refreshed: org.springframework.context.annotation.AnnotationConfigApplicationContext@6ce15112
      INFO 2021-10-09T05:04:12,290 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextStarted:173) - Spring context 'runtimeContext' started: org.springframework.context.annotation.AnnotationConfigApplicationContext@6ce15112
      INFO 2021-10-09T05:04:14,301 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.process:35) - Initializing 1 NORMAL priority data sources in 1 threads
      INFO 2021-10-09T05:04:14,399 (com.serotonin.m2m2.rt.DataPointGroupInitializer.initialize:40) - Initializing 25 data points in 1 threads
      INFO 2021-10-09T05:04:14,405 (com.serotonin.m2m2.rt.DataPointGroupInitializer.processItem:64) - Initializing group 0 of 25 data points
      INFO 2021-10-09T05:04:14,479 (com.serotonin.m2m2.rt.DataPointGroupInitializer.processItem:120) - Group 0 successfully initialized 25 of 25 data points in 74 ms
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.DataPointGroupInitializer.initialize:54) - Initialization of 25 data points in 1 threads took 84 ms
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.RuntimeManagerImpl.startDataSource:321) - Data source (name=Mango Internal, id=1, type=InternalDataSourceRT) took 175ms to start
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.process:40) - Initialization of 1 NORMAL priority data sources in 1 threads took 184 ms
      INFO 2021-10-09T05:04:14,767 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:183) - Starting 0 Publishers...
      INFO 2021-10-09T05:04:14,779 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:194) - 0 Publisher's started in 19ms
      INFO 2021-10-09T05:04:16,561 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'rootWebContext' refreshed: Root WebApplicationContext
      WARN 2021-10-09T05:04:16,967 (org.springframework.core.log.CompositeLog.warn:127) - For Jackson Kotlin classes support please add "com.fasterxml.jackson.module:jackson-module-kotlin" to the classpath
      INFO 2021-10-09T05:04:17,130 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'restDispatcherContext' refreshed: WebApplicationContext for namespace 'REST_DISPATCHER-servlet'
      INFO 2021-10-09T05:04:21,000 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'restV3Context' refreshed: WebApplicationContext for namespace 'restV3DispatcherServlet-servlet'
      WARN 2021-10-09T05:14:16,684 (com.zaxxer.hikari.pool.PoolBase.isConnectionAlive:184) - HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@6a1ff639 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
      WARN 2021-10-09T05:14:16,685 (com.zaxxer.hikari.pool.PoolBase.isConnectionAlive:184) - HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3b4d7ce9 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

      posted in User help
      ricardo
      ricardo
    • RE: Mango v4.2 with mysql server 8 - Failed to validate connection

      @terrypacker the wait_timeout is at default 28,800 secs (8 hours).

      $ mysql
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 65191
      Server version: 8.0.15.0 Source distribution

      Copyright (c) 2000, 2021, Oracle and/or its affiliates.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      mysql> SHOW VARIABLES like '%timeout%';
      +-----------------------------------+----------+
      | Variable_name | Value |
      +-----------------------------------+----------+
      | connect_timeout | 10 |
      | delayed_insert_timeout | 300 |
      | have_statement_timeout | YES |
      | innodb_flush_log_at_timeout | 1 |
      | innodb_lock_wait_timeout | 50 |
      | innodb_log_closer_timeout | 1000 |
      | innodb_log_flush_notifier_timeout | 10 |
      | innodb_log_flusher_timeout | 10 |
      | innodb_log_wait_for_flush_timeout | 1000 |
      | innodb_log_wait_for_write_timeout | 1000 |
      | innodb_log_write_notifier_timeout | 10 |
      | innodb_log_writer_timeout | 10 |
      | innodb_rollback_on_timeout | OFF |
      | interactive_timeout | 28800 |
      | lock_wait_timeout | 31536000 |
      | net_read_timeout | 120 |
      | net_write_timeout | 240 |
      | rpl_stop_slave_timeout | 31536000 |
      | slave_net_timeout | 60 |
      | thread_pool_batch_wait_timeout | 10000 |
      | wait_timeout | 28800 |
      +-----------------------------------+----------+
      21 rows in set (0.01 sec)

      posted in User help
      ricardo
      ricardo

    Latest posts made by ricardo

    • RE: [SOLVED] Autologin or anonymous view access from kiosk for remote display

      @Jared-Wiltshire Sorry to re-open this thread, but with the anonymous user role introduced in v4, does it mean we should be able to define certain pages with anonymous "View Page" permission which allow access of these pages without the need of Mango login?

      BR,
      Ricardo

      posted in Dashboard Designer & Custom AngularJS Pages
      ricardo
      ricardo
    • Data point multiplier

      I remember we used to have a multiplier in the data point to multiply the raw data point with a multiplier. For instance, if a MQTT data point comes in as mV, we can use a 0.001 multiplier and store the data point as V. Is this no longer available?

      Best regards,
      Ricardo

      posted in How-To
      ricardo
      ricardo
    • Remove item text in ma-pie-chart

      I have created a ma-pie-chart, I would like to remove the item text.
      Instead I would like to add a legend in chart. Does someone know how to do this?

      7a25e936-df8d-4960-8c7f-ae59d8963c95-image.png

      <ma-pie-chart style="height: 300px; width: 600px" values="[ { value: 30, text: 'hot', color: '#ff9300' }, { value: 70, text: 'cold', color: '#942192' } ]"
options="{depth3D:15,angle:30}"></ma-pie-chart>
      posted in Dashboard Designer & Custom AngularJS Pages
      ricardo
      ricardo
    • RE: Which NoSQL is used by Mango?

      @jared-wiltshire Thank you for your update. I came across InfluxDB (https://www.influxdata.com/products/influxdb/). It may be a good fit.

      posted in User help
      ricardo
      ricardo
    • RE: Which NoSQL is used by Mango?

      @craigweb Is timeScaleDatabase ready? Any material on how to use it? I am interested in hosting the DB for the point values on another server apart from the application server.

      posted in User help
      ricardo
      ricardo
    • RE: Mango v4.2 with mysql server 8 - Failed to validate connection

      @terrypacker the wait_timeout is at default 28,800 secs (8 hours).

      $ mysql
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 65191
      Server version: 8.0.15.0 Source distribution

      Copyright (c) 2000, 2021, Oracle and/or its affiliates.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      mysql> SHOW VARIABLES like '%timeout%';
      +-----------------------------------+----------+
      | Variable_name | Value |
      +-----------------------------------+----------+
      | connect_timeout | 10 |
      | delayed_insert_timeout | 300 |
      | have_statement_timeout | YES |
      | innodb_flush_log_at_timeout | 1 |
      | innodb_lock_wait_timeout | 50 |
      | innodb_log_closer_timeout | 1000 |
      | innodb_log_flush_notifier_timeout | 10 |
      | innodb_log_flusher_timeout | 10 |
      | innodb_log_wait_for_flush_timeout | 1000 |
      | innodb_log_wait_for_write_timeout | 1000 |
      | innodb_log_write_notifier_timeout | 10 |
      | innodb_log_writer_timeout | 10 |
      | innodb_rollback_on_timeout | OFF |
      | interactive_timeout | 28800 |
      | lock_wait_timeout | 31536000 |
      | net_read_timeout | 120 |
      | net_write_timeout | 240 |
      | rpl_stop_slave_timeout | 31536000 |
      | slave_net_timeout | 60 |
      | thread_pool_batch_wait_timeout | 10000 |
      | wait_timeout | 28800 |
      +-----------------------------------+----------+
      21 rows in set (0.01 sec)

      posted in User help
      ricardo
      ricardo
    • Mango v4.2 with mysql server 8 - Failed to validate connection

      I have a freshly installed Mango v4.2 using mysql server 8. It keeps getting a HikariPool-1 - Failed to validate connection warning. Any ideas?

      WARN 2021-10-09T05:04:03,568 (com.serotonin.m2m2.TimedLicenseRegistrar.checkLicenses:65) - Mango NoSQL database is running in free mode, Mango will shutdown at 1:04:03 9/10/2021.
      INFO 2021-10-09T05:04:03,750 (com.serotonin.m2m2.db.BasePooledProxy.initializeImpl:28) - Initializing pooled connection manager
      INFO 2021-10-09T05:04:06,791 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgrade:37) - Starting instance with core version 4.2.1, schema v42
      INFO 2021-10-09T05:04:06,936 (com.infiniteautomation.nosql.MangoNoSqlProxy.initialize:68) - Starting MangoNoSql Database
      INFO 2021-10-09T05:04:06,980 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:149) - Database at /opt/mango-data/databases/mangoTSDB started
      INFO 2021-10-09T05:04:07,015 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:178) - Empty dir delete for database at /opt/mango-data/databases/mangoTSDB took 7ms
      INFO 2021-10-09T05:04:07,030 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:149) - Database at /opt/mango-data/databases/mangoTSDBAux started
      INFO 2021-10-09T05:04:07,060 (com.infiniteautomation.tsdb.impl.IasTsdbImpl.<init>:178) - Empty dir delete for database at /opt/mango-data/databases/mangoTSDBAux took 4ms
      INFO 2021-10-09T05:04:12,287 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'runtimeContext' refreshed: org.springframework.context.annotation.AnnotationConfigApplicationContext@6ce15112
      INFO 2021-10-09T05:04:12,290 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextStarted:173) - Spring context 'runtimeContext' started: org.springframework.context.annotation.AnnotationConfigApplicationContext@6ce15112
      INFO 2021-10-09T05:04:14,301 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.process:35) - Initializing 1 NORMAL priority data sources in 1 threads
      INFO 2021-10-09T05:04:14,399 (com.serotonin.m2m2.rt.DataPointGroupInitializer.initialize:40) - Initializing 25 data points in 1 threads
      INFO 2021-10-09T05:04:14,405 (com.serotonin.m2m2.rt.DataPointGroupInitializer.processItem:64) - Initializing group 0 of 25 data points
      INFO 2021-10-09T05:04:14,479 (com.serotonin.m2m2.rt.DataPointGroupInitializer.processItem:120) - Group 0 successfully initialized 25 of 25 data points in 74 ms
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.DataPointGroupInitializer.initialize:54) - Initialization of 25 data points in 1 threads took 84 ms
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.RuntimeManagerImpl.startDataSource:321) - Data source (name=Mango Internal, id=1, type=InternalDataSourceRT) took 175ms to start
      INFO 2021-10-09T05:04:14,484 (com.serotonin.m2m2.rt.DataSourceGroupInitializer.process:40) - Initialization of 1 NORMAL priority data sources in 1 threads took 184 ms
      INFO 2021-10-09T05:04:14,767 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:183) - Starting 0 Publishers...
      INFO 2021-10-09T05:04:14,779 (com.serotonin.m2m2.rt.RuntimeManagerImpl.initialize:194) - 0 Publisher's started in 19ms
      INFO 2021-10-09T05:04:16,561 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'rootWebContext' refreshed: Root WebApplicationContext
      WARN 2021-10-09T05:04:16,967 (org.springframework.core.log.CompositeLog.warn:127) - For Jackson Kotlin classes support please add "com.fasterxml.jackson.module:jackson-module-kotlin" to the classpath
      INFO 2021-10-09T05:04:17,130 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'restDispatcherContext' refreshed: WebApplicationContext for namespace 'REST_DISPATCHER-servlet'
      INFO 2021-10-09T05:04:21,000 (com.infiniteautomation.mango.spring.MangoRuntimeContextConfiguration.contextRefreshed:159) - Spring context 'restV3Context' refreshed: WebApplicationContext for namespace 'restV3DispatcherServlet-servlet'
      WARN 2021-10-09T05:14:16,684 (com.zaxxer.hikari.pool.PoolBase.isConnectionAlive:184) - HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@6a1ff639 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
      WARN 2021-10-09T05:14:16,685 (com.zaxxer.hikari.pool.PoolBase.isConnectionAlive:184) - HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3b4d7ce9 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.

      posted in User help
      ricardo
      ricardo
    • Doubled event counts in fresh install of Mango v4.2

      I noticed the unack'ed event counter at the top right corner is doubled of the actual event counters shown in the Events page. Is this the expected behavior?

      c0c48acf-1fa0-403f-a368-dfc41b346eff-image.png

      7aa8ecb0-1e03-442c-aa99-4fcfc4968f04-image.png

      posted in User help
      ricardo
      ricardo
    • RE: Mango 4.2 install-mango.sh script and mysql

      @jared-wiltshire Since I cannot do database conversion, I tried reinstalling mango via the script again and was successful after creating the .mylogin.cnf file for the root account.

      sudo -s
      mysql_config_editor set --host=...

      Thanks for your help!

      posted in User help
      ricardo
      ricardo
    • RE: Mango 4.2 install-mango.sh script and mysql

      @jared-wiltshire We have installed Mango 4.2 with h2. Now we want to do database conversion to mysql. We tried following the method from https://docs-v4.mango-os.com/database-conversions by adding convert.db.* lines to mango.properties file. After restarting mango and reviewing the ma.log, it seems like mango is still using h2 database. Please advise.

      posted in User help
      ricardo
      ricardo