Web GUI Unusable, Crashes System after Config Import
I tried to migrate the users, system settings, point property templates, global scripts, excel report templates, and graphical views from Mango ES serial number 3386 to serial number 3396 using the Configuration Import/Export utility in the new GUI. The unit in question, 3396, seemed to be working okay before this. After importing the JSON and restarting, it's now unusable via the web interface. It boots showing the debug output on the web page, then when it tries to launch the GUI, the spinning loading ring just stays there. When the page is refreshed, the system crashes and it starts again.
I also cannot access the system over SSH. I plugged a monitor in and was able to delete the H2 database and clear the jsp folder so that they can be repopulated. The problem persists.
I'm trying to figure out how to recover this unit. I cannot provide any detailed info from the web GUI since I can't get to it, but I can provide anything accessible over local CLI. Firmware is V3_XU4_3.2.1_09_06_17_R. Accessing the device over Firefox 56.0.1 on Windows 10.
Well, as seems to be my luck on this forum, the moment I posted, I tried to refresh the device again after it's been idling for a good 15 minutes, and now it seems to be working again. The GUI loaded okay and I'm able to login, and it's behaving as though it's a fresh install as expected after clearing the H2 database.
Not sure what was going on, but I'm not going to try the config import again for now since we critically need this device working tomorrow. I'm just going to manually set it up.
Either way, if I didn't use the recommended method for migrating configuration between devices, and there's a suggested way to do it, I'm all ears. Otherwise, I'm curious if there's a theory on why the GUI became unusable after importing a configuration JSON.
It seems I spoke too soon. After configuring the device a bit (adding users, etc), updating modules, and restarting, it's back to misbehaving. The GUI load circle spins indefinitely, then when refreshing the page, the device crashes and repeat.
@coreyf Sorry about the trouble you are experiencing. The spinning loading ring thing will sometimes occur if the angular app can't load a particular file, check you don't have a ad blocker installed. Is it a local connection or over the internet?
If you are doing a large import/export I'd definitely suggest using the "Download JSON file" / "Upload JSON file" rather than copy-pasting.
It sounds like there are a few issues here.
SSH not working. Were you trying port 2222? I would be surprised if SSH were down, but if you're at the CLI you can do
pidof sshd, with no pids meaning it isn't running. You can also try webmin at https://ip:10000
You say the device crashes. What does this mean? Can you provide the Mango/logs/ma.log output? Or do you mean it seems to suffer a physical reboot? This file will hopefully have what I need to make a recommendation.
The configuration import is causing instability. I would advise from a workaround perspective that you rename Mango/databases while Mango is off and then start clean. Import pieces of the JSON, like the data sources and data points, apart from importing everything else. The JSON configuration moving should work in your version as well as using the H2 database dump in your old Mango/backups/ directory. That would perhaps be considered more preferred, since you can restore your Mango/databases/mangoTSDB if and only if your configuration was restored from a database backup.
Thanks for all the responses. I'm out of the office the rest of this week, but can try to debug when I'm back on Tuesday.
What I can tell you at the moment is...
I'm accessing the interface over the LAN. It was working prior to importing the JSON config, and nothing about the setup changed on the browser end.
I tried SSH with port 2222 using PuTTY. It would try to establish a connection, and Mango ES would actively refuse. Sometimes, if I caught it at the right time, I could establish a connection and log in, but after 10-15 seconds, it would stop responding.
The system crash was that, when refreshing the browser, all lights on the device would turn off except for power, then the lights would go through the normal bootup pattern, finishing with two or three flashes of the three aux lights. During this time, the web interface would show boot up output, before going back to the spinning ring. I can check the ma.log when I'm back in the office.
I did rename/delete the individual H2 database and it created a new one, but with no effect. I'll check it out again when I'm back.
That sounds like your server is restarting a lot. I would have expected you to notice this while you were using the command line.
The most obvious thing that could cause that is a process event handler on the Mango startup event to restart the server. But why / how would that have happened?
It could be a power issue, but then I would think the configuration would be incidental (unless it provides the load and you were previously right on the line of a sufficient power supply). Can you check the voltage and estimate your supply at that voltage? Are you sure the power supply isn't spotty and cutting out?
I believe we've isolated the cause of our problems to the new power supply. It's a 5V 2A power supply, which should be sufficient per the SBC's spec, but I suspect that it may be a switching supply or we're pulling more load than expected or some other issue is causing it to fault.
Moving forward, I'd prefer to power our device through the screw terminal inputs. I have some more detailed technical questions on that front, but I'll reach out over email since this might be beyond the scope of the forums.
I'm not sure what an SBC is exactly. But, this is powering a MangoES? 5V 2A is not the recommended power supply! https://help.infiniteautomation.com/mangoes-faq/
Does it come with a Power Supply?
No, you can use any power supply that is 12-24 VDC with a minimum of 20 watts (12vdc @ 2 amps or 24vdc @ 1 amp minimum).
With a sticker on the unit that should say "12-24 VDC"
If you have an older unit that also lists AC on the sticker, you can use 12VAC but do not use 24VAC as this is the RMS usually when listed by the power supply and the peak will damage the ES.
The 5V power supply was being used for the barrel jack directly on the single board computer (SBC) in the ES. The first unit we received from IAS actually came with a similar power supply, and we've been using them for powering ES devices on the lab bench while we configure them.
Moving forward, we're going to switch to using the screw terminal block power input with a compatible power source.