WebApp 500 Error

robertwbrandt

We have a user that us unable to log into WebApp and gets a 500 error.

In the past we user to run a script called “reset_webapp-settings.py username” which would fix the problem and Bob’s your uncle. But this script is no longer working?

Is there a replacement? New Command?
I have looked at both kopano-admin and kopano-cli but neither have this functionality. I also can’t seen to find any other command that is on point.

Thanks
Bob

marty

Hi Bob,

I’m curious, What version of WebApp.

I’ve created a PR to add a remove option for this script:
https://stash.kopano.io/projects/KSC/repos/webapp-tools/browse/webapp_settings.py

You can already try it on the branch:
https://stash.kopano.io/projects/KSC/repos/webapp-tools/commits/308910a75f975db164615a42c2314e5f6b2a20d8

Keep in mind it’s untested.

robertwbrandt

Thanks!

We are running:
WebApp 3.4.6.1249+48.1
Kopano Core 8.5.2

I will let you know if this works!

Bob

robertwbrandt

So the command ran fine, but the user can’t login. So it might be a different problem.
I also tried to backup a good user and restore it to the problem user, but that didn’t work with this error:
root@kopano-core:~# python /opt/Kopano/tools/webapp-tools/webapp_settings.py --restore --user flanaganca -c rockss.json
{u’settings’: {u’zarafa’: {u’v1’: {u’contexts’: {u’mail’: []}, u’main’: {u’keycontrols’: u’disabled’, u’working_days’: [1, 5, 2, 3, 4], u’active_theme’: u’Basic’, u’show_welcome’: False}, u’plugins’: {u’spreedwebrtc’: {u’last_start_in_external_window’: False, u’last_start_in_iframe’: False, u’popout_info_lost_data_do_not_show’: False}}}}}}
Traceback (most recent call last):
File “/opt/brandt/Kopano/tools/webapp-tools/webapp_settings.py”, line 52, in <module>
main()
File “/opt/brandt/Kopano/tools/webapp-tools/webapp_settings.py”, line 46, in main
user.store.prop(PR_EC_WEBACCESS_SETTINGS_JSON).set_value(json.dumps(data))
AttributeError: ‘Property’ object has no attribute ‘set_value’
root@kopano-core:~# mv rockss.json flanaganca.json
root@kopano-core:~# python /opt/Kopano/tools/webapp-tools/webapp_settings.py --restore --user flanaganca
{u’settings’: {u’zarafa’: {u’v1’: {u’contexts’: {u’hierarchy’: {u’show_default_favorites’: False}, u’mail’: []}, u’state’: {u’folders’: {u’00000000b5ab1f1d3f384728a6dfcf311c4444cf01000000030000004b414de2a05345fa948611f61c7499c800000000’: {u’tree’: {u’is_open’: True}}}, u’models’: {u’note’: {u’current_data_mode’: 0, u’last_used_folders’: {u’0000000038a1bb1005e5101aa1bb08002b2a56c200007a617261666136636c69656e742e646c6c0000000000b5ab1f1d3f384728a6dfcf311c4444cf0100000001000000c7dc6a4e95ec4d26900fd3ad12aab06170736575646f3a2f2f4b6f70616e6f00’: [u’00000000b5ab1f1d3f384728a6dfcf311c4444cf01000000030000003cf1d334afcd45c2a8b006392fc5850b00000000’]}}}, u’sidebars’: {u’hierarchybar’: {u’collapsed’: False}, u’todaybar’: {u’collapsed’: True}}}, u’main’: {u’keycontrols’: u’disabled’, u’new_features_dialog’: {u’last_version’: {u’plugins’: {u’spreedwebrtc’: u’3.0’}}}, u’active_theme’: u’Basic’, u’show_welcome’: False, u’working_days’: [1, 5, 2, 3, 4]}, u’plugins’: {u’spreedwebrtc’: {u’last_start_in_external_window’: False, u’last_start_in_iframe’: False, u’popout_info_lost_data_do_not_show’: False}}}}}}
Traceback (most recent call last):
File “/opt/brandt/Kopano/tools/webapp-tools/webapp_settings.py”, line 52, in <module>
main()
File “/opt/brandt/Kopano/tools/webapp-tools/webapp_settings.py”, line 46, in main
user.store.prop(PR_EC_WEBACCESS_SETTINGS_JSON).set_value(json.dumps(data))
AttributeError: ‘Property’ object has no attribute ‘set_value’

So what happens is that the user logs in successfully, but the just gets a blank white page.
The user can login successfully to our legacy WebAccess server.

Any ideas?
Bob

marty

Could you check the webserver error logs for more info?
Might be some more useful data.

as for the error…that seems to be a bug in python-kopano, which I will fix in the script

marty

Hi @robertwbrandt

The PR I made was merged. Could you try the script again?

Although error.log might give you more info though.

robertwbrandt

There is noting in the error.log nor the php-error.log.

Thanks for the PR update

robertwbrandt

FYI: the restore worked, but I still get a blank screen. Thanks!

I’ll open a support ticket.