Skip to content

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

@macleajb

Description

@macleajb

⚠️ 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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions