Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Viewing via Public Link no longer logged in oc_activity table #50785

Open
6 of 8 tasks
macleajb opened this issue Feb 13, 2025 · 1 comment
Open
6 of 8 tasks

[Bug]: Viewing via Public Link no longer logged in oc_activity table #50785

macleajb opened this issue Feb 13, 2025 · 1 comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug

Comments

@macleajb
Copy link

⚠️ This issue respects the following points: ⚠️

Bug description

Hi Folks,

Previous versions of Nextcloud would update the oc_activity table when a file like a PDF was viewed via a shared link.

It would get added to oc_activity under the subject of public_shared_file_downloaded.
It appeared to be called through singleFileDownloaded in apps/files_sharing/lib/Controller/ShareController.php.

Noticed that now, after upgrading to Nextcloud Hub 9(30.0.5), no longer is an alert added to oc_activity when you view a PDF via a shared link.

It does log to oc_activity when you download the file from a shared link. That still appears to call singleFileDownloaded.

Cheers,
DrJES

Steps to reproduce

1.Share a link of a PDF
2.Open the PDF to view via the created link
3.Search for an entry in oc_activity confirming that file was accessed. There will be no record:
example SQL: select subject,timestamp,file from oc_activity where subject='public_shared_file_downloaded' ;

Expected behavior

Viewing of files shared via a link should have their access logged. Worked at least in version 24.

Nextcloud Server version

30

Operating system

RHEL/CentOS

PHP engine version

PHP 8.3

Web server

Apache (supported)

Database engine version

MySQL

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

{
    "system": {
        "auth.bruteforce.protection.enabled": false,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.4.1",
        "overwriteprotocol": "https",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "25",
        "sharing.enable_share_mail": false,
        "maintenance": false,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "debug": false,
        "theme": "",
        "localstorage:allowsymlinks": true,
        "localstorage.allowsymlinks": true,
        "default_phone_region": "CA",
        "logtimezone": "America\/Halifax",
        "maintenance_window_start": 4,
        "app_install_overwrite": [
            "documentserver_community"
        ],
        "enable_previews": false
    }
}

List of activated Apps

Enabled:
  - activity: 3.0.0
  - admin_audit: 1.20.0
  - app_api: 4.0.3
  - cloud_federation_api: 1.13.0
  - dav: 1.31.1
  - documentserver_community: 0.1.20
  - federatedfilesharing: 1.20.0
  - files: 2.2.0
  - files_downloadlimit: 3.0.0
  - files_external: 1.22.0
  - files_pdfviewer: 3.0.0
  - files_reminders: 1.3.0
  - files_sharing: 1.22.0
  - lookup_server_connector: 1.18.0
  - oauth2: 1.18.1
  - onlyoffice: 9.5.0
  - password_policy: 2.0.0
  - photos: 3.0.2
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - related_resources: 1.5.0
  - settings: 1.13.0
  - text: 4.1.0
  - theming: 2.5.0
  - theming_customcss: 1.17.0
  - twofactor_backupcodes: 1.19.0
  - user_saml: 6.4.1
  - viewer: 3.0.0
  - webhook_listeners: 1.1.0-dev
  - workflowengine: 2.12.0
Disabled:
  - bruteforcesettings: 3.0.0 (installed 2.4.0)
  - circles: 30.0.0 (installed 24.0.0)
  - comments: 1.20.1 (installed 1.9.0)
  - contacts: 5.5.3 (installed 5.5.3)
  - contactsinteraction: 1.11.0 (installed 1.0.0)
  - dashboard: 7.10.0 (installed 7.0.0)
  - encryption: 2.18.0
  - federation: 1.20.0 (installed 1.9.0)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - files_trashbin: 1.20.1 (installed 1.9.0)
  - files_versions: 1.23.0 (installed 1.12.0)
  - firstrunwizard: 3.0.0 (installed 2.7.0)
  - logreader: 3.0.0 (installed 3.0.0)
  - nextcloud_announcements: 2.0.0 (installed 1.8.0)
  - notifications: 3.0.0 (installed 2.8.0)
  - recommendations: 3.0.0 (installed 0.7.0)
  - serverinfo: 2.0.0 (installed 1.9.0)
  - sharebymail: 1.20.0 (installed 1.9.0)
  - spreed: 15.0.8 (installed 15.0.8)
  - support: 2.0.0 (installed 1.2.1)
  - survey_client: 2.0.0 (installed 1.7.0)
  - suspicious_login: 8.0.0
  - systemtags: 1.20.0 (installed 1.9.0)
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - updatenotification: 1.20.0 (installed 1.20.0)
  - user_ldap: 1.21.0
  - user_status: 1.10.0 (installed 1.0.1)
  - weather_status: 1.10.0 (installed 1.0.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs

Additional info

No response

@macleajb macleajb added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Feb 13, 2025
@boutilpj
Copy link

Same here. Version 30.0.5.1 .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug
Projects
None yet
Development

No branches or pull requests

3 participants