Problem: OX Connector: Duplicate mail account for user

Problem:

OX Connector: Duplicate mail account for user

2023-12-28 00:00:11 INFO    utils._handle_output:299  Modifying Object('users/user', 'uid=scheinig,cn=users,dc=schein,dc=ig')
2023-12-28 00:00:11 INFO    utils._handle_output:299  Old Object('users/user', 'uid=scheinig,cn=users,dc=schein,dc=ig') has no context ID. Using new context ID instead...
2023-12-28 00:00:11 INFO    utils._handle_output:299  Searching for scheinig in context 1
2023-12-28 00:00:12 INFO    utils._handle_output:299  Error while processing /var/lib/univention-appcenter/apps/ox-connector/data/listener/2023-12-22-05-00-18-476862.json
2023-12-28 00:00:12 WARNING utils._handle_output:299  Traceback (most recent call last):
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/tmp/univention-ox-connector.listener_trigger", line 341, in run_on_files
2023-12-28 00:00:12 WARNING utils._handle_output:299      function(obj)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/provisioning/__init__.py", line 86, in run
2023-12-28 00:00:12 WARNING utils._handle_output:299      modify_user(obj)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/provisioning/users.py", line 445, in modify_user
2023-12-28 00:00:12 WARNING utils._handle_output:299      user.modify()
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/soap/backend.py", line 477, in modify
2023-12-28 00:00:12 WARNING utils._handle_output:299      super(SoapUser, self).modify()
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/soap/backend.py", line 180, in modify
2023-12-28 00:00:12 WARNING utils._handle_output:299      self.service(self.context_id).change(obj)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/soap/services.py", line 536, in change
2023-12-28 00:00:12 WARNING utils._handle_output:299      return self._call_ox('change', usrdata=user)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/univention/ox/soap/services.py", line 163, in _call_ox
2023-12-28 00:00:12 WARNING utils._handle_output:299      return getattr(service, func)(**kwargs)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/zeep/proxy.py", line 46, in __call__
2023-12-28 00:00:12 WARNING utils._handle_output:299      return self._proxy._binding.send(
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/zeep/wsdl/bindings/soap.py", line 135, in send
2023-12-28 00:00:12 WARNING utils._handle_output:299      return self.process_reply(client, operation_obj, response)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/zeep/wsdl/bindings/soap.py", line 229, in process_reply
2023-12-28 00:00:12 WARNING utils._handle_output:299      return self.process_error(doc, operation)
2023-12-28 00:00:12 WARNING utils._handle_output:299    File "/usr/lib/python3.9/site-packages/zeep/wsdl/bindings/soap.py", line 329, in process_error
2023-12-28 00:00:12 WARNING utils._handle_output:299      raise Fault(
2023-12-28 00:00:12 WARNING utils._handle_output:299  zeep.exceptions.Fault: ACC-0017 Categories=USER_INPUT Message='Duplicate mail account for user 1873 in context 1.'
exceptionID=567333900-98066427; exceptionId 592895768-140402
2023-12-28 00:00:12 INFO    utils._handle_output:299  This is consecutive error #70189

Investigation:

Check for users within guests:

/opt/open-xchange/sbin/listuser -A oxadmin -P $(< /etc/ox-secrets/context10.secret) -c 10 --includeguests

article 21897 may help

Looking for the user in the mysql database:
MariaDB [localhost_5]> select cid, id, user, primary_addr, login, name from user_mail_account where login like '%scheinig%';

+-----+------+------+---------------------------------------+---------------------------------------+-------------+
| cid | id   | user | primary_addr                          | login                                 | name        |
+-----+------+------+---------------------------------------+---------------------------------------+-------------+
|   1 |    0 | 1873 | christina.Scheinig@schein.ig | christina.scheinig@schein.ig | E-Mail      |
|   1 | 3812 | 1873 | beschwerden@schein.ig   | christina.scheinig@schein.ig | Beschwerden |
+-----+------+------+---------------------------------------+---------------------------------------+-------------+

The beschwerden@schein.ig is not an ox user. Login has to be unique in ox, so the user must have been created an none ucs way.

Solution:

Delete the beschwerden user from ox.

Mastodon