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.

OK Thanks Jared I have it working now. Thank-you very much for all your help and to the other guys as well. That's great.

@Pedro

After even further discussion we will be adding the get() function back in. It will work for multistate and binary points to get the StartsAndRuntime object for that state, and it will return a 0 starts, 0 proportion, 0 runtime object for states that did not occur. To check if a state is present in a statistics object, therefore, one can check that (if they feel it is distinct to their scripts' logic) by .past(HOUR, 1).startsAndRuntime[true] == null

Sorry for any inconvenience this caused.

Edit: Here is the example from the JavaScript help internal to Mango,

var stats = b.past(MONTH, 2); var sar = stats.get(false).proportion; //get the proportion of time in false whether or not false occurred var stateNotNull = stats.getStartsAndRuntime().containsKey(false); //see if false occurred

and here is the help page's example, https://help.infiniteautomation.com/about-mango-java-script/

return b.past(MONTH, 2).get(false).proportion;

@phildunlap I moved enable-alph extension script to ext-enable folder, and also I made the SSL settings like before but I get the same errors and I couldn't navigate to the web page.

Still weird to me that wouldn't produce errors if you launched at the command line!

Thanks for sharing the resolution.

@phildunlap said in Implementing project tracking sheet:

Not yet. It would take something like a script shuffling it into a data point to make it available to an excel report, currently.

Would it be better, and feasible, to implement the same thing using alpha points?

Check filestore permissions under
administration->system-settings->permissions
for a start.

Fox

Good Morning Phil,

You can cancel this request, I was able to solve my Authorization Request Header issue.

Thanks again for all the help!!

I would not expect a history generation to cause the issue again with the settings changed.

I see your point about the delay in shutdown. You can wait in the shutdown until it is reporting that it is waiting for batch write behind tasks to finish, and then use a kill -9 to stop Mango, this should not cause issues. It is possible to reflect out the counter and manually set it to something, but I think it would be better to restart Mango.

I like mod_rewrites because you can stack a load of conditions/regexs. That and mod rewrites generally pass header info if I recall correctly. Although it's possible that your permanent will give a 301 http header.

Ignore the proxy* I think that was from my experiment to get letsencrypt working. I succeeded with the proxypass .well-known ! line. I could be wrong and it's there for another reason... shoulda left a comment!!!

But as you know, the * applies to all paths,

@dennisbetty201 Phillip's instructions will not fix this issue. Please see https://forum.mango-os.com/topic/3551/data-sources-does-not-appear/14 or download an old web browser (e.g. standalone Firefox)

@jared-wiltshire
It's running as Mango.

I'll start a new post as I don't want to hijack this one. Same error but not from the installation script.

I use axis because i know it better, and it has ANT support (which i couldn't find in less than 5 minutes for JAX). But if someone else is doing the work it doesn't matter to me.

Glad to hear. Thanks for closing off.

I'm not going to paste the code in the forum, because you really need the bacnet4j source so that you can test it out, download the source from http://sourceforge.net/projects/bacnet4j/files/bacnet4j/1.3/

and make sure you don't have any problems with running all the tests.

And as I said before, it's been over a year since I touched bacnet4j, so good luck, I'm sure once you have the source, you'll figure out what is going wrong.

@terrypacker Thanks for the update. Please keep in mind that this problem is not unique to my installation.

@whileoneloop the link will be https://github.com/infiniteautomation/ma-dashboards/tree/2.7.x/Custom Dashboards/web/loginPageTemplate now

Hmm.

So, you have the bridge device making a TCP connection to Mango, then Mango doing Modbus out the virtual port connected to that server socket?

Are there any options on the GSM-RS485? Specifically, are you using TCP or TCP with keep-alive? I would recommend going with keep-alive, as I would speculate the bridge is closing the connection, perhaps. Is there more to the stack trace in the log?

The database would undergo the same updates it would if it were upgrading to 2.7.

No the upgrades have not been updated to drop the tables, it slipped my mind to get "DROP IF EXISTS" into the mysql upgrade scripts, so you may have to drop the tables the upgrades create, or restore your MySQL dump into a new MySQL database.

That shouldn't change anything. It should function exactly as it was, although there probably is some way to sandbox it using Windows Firewall if it's IP, I wouldn't expect that to be the default (and all polling would fail).

I would expect it to be slightly different, you can try, but the recommendation we made was to update to the latest BACnet in Mango 3.