⚠️ This issue respects the following points: ⚠️
Bug description
Hello,
Using Nextcloud 26.0.2 (Yunohost package, but it seems not to be limited to that very package), when deleting a user using occ, I notice that if most of that user data is deleted as expected, some do remains (neither particularly heavy nor sensitve data, but still...) in the following tables
oc_addressbookchanges
oc_jobs - this table seems related to logging, probably it is fine not to remove the deleted user's data from there?
oc_storages
oc_mail_tags - reported at Nextcloud Mail app's forum
oc_notifications_settings
Steps to reproduce
- Create a user
testuser
- Associate an email account to it in Nextcloud Mail app (that may be an optional step)
- Delete the user using
occ user:delete testuser
- Check mentioned MySQL table to see whether data related to
testuser still remain in there.
Expected behavior
I guess all data related to the deleted user should be removed (or at least that there an option is provided to do so)
Installation method
None
Nextcloud Server version
26
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.1
Web server
Nginx
Database engine version
MariaDB
Is this bug present after an update or on a fresh install?
None
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
Configuration report
{
"system": {
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"localhost",
"mydomain.tld"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "25.0.6.1",
"overwrite.cli.url": "https:\/\/mydomain.tld",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"installed": true,
"instanceid": "***REMOVED SENSITIVE VALUE***",
"ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
"updatechecker": false,
"memcache.local": "\\OC\\Memcache\\APCu",
"integrity.check.disabled": true,
"filelocking.enabled": true,
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": "5555",
"timeout": "0.0",
"password": "***REMOVED SENSITIVE VALUE***"
},
"hashing_default_password": true,
"localstorage.allowsymlinks": true,
"simpleSignUpLink.shown": false,
"logout_url": "https:\/\/mydomain.tld\/yunohost\/sso\/?action=logout",
"maintenance": false,
"loglevel": 2
}
}
List of activated Apps
Enabled:
- calendar: 4.3.4
- circles: 25.0.0
- cloud_federation_api: 1.8.0
- comments: 1.15.0
- contactsinteraction: 1.6.0
- dashboard: 7.5.0
- dav: 1.24.0
- federatedfilesharing: 1.15.0
- federation: 1.15.0
- files: 1.20.1
- files_external: 1.17.0
- files_mindmap: 0.0.28
- files_pdfviewer: 2.6.0
- files_rightclick: 1.4.0
- files_sharing: 1.17.0
- files_trashbin: 1.15.0
- files_versions: 1.18.0
- firstrunwizard: 2.14.0
- forms: 3.3.0
- logreader: 2.10.0
- lookup_server_connector: 1.13.0
- mail: 2.2.6
- nextcloud_announcements: 1.14.0
- notifications: 2.13.1
- oauth2: 1.13.0
- password_policy: 1.15.0
- photos: 2.0.1
- polls: 5.0.5
- privacy: 1.9.0
- provisioning_api: 1.15.0
- ransomware_protection: 1.14.0
- recommendations: 1.4.0
- related_resources: 1.0.4
- serverinfo: 1.15.0
- settings: 1.7.0
- sharebymail: 1.15.0
- spreed: 15.0.6
- support: 1.8.0
- survey_client: 1.13.0
- systemtags: 1.15.0
- tasks: 0.15.0
- text: 3.6.0
- theming: 2.0.1
- twofactor_backupcodes: 1.14.0
- user_ldap: 1.15.0
- user_status: 1.5.0
- viewer: 1.9.0
- weather_status: 1.5.0
- workflowengine: 2.7.0
Disabled:
- accessibility
- activity: 2.15.0
- admin_audit
- bruteforcesettings
- deck: 1.8.5
- encryption
- files_videoplayer
- groupfolders: 13.1.3
- integration_whiteboard: 0.0.14
- richdocuments: 7.1.4
- shifts: 1.8.6
- suspicious_login
- talked: 0.5.0
- twofactor_totp
- updatenotification: 1.12.0
Nextcloud Signing status
No response
Nextcloud Logs
No response
Additional info
No response
Bug description
Hello,
Using Nextcloud 26.0.2 (Yunohost package, but it seems not to be limited to that very package), when deleting a user using
occ, I notice that if most of that user data is deleted as expected, some do remains (neither particularly heavy nor sensitve data, but still...) in the following tablesoc_addressbookchangesoc_jobs- this table seems related to logging, probably it is fine not to remove the deleted user's data from there?oc_storagesoc_mail_tags- reported at Nextcloud Mail app's forumoc_notifications_settingsSteps to reproduce
testuserocc user:delete testusertestuserstill remain in there.Expected behavior
I guess all data related to the deleted user should be removed (or at least that there an option is provided to do so)
Installation method
None
Nextcloud Server version
26
Operating system
Debian/Ubuntu
PHP engine version
PHP 8.1
Web server
Nginx
Database engine version
MariaDB
Is this bug present after an update or on a fresh install?
None
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
Configuration report
{ "system": { "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost", "mydomain.tld" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "25.0.6.1", "overwrite.cli.url": "https:\/\/mydomain.tld", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "mysql.utf8mb4": true, "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory", "updatechecker": false, "memcache.local": "\\OC\\Memcache\\APCu", "integrity.check.disabled": true, "filelocking.enabled": true, "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": "5555", "timeout": "0.0", "password": "***REMOVED SENSITIVE VALUE***" }, "hashing_default_password": true, "localstorage.allowsymlinks": true, "simpleSignUpLink.shown": false, "logout_url": "https:\/\/mydomain.tld\/yunohost\/sso\/?action=logout", "maintenance": false, "loglevel": 2 } }List of activated Apps
Nextcloud Signing status
No response
Nextcloud Logs
No response
Additional info
No response