Problem with WebApp Calendar after ICS-Import



  • 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.

    List view

    Month view

    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



  • 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.



  • 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


  • Kopano

    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)



  • 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…



  • 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



  • 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!!!


  • Kopano

    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.



  • 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.



  • @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).



  • Thanks for this info. Do you mean this tool?

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



  • I tried the procedure. Unfortunately without success.



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

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

Log in to reply