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.

@sean Are you providing a JWT key in the request ?

@fishfacs so you don't have noSql then.
There should be a pointvalues table in your h2 db that is populated with data then.

Fox

@CraigWeb mango version is 3.7.12
this datapoint is temperature sensor point so, recorde is normaly 2x °C
so 4376.54 and 459.62 is incorrect, so I want to reset value or delete this 2 values in timestamp

[PointValueTime(22.6@2023/05/24 13:30:12.836), PointValueTime(4376.54@2023/05/24 13:35:12.836), PointValueTime(459.62@2023/05/24 13:40:12.836), PointValueTime(22.8@2023/05/24 13:45:12.836), PointValueTime(22.886666666666667@2023/05/24 13:50:12.836)]

time = 1684906212836 , point= PointValueTime(22.6@2023/05/24 13:30:12.836)
time = 1684906512836 , point= PointValueTime(4376.54@2023/05/24 13:35:12.836)
time = 1684906812836 , point= PointValueTime(459.62@2023/05/24 13:40:12.836)
time = 1684907112836 , point= PointValueTime(22.8@2023/05/24 13:45:12.836)
time = 1684907412836 , point= PointValueTime(22.886666666666667@2023/05/24 13:50:12.836)

Hi @CraigWeb , actually I was trying to install a new Mango 5 instance. Everything is totally new. These are what I did:

1/ Install MySQL 8.0, create a database (scheme) named mango
2/ Install Mango 5 and paste a mango.properties file with MySQL info as above mentioned in mango_data folder.
3/ Start mango service and change admin password.
4/ Create a data source with some data point.
5/ Backup with Backup feature in System Setting -> SQL backup
6/ Delete data source and restore with System Setting -> SQL backup.
7/ See that orange warning pop up, but the deleted data source and data point is back, but I'm not sure if it normal or not.

@CraigWeb Heya Craig. Thanks for that! That's exactly what I was thinking. It's absolutely great now that Mango runs under its own user, but that user can't be logged into (at least, at least not without a fair amount of headache). Once CertBot is deployed, Mango will (likely) have no trouble updating them, but on the first run, almost everyone using those scripts will be logging in or SUDOing into root or whatever to make that happen.

The easiest solution (I think) is to juts do something like:
export mango_paths_data=/opt/mango-data
export mango_paths_home=/opt/mango

Or something when you sudo in to do these scripts. or you have to enable the mango user account to be loggable-innable, but that's the whole point (I think) of creating a mango-user in the first place, to not have it be a login account.. Which is sound design practice.

I'm probably going to try that over the weekend again- Thanks so much for looking through those scripts. When I first was trying this, I thought I was out of my mind, but it turns out there's both an easy solution (at least temporarily) to make this work, and no problem when the certbot hook runs (since it's already running as the mango user).

This problem only popped up because the new mango install script does everything under a user it creates, and the interactive config stuff happens because users are logging in and modifying another users's (mangos) settings. It all makes pretty solid sense, but only once you sit down and think through it.

Who knew environment variables would continue to be such a headache?

@cbyrne
Ye, I hear what you saying but the component was designed to enable highly accurate filters and we can't lose that. it's needed in the bulk editor and other pages. Maybe adding 2 different filter modes would be helpful to use in general dashboards.

@CraigWeb We just tried to make this change and I noticed a couple of things.
There is no option for setting intervalLoggingType once you've set loggingType to "Interval and when point value changes" via the GUI.

We ended up just changing the JSON and pushing that out, which it seems to have taken the changes.

Also interesting, when hitting the API endpoint for data point details...if the point is configured as ON_CHANGE_INTERVAL it does not return a key for "intervalLoggingType" nor is any value for any keys set to "AVERAGE" but I certainly do see those for points configured as "INTERVAL"

I honestly always assumed the way ON_CHANGE_INTERVAL worked was it logs on changes and the current value once per minute, I had no idea this would be averaging over that minute and then recording the average.

Anyway...I'll let you know the results, just wanted to give that info.

@MattFox said in Java problem may crash my instance:

@tungthanh500 stick to adopt11, it's fast and works

Fox

Thank you for your advice. How are you doing?

@terrypacker said in Java problem may crash my instance:

I have seen situations where our monitoring library can't handle the hardware it is running on. You can disable this using the mango property:

# enables getting operating system, process, and hardware information via the OSHI native library internal.monitor.enableOperatingSystemInfo=true

Thank you, I will try to add that.

@CraigWeb That's a good re-assurance I'm on the right train of though.

It would be neat if there was a data point that could capture sunrise and sunset for a given location. Changes in those values would trigger a context change and update the statistical point. Sunrise and Sunset values would be great if they could be used in the advanced scheduler, too, as one could save energy by using those values to trigger events like setpoints and the like.

I was hoping to use the envcands Environment Canada module to capture weather data and perhaps sunrise/sunset, but I never managed to make it work. There's a distinct lack of documentation on that module. If there is documentation, that would be extremely useful.

@rob987 Hi, have you find solution for you JSON timestamp?

@kyle-Hughes its kind of hard for me to follow your configuration and identify what the actual problem is. Maybe you could do a diagram on how each Mango assets links together ?

@cbyrne I'd build an overridden mangoUI with development mode enabled, then you can do whatever you want, could likely also do a hack with the userModule, but the overriding would be giving you more freedom

Fox

edit: nevermind just had to clear all browsing data.

@Turbo

The behavior you described that causes the script to execute continuously; Is this by design? If so, can you explain how that works?

The data source can either execute on an interval defined by the polling period or a context update from either an external point or an internal point. Both external points and internal points can be configured to trigger the script by checking the update context box. but if an internal point is configured to update the context and that point itself is updated by the script then there will be a cyclical situation. So the solution is to make sure that any point that the script affects does not have the "updates context" check box checked.

Kind of difficult for me to follow and understand your 6 chained scripts, to be honest, but the first step is to make sure that you don't have a situation as I mentioned above.

@CraigWeb
Hi, Craig
Good to see you back on here.

I will definitely submit this for my project since I have an existing Mango system running.
Should I just get in contact with technical support?

@CraigWeb Sure:

This is running the latest Mango V4.5. I'm using the Raw TCP data source to chat with a TCP <-> GPIB Adapter, but this bug (also) appears in the serial data source as well. It mentions it in the documentaiton somehwere, too, that you should be able to put \r\n in the "delimiter" and have it sense that as the end of message.

This does not work.

To make it work, you have to download the JSON file and manually put in "\r\n" and then re-import it, at which point the datasource "delimiter" blank shows up blank.

Here's the screen grab of our (working) data source:
a21bc8bf-3398-4d1d-8a7b-d8ee08a0edea-image.png

Notice: Nothing in the "Delimiter" field.

If I download the JSON for that data source, however, I see this:

"updatePeriodType":"SECONDS", "delimiter":"\r\n", "hex":false,

which shows the proper delimiter. This works (btw) so mango is processing the delimiter properly internally, it just doesn't display right in the UI.

"acceptance criteria" would be "The actual delimiter value should be visible in the Delimiter blank, somehow, even of it consists of nonprintable characters"

In the datasource help, attached below as a screen grab, with my highlighting shown, it says " Delimiters are unescaped before sending, so "\r" translates to carrriage return.":

68cd3674-8d47-4f2a-9d8d-97eb66c16e19-image.png

If you put "\n" in that blank, you get this in the JSON:

"updatePeriodType":"MINUTES", "delimiter":"\"\\n\"", "hex":false,

If you put \n (no quotes) you get this:

"updatePeriodType":"MINUTES", "delimiter":"\\n", "hex":false,

Which seems to mean that the parser expects \\n (not a \n)

The only way I was able to get the TCP data source to store the data using \r\n was to edit the JSON file as above, which seems to work properly. But then the \r\n doesn't show up properly in the "delimiter" blank

@CraigWeb

Uh oh, that's a mistake on my part.

Thanks for catching that!

@tungthanh500 It should accept any characters. Do you have this problem if you export a file and directly import it without editing it? can you share a snippet of a JSON file that has bad chars so I can test?

If you are editing the file your text editor could be adding a BOM to the start of the file. Please check for that and if it is there remove it.