UCS & OX Group Sync


#1

Hi,
weve set up a test instance of UCS with Open Xchange using the build in services.
There seems to be a problem with keeping UCS and OX in sync.
Removal of Groups isnt reflected in ox.

Is there a fix for this?


#2

When a group is deleted in UCS, it is deleted in OX as well.

Maybe there is an older transaction blocking this one on your server. Please run and copy its output here:
/usr/share/univention-ox/manage_listener_queue --list


#3

Hi,
thank you for you quick reply.

Heres the output of
/usr/share/univention-ox/manage_listener_queue --list

len(f.dn) for f in self.pickle_files.values()=[34, 35, 35, 39, 33, 39, 37, 35, 36, 31, 33, 35, 32, 36, 33, 36, 34, 36, 35, 36, 33, 39, 34, 37, 33, 37, 35, 34, 34, 31, 34, 34, 33, 32, 35, 36, 31, 39, 31, 39, 34, 34, 34, 37, 36, 35, 32]
        Date        |  Module  | * |        Name        |       Timestamp
-------------------------------------------------------------------------------
2018-01-10 14:05:58 | groups   | a | Chefs              | 1515589558.8639008999
2018-01-10 14:07:01 | groups   | a | Controlling        | 1515589621.9199268818
2018-01-10 14:08:05 | groups   | a | Buli-Team          | 1515589685.9271941185
2018-01-10 14:08:56 | groups   | a | BOB-Team           | 1515589736.2467720509
2018-01-10 14:09:37 | groups   | a | Admins             | 1515589777.4075500965
2018-01-10 14:10:24 | groups   | a | Test-Team          | 1515589824.6177589893
2018-01-10 14:11:24 | groups   | m | Test-Team          | 1515589884.2163519859
2018-01-10 14:12:41 | groups   | a | WLP                | 1515589961.5210239887
2018-01-10 14:26:30 | groups   | a | WLP-Gruppen        | 1515590790.8120799065
2018-01-10 14:26:35 | groups   | m | WLP-Gruppen        | 1515590795.6635270119
2018-01-10 14:26:40 | groups   | m | WLP-Gruppen        | 1515590800.0284650326
2018-01-10 14:27:02 | groups   | a | WLP                | 1515590822.7361109257
2018-01-10 14:33:12 | groups   | m | WLP                | 1515591192.0446679592
2018-01-10 14:36:56 | groups   | a | WLP                | 1515591416.1712419987
2018-01-10 14:43:56 | groups   | a | WLP-Alle           | 1515591836.9907269478
2018-01-10 19:59:38 | user     | m | schlumpf           | 1515610778.9583148956
2018-01-10 23:10:31 | user     | m | schlumpf           | 1515622231.5546491146
2018-01-10 23:12:51 | user     | m | schlumpf           | 1515622371.4751319885
2018-01-10 23:14:24 | user     | m | schlegel           | 1515622464.5971610546
2018-01-10 23:15:14 | user     | m | schlumpf           | 1515622514.1049900055
2018-01-10 23:16:11 | user     | m | schlumpf           | 1515622571.5427830219
2018-01-10 23:17:19 | user     | m | burger             | 1515622639.6565949917
2018-01-10 23:18:46 | user     | m | bblas              | 1515622726.1472580433
2018-01-10 23:19:24 | user     | m | knurr              | 1515622764.0308239460
2018-01-10 23:19:53 | user     | m | fnop               | 1515622793.0088961124
2018-01-10 23:20:22 | user     | m | gopfs              | 1515622822.3077089787
2018-01-10 23:20:51 | user     | m | homann             | 1515622851.0148909092
2018-01-10 23:22:12 | user     | m | knebel             | 1515622932.9300060272
2018-01-10 23:22:37 | user     | m | knebel             | 1515622957.0532279015
2018-01-10 23:23:23 | user     | m | knast              | 1515623003.9184420109
2018-01-10 23:23:51 | user     | m | otto               | 1515623031.9995698929
2018-01-10 23:24:21 | user     | m | pfelzer            | 1515623061.0877549648
2018-01-10 23:24:50 | user     | m | peers              | 1515623090.4888470173
2018-01-10 23:25:22 | user     | m | shnulze            | 1515623122.8963758945
2018-01-10 23:25:56 | user     | m | schubidu           | 1515623156.1904571056
2018-01-10 23:26:31 | user     | m | stehl              | 1515623191.4681439400
2018-01-10 23:27:07 | user     | m | swinge             | 1515623227.8352189064
2018-01-10 23:27:46 | user     | m | tibs               | 1515623266.3693189621
2018-01-10 23:28:26 | user     | m | vink               | 1515623306.1661589146
2018-01-10 23:29:09 | user     | m | winner             | 1515623349.5642969608
2018-01-10 23:29:53 | user     | m | wolski             | 1515623393.3864059448
2018-01-10 23:30:38 | user     | m | winner             | 1515623438.9085049629
2018-01-10 23:31:27 | user     | m | winner             | 1515623487.2291579247
2018-01-10 23:32:15 | user     | m | wolski             | 1515623535.3084440231
2018-01-10 23:34:42 | user     | m | schlumpf           | 1515623682.3526160717
2018-01-10 23:35:37 | user     | m | schlumpf           | 1515623737.0139420033
2018-01-18 09:24:56 | groups   | m | WLP-Alle           | 1516263896.1430039406

Seems like the group in question isnt even listed.


#4

There are a lot of failed transactions in the queue. As long as they are there, newer transaction will not be processed. You’ll have to decide what to do with them. If it is a test system and you can simply delete them, then you can used the manage_listener_queue tool to do that (see --help for usage). It can alternatively also move them to a backup directory.

What version of the app is installed? Please send the output of:
univention-app info


#5
UCS: 4.2-3 errata256
App Center compatibility: 4
Installed: mailserver=11 open-xchange-guard=2.8.0-ucs1 open-xchange-text=7.8.4-ucs1 oxseforucs=7.8.4-ucs9
Upgradable:

We just updated to

UCS: 4.2-3 errata265
App Center compatibility: 4
Installed: mailserver=11 open-xchange-guard=2.8.0-ucs1 open-xchange-text=7.8.4-ucs1 oxseforucs=7.8.4-ucs10
Upgradable: oxseforucs

I also deleted the queue and am now waiting if it fills again.

SInce im still having those additional groups in open xchange: How can i remove them?


#6

You could do it manually by using the OX command line tools (/opt/open-xchange/sbin/deletegroup), but I think that’s a last resort. For now simply try to 1. enable the OX-flag in the UMC and 2. remove it again.

When you do that, please watch the log file for messages. If an error occurs it will help to debug it. I suggest to temporarily raise the loglevel too:

ucr set ox/debug/level=4
service univention-directory-listener restart
tail -f /var/log/univention/listener.log

Relevant messages will be prefixed with “ox-groups”.

To lower the loglevel after the changes run:

ucr set ox/debug/level=2
service univention-directory-listener restart

When everything worked fine, no new entries should be in the queue.


#7

Thank you for your answer. I will post the results later.