V6.4.92 admin: no users or groups shown

Having trouble installing Group-Office? No worries. Help is on the way.

Moderator: Developers

bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

V6.4.92 admin: no users or groups shown

Postby bachgroup » Wed Dec 18, 2019 8:35 pm

Since Update from 6.4.36 to 6.4.92 Admin cannot see any users or groups in system settings any more. After pressing the link "users" or "groups", GO tries to load that page forever.
Before we had no problem with users/groups in Admin-mode at all.

System: Debian 9, PHP 7.3.
GO Test script: everything is green, no error.

Users/groups are selectable in e.g. rights mode for calendard (users, groups are shown).

Does anyone have an idea? :idea:

Thanks, Markus
mschering
Site Admin
Site Admin
Posts: 8357
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: V6.4.92 admin: no users or groups shown

Postby mschering » Fri Dec 20, 2019 3:42 pm

Are there any errors in the log file or browser console?
Best regards,

Merijn Schering
Intermesh
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Tue Jan 07, 2020 3:17 pm

Following Errors are found in the Browser Console:
server-side JMAP failure
Array(3) [ "error", {…}, "clientCallId-7" ]

script.php:1929:26

Firefox kann keine Verbindung zu dem Server unter http://***.domain.it/groupoffice/api/sse.php?types=Group,User,Field,FieldSet,Module,Link,Search,EntityFilter,SmtpAccount,EmailTemplate,Note,NoteBook,Comment,CommentLabel,Contact,AddressBook,AddressBookGroup,Bookmark,BookmarksCategory,Newsletter,AddressList,WopiService aufbauen.

script.php:1919:168

Content Security Policy: Die Einstellungen der Seite haben das Laden einer Ressource auf http://***.domain.it/groupoffice/api/sse.php?types=Group,User,Field,FieldSet,Module,Link,Search,EntityFilter,SmtpAccount,EmailTemplate,Note,NoteBook,Comment,CommentLabel,Contact,AddressBook,AddressBookGroup,Bookmark,BookmarksCategory,Newsletter,AddressList,WopiService blockiert ("default-src").

Following Errors are found in the apache2 error log:

[Tue Jan 07 15:35:35.033870 2020] [php7:notice] [pid 49324] [client myipxx.xx.xx.xx:52994] GO\\Base\\Exception\\SecurityTokenMismatch in /usr/share/groupoffice/go/base/controller/AbstractController.php at line 203: Security token mismatch in route: summary/announcement/checkLatestRead, referer: https://***.domain.it/groupoffice/

[Tue Jan 07 15:35:35.863710 2020] [php7:notice] [pid 49034] [client myipxx.xx.xx.xx:52998] GO\\Base\\Exception\\SecurityTokenMismatch in /usr/share/groupoffice/go/base/controller/AbstractController.php at line 203: Security token mismatch in route: tasks/portlet/portletGrid, referer: https://***.domain.it/groupoffice/

[Tue Jan 07 15:35:35.866604 2020] [php7:notice] [pid 49303] [client myipxx.xx.xx.xx:52997] GO\\Base\\Exception\\SecurityTokenMismatch in /usr/share/groupoffice/go/base/controller/AbstractController.php at line 203: Security token mismatch in route: summary/announcement/store, referer: https://***.domain.it/groupoffice/

[Tue Jan 07 15:35:35.868975 2020] [php7:notice] [pid 49186] [client myipxx.xx.xx.xx:52999] GO\\Base\\Exception\\SecurityTokenMismatch in /usr/share/groupoffice/go/base/controller/AbstractController.php at line 203: Security token mismatch in route: calendar/portlet/portletGrid, referer: https://***.domain.it/groupoffice/

[Tue Jan 07 15:35:35.882405 2020] [php7:notice] [pid 49325] [client myipxx.xx.xx.xx:52996] GO\\Base\\Exception\\SecurityTokenMismatch in /usr/share/groupoffice/go/base/controller/AbstractController.php at line 203: Security token mismatch in route: summary/note/load, referer: https://***.domain.it/groupoffice/

[Tue Jan 07 15:40:20.392184 2020] [php7:notice] [pid 49034] [client myipxx.xx.xx.xx:53042] PDOException in /usr/share/groupoffice/go/core/db/Statement.php at line 91: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`groupoffice-com`.`core_change`, CONSTRAINT `core_change_ibfk_2` FOREIGN KEY (`aclId`) REFERENCES `core_acl` (`id`) ON DELETE SET NULL), referer: https://***.domain.it/groupoffice/

I'm guessing the last entry of the apache2 error logs might indicate whats wrong?
Any help would be appreciated! Thanks
Last edited by bachgroup on Wed Jan 08, 2020 7:51 pm, edited 1 time in total.
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Tue Jan 07, 2020 3:40 pm

I just found and checked the GO error log under files/logfiles/error.log and I noticed it hasn't recorded any errors since 2018. Could this also be connected to the issue?
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Wed Jan 08, 2020 11:07 pm

After changeing (in system settings) the full url from http://***.domain.it to https://***.domain.it I now receive the following failure:

Firefox kann keine Verbindung zu dem Server unter https://***.domain.it/groupoffice/***.domain.it/groupoffice/api/sse.php?types=Group,User,Field,FieldSet,Module,Link,Search,EntityFilter,SmtpAccount,EmailTemplate,Note,NoteBook,Comment,CommentLabel,Contact,AddressBook,AddressBookGroup,Bookmark,BookmarksCategory,Newsletter,AddressList,WopiService aufbauen. script.php:1919:168

So path is wrong, but I see no reason why. Never had this problem before...

Thanks!
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Wed Jan 08, 2020 11:20 pm

After upgrading to 6.4.99 the failure still persists.
The last error message (double url in path) does not exist any more.
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Thu Jan 23, 2020 11:40 am

Does anyone have the same behaviour of not showing groups and users because of JMAP / API error?

Thanks, Markus
mschering
Site Admin
Site Admin
Posts: 8357
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: V6.4.92 admin: no users or groups shown

Postby mschering » Thu Jan 30, 2020 4:31 pm

The URL at System Settings -> General is probably misconfigured.
Best regards,

Merijn Schering
Intermesh
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Mon Feb 03, 2020 6:46 pm

This is, what I thought as well.
But domain seems to be okay, because we use it all the time.

System Settings -> General: https://crm.domain.com/groupoffice/

We tried it with and without https...
And everything else work...


Cheers, Markus
mschering
Site Admin
Site Admin
Posts: 8357
Joined: Tue Apr 20, 2004 1:06 pm
Location: The Netherlands - Den Bosch
Contact:

Re: V6.4.92 admin: no users or groups shown

Postby mschering » Tue Feb 11, 2020 3:12 pm

What's the HTTP status code from the sse.php request?
Best regards,

Merijn Schering
Intermesh
bachgroup
Posts: 9
Joined: Thu Nov 21, 2013 1:48 pm

Re: V6.4.92 admin: no users or groups shown

Postby bachgroup » Mon Mar 02, 2020 8:35 am

mschering wrote: Tue Feb 11, 2020 3:12 pm What's the HTTP status code from the sse.php request?
The sse.php request doesn't get a status code at all, althought it does get called.
See the attached screenshot.
Screenshot of sse.php request
Screenshot of sse.php request
SSE.jpg (84.76 KiB) Viewed 4158 times

Who is online

Users browsing this forum: No registered users and 1 guest

cron