@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!
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.
Best posts made by ricardo
-
RE: Mango 4.2 install-mango.sh script and mysqlposted in User help
-
RE: Mango 4.2.0 Releaseposted in Announcements
@terrypacker said in Mango 4.2.0 Release:
Any migration guide from V4b12?
-
Mango v4.2 with mysql server 8 - Failed to validate connectionposted in User help
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.
-
RE: Mango v4.2 with mysql server 8 - Failed to validate connectionposted in User help
@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 distributionCopyright (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)
Latest posts made by ricardo
-
Data point multiplierposted in How-To
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
-
Remove item text in ma-pie-chartposted in Dashboard Designer & Custom AngularJS Pages
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?
<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>
-
RE: Which NoSQL is used by Mango?posted in User help
@jared-wiltshire Thank you for your update. I came across InfluxDB (https://www.influxdata.com/products/influxdb/). It may be a good fit.
-
RE: Which NoSQL is used by Mango?posted in User help
@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.
-
RE: Mango v4.2 with mysql server 8 - Failed to validate connectionposted in User help
@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 distributionCopyright (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)
-
Mango v4.2 with mysql server 8 - Failed to validate connectionposted in User help
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.
-
Doubled event counts in fresh install of Mango v4.2posted in User help
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?
-
RE: Mango 4.2 install-mango.sh script and mysqlposted in User help
@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!
-
RE: Mango 4.2 install-mango.sh script and mysqlposted in User help
@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.