Problem with WebApp Calendar after ICS-Import

norman

Hello,

I am desperate and hope that somebody can help me.

I have tried to add calendar entries to a subfolder of my calender with help of this documentation:
https://kb.kopano.io/display/WIKI/Importing+ICAL+.ics+files+into+Kopano

I have tried several calls:

curl -u user:pw -T kalender.ics https://www.domain.de:8123/calendars/norman/Abfall
curl -u user:pw -T kalender.ics https://www.domain.de:8443/caldav/norman/FLDPRFX_77ED22B276B947FFA37C34EF2B8BC7EF
curl -k -u user:pw -T kalender.ics https://www.domain.de:8443/caldav/norman/FLDPRFX_77ED22B276B947FFA37C34EF2B8BC7EF
curl -k -u user:pw -T kalender.ics http://www.domain.de:8080/ical/norman/FLDPRFX_77ED22B276B947FFA37C34EF2B8BC7EF

I think the last two attempts did not produce an error and the last one was successfull.

Now I can see my calendar entries with CalDav and in the WebApp if I use the list view. But day, week, month view don’t work - they are empty. I have deleted the subfolder, but my main calendar doesn’t work correctly. Other users have no problems. In the log files I couldn’t find an error.

Has somebody an idea what I can do? Is it possible to repair it? Can I create a second or a new calendar for my user without this problem? Can I reset my calendar?

Thanks, Norman

norman

WebApp Error log is activated in config.php:

ini_set("log_errors", true);
error_reporting(E_ERROR);

Last entries in Apache log file:

[Thu Sep 27 03:08:15.013762 2018] [:error] [pid 21594] [client xxx.xxx.xxx.xxx:54329] [DBG][AccountStore] Found 1 accounts., referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.013829 2018] [:error] [pid 21594] [client xxx.xxx.xxx.xxx:54329] [DBG][FilesAccountModule] Sorting by account_sequence in direction: ASC, referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.019625 2018] [:error] [pid 21017] [client xxx.xxx.xxx.xxx:54328] [DBG][BackendStore] Searching for external backends in /usr/share/kopano-webapp/plugins/,referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.019832 2018] [:error] [pid 21017] [client xxx.xxx.xxx.xxx:54328] [DBG][BackendStore] Registering backend: Webdav, referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.020484 2018] [:error] [pid 21017] [client xxx.xxx.xxx.xxx:54328] [DBG][BackendStore] Registering backend: FTP, referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.020819 2018] [:error] [pid 21017] [client xxx.xxx.xxx.xxx:54328] [DBG][BackendStore] Registering external backend: Owncloud, referer: https://www.domain.de/webapp/
[Thu Sep 27 03:08:15.021039 2018] [:error] [pid 21017] [client xxx.xxx.xxx.xxx:54328] [DBG][BackendStore] Registering external backend: SMB, referer: https://www.domain.de/webapp/

There isn’t an error in the developer tools of Firefox > Runtime analysis / console.

No new entries in the Kopano server.log.

norman

Hello,

I have a new finding: I can not open any calendar in the WebApp with my account. Other users can open their calendar but also mine. What could be behind it?

Thanks, Norman

marty

What happens when you open the appointment from the list view?
Does this ics file has METHOD:REQUEST or METHOD:PUBLISH?

We’re working on ics file import from WebApp, so would be great if you can share this ics file
(strip sensitive data of course)

norman

I have deleted all new entries - I can not say that. The ICS file was very simple.

In the morning I have create a new user with rights for my calendar and everything works. But now the same problem also with the new user and his empty calendar.

Very strange…

norman

Because I could not find the reason, I have successfully created a new account and migrated the data now.

Created a new Kopano account with kopano-admin (normannew; normannew@domain.de)
Gave permissions in new account for old account and opened shared folder in old account with WebApp (i think only this direction is possible to prevent, that the problem is also on the new account!)
Used old account to copy mail, contacts, calendar (list view; only 6 month old data and all recurring calender entries with recurring info column; some old calender entries could not be copied - but that’s ok) with WebApp
Deleted permissions and the shared folder with WebApp
Deleted Exchange account on smartphone
Renamed old account (norman -> normanold; norman@domain.de -> normalold@domain.de) with kopano-admin
Renamed new account (normannew -> norman; normannew@domain.de -> norman@domain.de) with kopano-admin
Created Exchange account on smartphone

Norman

norman

would be great if you can share this ics file

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//awr.de//NONSGML kigkonsult.se iCalcreator 2.16.6//
CALSCALE:GREGORIAN
METHOD:PUBLISH
BEGIN:VEVENT
UID:20180928T121725CEST-8452nW0WHl@awr.de
DTSTAMP:20180928T101725Z
DESCRIPTION:Abfuhrtermine und aktuelle Störungsmeldungen auf www.awr.de
DTSTART;VALUE=DATE:20181002
DURATION:P1D
LOCATION:yyy\, xxx
SUMMARY:Restabfall(14-täglich)
TRANSP:TRANSPARENT
URL:https://www.awr.de
X-MICROSOFT-CDO-BUSYSTATUS:FREE
END:VEVENT
BEGIN:VEVENT
UID:20180928T121725CEST-8461DcCWUT@awr.de
DTSTAMP:20180928T101725Z
DESCRIPTION:Abfuhrtermine und aktuelle Störungsmeldungen auf www.awr.de
DTSTART;VALUE=DATE:20181016
DURATION:P1D
LOCATION:yyy\, xxx
SUMMARY:Restabfall(14-täglich)
TRANSP:TRANSPARENT
URL:https://www.awr.de
X-MICROSOFT-CDO-BUSYSTATUS:FREE
END:VEVENT
...

We’re working on ics file import from WebApp

Perfect!!!

marty

I’m missing the END:VCALENDAR in the file, but that’s probably just cut off.
With python-kopano import it works fine in WebApp (every view)

Btw: currently only the first entry is imported. That’s something that has to be fixed in kopano-core.

norman

Yes - ICS is ok with END:VCALENDAR.
I think it was not the ICS file itself but one of the import attempt messed up everything internal.

tosty

@norman
I’ve experienced similar problems on different versions of WebApp a few times. Users don’t remember what they did with their calendars before the problem occurred.

A symptom was always, that no entries where show in the day / week / month views.

I then exported the WebApp settings as a JSON file with

kopano-tools-webapp_settings --user jdoe --backup

cleaned it manually from all calendar related settings und restore it back (–restore).

norman

Thanks for this info. Do you mean this tool?

https://kb.kopano.io/display/WIKI/Backup+and+restore+WebApp+settings

norman

I tried the procedure. Unfortunately without success.

tosty

Sorry to hear that. You could also try to completely reset the WebApp settings.

kopano-tools-webapp_settings --user jdoe --remove