No access to webui after upgrade to 7.0

[kmlan]

Hi.
Found some updates to do using the Update button earlier today and decided to let it go ahead.
Dialog box reported success and there was a warning to be patient while redirecting to a new page.
The interface did load but gave continual dialog popups saying timeout.

Restart.

After restart attempted logins to the configuration page result in the message:
"Internal Server Error"

How can I force a new upgrade install or can anyone suggest a fix ?

---

Background:

:machine ESX4i => 2CPU, 2GB RAM, 100GB HDD
:VMTools not installed
:UT version => continuing auto upgrade from 5.3 to 6.2
:nTop installed
:mixture of paid and OS applications installed

:upgraded using Upgrade button in UT6.2
:upgrade reports successful

:apache is running
:nTop is running

:error after logging into webui admin page - Internal Server Error

:no. of reboots - plenty

:apache2/error.log
[error] mod_python (pid=8023, interpreter='utm.rt.local', phase='PythonHandler', handler='mod_python.publisher'): Application error, referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] ServerName: 'utm.rt.local', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] DocumentRoot: '/var/www/', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] URI: '/auth/login', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] Location: None, referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] Directory: '/usr/share/untangle/mod_python/auth/', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] Filename: '/usr/share/untangle/mod_python/auth/index.py', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] PathInfo: '', referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] Traceback (most recent call last):, referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1537, in HandlerDispatch\n default=default_handler, arg=req, silent=hlist.silent), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1229, in _process_target\n result = _execute_target(config, req, object, arg), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/importer.py", line 1128, in _execute_target\n result = object(arg), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/publisher.py", line 213, in handler\n published = publish_object(req, object), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/publisher.py", line 425, in publish_object\n return publish_object(req,util.apply_fs_data(object, req.form, req=req)), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/site-packages/mod_python/util.py", line 554, in apply_fs_data\n return object(**args), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/share/untangle/mod_python/auth/index.py", line 44, in login\n if _valid_login(req, realm, username, password):, referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/share/untangle/mod_python/auth/index.py", line 78, in _valid_login\n return _admin_valid_login(req, username, password), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/share/untangle/mod_python/auth/index.py", line 98, in _admin_valid_login\n uvmlogin.log_login(req, username, False, True, None), referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] File "/usr/lib/python2.5/uvmlogin.py", line 274, in log_login\n (client_addr, login, local, succeeded, reason));, referer: http://10.10.10.1/auth/login?url=/we...=Administrator

[error] ProgrammingError: ERROR: relation "events.u_login_evt" does not exist\n\nINSERT INTO events.u_login_evt (event

[iamrobert]

I got the same problem when I tried to access my untangle box today.
I didn't remember if I enable the auto upgrade function.

[marcot]

Same issue here - login to WebClient is not possible anymore (throws 500 internal server error) and, additionally, Untagle adds it´s login url sometimes to web server urls inside the net.

From the logs it looks like the database is not up & running.

Anyone who has found the cause for this issue yet, or is there any way to revert back the update ?

[rbscott]

Is there a java process running? Is there anything in /var/log/uvm/console.log or /var/log/uvm/wrapper.log?

[kmlan]

Is there a java process running? Is there anything in /var/log/uvm/console.log or /var/log/uvm/wrapper.log?

Hi rbscott.
Thanks for your reply.

Looks like Java is running. ps shows a Java line with lots of switches.

console.log shows nothing. Apart from a few libnetcap lines after a reboot it starts: UVM startup complete and ends: UVM postInit complete

wrapper.log shows a message: Migrating from postgres 7 to postgres 8 each reboot

At the time of the upgrade wrapper.log shows a lot of CREATE TABLE, CREATE INDEX, ALTER TABLE and then Migrating from postgres 7 to postgres 8.
Maybe it didn't complete.

Similar to the Apache log excerpt posted earlier uvm.log shows a problem with the events system:
06 20:16:05.450 ERROR [JDBCExceptionReporter] Batch entry 0 insert into events.pl_endp (time_stamp, c_client_addr, c_client_port, c_server_addr, c_server_port, s_client_addr, s_client_port, s_server_addr, s_server_port, client_intf, policy_id, proto, server_intf, session_id, event_id) values ( was aborted. Call getNextException() to see the cause.
06 20:16:05.451 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 42P01
06 20:16:05.451 ERROR [JDBCExceptionReporter] ERROR: relation "events.pl_endp" does not exist

Might be time to contact support or re-install.

[jtmiles]

I have the same problem on two of three UT boxes. Any resolution at this point? Reinstall really not an option on one box as it six hours away!?

[marcot]

As far as I´m related - yes, there have been messages in the log, the console crashed instantly over and over again. At this point I´ve been deciding to reinstall (and to disable auto update...).

[juank]

I am having the same issue but it wasn't an auto-upgrade. I did a fresh install and then restores a configuration file from 6.1 in 7.0.

[dmorris]

no idea whats going on here.

I wouldn't reboot during the upgrade - if you rebooted during the upgrade its probably a mess and easiest to reinstall. If you can't reach the UI after pressing the button its because the upgrade is in progress and the server isn't running. A reboot during this time is very bad.

run "ucli instances"
try restarting apache "/etc/init.d/apache restart"

[jtmiles]

dmorris,
My upgrade was auto so I don't think there was a restart involved. Short of the gui interface, I am at a loss. I assume you are talking about running those commands from the terminal? Let me know when you get the chance.
Thanks