• 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
  • M
    mseverin

    When I modified my h2-web-console.sh like yours, I can now get to the Login screen but then I get

    0_1579029431362_37db229b-e085-4b7d-b945-8c1c8b891598-image.png

    posted in Mango Automation general Discussion read more
  • M
    mseverin

    @craigweb

    Hello,

    Yes, I was running it like ./h2-web-console.sh - webAllowOthers.

    I modified the h2-web-console.sh and added -webAllowOthers to the end of the file but I still get the same result...

    (Web Console server running at http://127.0.1.1:8081 (only local connections).

    posted in Mango Automation general Discussion read more
  • M
    mseverin

    I'm really stuck. The events table has over 100,000 lines in it and even running in safe mode I am unable to purge the events.

    I really need a way to access the H2 database outside of Mango so I can manually purge the table.

    Mango is running on a Linux box with command line only.

    Any help would be appreciated as Mango has been down for over a week now.

    posted in Mango Automation general Discussion read more
  • M
    mseverin

    Thanks for all the suggestions.

    I have started Mango in SAFE mode (verified by looking in the ma.log file but I still can't get logged in.

    I changed the env.properties file to set set db.web.start=true and tried to run the H2 web Console using web-console.sh -webAllowOthers but I get the message "Web Console server running at http://127.0.1.1:8081 (only local connections).

    I thought the flag -webAllowOthers would let me connect to the Console from my laptop.

    Is there something I'm missing in order to run the H2 database manager?

    posted in Mango Automation general Discussion read more
  • M
    mseverin

    Hello,

    We are in the middle of switching BAS providers and as a result Mango has been flooded with events as devices go offline and then come back online.

    My events table has too many records and now I can't connect to Mango.

    I've tried to use the "purge all events" button from System Settings, but cannot stay logged in long enough to get to this page.

    I also tried using Mango/bin/h2-web-console.sh but the page doesn't load.

    Is there any other way I can delete all events?

    posted in Mango Automation general Discussion read more