View Issue Details

IDProjectCategoryView StatusLast Update
0006050SOGoBackend Generalpublic2025-01-13 15:53
Reportersaueee Assigned To 
PrioritynormalSeveritymajorReproducibilityrandom
Status newResolutionopen 
OSDebian 12 
Product Version5.11.0 
Summary0006050: Sogo invitation-reply spam every 5 minutes
Description

This is the third time in one year we encounter a bug where sogo sends repeated invitation replies and never stops.

  1. User gets Invitation from third party to his Thunderbird.
  2. User accepts the invitation and add it to his sogo-synced calendar.
  3. Sogo-WebUI does NOT show the event.
  4. Sogo sends repeated "invitation-reply" e-mails to the Inviter every 5 minutes.

The only way to stop this is to enable the option:
Options -> Calendar -> Invitations -> "Disable e-mail notifications on CalDAV"
However if you disable it, sogo sends invitation-replies again.

Steps To Reproduce

Not easily reproducible.

Please help to find the cause of this problem.
What debug options are necessary to debug the creation of the invitation-reply?

Additional Information

The mail sogo sends every 5 minutes is attached.

TagsNo tags attached.

Activities

saueee

saueee

2024-10-23 09:14

reporter  

Screenshot 2024-10-23 105443.png (121,038 bytes)   
Screenshot 2024-10-23 105443.png (121,038 bytes)   
sebastien

sebastien

2024-10-24 08:47

administrator   ~0017917

What do you see in sogo logs ? Is there multiple calls to caldav urls ?

webmestre@hespul.org

webmestre@hespul.org

2025-01-13 15:53

reporter   ~0018030

Same issue encountered here (debian 11 with iRedMail Easy configuration)

Postfix shows every 5 minutes a SOGo connexion followed by an automated invitation reply message.
This happens on business hours only, when the SOGo web interface is opened in the browser of the user whose accounts send the repeated replies.

In the SOGo logs:

Jan 10 11:56:37 sogod [2199457]: <0x0x55f3e2f6e560[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponen
t:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x55f3dd059860> NAME:Executio
nFailed REASON:Incorrect string value: '\xF0\x9F\x98\x89)\x0A...' for column sogo.sogo_quick_appointmen t.c_description at row 1
Jan 10 11:56:37 sogod [2199457]: [ERROR] <0x55f3ea1fb7e0[SOGoAppointmentObject]:040000008200E00074C5B7101A
82E00800000000009B4D0F7F5BDB0100000000000000001000000065696F7A7D038C409AA5FE5F38D73CFB.ics> write failed:
<MySQL4Exception: 0x55f3dd059860> NAME:ExecutionFailed REASON:Incorrect string value: '\xF0\x9F\x98\x89)\x
0A...' for column sogo.sogo_quick_appointment.c_description at row 1

Those errors always seem to happen 1 or 2 seconds before the mail pops in postfix.

The event invitation which caused this has been generated by Microsoft Teams, and thus is very long and contains emojis (an entire email thread is embedded in the event description)

This could be related to this other issue about SOGo database charset and encoding: https://bugs.sogo.nu/view.php?id=5630#c16393

If I try to guess the chain of events :

  1. an email containing an invitation is received
  2. the user accepts it
  3. SOGo tries to save the event but fails
  4. a reply email is sent regardless
  5. 5 minutes after, SOGo tries again: GOTO 3.

And this for the entire lifetime of the web tab — the problem pauses while the computer sleeps, stops only if the tab is closed or refreshed.

Issue History

Date Modified Username Field Change
2024-10-23 09:14 saueee New Issue
2024-10-23 09:14 saueee File Added: Screenshot 2024-10-23 105443.png
2024-10-24 08:47 sebastien Note Added: 0017917
2025-01-13 15:53 webmestre@hespul.org Note Added: 0018030