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.

I know it's been a while, but I wanted to let others know what I found with this.

I created a test scripting data source with 110 data points. (I would post it here, but its 5700 lines and I don't have permissions to attach the file.) I basically use the .set for all 110 data points.

When I clicked the validate button I would get the following error:

ReferenceError: "varDP110" is not defined at line: 28

The error was not generated when the script ran on its normal schedule, so from what I can tell it's something related to how the validate button pulls in the variables for the script to run.

Thanks,
Chad

@tped Thanks for the input. Double checked that it's exactly the same. Send the file to the support folks, they don't see anything out of place.

Hi zenvakil,

My working example for Mango:

<wind value="10" unit="km/h" dir="S" symbol="13" symbolB="37"/>

If I want the winddirection (=S) I have to code:

dir="(.*?)"

So try

SoC"(.*?)"

If you have more than 1 SoC in your webpage:

<hour value="01:00"> <temp value="0" unit="°C"/> <symbol value="1" desc="Sonne" value2="1" desc2="Sonne"/> <wind value="10" unit="km/h" dir="S" symbol="13" symbolB="37"/> <wind-gusts value="27" unit="km/h"/> <rain value="0" unit="mm"/> <humidity value="88"/> <pressure value="1006" unit="mb"/> <clouds value="0%"/> <snowline value="600" unit="m"/> <windchill value="-4" unit="°C"/> <uv_index value="0"/> </hour>

try this:

01:00"><.*?><.*?><.*?><.*?><.*?><humidity value="(.*?)"

@cbyrne Well thank you that is very kind of you, now it's working great.

Cheers
Dan

This is a bug and will be corrected in Mango v4.3.

@tungthanh500 if you're using an angularjs controller, yes.

Otherwise you can use it to trigger a meta data point or scripting data source and use RuntimeManager.sleep(2000);
Between each data point supplied in the context to be changed to the desired values after each delay.

Fox

After much research, I realised Mango cannot subscribe to the AWS IoT. This is because the TLS version used by AWS requires to upload 3 certificates (private key, public key and private cert). Whereas the mqtt datasource only uses the private cert.

Hope this can be updated or are there any other alternatives?

Problem solved - do not put a period in front of the domain name in the proxy settings in CloudConnect.

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

One other note on this.

I found the following info on the 65533 value/� symbol:

U+FFFD (decimal 65533) is the "replacement character". When a decoder encounters an invalid sequence of bytes, it may (depending on its configuration) substitute � for the corrupt sequence and continue.

One common reason for a "corrupt" sequence is that the wrong decoder has been applied.

Hi Joel,

is there already a release date for the OPC UA module?
Any beta-version we can test?

@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 ...

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

@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!

@jared-wiltshire

Yep, that did it, thanks!