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.

We just installed a ClickPLC and are using Modbus TCP. This connection is going through a single hop through a Cisco switch. Right now I've only configured 1 point as a test. For our 1 point, I just checked with a 25 ms update period, and it's been stable for the past 10 minutes, as I haven't seen any errors on Mango's side. I'm sure how the polling is affected with more points. I plan on polling at 250 ms, as that is more than adequate for our needs.

Yeah, sorry, that was a bug. Got the fix in, though.

I meant to say it will use the NoSQL if installed. That's what I meant by prefer. I don't believe we created any tools to covert existing reportInstanceData tables to the NoSQL data store. So, I would expect any old report instances you have don't have their data available.

Upon examining the server, I observed all data from the SQL database had been successfully migrated. It was speculated the data that was sought hadn't been in the SQL database, and this is why it didn't appear after the migration.

Hi guys, Thanks very much for the advice. Upon @Jared-Wiltshire's recommendation I pasted my Google Analytics Property ID into the UI settings page. It's then as simple as creating an onclick event: https://developers.google.com/analytics/devguides/collection/analyticsjs/events <div flex layout="column" onclick="ga('send', 'event', 'buttons', 'click','B005');"></div> From here I was able to view real-time and historic page interactions based on clicking. I could also create events for mouse moving, but it generates a lot of events as you would expect and in google analytics you are limited to 500 hits per session or 10 million events per month. <div flex layout="column" onmousemove="ga('send', 'event', 'mouse', 'move','B005');"></div> Really happy though - exactly what I was after. [image: VyOiGCS.png]

Understood, but there was no such file. There is a file named com.serotonin.m2m2.db.upgrade.Upgrade17.log but it's empty -rw-r--r-- 1 mango mango 0 Nov 22 14:44 com.infiniteautomation.mango.scheduling.db.upgrade.Upgrade4.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade13.log -rw-r--r-- 1 mango mango 35 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade14.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade15.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade16.log -rw-r--r-- 1 mango mango 0 Nov 22 12:58 com.serotonin.m2m2.db.upgrade.Upgrade17.log The one file which isn't completely empty only reads: Updated 0 user comments with XIDs.

Hi te36051, Interesting! Thanks for sharing the solution. I wasn't familiar with that mysql option. The same problem may be solvable by modifying the connection string to use whatever pipe that configuration was creating. Some relevant information here: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html But, I would think binding the loopback address (127.0.0.1) would be adequate for most situations.

Was this ever resolved?

Get it! thanks

Now, I can login, but only in google chrome, internet explorer don't run.

Hmm. Well, I'll think about it more but I'm fairly confident Modbus4J handles it properly. Yeah you should be able to unpack the string the same way you packed it. Edit: My recommendation, to prove what you're saying, would be to disable all the points on your modbus data source, the enable IO logging and the two points as 4 byte variants. Do the read, disable the points. Enable the 8 byte single point, do a read. Post the resultant IO log.

Thanks Joel, I'll keep that in mind! Cheers!

Hi bwmasterson, Yes, there are both BACnet and Modbus publishers that can expose any data Mango has gathered over BACnet or Modbus. We have also looked into adding an SNMP publisher. There is of course the HTTP publisher as well but you're probably more interested in device protocols.

Hi eksantrik, The JDBC driver for MSSQL is not bundled with Mango. You can download it here: https://docs.microsoft.com/en-us/sql/connect/sql-connection-libraries#anchor-20-drivers-relational-access (has links for 6.0 and 6.2 for Java currently). You want the .tar.gz download, it'll have the driver compiled for Java 8, so copy that jar into your Mango/overrides/lib directory and try again.

thank you!

I tested publish information and is ok, but I can´t suscriber, I think that is a problem of the Broker in Blumix, Thank

I'm using Delta PLC, it doesn't have Ethernet port. Only Modbus RS485 is used for communication between PLC and Raspberry pi. And using TTL to RS485 Converter. I don't know how to write program for raspberry pi, please give me any example code.