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.

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?

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?

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?

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.

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.

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?

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.

@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

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