How to change the http sending value parameter

phildunlap

Wow 1800! Are they all to the same target point? At a certain number we may want to rethink the general tactic of wedging lots of points' alarms out one point. But, if it works, ok.

Off hand I can't think of a way to do what I was describing in the global script, but here's a python script to mass modify your point links. You probably want to keep a JSON backup of them, in case you wish to revert.

import json

configFile = open("/path/to/Mango/backup/Mango-Configuration.json")
config = json.load( configFile )
configFile.close()

x = 0
for pl in config["pointLinks"] :
  if pl["script"] != "" :
    pl["script"] = "TIMESTAMP=source.time+" + str(x) + ";\\n" + pl["script"]
    x += 1

outputFile = open("/path/to/output.json", "w+")
outputFile.write( json.dumps( {"pointLinks": config["pointLinks"]}, indent=4, sort_keys=False, separators=(",",": ") )
outputFile.close()

jmatos

I'm hopping to test the first code in six or 8 link points. That I can do one by one... ;-)

Thanks in advance for the second code.

I'll feedback to you.

Cheers

jmatos

@phildunlap said in How to change the http sending value parameter:

Wow 1800! Are they all to the same target point? At a certain number we may want to rethink the general tactic of wedging lots of points' alarms out one point. But, if it works, ok.

Off hand I can't think of a way to do what I was describing in the global script, but here's a python script to mass modify your point links. You probably want to keep a JSON backup of them, in case you wish to revert.
import json

configFile = open("/path/to/Mango/backup/Mango-Configuration.json")
config = json.load( configFile )
configFile.close()

x = 0
for pl in config["pointLinks"] :
  if pl["script"] != "" :
    pl["script"] = "TIMESTAMP=source.time+" + str(x) + ";\\n" + pl["script"]
    x += 1

outputFile = open("/path/to/output.json", "w+")
outputFile.write( json.dumps( {"pointLinks": config["pointLinks"]}, indent=4, sort_keys=False, separators=(",",": ")
outputFile.close()

Sorry. I get an invalid syntax at outputFile.close()

phildunlap

Whoops. Looks like there was a missing parenthesis. Fixed.

jmatos

@phildunlap said in How to change the http sending value parameter:

Whoops. Looks like there was a missing parenthesis. Fixed.

As the syntax error persists I try one more missed parenthesis. Your answer and Notepad++ made me see that conclusion. So 2 added.

outputFile.write( json.dumps( {"pointLinks": config["pointLinks"]}, indent=4, sort_keys=False, separators=(",",": ") ) )

Thank you

phildunlap

Oof, sorry. I've convinced myself I can write these little python things and not test them, but I really should have the preamble and output copied in so I can't do little things like that!

jmatos

Hi Phil,

I'm not figure it out... the code

TIMESTAMP = source.time+1; //one millisecond later than the source's TS
//you could use +2 on another one, and so on

Adds only a timestamp or in fact inserts a delay? Or both?

Thank you

phildunlap

The idea was to alter the timestamp set to the almnr point by some number of milliseconds into the future. They are varied because using the NoSQL database you cannot have two values at the same millisecond, and if these point links are triggered by one data source's polling (or just multiple points on some of the data sources), there's a high probability there are duplicate timestamps on the target point.

I'm not sure that's going to solve the issue you're describing, but it was something to try.

Edit: no delay should have been inserted.

Edit again, to explain:
TIMESTAMP is a variable name checked after the script returns its value, and if defined it is used as the timestamp for the value on the point set by the point link (or also the value assigned to a meta point, in that case)

jmatos

Hi Phil,

It does not work... :(

So I have cross my fingers and do a version upgrade to MANGO 3...

Now MANGO's not responding! (snif!). "ERR_CONNECTION_REFUSED" is all I get as browser response. The Webmin is working fine. Is there something else I can try before I restore the Mango directory ?

Thank you

phildunlap

Hi Jose,

I wouldn't expect the issue you're describing to be resolved by upgrading. But, you probably have an error in startup that we could see if you attempted to start Mango manually on the command line.

So navigate to Mango/bin and run either ./ma.sh start or ma-start.bat

Actually figuring out what's going on in your situation may be too difficult through the forum. I understand the issue to be something like...

Mango 1 polls a data source
Many points links set a point on Mango 1 many times.
The values of that point are published through an HTTP publisher
The receiving end is not ending up with the same set of data as the sending end, but no errors are being recorded on either Mango

There's a lot to explore there.

jmatos

here is the result

mango@mangoES3249:/opt/mango/bin$sudo ./ma.sh start
sudo: unable to resolve host mangoES3249
[sudo] password for mango:
sudo: ./ma.sh: command not found
mango@mangoES3249:/opt/mango/bin$ma.sh start
-bash: ma.sh: command not found
mango@mangoES3249:/opt/mango/bin$dir
ext-available  ext-enabled  h2-web-console.bat  h2-web-console.sh  ma-init.sh  ma.pid  ma-restart.sh  ma.sh  ma-start.bat  ma-start.sh  ma-stop.sh  upgrade.bat  upgrade.sh

phildunlap

Try...

sudo /opt/mango/bin/ma.sh start

sudo su; ./ma.sh start

phildunlap

It's possible ma.sh isn't executable, do sudo chmod +x /opt/mango/bin/ma.sh

jmatos

to all I get the same result:

sudo: unable to resolve host mangoES3249

unless for

sudo su; ./ma.sh start

where I get the PuTTY screen again - with the calendar, cpu info, etc. - as when I entered

phildunlap

You would do the ./ma.sh start after the sudo su scrolls by the login screen again. When you're root@mangoES3249:~

Hmm. That message suggests something is amiss in your /etc/hosts or /etc/hostname file. I bet you've got a line like 127.0.1.1 mangoes in your /etc/hosts file, where you'd want to change it to 127.0.1.1 mangoES3249 then log out and in again. The unable to resolve host message should be gone.

jmatos

@phildunlap

you have right with the issue 127.0.1.1 mangoes. I fix it but then I get

root@mangoES3249:/opt/mango/bin$./ma.sh start
MA_HOME is /opt/mango
./ma.sh: line 31: /opt/mango/bin/ma-start.sh: Permission denied

phildunlap

sudo chmod +x /opt/mango/bin/*.sh

jmatos

It works!!!
What could be wrong?

Thank you very much. I can sleep better this night :)

phildunlap

Well, the upgrade could have failed during the unzip, then it probably wouldn't have chmod'ed the bin directory properly. I would wonder if anything else did occur properly in the upgrade process.

jmatos

After the upgrade I get

???systemSettings.noSqlDatabaseSize(i18n_pt_PT)???

in the System settings > System Information section when refreshing the database size.

Should I worry about or is only a none translated item?