Open jinnko opened 3 years ago
Probably unrelated but the activity notification emails are also still being sent even after the global Administration > Activity > Send activity emails
setting is disabled.
Additionally looking at the contents of the email there are several items along the lines:
19 December 2019 at 14:00 Rich subject or a parameter for "{user} has updated the description of the card {card} in list {stack} on board {board}" is malformed
Probably unrelated but the activity notification emails are also still being sent even after the global Administration > Activity > Send activity emails setting is disabled.
The setting will only affect fresh activity generation. Everything in the activity_mq table will still be sent out.
I'll have a look at the errors, however for not sending out old activities that have piled up, I'd recommend to just purge oc_activity_mq once for the old entries.
Happy to clear out the old entries. Is it safe to just DELETE FROM activity_mq WHERE amq_affecteduser = "%s";
?
I was wondering whether it's falling over because of something like special characters or if some item that's being notified about has been removed. In either case I thought there's an opportunity to make it more robust.
Not sure why such old activity is being notified about now either. I've had this instance running for many years and haven't changed anything other than keeping up with updates released via the official docker channel and any installed addons.
Happy to clear out the old entries. Is it safe to just DELETE FROM activity_mq WHERE amq_affecteduser = "%s";?
Yep that would be fine.
Clearning out the oc_activity_mq
table for all users mentioned in the occ activity:send-mails
exceptions has allowed the occ activity:send-mails
command to run without error. Let see how things play out from here. Thanks for the help.
Probably unrelated but the activity notification emails are also still being sent even after the global Administration > Activity > Send activity emails setting is disabled.
The setting will only affect fresh activity generation. Everything in the activity_mq table will still be sent out.
I'll have a look at the errors, however for not sending out old activities that have piled up, I'd recommend to just purge oc_activity_mq once for the old entries.
This
The setting will only affect fresh activity generation. Everything in the activity_mq table will still be sent out.
is only true for new users, right? So when admin change activity settings it's just the default setting for new users. At least it seems to be at my instance.
Question arose, if there is any smart way to change the settings for my existing users, despite of manual database manipulation of course.
How to use GitHub
Describe the bug
One of my users has been received Activity notifications by email every 15 or 20 minutes for the past week. The contents of the emails has dozens of activity items dating back over a year.
To Reproduce
The issue is triggered by the cron. The cron is run every 5 minutes, but the Activity notification emails are sent only once every 15 or 20 minutes.
Expected behavior
Notifications should only be sent once.
Screenshots
The cron job itself doesn't generate any output, however:
Additionally in the UI logging interface there are many errors each cycle:
Client details: Not releveant
Server details
**Operating system**: Debian 10 with docker 19.03.13-3 **Web server:** nginx **Database:** MariaDB 10.3.23 **PHP version:** 7.4.11 **Nextcloud version:** 19.0.3 **Where did you install Nextcloud from:** Official docker at https://hub.docker.com/_/nextcloud/ **Signing status:** ``` No errors have been found. ``` **List of activated apps:** ``` Enabled: - accessibility: 1.5.0 - activity: 2.12.0 - admin_audit: 1.9.0 - analytics: 2.5.0 - appointments: 1.7.7 - apporder: 0.11.0 - calendar: 2.0.4 - camerarawpreviews: 0.7.8 - cloud_federation_api: 1.2.0 - comments: 1.9.0 - contacts: 3.4.0 - contactsinteraction: 1.0.0 - dav: 1.15.0 - deck: 1.1.0 - event_update_notification: 1.0.2 - federatedfilesharing: 1.9.0 - files: 1.14.0 - files_external: 1.10.0 - files_external_gdrive: 0.4.0 - files_markdown: 2.3.1 - files_pdfviewer: 1.8.0 - files_photospheres: 1.19.1 - files_rightclick: 0.16.0 - files_sharing: 1.11.0 - files_trashbin: 1.9.0 - files_versions: 1.12.0 - files_videoplayer: 1.8.0 - joplin: 0.0.25 - logreader: 2.4.0 - lookup_server_connector: 1.7.0 - metadata: 0.12.0 - nextcloud_announcements: 1.8.0 - notes: 3.6.4 - notifications: 2.7.0 - oauth2: 1.7.0 - password_policy: 1.9.1 - photos: 1.1.0 - piwik: 0.7.0 - privacy: 1.3.0 - provisioning_api: 1.9.0 - recommendations: 0.7.0 - richdocuments: 3.7.4 - serverinfo: 1.9.0 - settings: 1.1.0 - sharebymail: 1.9.0 - spreed: 9.0.4 - systemtags: 1.9.0 - tasks: 0.13.3 - text: 3.0.1 - theming: 1.10.0 - twofactor_admin: 3.0.0 - twofactor_backupcodes: 1.8.0 - twofactor_nextcloud_notification: 2.3.0 - twofactor_totp: 5.0.0 - twofactor_u2f: 6.0.0 - updatenotification: 1.9.0 - viewer: 1.3.0 - workflow_script: 1.4.0 - workflowengine: 2.1.0 Disabled: - bruteforcesettings - drawio - encryption - facerecognition - federation - files_fulltextsearch - files_fulltextsearch_tesseract - firstrunwizard - fulltextsearch - mail - news - polls - support - survey_client - twofactor_email - twofactor_gateway - user_ldap ``` **Nextcloud configuration:** ``` $ docker exec -it -u www-data nextcloud php ./occ config:list system { "system": { "htaccess.RewriteBase": "\/", "memcache.local": "\\OC\\Memcache\\APCu", "apps_paths": [ { "path": "\/var\/www\/html\/apps", "url": "\/apps", "writable": false }, { "path": "\/var\/www\/html\/custom_apps", "url": "\/custom_apps", "writable": true } ], "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "nextcloud.example.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/nextcloud.example.com", "overwriteprotocol": "https", "dbtype": "mysql", "version": "19.0.3.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "theme": "", "loglevel": 2, "maintenance": false, "mail_smtpmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "auth.bruteforce.protection.enabled": false, "mysql.utf8mb4": true, "has_rebuilt_cache": true, "twofactor_enforced": "true", "twofactor_enforced_groups": [], "twofactor_enforced_excluded_groups": [], "updater.release.channel": "stable", "app_install_overwrite": [ "twofactor_yubikey", "files_external_gdrive", "admin_notifications", "joplin" ] } } ``` **Are you using an external user-backend, if yes which one:** NoLogs
#### Nextcloud log (data/nextcloud.log) *See screenshot section above* ``` Insert your Nextcloud log here ``` #### Browser log Not relevant