Cannot login in admin web-interface / uwsgi error

stefan_o

I'm on Debian 12, unfortunately I just noticed I cannot login into the admin web-interface anymore. This is written to the syslog:

2023-12-10T21:48:24.123313+01:00  uwsgi[2725]: [ERROR] (grommunio Admin API) Traceback (most recent call last):
2023-12-10T21:48:24.123418+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1820, in full_dispatch_request
2023-12-10T21:48:24.123440+01:00  uwsgi[2725]:     rv = self.dispatch_request()
2023-12-10T21:48:24.123455+01:00  uwsgi[2725]:          ^^^^^^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123472+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/flask/app.py", line 1796, in dispatch_request
2023-12-10T21:48:24.123498+01:00  uwsgi[2725]:     return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
2023-12-10T21:48:24.123519+01:00  uwsgi[2725]:            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123539+01:00  uwsgi[2725]:   File "/usr/share/grommunio-admin-api/api/core.py", line 179, in wrapper
2023-12-10T21:48:24.123556+01:00  uwsgi[2725]:     return call()
2023-12-10T21:48:24.123577+01:00  uwsgi[2725]:            ^^^^^^
2023-12-10T21:48:24.123598+01:00  uwsgi[2725]:   File "/usr/share/grommunio-admin-api/api/core.py", line 144, in call
2023-12-10T21:48:24.123618+01:00  uwsgi[2725]:     ret = func(*args, **kwargs)
2023-12-10T21:48:24.123634+01:00  uwsgi[2725]:           ^^^^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123655+01:00  uwsgi[2725]:   File "/usr/share/grommunio-admin-api/endpoints/misc.py", line 43, in login
2023-12-10T21:48:24.123679+01:00  uwsgi[2725]:     success, val = loginUser(request.form["user"], request.form["pass"])
2023-12-10T21:48:24.123701+01:00  uwsgi[2725]:                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123720+01:00  uwsgi[2725]:   File "/usr/share/grommunio-admin-api/api/security.py", line 208, in loginUser
2023-12-10T21:48:24.123739+01:00  uwsgi[2725]:     user: Users = Users.query.join(Altnames, isouter=True)\
2023-12-10T21:48:24.123758+01:00  uwsgi[2725]:                   ^^^^^^^^^^^
2023-12-10T21:48:24.123777+01:00  uwsgi[2725]:   File "/usr/share/grommunio-admin-api/orm/__init__.py", line 32, in __get__
2023-12-10T21:48:24.123796+01:00  uwsgi[2725]:     mapper = class_mapper(type)
2023-12-10T21:48:24.123815+01:00  uwsgi[2725]:              ^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123833+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/base.py", line 448, in class_mapper
2023-12-10T21:48:24.123852+01:00  uwsgi[2725]:     mapper = _inspect_mapped_class(class_, configure=configure)
2023-12-10T21:48:24.123869+01:00  uwsgi[2725]:              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2023-12-10T21:48:24.123889+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/base.py", line 427, in _inspect_mapped_class
2023-12-10T21:48:24.123911+01:00  uwsgi[2725]:     mapper._check_configure()
2023-12-10T21:48:24.123930+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/mapper.py", line 1941, in _check_configure
2023-12-10T21:48:24.123949+01:00  uwsgi[2725]:     _configure_registries({self.registry}, cascade=True)
2023-12-10T21:48:24.123970+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/mapper.py", line 3527, in _configure_registries
2023-12-10T21:48:24.123992+01:00  uwsgi[2725]:     _do_configure_registries(registries, cascade)
2023-12-10T21:48:24.124010+01:00  uwsgi[2725]:   File "/usr/lib/python3/dist-packages/sqlalchemy/orm/mapper.py", line 3562, in _do_configure_registries
2023-12-10T21:48:24.124029+01:00  uwsgi[2725]:     raise e
2023-12-10T21:48:24.124063+01:00  uwsgi[2725]: sqlalchemy.exc.InvalidRequestError: One or more mappers failed to initialize - can't proceed with initialization of other mappers. Triggering mapper: 'mapped class MLists->mlists'. Original exception was: reverse_property 'mlist' on relationship MLists.user references relationship Users.mlist, which does not reference mapper mapped class MLists->mlists
2023-12-10T21:48:24.124085+01:00  uwsgi[2725]: [WARNING] (grommunio Admin API) POST /api/v1/login? from 10.10.3.2 -> 500 '{"message":"The server encountered an error while processing the request."}\n'

Any ideas what's wrong?

Best regards,
Stefan

WalterH

stefan_o Did you run grommunio-update update as last step?
Also try apt update; apt dist-upgrade and grommunio-update update. Hope this helps.

crpb

I tried after switching to community in my debian test system and it still worked after an upgrade.

root@grom-deb:~# apt policy
Package files:
 100 /var/lib/dpkg/status
     release a=now
 500 https://download.grommunio.com/community/Debian_12 Debian_12/main amd64 Packages
     release o=grommunio,n=Debian_12,l=grommunio,c=main,b=amd64
     origin download.grommunio.com
 500 http://ftp2.de.debian.org/debian bookworm-updates/main amd64 Packages
     release v=12-updates,o=Debian,a=stable-updates,n=bookworm-updates,l=Debian,c=main,b=amd64
     origin ftp2.de.debian.org
 500 http://security.debian.org/debian-security bookworm-security/main amd64 Packages
     release v=12,o=Debian,a=stable-security,n=bookworm-security,l=Debian-Security,c=main,b=amd64
     origin security.debian.org
 500 http://ftp2.de.debian.org/debian bookworm/main amd64 Packages
     release v=12.4,o=Debian,a=stable,n=bookworm,l=Debian,c=main,b=amd64
     origin ftp2.de.debian.org
Pinned packages:
     libapache2-mod-php -> 2:8.2+93 with priority -1
     apache2-bin -> 2.4.57-2 with priority -1
     apache2 -> 2.4.57-2 with priority -1
root@grom-deb:~# type _grom_versions
_grom_versions is a function
_grom_versions ()
{
    if test -f /etc/debian_version; then
        dpkg-query -Wf '${Package;-40}${Version;-30};${Maintainer}\n' ${1-} | awk -F\; '/(grommunio|gromox)/ {print $1}';
    else
        rpm -q -a --qf "%-40{Name}%-30{Version}%{Release}:%{Vendor}\n" ${1-} | sort | awk -F: '/grommunio/ {print $1}';
    fi
}
root@grom-deb:~# _grom_versions
grommunio-admin-api                     1.14.2.63c43b5-1+87.2
grommunio-admin-common                  20.e87783f-1+16.2
grommunio-admin-web                     2.8.0.21.a468a5f-1+68.2
grommunio-common                        23.7d1954c-1+35.2
grommunio-dav                           1.3.18.e16f8a2-1
grommunio-error-pages                   1.0.10.bb2df37-1+17.1
grommunio-index                         0.1.37.74e396b-1+41.2
grommunio-sync                          2.0.46.619ae1c-0
grommunio-web                           3.6.5.24b2a42e-1+7.2
gromox                                  2.19.2.00ec2f5-1+47.1
libesedb1                               20231120-1+1.2
libexmdbpp0                             1.11.0.58baa16-1+55.1
libhx32                                 4.17-1+1.2
libolecf1                               20231203-1+1.2
libpff1                                 20231205-1+1.2
mapi-header-php                         1.3.0.a04f1af-1+4.1
python3-mattermostdriver                7.3.2-1+14.8
python3-more-itertools                  8.12.0-1+1.3
python3-openapi-core                    0.13.7-1+7.3
python3-openapi-schema-validator        0.1.5-1+10.8
python3-openapi-spec-validator          0.2.9-1+8.3
python3-pyexmdb                         1.11.0.58baa16-1+55.1
python3-rfc3339-validator               0.1.5-1+9.8
python3-strict-rfc3339                  0.1.5-1+13.3
system-user-grommunio                   3-1
system-user-gromox                      0-1

stefan_o

I updated again, now with grommunio-update update afterwards, it updated a lot of packages, but no difference, syslog entry is the same.

I have these versions installed:

grommunio-admin-api                     1.14.2.63c43b5-1+87.3         
grommunio-admin-common                  20.e87783f-1+16.3             
grommunio-admin-web                     2.8.0.21.a468a5f-1+68.3       
grommunio-common                        23.7d1954c-1+35.3             
grommunio-dav                           1.3.18.e16f8a2-1              
grommunio-error-pages                   1.0.10.bb2df37-1+10.3         
grommunio-sync                          2.0.46.619ae1c-0              
grommunio-web                           3.6.7.20975ed1-1+8.1          
gromox                                  2.19.2.00ec2f5-1+47.2         
libbfio1                                20221025-1+4.3                
libesedb1                               20231120-1+1.3                
libexmdbpp0                             1.11.0.58baa16-1+17.3         
libhx32                                 4.17-1+1.3                    
libolecf1                               20231203-1+1.3                
libpff1                                 20231205-1+1.3                
mapi-header-php                         1.3.0.a04f1af-1+2.3           
python3-mattermostdriver                7.3.2-1+14.9                  
python3-more-itertools                  8.12.0-1+1.8                  
python3-openapi-core                    0.13.7-1+7.4                  
python3-openapi-schema-validator        0.1.5-1+10.9                  
python3-openapi-spec-validator          0.2.9-1+8.4                   
python3-parse                           1.19.0-1+22.10                
python3-pyexmdb                         1.11.0.58baa16-1+17.3         
python3-rfc3339-validator               0.1.5-1+9.9                   
python3-strict-rfc3339                  0.1.5-1+13.4                  
system-user-grommunio                   3-1                           
system-user-gromox                      0-1

stefan_o

After latest updates still the same issues.

WalterH

I assume this is a incorrect configuration of your system.

stefan_o

It used to work and I did not change anything other than updating the system. What configuration could be wrong?

Tobias

Hi @stefan_o
did you, by any chance, missed to run
gromox-dbop -U

*just a first guess

stefan_o

Tobias
No, I did not do that. I run it now, but no difference. How am I supposed to know what other stuff I have to run after an update? I would expect (because all other packages behave like that) that all this stuff is run automatically during an update or that I get an information screen what has to be done manually.

Best regards
Stefan

jengelh

How am I supposed to know what other stuff I have to run after an update?

Cf. https://community.grommunio.com/d/1356-version-upgrades-should-check-and-upgrade-database-schema