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.

@dan said in Possible bug in Reports module?:

@jared-wiltshire thanks Jared.

No problem, I have committed a fix which will be included in the next Mango core release. The bug was in the core, not the module.

As an alternative work-around you could override or create a new email template .ftl file and replace the <@img logo="true"/> with <@img src="logo.png"/>

To create a new email template for your Excel report -

Copy the supplied template to your overrides, e.g. cp /opt/mango/web/modules/excelReports/resources/ftl/excelReports/reportEmailBody.ftl /opt/mango-data/overrides/ftl/excelReports/myTemplate.ftl Restart Mango Edit your report to use the new template file

@jared-wiltshire

Yep, that did it, thanks!

Hi Everyone. As promised we have added Series 4 pricing to the radixiot.com website. You can find it under Products / Pricing. At this point, it is a direct PDF, but as we have eluded to we have a 100% new website coming out hopefully in the next month that merges all of the other websites into one resource, and this will include an interactive pricing page.

You can also directly link to the pricing here:
https://radixiot.com/wp-content/uploads/2021/10/mango_v12.0_pricing_guide-FINALa.pdf

@Ricardo thanks, that all looks ok to me. Basically what is happening is that Mango uses a pool of TCP/IP connections to the database and when choosing one to use it tests it first to ensure it is still connected. In this case Mango sees that the connection is broken and the database pool library (Hikari) is logging that.

For some reason the database connections that Mango is opening are being closed. This is not normal. From your log posting I can see that the delay is pretty close to 10 minutes, so I would be looking for any settings between Mango and your MySQL server that timeout at 10 minutes. It is possible you have a Proxy or Firewall between the 2 that is severing the connections at 10 minutes...

If none of that helps then I suggest you post the mango.properties for your database. The begin like this:

# MySQL database settings. Your MySQL instance must already be running and configured before this can be used. db.type=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!

Any advise?