[Bug]: Failure on subscribing to a public Google calendar #48518

escoand · 2024-09-20T05:23:39Z

⚠️ This issue respects the following points: ⚠️

This is a bug, not a question or a configuration/webserver/proxy issue.
This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
I agree to follow Nextcloud's Code of Conduct.

Bug description

When using the calendar app to add a public Google calendar i get errors. Furthermore only a small selection of the events are shown.

An other Google calender is working without problems.

Steps to reproduce

Happening with every try with my specific calendar.

Expected behavior

This calendar is working like the others.

Nextcloud Server version

30

Operating system

Other

PHP engine version

PHP 8.2

Web server

Apache (supported)

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?

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

Configuration report

{
    "system": {
        "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
            }
        ],
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "password": "***REMOVED SENSITIVE VALUE***",
            "port": 6379
        },
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***",
            "***REMOVED SENSITIVE VALUE***"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "mysql",
        "version": "30.0.0.14",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "mysql.utf8mb4": true,
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_sendmailmode": "smtp",
        "skeletondirectory": "",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauth": 1,
        "mail_smtpsecure": "ssl",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "default_language": "de",
        "default_locale": "de_DE",
        "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "DE",
        "defaultapp": "calendar",
        "loglevel": 0,
        "maintenance": false,
        "theme": "",
        "htaccess.RewriteBase": "\/",
        "maintenance_window_start": "3",
        "overwriteprotocol": "https",
        "app_install_overwrite": [
            "polls",
            "forms"
        ]
    }
}

List of activated Apps

Enabled:
  - bruteforcesettings: 3.0.0
  - calendar: 5.0.0
  - calendar_resource_management: 0.8.0
  - cloud_federation_api: 1.13.0
  - contacts: 6.1.0
  - contactsinteraction: 1.11.0
  - dav: 1.31.1
  - 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
  - files_trashbin: 1.20.1
  - files_versions: 1.23.0
  - forms: 4.2.4
  - group_everyone: 0.1.16
  - impersonate: 1.17.0
  - logreader: 3.0.0
  - lookup_server_connector: 1.18.0
  - nextcloud_announcements: 2.0.0
  - notifications: 3.0.0
  - oauth2: 1.18.1
  - oidc: 0.9.4
  - password_policy: 2.0.0
  - polls: 7.2.3
  - previewgenerator: 5.6.0
  - privacy: 2.0.0
  - provisioning_api: 1.20.0
  - serverinfo: 2.0.0
  - settings: 1.13.0
  - sharebymail: 1.20.0
  - text: 4.1.0
  - theming: 2.5.0
  - twofactor_backupcodes: 1.19.0
  - updatenotification: 1.20.0
  - viewer: 3.0.0
  - webapppassword: 24.9.0
  - workflowengine: 2.12.0
Disabled:
  - activity: 3.0.0 (installed 2.18.0)
  - admin_audit: 1.20.0
  - calendar.bak: 5.0.0
  - circles: 30.0.0-dev (installed 26.0.0)
  - comments: 1.20.1 (installed 1.16.0)
  - dashboard: 7.10.0 (installed 7.6.0)
  - encryption: 2.18.0
  - federation: 1.20.0 (installed 1.17.0)
  - firstrunwizard: 3.0.0 (installed 2.15.0)
  - phonetrack: 0.8.1 (installed 0.8.1)
  - photos: 3.0.2 (installed 2.2.0)
  - recommendations: 3.0.0 (installed 1.5.0)
  - related_resources: 1.5.0 (installed 1.1.0-alpha1)
  - support: 2.0.0 (installed 1.9.0)
  - survey_client: 2.0.0 (installed 1.14.0)
  - suspicious_login: 8.0.0 (installed 8.0.0)
  - systemtags: 1.20.0 (installed 1.16.0)
  - twofactor_nextcloud_notification: 4.0.0
  - twofactor_totp: 12.0.0-dev
  - user_ldap: 1.21.0
  - user_status: 1.10.0 (installed 1.6.0)
  - weather_status: 1.10.0 (installed 1.6.0)
  - webhook_listeners: 1.1.0-dev (installed 1.1.0-dev)

Nextcloud Signing status

No response

Nextcloud Logs

{
  "reqId": "kbmyKr2K2FEYkV3xFQex",
  "level": 0,
  "time": "2024-09-20T05:02:28+00:00",
  "remoteAddr": "10.89.0.133",
  "user": "...",
  "app": "no app in context",
  "method": "MKCOL",
  "url": "/remote.php/dav/calendars/.../...",
  "message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0",
  "version": "30.0.0.14",
  "exception": {
    "Exception": "Exception",
    "Message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
        "line": 50,
        "function": "executeQuery",
        "class": "OC\\DB\\Connection",
        "type": "->",
        "args": [
          "SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
          ["*** sensitive parameters replaced ***"],
          [2]
        ]
      },
      {
        "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 272,
        "function": "executeQuery",
        "class": "OC\\DB\\ConnectionAdapter",
        "type": "->",
        "args": [
          "SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
          ["*** sensitive parameters replaced ***"],
          [2]
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 2551,
        "function": "executeQuery",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php",
        "line": 162,
        "function": "getSubscriptionsForUser",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/WebcalCaching/RefreshWebcalService.php",
        "line": 40,
        "function": "getSubscription",
        "class": "OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***",
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Listener/SubscriptionListener.php",
        "line": 45,
        "function": "refreshSubscription",
        "class": "OCA\\DAV\\CalDAV\\WebcalCaching\\RefreshWebcalService",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***",
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php",
        "line": 68,
        "function": "handle",
        "class": "OCA\\DAV\\Listener\\SubscriptionListener",
        "type": "->",
        "args": [["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]]
      },
      {
        "file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
        "line": 230,
        "function": "__invoke",
        "class": "OC\\EventDispatcher\\ServiceEventListener",
        "type": "->",
        "args": [
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["Symfony\\Component\\EventDispatcher\\EventDispatcher"]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
        "line": 59,
        "function": "callListeners",
        "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          [["Closure"]],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
        "line": 67,
        "function": "dispatch",
        "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"],
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent"
        ]
      },
      {
        "file": "/var/www/html/lib/private/EventDispatcher/EventDispatcher.php",
        "line": 79,
        "function": "dispatch",
        "class": "OC\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [
          "OCA\\DAV\\Events\\SubscriptionCreatedEvent",
          ["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalDavBackend.php",
        "line": 2622,
        "function": "dispatchTyped",
        "class": "OC\\EventDispatcher\\EventDispatcher",
        "type": "->",
        "args": [["OCA\\DAV\\Events\\SubscriptionCreatedEvent"]]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/CalDAV/CalendarHome.php",
        "line": 249,
        "function": "createSubscription",
        "class": "OCA\\DAV\\CalDAV\\CalDavBackend",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/apps/dav/lib/CalDAV/CalendarHome.php",
        "line": 77,
        "function": "createExtendedCollection",
        "class": "Sabre\\CalDAV\\CalendarHome",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 1199,
        "function": "createExtendedCollection",
        "class": "OCA\\DAV\\CalDAV\\CalendarHome",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 560,
        "function": "createCollection",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": ["*** sensitive parameters replaced ***"]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMkcol",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->",
        "args": [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          "method:MKCOL",
          [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 253,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [["Sabre\\HTTP\\Request"], ["Sabre\\HTTP\\Response"]]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Server.php",
        "line": 370,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
        "line": 19,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/remote.php",
        "line": 146,
        "args": ["/var/www/html/apps/dav/appinfo/v2/remote.php"],
        "function": "require_once"
      }
    ],
    "File": "/var/www/html/lib/private/DB/Connection.php",
    "Line": 402,
    "message": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc",
    "tables": ["oc_calendarsubscriptions"],
    "reads": ["oc_calendarsubscriptions"],
    "exception": [],
    "CustomMessage": "dirty table reads: SELECT `displayname`, `refreshrate`, `calendarorder`, `calendarcolor`, `striptodos`, `stripalarms`, `stripattachments`, `id`, `uri`, `source`, `principaluri`, `lastmodified`, `synctoken` FROM `*PREFIX*calendarsubscriptions` WHERE `principaluri` = :dcValue1 ORDER BY `calendarorder` asc"
  },
  "id": "66ed01eb73efe"
}

Additional info

joshtrichards · 2024-09-20T13:31:25Z

Was is the XML response under your browser inspector under the Network tab for the transaction that is returning a 403?

escoand · 2024-09-23T12:04:24Z

Yes,

<?xml version="1.0" encoding="utf-8"?>
<d:error xmlns:d="DAV:" xmlns:s="http://sabredav.org/ns">
	<s:exception>Interner Serverfehler</s:exception>
	<s:message>
		Der Server konnte die Anfrage nicht fertig stellen.		Sollte dies erneut auftreten, sende bitte die nachfolgenden technischen Einzelheiten an deinen Server-Administrator.		Weitere Details können im Server-Protokoll gefunden werden.			</s:message>

	<s:technical-details>
		<s:remote-address>10.89.0.133</s:remote-address>
		<s:request-id>vaFRfVFMcxv0qTSSzEmt</s:request-id>

		</s:technical-details>
</d:error>

escoand · 2024-09-25T05:41:46Z

I tried another Nextcloud instance with the same result. Does this google calendar maybe has some special entries crashing the import?

escoand · 2024-09-25T10:48:21Z

Found the reason and created a pull request. #48349

joshtrichards · 2024-09-26T13:39:04Z

Re-opening to track dev progress. We'll let a successful merge auto-close the Issue via the linked PR. :)

escoand added the bug label Sep 20, 2024

joshtrichards transferred this issue from nextcloud/server Sep 20, 2024

escoand mentioned this issue Sep 25, 2024

fix(dav): don't crash subscription on invalid calendar object #48349

Closed

5 tasks

escoand closed this as completed Sep 25, 2024

joshtrichards reopened this Sep 26, 2024

joshtrichards added the 2. developing Work in progress label Sep 26, 2024

kesselb transferred this issue from nextcloud/calendar Oct 2, 2024

kesselb mentioned this issue Oct 2, 2024

fix(dav): don't crash subscription on invalid calendar object #48519

Merged

6 tasks

SebastianKrupinski closed this as completed in #48519 Oct 2, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[Bug]: Failure on subscribing to a public Google calendar #48518

[Bug]: Failure on subscribing to a public Google calendar #48518

escoand commented Sep 20, 2024 •

edited

Loading

joshtrichards commented Sep 20, 2024

escoand commented Sep 23, 2024

escoand commented Sep 25, 2024

escoand commented Sep 25, 2024

joshtrichards commented Sep 26, 2024

[Bug]: Failure on subscribing to a public Google calendar #48518

[Bug]: Failure on subscribing to a public Google calendar #48518

Comments

escoand commented Sep 20, 2024 • edited Loading

⚠️ This issue respects the following points: ⚠️

Bug description

Steps to reproduce

Expected behavior

Nextcloud Server version

Operating system

PHP engine version

Web server

Database engine version

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

Are you using the Nextcloud Server Encryption module?

What user-backends are you using?

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

joshtrichards commented Sep 20, 2024

escoand commented Sep 23, 2024

escoand commented Sep 25, 2024

escoand commented Sep 25, 2024

joshtrichards commented Sep 26, 2024

escoand commented Sep 20, 2024 •

edited

Loading