[SOGo] BTS activities for Tuesday, December 10 2019

2019-12-10 Thread SOGo reporter 
Title: BTS activities for Tuesday, December 10 2019





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Tuesday, December 10 2019

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4868
	2019-12-10 07:39:35
	updated (open)
	ActiveSync
	Searching with iOS Mail Client gives only results from subject - no fts
	
	  
	
4873
	2019-12-10 07:46:06
	updated (open)
	Backend Calendar
	TB Lighting does not work as expected with shared resources
	
	  
	
4877
	2019-12-10 16:17:09
	updated (open)
	Backend Calendar
	Event created with the most recent thunderbird are shifted one hour earlier in the web access and on Smartphone Client (ASync)
	
	  
	
4898
	2019-12-10 04:51:14
	updated (open)
	Web Calendar
	Include in Free/busy does not work as intended
	
	  
	
4752
	2019-12-10 15:02:48
	updated (open)
	Web Mail
	Search message by read/unread flag
	
	  
	
4870
	2019-12-10 10:47:25
	updated (open)
	Web Mail
	Index of messages
	
	  
	
4904
	2019-12-10 17:03:29
	updated (open)
	Web Mail
	When an email is forwarded or answered, attachments are lost
	
	  
	
4905
	2019-12-10 08:16:11
	updated (open)
	Web Mail
	Weird ACL with SOGo and CyrusImapd through webui
	
	  
	
4906
	2019-12-10 08:24:14
	updated (open)
	Web Mail
	ACL right are not complete
	
	  
	
4894
	2019-12-10 16:16:46
	resolved (fixed)
	Web Calendar
	Sogo shows event created in external app moved by one hour
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Tons of duplicate contacts

2019-12-10 Thread Christian Mack 
Hello

Duplicates should be removed with that sogo-tool command.
Do those remaining duplicates differ in any way from each other?


Kind regards,
Christian Mack

Am 08.12.19 um 17:24 schrieb Gilles Quenot (gilles.que...@stardustone.io):
> Hi,
> 
> I ran successfully 'sogo-tool me personal' to remove some duplicates
> contacts, removed =~ 50 000 duplicates. Thanks Christian Mack
> 
> 
> But still remains =~ 200 000 contacs, where I should have less than 2000
> items.
> 
> Is someone have a clue to remove duplicates contacts properly ?
> 
> The duplicates was coming from the update of sogo 3.* to sogo 4.*.
> 
> It makes ActiveSync failing to synchronize contacts.
> 
> Configuration :
> Sogo 4.0.7.20190404-1
> MariaDB
> Linux Debian 10
> 
> List of sogo tables :
> ---8<--
> MariaDB [sogo]> show tables;
> +---+
> | Tables_in_sogo    |
> +---+
> | sogo_acl  |
> | sogo_alarms_folder    |
> | sogo_cache_folder |
> | sogo_folder_info  |
> | sogo_quick_appointment    |
> | sogo_quick_contact    |
> | sogo_sessions_folder  |
> | sogo_store    |
> | sogo_user_profile |
> | sogogillesqu0014c5cb855   |
> | sogogillesqu0014c5cb855_acl   |
> | sogogillesqu0014c5cb855_quick |
> | sogogillesqu0015396f580   |
> | sogogillesqu0015396f580_acl   |
> | sogogillesqu0015396f580_quick |
> | sogogillesqu0024bb73092   |
> | sogogillesqu0024bb73092_acl   |
> | sogogillesqu0024bb73092_quick |
> | sogogillesqu002647702b5   |
> | sogogillesqu002647702b5_acl   |
> | sogogillesqu002647702b5_quick |
> | sogogillesqu003044ce6c4   |
> | sogogillesqu003044ce6c4_acl   |
> | sogogillesqu003044ce6c4_quick |
> | sogogillesqu003686d9622   |
> | sogogillesqu003686d9622_acl   |
> | sogogillesqu003686d9622_quick
> ---8<--
> 
> Regards
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Calendars have changed behaviour with all day events

2019-12-10 Thread Christian Mack 
Hello

Am 09.12.19 um 10:35 schrieb John Stirling (j...@johnstirling.co.uk):
> Hi Christian,
> 
> Thank you for replying
> 
> On 05/12/2019 08:39, Christian Mack (christian.m...@uni-konstanz.de) wrote:
>> Hello
>>
>> Am 28.11.19 um 18:56 schrieb John Stirling (j...@johnstirling.co.uk):
>>> Hi guys,
>>>
>>> I could really use some advice please.
>>>
>>> I'm using sogo 4.1.1 (@shiva2.inverse 201911280300) on Ubuntu 18.04.4
>>> with a mixed environment of Mozilla Thunderbird versions from 68 or so
>>> through to 71, and some phones, apple and android. We aren't a big site,
>>> 12 users, with maybe 8 phones connected.
>>>
>>> Today following an update to the server (Ubuntu standard update), and an
>>> increase to WOWorkersCount and PREFORK all day events have started
>>> behaving oddly (I don't thing it can be the config change, but since
>>> it's a change I'm mentioning it
>>>
>>> The behaviour is that instead of showing at the top of the calendar in
>>> Thunderbird, they now get treated as 24 hour events. This is a
>>> significant issue for us as there are a lot of shared diaries, and we
>>> use all day events quite a bit.  The web version of SOGo works fine.
>>>
>>> It's odd as it seems to be applying to all versions of Thunderbird, but
>>> there have been no updates to Thunderbird, so it appears to be how SOGo
>>> is treating all day requests as standard from Thunderbird.  When these
>>> events are opened in SOGo web interface they do not register as all day
>>> events.
>>>
>>> Thanks
>>>
>>> John
>>>
>> Do you use ActiveSync?
>>
>> Which timezones have you set on Thunderbird clients and sogo.conf and
>> user settings?
>>
>> Please give an example in raw form.
> BEGIN:VCALENDAR
> 
> PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
> VERSION:2.0
> BEGIN:VEVENT
> CREATED:20191203T173909Z
> LAST-MODIFIED:20191206T144043Z
> DTSTAMP:20191206T132229Z
> UID:97d0e002-4dc9-4a27-be06-4ef3f94b2b20
> SUMMARY:test
> DTSTART;VALUE=DATE:20191207
> DTEND;VALUE=DATE:20191208
> CLASS:PUBLIC
> TRANSP:TRANSPARENT
> SEQUENCE:3
> X-MOZ-GENERATION:4
> END:VEVENT
> END:VCALENDAR
> 
>> One event created from SOGo Webfrontend which is not displayed as all
>> day event in Thunderbird.
> If the event is created within the SOGo Webfrontend it is displayed correctly 
> within thunderbird and SOGo.  If the event is then edited within Thunderbird 
> or 
> a new event is created within Thunderbird then the event no long displays 
> correctly in either SOGo or Thunderbird.
>> And one event created in Thunderbird, which is not displayed in SOGo
>> webfrontend as all day.
> 
> BEGIN:VCALENDAR
> PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
> VERSION:2.0
> BEGIN:VTIMEZONE
> TZID:Europe/London
> LAST-MODIFIED:20191023T183904Z
> X-LIC-LOCATION:Europe/London
> BEGIN:DAYLIGHT
> TZNAME:BST
> TZOFFSETFROM:+
> TZOFFSETTO:+0100
> DTSTART:19700329T01
> RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU
> END:DAYLIGHT
> BEGIN:STANDARD
> TZNAME:GMT
> TZOFFSETFROM:+0100
> TZOFFSETTO:+
> DTSTART:19701025T02
> RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU
> END:STANDARD
> END:VTIMEZONE
> BEGIN:VEVENT
> CREATED:20191203T173909Z
> LAST-MODIFIED:20191206T132229Z
> DTSTAMP:20191206T132229Z
> UID:97d0e002-4dc9-4a27-be06-4ef3f94b2b20
> SUMMARY:test
> DTSTART;TZID=Europe/London:20191207T00
> DTEND;TZID=Europe/London:20191208T00
> CLASS:PUBLIC
> TRANSP:TRANSPARENT
> SEQUENCE:3
> X-MOZ-GENERATION:4
> END:VEVENT
> END:VCALENDAR
> 
> This is an iRedmail installation of SOGo, updated through Ubuntu apt upgrade. 
>  
> We do not have any outlook clients currently.  We use android with webdav and 
> imap, and have a few iPhones which connect using whatever dark arts apple use 
> - 
> so I don't think so, but I don't actually know.
> 
> Timezone in Thunderbird is Europe/London
> 
> SOGoTimeZone in sogo.conf is "Europe/London"
> 
> Many thanks
> 
> John Stirling
> 

Hmmmh...
Those are both generated in Thunderbird/Lightning:
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN

The first event misses a Z character at the end in DTSTART and DTEND in
the event definition.
currently is:
DTSTART;VALUE=DATE:20191207
DTEND;VALUE=DATE:20191208

should be:
DTSTART;VALUE=DATE:20191207Z
DTEND;VALUE=DATE:20191208Z

Without that Z (which means Zulu, which in turn means timezone UTC) that
event is in local time per standard, as no time zone is set at all.
So this event has a false time zone set ("Europe/London" from sogo.conf).
With that this event will not start and end at 00:00:00 UTC, but at
00:00:00 of the set local timezone.
SOGo only accepts events in UTC as all day events.


The second event has a time zone set in the event, but in that timezone
definition it also has not set the Z character in DAYLIGHT and STANDARD
for DTSTART.
This is definitely a bug in Thunderbird/Lightning.
If I understand the RFC correctly, it always has to be Zulu timezone in
timezone definitions.
But as the set timezone is not UTC, even if that bug is corrected, this
event will