• M
    mseverin

    I sent the requested data a couple weeks and haven't heard anything. Is there any update on this or can someone give my a different way to extract historical data.

    I'm being asked to provide daily gas and water usage for the entire 2019 year.

    posted in User help read more
  • M
    mseverin

    My report still shows queued under the State heading and the download and view buttons are disabled. I've tried a new simple report with just Timestamp and value and it does the same thing.

    I see no errors in the log file.

    Any ideas?

    posted in User help read more
  • M
    mseverin

    Thanks, that helped, The report I created was uploaded and I assigned data points. When I run it, it shows up in the Finished / in-progress with the state "queued".

    what does this mean?

    posted in User help read more
  • M
    mseverin

    I'm trying to create a new hourly rollup excel report. When I copy the hourly report sample and try to save it as a new report I get "Report template file not found".

    Under the "select template file" link, when I click on Sample1_2.xlsx it opens up File stores > Excel_report_templates and it's empty.

    If I try to create a new excel report I can't save it because i get the same "Report template file not found" error.

    How do I get the report templates back or how do I create a new excel report?

    posted in User help read more
  • M
    mseverin

    I'm going to convert my H2 database to a MySql database. I have read all the posts I can find and am confident I can manage the conversion but I didn't find anything about what version of MySQL to use and I want to make sure I use a version of MySql that has been tested.

    What is the recommended version of MySQL should I be installing?

    I'm running Mango version 3.7.4.

    posted in User help read more
  • M
    mseverin

    Sorry.

    I have lost my dashboard data as well. When I go to the edit menu items page, I don't see any of my custom menus.

    If I create a new menu and try to point it to my custom pages, there are no pages there to point it to.

    If I look in the JSON, there are no custom menu items.

    posted in User help read more
  • M
    mseverin

    Because I'm running Mango in a vm, I restored a snapshot to just prior to purging the events and have determined that things disappeared after I did the purge of events using the H2 Console.

    Do to the large number of events, I couldn't get logged in long enough to purge them thru system settings, so I connected to the H2 console and ran "delete from events".

    Is there a better way that I should have used?

    posted in User help read more
  • M
    mseverin

    I had a problem where my events table had got really big so I couldn't log in (it kept timing out). Using the H2 Console I was able to delete everything from the events table but now I have no custom pages or menu structure.

    If I edit the latest json backup, it looks like the menu structure is there but I get nothing except for Data Point Details, Events, Watch lists and the Administration section, even after re-importing the json file.

    I also don't see any errors in the ma.log except for a server key validation issue regarding CloudConnect.

    Any help would be greatly appreciated.

    posted in User help read more
  • M
    mseverin

    @terrypacker

    Thanks for the reply.

    I have finally been able to connect.

    The solution was to change my h2-web-console.sh back to -webAllowOthers

    and my JDBC URL to jdbc:h2:/opt/mango/databases/mah2.199

    posted in Mango Automation general Discussion read more
  • M
    mseverin

    @joelhaggar

    I can't connect the same as the example because the database is on a different server from where I'm running the web browser so I get the message "Database /opt/mango/mah2 not found". However if I modify the file to -tcp -tcpAllowOthers as the help link suggests, then I just get "This page isn't working.

    posted in Mango Automation general Discussion read more