View Issue Details

IDProjectCategoryView StatusLast Update
0000904Funambol SOGo ConnectorBackend Calendarpublic2016-12-21 14:48
Reporterwimmer Assigned Toludovic  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionwon't fix 
Summary0000904: \r\r in VCALENDAR data
Description

Problem with two somehow occured \r\r in VCALENDAR data was mention many times.
It causes problems by synchronization via Funambol, where sync process is interrupted from this reason.
Today I found interesting thing:

  • user created new event (probably in Lightning) few days ago
    • its VCALENDAR data were ok (I have backup from 'sogo-tool backup')
  • user modified that event yesterday via sogo/dav (probably in Lightning)
    • its VCALENDAR data included \r\r in the DESCRIPTION line after it
    • I inserted affected DESCRIPTION line into Additional Information...

I think when user would open and close this modified event in the WebGUI now, SOGo will remove that \r\r from DESCRIPTION line again. But why was DESCRIPTION line affected?

Additional Information

DESCRIPTION:Dobr\U00FD den\,\npotvrzuji sch\U016Fzku kv\U016Fli d\U011Bjin\U00E1m um\U011Bn\U00ED s p^M
anem prod\U011Bkanem \U010Cepi\U010Dkou 12.10. 2010 v 10.15 hodin na KTV.\n\nP\U0159eji h^M
ezk\U00FD den. Jana Rambalov\U00E1\,sekretari\U00E1t kvk^M^M

TRANSP:OPAQUE^M

TagsNo tags attached.

Activities

ludovic

ludovic

2010-11-04 20:39

administrator   ~0001707

I can't reproduce this and I've toyed around quite a lot with SOGo/Lightning. Removing as a 1.3.4 blocker. Please see if you can find a step-by-step way of reproducing this. Also, which version is this?

There has been some changes in NGCards for v1.3.1 that might have an impact on this - see http://sogo.nu/bugs/view.php?id=690 for details.

wimmer

wimmer

2010-11-05 11:22

reporter   ~0001711

I think we have no stable step-by-step way for reproducing this.
I have 13000+ users and this problem occurs in 1 event in 1 week about.

Few days ago I found interesting case:

  • user A created new event with attendees B,C,D
  • user B accepted this event in lightning-1.0b2.103_linux-i686 and event
    is written in his calendar with:
    "SUMMARY:Projekt REMDAT - propagov\U00E1n\U00ED identit a opr\U00E1vn\U011Bn\U00ED u\U017Eivatel\U016F^M^M

"

  • I see it in his 'sogo-tool backup' file.
  • so user B cannot change "SUMMARY" by any way, but by accepting this event was data written wrong.
  • this event was created and accepted in the same day, so I cannot confirm that "^M^M" was written by accepting process.
  • users C and D accepted this event too and their 'backup' data are fine

I used sogo-mtn-1.3.3-201010281145 in that time.
User B accepted lot of other events in the same client without this issue.


I found stil one other case - look to backup data of the same event in uploaded file event.zip

2010-11-05 11:23

 

event.zip (2,032 bytes)
wsourdeau

wsourdeau

2010-11-15 16:35

viewer   ~0001813

Hi Milos,

I suspect that those events may have been modified during a Funambol synchronization. Can you check this in your Funambol logs?

Cheers,

wimmer

wimmer

2010-11-15 21:17

reporter   ~0001820

Hello Wolfgang,

yes, funambol log from that day includes "^M^M" followed by blank line:

SUMMARY:Projekt REMDAT - propagování identit a oprávn?ní uživatel?^M^M

ORGANIZER;RSVP=TRUE;CN=RNDr. Daniela SAFARIKOVA;PARTSTAT=ACCEPTED;ROLE=CHA^M

Notes:

  • direction of that Funambol synchronization was from SOGo to PDA
  • it tells us that "^M^M" was or originated there, but it doesn't tell us if "^M^M" was in the record before Funambol sync
  • I would say that all occurrences of this problem were by people who use Funambol sync. (but not all people using Funambol sync met this problem).
wsourdeau

wsourdeau

2010-11-16 20:26

viewer   ~0001849

Can you test by creating a totally new event from the device and see if it already contains ^M chars before reaching SOGo ?

Thanks

wimmer

wimmer

2010-11-16 20:38

reporter   ~0001850

I'm sorry, Wolfgang, I'm not understanding your request.
Do you mean create new event from PDA?
Yes, I can do it, but:

  • this problem occurs when event was created from Lightning (or later by another processes)
  • it is impossible to simulate it. When I check all 14,000 exported/backuped calendars of our users, I find 1 this problem after 3 weeks or so.
  • normally there is no problem by creating of event from the PDA (the same as from Lightning or WebGUI)...
wsourdeau

wsourdeau

2010-11-16 20:39

viewer   ~0001851

Hi Milos,

Yes, that's what I was asking....

Of course, if it occurs this "often" I would not request that though.... Now, the question is if it always happens with the same users ?

wimmer

wimmer

2010-11-16 21:38

reporter   ~0001855

This problem occurs till summer often.
I found 45 different users with "^M^M" in their calendars in September backup.
Once I repaired all these occurrences in their data in postgresql. After that I found this problem by few users only. They all are using Funambol sync.
One user with Apple iCAL had the same problem in the past too.

Wolfgang, if you have no idea where this bug can be, leave it. It is not hot now.
When I will have some new occurrence and findings, we can return to it again...

Thanks.

wimmer

wimmer

2011-09-06 13:05

reporter   ~0002843

now I have procedure how to reproduce it:

1) import z.ics into USER calendar in Lightning
2) do sogo-tool backup USER
3) you will find two \r\r in the backup file :
ORGANIZER;CN=Andrea Simkova/AAAAAAAA/CZ:mailto:Andrea.Simkova@xxxxxxxx.cz^M^M

It looks it causes length (75 characters) of the line in the ICS file

ORGANIZER;CN="Andrea Simkova/AAAAAAAA/CZ"
:mailto:Andrea.Simkova@xxxxxxxx.cz

You can find the same problem when you receive invitation with this ICS file in attachment and you will accept it.

This problem doesn't occur by importing the same ICS in WebGUI.

2011-09-06 13:05

 

z.ics (1,414 bytes)   
BEGIN:VCALENDAR
X-LOTUS-CHARSET:UTF-8
VERSION:2.0
PRODID:-//Lotus Development Corporation//NONSGML Notes 8.5.2//EN_S
METHOD:REQUEST
BEGIN:VTIMEZONE
TZID:Central Europe
BEGIN:STANDARD
DTSTART:19501029T020000
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
RRULE:FREQ=YEARLY;BYMINUTE=0;BYHOUR=2;BYDAY=-1SU;BYMONTH=10
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:19500326T020000
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
RRULE:FREQ=YEARLY;BYMINUTE=0;BYHOUR=2;BYDAY=-1SU;BYMONTH=3
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID="Central Europe":20110906T180000
DTEND;TZID="Central Europe":20110906T193000
TRANSP:OPAQUE
DTSTAMP:20110906T075029Z
SEQUENCE:0
ATTENDEE;ROLE=CHAIR;PARTSTAT=ACCEPTED;CN="Andrea Simkova/AAAAAAAA/CZ";
 RSVP=FALSE:mailto:Andrea.Simkova@xxxxxxxx.cz
ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE
 :mailto:simekx@yyyyyyy.cz
CLASS:PRIVATE
SUMMARY:Plavání
ORGANIZER;CN="Andrea Simkova/AAAAAAAA/CZ"
 :mailto:Andrea.Simkova@xxxxxxxx.cz
UID:848086D36A091486C1257903002B0736-Lotus_Notes_Generated
X-LOTUS-BROADCAST:FALSE
X-LOTUS-UPDATE-SEQ:1
X-LOTUS-UPDATE-WISL:$S:1;$L:1;$B:1;$R:1;$E:1;$W:1;$O:1;$M:1;RequiredAttendees:1;INetRequiredNames:1;AltRequiredNames:1;StorageRequiredNames:1;OptionalAttendees:1;INetOptionalNames:1;AltOptionalNames:1;StorageOptionalNames:1
X-LOTUS-NOTESVERSION:2
X-LOTUS-NOTICETYPE:I
X-LOTUS-APPTTYPE:3
X-LOTUS-CHILD-UID:848086D36A091486C1257903002B0736
END:VEVENT
END:VCALENDAR

z.ics (1,414 bytes)   
ludovic

ludovic

2016-12-21 14:48

administrator   ~0011065

Funambol is dead.

Issue History

Date Modified Username Field Change
2010-10-13 22:18 wimmer New Issue
2010-10-29 20:42 wsourdeau Target Version => 1.3.4
2010-11-04 19:13 ludovic Status new => assigned
2010-11-04 19:13 ludovic Assigned To => ludovic
2010-11-04 20:39 ludovic Note Added: 0001707
2010-11-04 20:39 ludovic Target Version 1.3.4 =>
2010-11-05 11:22 wimmer Note Added: 0001711
2010-11-05 11:23 wimmer File Added: event.zip
2010-11-15 16:35 wsourdeau Note Added: 0001813
2010-11-15 21:17 wimmer Note Added: 0001820
2010-11-16 20:26 wsourdeau Note Added: 0001849
2010-11-16 20:38 wimmer Note Added: 0001850
2010-11-16 20:39 wsourdeau Note Added: 0001851
2010-11-16 21:38 wimmer Note Added: 0001855
2011-09-06 13:05 wimmer Note Added: 0002843
2011-09-06 13:05 wimmer File Added: z.ics
2014-02-07 12:32 ludovic Project SOGo => Funambol SOGo Connector
2016-12-21 14:48 ludovic Note Added: 0011065
2016-12-21 14:48 ludovic Status assigned => closed
2016-12-21 14:48 ludovic Resolution open => won't fix