Cannot access calendar next to upgrade to NC21 / Contacts 2.1.3

[nsteinmetz]

Steps to reproduce

1. Migrate to NC 21.0 + Contacts 2.1.3
2. Go to calendar : calendar will not load - birthdays calendar is ok
3. Clients apps reports 404 for calendar url

Expected behaviour

Calendar should display and sync on client side

Actual behaviour

UI does not display calendar

[DEBUG] calendar: Current user principal is /remote.php/dav/principals/users/nsteinmetz/ 
<empty string> Error: 
    I calendar.js:2
    r calendar.js:2
    r calendar.js:2
    o attachError.js:36
    t calendar.js:2
    n calendar.js:2
    t calendar.js:2
    n calendar.js:2
    onreadystatechange request.js:353
main.js:6306:8

On container side, logs show this 404:

10.0.0.86 - - [25/Feb/2021:11:26:19 +0000] "PROPPATCH /remote.php/dav/calendars/nsteinmetz/nicolas-steinmetz/ HTTP/1.1" 207 1031 "-" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:85.0) Gecko/20100101 Firefox/85.0"
10.0.0.86 - - [25/Feb/2021:11:26:19 +0000] "REPORT /remote.php/dav/calendars/nsteinmetz/nicolas-steinmetz/ HTTP/1.1" 404 775 "-" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:85.0) Gecko/20100101 Firefox/85.0"

But seems OSX Calendar can access to resources but it uses /remote.php/dav/principals/users/nsteinmetz

Tell us what happens instead

Calendar app

Calendar app version: 2.1.3

CalDAV-clients used: DAVx5, Evolution, macOS Calendar

Client configuration

Browser: : Firefox 85.0.1

Operating system: Fedora 33

Server configuration

Operating system: Debian 10, but using nextcloud:21 docker image

Web server: Apache Provided with docker image

Database: PostgreSQL 12

PHP version: (e.g. 7.0.3) PHP provided with docker image

Nextcloud Version: 21.0

Updated from an older installed version or fresh install: from 20.7 nextcloud instance

List of activated apps:

• contacts
• calendars
• • default apps

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your instance's installation folder

Nextcloud configuration:

Enabled:
  - accessibility: 1.7.0
  - activity: 2.14.3
  - calendar: 2.1.3
  - cloud_federation_api: 1.4.0
  - comments: 1.11.0
  - contacts: 3.4.3
  - contactsinteraction: 1.2.0
  - dashboard: 7.1.0
  - dav: 1.17.1
  - federatedfilesharing: 1.11.0
  - federation: 1.11.0
  - files: 1.16.0
  - files_external: 1.12.0
  - files_pdfviewer: 2.1.0
  - files_rightclick: 1.0.0
  - files_sharing: 1.13.1
  - files_trashbin: 1.11.0
  - files_versions: 1.14.0
  - files_videoplayer: 1.10.0
  - firstrunwizard: 2.10.0
  - logreader: 2.6.0
  - lookup_server_connector: 1.9.0
  - nextcloud_announcements: 1.10.0
  - notifications: 2.9.0
  - oauth2: 1.9.0
  - password_policy: 1.11.0
  - photos: 1.3.0
  - privacy: 1.5.0
  - provisioning_api: 1.11.0
  - recommendations: 1.0.0
  - serverinfo: 1.11.0
  - settings: 1.3.0
  - sharebymail: 1.11.0
  - support: 1.4.0
  - survey_client: 1.9.0
  - systemtags: 1.11.0
  - text: 3.2.0
  - theming: 1.12.0
  - twofactor_backupcodes: 1.10.0
  - updatenotification: 1.11.0
  - user_status: 1.1.1
  - viewer: 1.5.0
  - weather_status: 1.1.0
  - workflowengine: 2.3.0
Disabled:
  - admin_audit
  - encryption
  - user_ldap

Logs

Web server error log (e.g. /var/log/apache)

10.0.0.86 - - [25/Feb/2021:11:26:19 +0000] "PROPPATCH /remote.php/dav/calendars/nsteinmetz/nicolas-steinmetz/ HTTP/1.1" 207 1031 "-" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:85.0) Gecko/20100101 Firefox/85.0"
10.0.0.86 - - [25/Feb/2021:11:26:19 +0000] "REPORT /remote.php/dav/calendars/nsteinmetz/nicolas-steinmetz/ HTTP/1.1" 404 775 "-" "Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:85.0) Gecko/20100101 Firefox/85.0"

I saw the 2.0.5 release fixed some issues on calendar objects, is the same required on the 2.1.x branch ?

[tcitworld]

Possibly related to nextcloud/server#25165, maybe an issue with special characters.

[tcitworld]

Can you perform the following query again your database and tell us what's returned?

select uri from oc_calendars where principaluri = 'principals/users/nsteinmetz';

Is macOS Calendar the only client left working, or is it just the Nextcloud Calendar app that has issues?

[nsteinmetz]

Hi @tcitworld

Result below:

select uri from oc_calendars where principaluri = 'principals/users/nsteinmetz';
        uri
-------------------
 nicolas-steinmetz
 contact_birthdays
(2 rows)

macOs calendar seems to work well as expected.

Issue is in Evolution (based on Gnome Integration) and in DavX on Android which reports 404 issues. and also in the nextcloud calendar apps ui

[nsteinmetz]

Comparing attributes in the db, I notice some \r in the timezone column for old vs new (ie test ex) calendars:

 2 | principals/users/nsteinmetz | nicolas-steinmetz | nicolas-steinmetz |          1466 | BEGIN:VCALENDAR\r                                  +|           0
    |                             |                   |                   |               | VERSION:2.0\r                                      +|
    |                             |                   |                   |               | PRODID:-//Apple Inc.//macOS 11.2.1//EN\r           +|
    |                             |                   |                   |               | CALSCALE:GREGORIAN\r                               +|
    |                             |                   |                   |               | BEGIN:VTIMEZONE\r                                  +|
    |                             |                   |                   |               | TZID:Europe/Paris\r                                +|
    |                             |                   |                   |               | BEGIN:DAYLIGHT\r                                   +|
    |                             |                   |                   |               | TZOFFSETFROM:+0100\r                               +|
    |                             |                   |                   |               | RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU\r           +|
    |                             |                   |                   |               | DTSTART:19810329T020000\r                          +|
    |                             |                   |                   |               | TZNAME:UTC+2\r                                     +|
    |                             |                   |                   |               | TZOFFSETTO:+0200\r                                 +|
    |                             |                   |                   |               | END:DAYLIGHT\r                                     +|
    |                             |                   |                   |               | BEGIN:STANDARD\r                                   +|
    |                             |                   |                   |               | TZOFFSETFROM:+0200\r                               +|
    |                             |                   |                   |               | RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU\r          +|
    |                             |                   |                   |               | DTSTART:19961027T030000\r                          +|
    |                             |                   |                   |               | TZNAME:UTC+1\r                                     +|
    |                             |                   |                   |               | TZOFFSETTO:+0100\r                                 +|
    |                             |                   |                   |               | END:STANDARD\r                                     +|
    |                             |                   |                   |               | END:VTIMEZONE\r                                    +|
    |                             |                   |                   |               | END:VCALENDAR\r                                    +|
    |                             |                   |                   |               |                                                     |
 12 | principals/users/nsteinmetz | test              | test              |             2 | BEGIN:VCALENDAR                                    +|           0
    |                             |                   |                   |               | PRODID:-//IDN nextcloud.com//Calendar app 2.1.3//EN+|
    |                             |                   |                   |               | CALSCALE:GREGORIAN                                 +|
    |                             |                   |                   |               | VERSION:2.0                                        +|
    |                             |                   |                   |               | BEGIN:VTIMEZONE                                    +|
    |                             |                   |                   |               | TZID:Europe/Paris                                  +|
    |                             |                   |                   |               | BEGIN:DAYLIGHT                                     +|
    |                             |                   |                   |               | TZOFFSETFROM:+0100                                 +|
    |                             |                   |                   |               | TZOFFSETTO:+0200                                   +|
    |                             |                   |                   |               | TZNAME:CEST                                        +|
    |                             |                   |                   |               | DTSTART:19700329T020000                            +|
    |                             |                   |                   |               | RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU             +|
    |                             |                   |                   |               | END:DAYLIGHT                                       +|
    |                             |                   |                   |               | BEGIN:STANDARD                                     +|
    |                             |                   |                   |               | TZOFFSETFROM:+0200                                 +|
    |                             |                   |                   |               | TZOFFSETTO:+0100                                   +|
    |                             |                   |                   |               | TZNAME:CET                                         +|
    |                             |                   |                   |               | DTSTART:19701025T030000                            +|
    |                             |                   |                   |               | RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU            +|
    |                             |                   |                   |               | END:STANDARD                                       +|
    |                             |                   |                   |               | END:VTIMEZONE                                      +|
    |                             |                   |                   |               | END:VCALENDAR                                       |

I also notived that calendar with issue has a VTODO property too:

select id, principaluri, uri, synctoken, calendarorder, transparent, components from oc_calendars where principaluri='principals/users/nsteinmetz';
 id |        principaluri         |        uri        | synctoken | calendarorder | transparent |  components
----+-----------------------------+-------------------+-----------+---------------+-------------+--------------
  4 | principals/users/nsteinmetz | contact_birthdays |       107 |           100 |           0 | VEVENT
  2 | principals/users/nsteinmetz | nicolas-steinmetz |      1466 |           101 |           0 | VEVENT,VTODO
 12 | principals/users/nsteinmetz | test              |         2 |           102 |           0 | VEVENT

[nsteinmetz]

Hi,

Just created new calendars and it works as expected on all devices & softwares.

So I guess there is something missing during the upgrade from NC 20 to 21 or at Calendar app level

[pietervandereems]

Just to add for other people who have the same problem (calendar not syncing in thunderbird and evolution) after an upgrade to nextcloud version 21.

In my case I have the nextcloud snap running and it recently upgraded itself to version 21.
Thunderbird would connect and show me the calendar at startup but would loose connection after a short while. Evolution (gnome) never got a connection (it did not show any events in the gnome calendar).

I connected to the database (snap.mysql-client) and in my case a select (select * from oc_calendars ) showed all the timezone fields had the value NULL.

I then created a new test calendar. This new calendar had about the same value for "timezone" as show in the comment by nsteinmetz (different timezone). I then updated the timezone field for my personal calendar, and it started working again in thunderbird and evolution/gnome

[pietervandereems]

Addition: Thunderbird continues to have issues when adding or altering an appointment/event/item in the calendar.

[jamesstanw]

I also have a similar issue.
Nextcloud 21.0.3; PhP 8.0.8; Nginx 1.21.1 Calendar app 2.3.1
As background I was running NC 16 (with older versions of php, nginx, and Mariadb (10.4) on an Ubuntu 18.04 vm). The VM went bad, so after getting that running, I upgraded through the versions of NC to 21 fixing errors in the database as I went. I then created a new instance of NC (as above and on ubuntun 20.04), ran a mysql dump and moved both this and my data folder to this new instance. All has been working well apart from a few glitches - this being one!
The calendar will not show on my phone but is showing correctly within NC on a browser.

The caldav link is:
https://stanworth.cloud/remote.php/dav/principals/users/james2/

Running
select uri from oc_calendars where principaluri = 'principals/users/james2;

Shows:
MariaDB [nextcloud]> select uri from oc_calendars where principaluri = 'principals/users/james2'; +-------------------+ | uri | +-------------------+ | contact_birthdays | | james | | james-tasks | | research-1 | | teaching | +-------------------+ 5 rows in set (0.001 sec)
Any help in getting the calendars to show on the phone would be really appreciated!