@tungthanh500 get rid of the runtime sleep call. Set the context point related to the data point you are validating and set the script to trigger from one of them for a start.
Alternatively use a cron timer setting set to 15 seconds.

Fox

Update: I can do it. The most important content of the instruction is: "The data will be classified by Site, Device Type, and Device IDs which are the main tags that need to be configured in the data points to allow this module to show accurate data."

This should be highlighted, in bold because it is in the introduction and non-English speaker like me always miss it!

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 thank you. I start fresh and restore with System settings -> SQL database backup -> select latest core-database-H2 zip file.
Is that enough? I check the Data point detail and found nothing in history :| Is there something I miss? I see also see MangoNoSQL-incremental-Mar-12-2023_063732.zip in backup folder but I have no idea how restore this file.

Update: I restored from another backup file and found out that that latest is broken. All data is lost.

Thank you all for your help.

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

@tungthanh500 Uou might want to email the sales channel instead of support. This is a license issue.

@tungthanh500 it comes with understanding angularJS scopes ($scope).
In this case you have a variable of $scope.currentArea
Since this scope is attached to our view, the variable (in this case) can be accessed as currentArea.
Since we want the variable and not a string called "currentArea", we "add" (I use the term loosely here) the strings that make up your RQL query and supply the dynamically allocated currentArea variable.

Also look at controllerAs to understand nesting controllers and their respective scopes.

Fox

Rectified with the use of an angularJS controller and only two ma-point-values lookups

Fox

@tungthanh500 Going out on a limb here (and assuming you've got mango4), but I suspect it's
mango/data/excelReports/report-data

Fox

@tungthanh500 have you seen the UI settings at /ui/administration/ui-settings which allow you to choose an audio file? There's no provision to loop an audio file as far as I remember, you would need to create a custom component for this.

6b1e3476-4f47-48f5-a465-ded1e1b46fe3-image.png

I think there is a component similar to what you are asking about in this demo https://github.com/infiniteautomation/mango-demo

The demo is for Mango v4 and is a bit outdated but might give you some ideas on how to get it done.

@jared-wiltshire
Thank you for your explaination. Can you be more specific about "datebar.to" and what is it in mango? I mean, there should be something like "myPoint.value" to show/assign a point value or "myDevice.name" to show the device name.

@tungthanh500
yes, there are buttons on the top right hand corner of the page that you can use to create folders and files.

you need root privileges to bind to ports below 1024. Since this is on digital ocean you would not want that. You should leave it on port 8433 and setup some persistent IP tables.

Check out these links:
https://o7planning.org/en/11363/redirecting-port-80-443-on-ubuntu-server-using-iptables
https://www.digitalocean.com/community/tutorials/iptables-essentials-common-firewall-rules-and-commands

@tungthanh500 said in Device disconnect and data logging:

From 3PM to 9PM, the server is disconnected so I expect the value should be 0.
Is there are any setting so I can make sure the logging value is 0 if server/power meter disconnected, therefore I or anyone can realize the abnormal and check the server/meter?

Setting a point that is unhealthy to zero. would have a lot of unwanted consequences and create a lot of noise in your data when doing analytics on it... The point does indicate that it is unhealthy, just not on the chart. The live value will have an exclamation mark next to it.

Also even if you do not log the point when it is unhealthy, your chart will still have the same shape... IF you want to be get notified when the point goes unhealthy you can set a "has not updated" event detector on the point and link the detector to an email event handler.