View Issue Details

IDProjectCategoryView StatusLast Update
0003399SOGosogo-toolpublic2016-11-23 08:54
ReporterGunnar Weissmann Assigned To 
PriorityhighSeverityminorReproducibilityalways
Status newResolutionopen 
Platform[Client] AppleOSOS XOS Version10.9
Product Version2.2.13 
Summary0003399: Problem with deleting users with the sogo-tool
Description

we removed a user with the sogo-tool:

sogo-tool remove username

The database was removed successfully, but there are still events with
this user as organizer and also as attendee on the server. We think that
the sogo-tool should remove all events in case he is the organizer and all
attendee entries on events from other users.

Should the sogo-tool remove all events that belongs to this user or is
there another way to do this? When not is it possible to implement this?

Thank you.

Kind Regards.

G. Weissmann

TagsNo tags attached.

Activities

esco

esco

2015-11-27 20:44

reporter   ~0009172

I don't think that this doable and is not a good idea at all.

Manipulating a non-expectable number of calendar in this way wouldn't scale well.

And why should events silently be dropped if you just delete the organizer?

Gunnar Weissmann

Gunnar Weissmann

2015-11-30 11:48

reporter   ~0009174

@esco

it would be a great option to decide whether you want to do this or not when deleting the user.

The problem is exactly this that all events of the deleted user are still there an no one can edit the events because no one has the privilege to edit/delete the event.

The result is, that there are various "dead" events an no one can clean them up. With a lot of events in an organization it is very important to clean up after a user retire.

esco

esco

2015-11-30 12:29

reporter   ~0009175

Deleting/cleaning entries from the own calendar should always be possible. Or using an administrator account should be possible, too.

A workaround would be to delete the events before deleting the user account with a CalDAV Client or the web interface. Login with admin account or reset the password of the user..

Gunnar Weissmann

Gunnar Weissmann

2016-11-22 07:04

reporter   ~0010899

Is there a way to delete the user including all events directly in the mysql-database?

Christian Mack

Christian Mack

2016-11-23 08:54

developer   ~0010903

After deleting the user, you would have to scan over all users, all calendars and all events, in order to find events which have the deleted user as attendee or owner. Then you have to delete remove him/her there and in the corresponding quick tables.

As alternative you could delete all events in the users calendars before deleting his account via admin webinterface.

This both will not scale well (to say the least).
This also could delete personal/private events, which are perhaps still valid.

Issue History

Date Modified Username Field Change
2015-11-27 14:22 Gunnar Weissmann New Issue
2015-11-27 20:44 esco Note Added: 0009172
2015-11-30 11:48 Gunnar Weissmann Note Added: 0009174
2015-11-30 12:29 esco Note Added: 0009175
2016-11-22 07:04 Gunnar Weissmann Note Added: 0010899
2016-11-23 08:54 Christian Mack Note Added: 0010903