Error 500: JSONRpcClientException after the sql error

[elmy79]

Hello. For a little while ago I had this SQL error that fixed itself by turning off the untangle box and turn it on again. https://forums.untangle.com/feedback...on-12-0-a.html

Now I get a connection error 500 at login(after discovering that I have no internet access) name: JSONRpcClientException

This now happens 1-2 times a day.

The system runs on a fairly new Corsair 60GB ssd. When this happens, it's the only time I can kinda see a 2% cpu(Intel I3 3.5GHz) use from the normal 0.1-0.8% normal use. Memory use of the 8GB is under 25% at all times.

So I may try a clean install and apply the backup config file.
But will it help or is it a hardware error? Faulty ssd....?

(Untangle version 12.0)

[jcoffin]

Open a support ticket if you can able remote support on the GUI.

[dmorris]

stop rebooting, contact support.

[elmy79]

Sure. I do now where to enable support in Untangle. But I'm not sure what needs to be open for it to work. I kinda disabled and blocked all remote ports like SSH and stuff to untangle in filter rules. If anything needs to be enabled I will do so. Just tell me what needs to be enabled

Oh and the login kinda fails when I get this error as it keeps getting connection error. I have not tried directly on the box. Just logged in from my pc. So if I do enable access for support. I guess I should do it before it goes down again?

[dmorris]

In Config > System > Support
check "Allow secure access to your server for support purposes"

Don't mess with your filter rules or make other configuration changes.

[elmy79]

I have messed the filter rules too much before this happened. But if you say I need not to allow anything but the support access. Then it's okey. I have enabled it. Now I guess I need to wait until it crashes again. Dumb question. How do I contact support for this?
I can always get internet access from my phone after that.

[dmorris]

Just open a ticket with the support tab on the right side of the screen, or email support@untangle.com
Specify your UID in the ticket.

No need to wait until it happens again. My guess is that we'll be able to figure it out.

[elmy79]

I'v been out for some hours. But I found the support box you mentioned. I just put in a support ticket

Number #59332

[dmorris]

Well, maybe I spoke too soon.
Either your internet connection or you server is really really REALLY slow. Are you online?

If I can manage to connect, I have to wait about 2 minutes before my typing is echod to my terminal.
There is no hope I'll be able to login to the administration UI.
Are you on dialup? Is something obviously wrong?

[dmorris]

Well, I'm not sure. I would click "show details" and take a screenshot next time you see the error.

My guess is that you are just losing connection to the server. Is this in a VM?
Somethings either really wrong with it or your connection is very very bad.

You really really really need to stop rebooting.
http://wiki.untangle.com/index.php/A_Reboot_Fixed_It
I wouldn't at all be suprised if you have DB issues. The thing is being rebooted often by just pulling the plug.

You also have something really weird with your network. The interfaces are constantly going up and down.
eth5 is coming and going a lot.

Apr 22 00:57:52 Elmy-Gateway kernel: [44625.130994] e1000e: eth5 NIC Link is Down
Apr 22 00:57:52 Elmy-Gateway kernel: [44625.131053] br.eth4: port 4(eth5) entered disabled state
Apr 22 00:57:58 Elmy-Gateway kernel: [44631.604502] e1000e: eth5 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: None
Apr 22 00:57:58 Elmy-Gateway kernel: [44631.604546] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:57:58 Elmy-Gateway kernel: [44631.604568] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:09 Elmy-Gateway kernel: [44641.882741] e1000e: eth5 NIC Link is Down
Apr 22 00:58:09 Elmy-Gateway kernel: [44641.882818] br.eth4: port 4(eth5) entered disabled state
Apr 22 00:58:12 Elmy-Gateway kernel: [44644.765689] e1000e: eth5 NIC Link is Up 100 Mbps Full Duplex, Flow Control: None
Apr 22 00:58:12 Elmy-Gateway kernel: [44644.765698] e1000e 0000:00:19.0 eth5: 10/100 speed: disabling TSO
Apr 22 00:58:12 Elmy-Gateway kernel: [44644.765738] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:12 Elmy-Gateway kernel: [44644.765759] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:12 Elmy-Gateway kernel: [44645.275933] e1000e: eth5 NIC Link is Down
Apr 22 00:58:13 Elmy-Gateway kernel: [44645.767662] br.eth4: port 4(eth5) entered disabled state
Apr 22 00:58:18 Elmy-Gateway kernel: [44651.140491] e1000e: eth5 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: None
Apr 22 00:58:18 Elmy-Gateway kernel: [44651.140537] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:18 Elmy-Gateway kernel: [44651.140562] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:28 Elmy-Gateway kernel: [44661.358682] e1000e: eth5 NIC Link is Down
Apr 22 00:58:28 Elmy-Gateway kernel: [44661.358751] br.eth4: port 4(eth5) entered disabled state
Apr 22 00:58:32 Elmy-Gateway kernel: [44664.943688] e1000e: eth5 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: Rx/Tx
Apr 22 00:58:32 Elmy-Gateway kernel: [44664.943731] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:32 Elmy-Gateway kernel: [44664.943754] br.eth4: port 4(eth5) entered forwarding state
Apr 22 00:58:47 Elmy-Gateway kernel: [44679.986132] br.eth4: port 4(eth5) entered forwarding state
Apr 22 03:01:15 Elmy-Gateway kernel: [52039.204715] [drm:drm_edid_block_valid] *ERROR* EDID checksum is invalid, remainder is 60
Apr 22 03:01:16 Elmy-Gateway kernel: [52040.199275] e1000e: eth5 NIC Link is Down
Apr 22 03:01:16 Elmy-Gateway kernel: [52040.199350] br.eth4: port 4(eth5) entered disabled state
Apr 22 03:01:18 Elmy-Gateway kernel: [52042.914959] e1000e: eth5 NIC Link is Up 100 Mbps Full Duplex, Flow Control: Rx/Tx
Apr 22 03:01:18 Elmy-Gateway kernel: [52042.914967] e1000e 0000:00:19.0 eth5: 10/100 speed: disabling TSO
Apr 22 03:01:18 Elmy-Gateway kernel: [52042.915005] br.eth4: port 4(eth5) entered forwarding state
Apr 22 03:01:18 Elmy-Gateway kernel: [52042.915025] br.eth4: port 4(eth5) entered forwarding state
Apr 22 03:01:19 Elmy-Gateway kernel: [52043.761757] e1000e: eth5 NIC Link is Down
Apr 22 03:01:19 Elmy-Gateway kernel: [52043.915971] br.eth4: port 4(eth5) entered disabled state