• C
    cmason

    UPDATE

    Never mind I found the issue! Actually coming back to check this post I noticed it straight away. For whatever reason the code highlighter in the browser was more useful then the colors in Mango. Comparison below. I used a '-' instead of a '=' sign.


    I've made a dashboard but I can't get that values to update at a set period.
    The Display is static and so I'm using a hidden <ma-date-range-picker> with update-interval="10 seconds".
    But The display doesn't update unless I refresh the page.

    I'm using watchlist and ma-point-statistics on the page.

    Am I missing something?

    <!-- Invisible data-range picker for setting a constant time period -->
    <ma-date-range-picker style="display: none" preset="LAST_1_WEEKS" to="lastWeek.to" from="lastWeek.from" update-interval-"1 seconds"></ma-date-range-picker>
    <ma-date-range-picker style="display: none" preset="DAY_SO_FAR" to="daySoFar.to" from="daySoFar.from" update-interval-"1 seconds"></ma-date-range-picker>
    

    Here's how it looked in Mango
    0_1600724007267_update interval.png

    posted in User help read more
  • C
    cmason

    I've tried multiple browsers but forum search isn't working for me. Every thing comes back with not found. I've even tried 'mango' as a key word and it came back with nothing

    posted in User help read more
  • C
    cmason

    I'm trying to make a chart that displays a view of the current 24 hour window. i.e. if it's 3pm now, I want to view from midnight 15 hours ago, all the way to midnight tonight (which will obviously have no data).

    This is fine, except the charts take the last value, and then continue a straight line straight off the edge of the screen. It doesn't seem to matter what type it is, i.e. line, bar etc. Or if roll-ups are used. I've tried booked=true and bookend=false on the ma-point-values.
    I also tried passing in options {connect:false} on the AmGraph options as described here (The image below shows me using true but if I used false nothing would render at all). Also this link does refer to v4 amcharts but the option is a valid entry for AmGraph in V3 also, though I do see that it says the feature doesn't work with the XY chart, which I assume is what the serial chart is?

    0_1600401157988_Chart Gaps.png

    0_1600401586703_Connect Option.png

    Regardless of the implementation, there must be a way to achieve what I'm trying to accomplish?
    Any suggestions?

    posted in User help read more
  • C
    cmason

    @craigweb said in Best backup strategy including low bandwidth:

    @cmason

    The core database - What does this keep?
    All configurations. Used to restore the unit to exactly what it was configured apart from time-series data.

    JSON Configuration - What does this keep?
    All configurations but can be considered a shallow copy of the configurations, This backup is not sufficient to restore an instance as when you import this the table id's will not be the same.

    Thanks Craig.

    I've got three identical deployments to go out. What's the best way to copy the configuration over if I develop on one HTS unit and then copy it to the other two?

    posted in User help read more
  • C
    cmason

    @mattfox said in Best backup strategy including low bandwidth:

    Anytime, just be mindful of database changes between module upgrades. The last thing you want is a corrupt DB. Be sure to backup the mango directory minus the backups and logs every time you run an upgrade - especially if this is a remote setup.

    Right, so like the whole /opt/mango/ directory?

    posted in User help read more
  • C
    cmason

    @mattfox
    So as long as that's not an issue I think you'll be jammy.

    Cool, Thanks Fox!

    posted in User help read more
  • C
    cmason

    @mattfox Yeah I've done something similar as I have some scripts collecting logs from other devices and using rsync to send it off-site.

    Are you doing incremental backups of the NoSQL DB?

    Take into account you will be hard pressed to keep the data flowing if you have only allowed for so many tens of megabytes.

    Yeah that's why I was thinking if i just take the configuration backup and H2 Database backup off-site (as well as the long term data we get from the PTCP Connection). And just do incremental NoSQL DB Backups to the PC that's on site. That way I've at least got the config backups.

    Excluding point data, will the H2 Database and Configuration.json be enough to get a new device up and running with the old configuration?

    posted in User help read more
  • C
    cmason

    What's the best way to get 'snapshots' or backups of mango when bandwidth is small?

    Scenario, we've got site based mango which collects data and keeps it as two versions, short term (1 second samples) and long term (5 minutes samples)
    The short term data is kept for say 30 days, and the long term is kept relatively indefinitely and is also sent to a central mango server over PTCP.
    On site there will also be a rugged Windows PC with RAID 1 which I can ftp to also.

    So with regards to Mango backups, I see there's a few different things to back up.

    • The core database - What does this keep?

    • JSON Configuration - Whay does this keep?

    • The Mango NoSQL Database - I assume this is point history data?

    Attached is a screen shot of what I've just pulled from my test unit.
    0_1599016729302_Mango Backups.png

    Questions

    1. What should I absolutely backup off-site? (Basically so I could have a standby HTS unit and get going ASAP if ever needed). Keep in mind daily bandwidth is a limiting factor, 10's of MB
    2. With the NoSQL database, I thought I'd do backups incrementally and also ftp them over to the windows PC for another form of backup. Is there any reason I shouldn't do incremental? Is it still going to be able to restore ok if needed?
    3. would I just be better of FTP'ing the entire /opt/mango directory to the windows PC instead?
    4. Is there any info in the backups that could compromise security? Thinking more if I FTP the incremental backups to the PC, we don't necessarily own exclusive admin rights to that PC. the client may have admin rights too.

    Anything other recommendations much appreciated.

    posted in User help read more
  • C
    cmason

    @MattFox @CraigWeb

    Thanks Guys. I followed what you guys said and stripped it all back to the basics and got it working without the proxy. Funnily enough though It worked with HTTPS 'ssl.on=true' (self signed on the mango) but HTTP was having issues.
    Anyway I enabled set 'ssl.on=true' on the server and got it all working.

    Then I moved it all back behind the reverse proxy, and so far it all seems to be working fine.
    The only difference this time is the ssl.on = true.

    I may be wrong but how I don't see how the reverse proxy will make it more secure

    Yeah I mainly did this because I'm using a Synology NAS as the reverse proxy, it has nginx built in. Having this take care of the certificates and the auto renewals etc seemed a lot more straight forward then getting it to work on the mango with the java keystore etc. Perhaps a feature to add for Mango 4? haha.

    I'll see how this goes and keep you posted.

    Bearing in mind that the ports 9005 for cloud connect and the ports I've opened for the PTCP publishers get forwarded straight to the mango itself. I haven't got them going through the reverse proxy. Are the HTTP/S payloads?

    posted in User help read more
  • C
    cmason

    @craigweb said in Cloud Connect Help:

    I suggest trying to get it working without the complexity of your reverse proxy first.

    Ok I'll try that out. What's the recommended way to secure the connections then between the mango and the internet? The main reason I was using the reverse proxy was for security.

    @MattFox Are you using cloud connect with the reverse proxy? If so is that using apache on the same machine as your mango like I've seen you describe in some of the other threads?

    posted in User help read more