One hour shift of recurring meetings sent as invite to shared mailbox

KaBi · February 6, 2020, 4:26pm

Hi guys,

we are running Kopano on UCS, clients are using mostly Outlook. When setting an all-day reccuring appointment in Outlook and sending an invite to a shared (non-active) mailbox, which accepts meetings automatically, the appointment is set to one hour later in the shared calender. In the sender’s calender the time is correct (0 o’clock to 0 o’clock), but the shared mailbox spans the meeting to two days (1am to 1 am, caused by the 1 hour shift).
This behavior is not observed when this invite is done through Kopano Webapp.
I could replicate the shift on 2 Kopano servers with Outlook at the other end.
I also read somewhere, that it could have something to do with Nextcloud, but on one of the mentioned servers there is a NC installation, on the other one there is none.
I also read about setting timezone in Outlook, but how to set it for a shared calendar??
Any help would be appreciated, I have no idea what to search for and it is driving me nuts
Kind regards
KaBi

fbartels · February 7, 2020, 7:10am

Hi @KaBi,

can you share some version information about your setup (commands are explained in https://wiki.z-hub.io/display/K4U/Debugging+Kopano+on+Univention)?

The Outlook client is using ActiveSync to connect and send? What is you actual timezone? Is the UCS system using the same timezone your users are using?

PS: If you have a subscription it could be worth reaching out to our support so they can have a direct look at your system.

KaBi · February 7, 2020, 8:17am

Hi @fbartels,

thanks for your response.

Outlook uses ActiveSync, our timezone is Europe/Berlin, Server timezone:

cat /etc/timezone
Europe/Berlin

In the webapp/config.php I found Europe/London and changed it to Erope/Berlin, but this did not have any effect on the time shift.

if(!ini_get('date.timezone')) {
                date_default_timezone_set('Europe/Berlin');
        }

The installed versions are:

UCS: 4.4-1 errata376
Installed: dhcp-server=12.0 fetchmail=6.3.26 kopano-core=8.7.1.0-1 
kopano-webapp=3.5.5.2276 samba4=4.10 z-push-kopano=2.4.5 4.1/nextcloud=16.0.6-0

ii  kopano-server-packages                              8.7.9.0-0+16.1                                   
ii  kopano-webapp                                       3.5.14.2539+111.1                                
ii  kopano-webapp-plugin-desktopnotifications           2.0.3.26+32.1 
ii  kopano-webapp-plugin-filepreviewer                  2.2.0.26+24.1
ii  kopano-webapp-plugin-files                          2.1.5.305+101.2  
ii  kopano-webapp-plugin-filesbackend-owncloud          2.1.0.87+42.5 
ii  kopano-webapp-plugin-filesbackend-smb               2.1.0.50+31.5    
ii  kopano-webapp-plugin-folderwidgets                  3.5.14.2539+111.1       
ii  kopano-webapp-plugin-mdm                            2.1.1.109+38.3   
ii  kopano-webapp-plugin-smime                          2.2.2.240+23.1     
ii  kopano-webapp-plugin-spell                          2.0.1.26+42.1      
ii  kopano-webapp-plugin-spell-de-de                    2.0.1.3+39.1        
ii  kopano-webapp-plugin-spell-en                       2.0.1.1+39.1    
ii  kopano-webapp-plugin-spell-nl                       2.0.1.1+40.1   
ii  kopano-webapp-plugin-titlecounter                   3.5.14.2539+111.1     
ii  kopano-webapp-plugin-webappmanual                   3.5.14.2539+111.1  
ii  kopano4ucs                                          1.6.2  
ii  kopano4ucs-app                                      1.6.2   
ii  kopano4ucs-lib                                      1.6.2              
ii  kopano4ucs-schema                                   1.6.2            
ii  kopano4ucs-udm                                      1.6.2                
ii  kopano4ucs-webapp                                   1.5.33            
ii  kopano4ucs-z-push                                   1.5.33             
ii  z-push-kopano                                       2.5.1+0-0         
ii  z-push-kopano-gabsync                               2.5.1+0-0

UCR dump

kopano/cfg/admin/default_store_locale: de_DE.UTF-8
kopano/cfg/dagent/lmtp_listen: 127.0.0.1:2003
kopano/cfg/gateway/imaps_listen: *:993
kopano/cfg/gateway/pop3s_listen: *:995
kopano/cfg/gateway/ssl_certificate_file: /etc/kopano/ssl/cert.pem
kopano/cfg/gateway/ssl_private_key_file: /etc/kopano/ssl/private.key
kopano/cfg/ical/icals_listen: *:8443
kopano/cfg/ical/server_timezone: @&@/etc/timezone@&@
kopano/cfg/ical/ssl_certificate_file: /etc/kopano/ssl/cert.pem
kopano/cfg/ical/ssl_private_key_file: /etc/kopano/ssl/private.key
kopano/cfg/ldap.propmap/0x3004001E: description
kopano/cfg/ldap.propmap/0x3A06001E: givenName
kopano/cfg/ldap.propmap/0x3A08001E: telephoneNumber
kopano/cfg/ldap.propmap/0x3A09001E: homePhone
kopano/cfg/ldap.propmap/0x3A11001E: sn
kopano/cfg/ldap.propmap/0x3A16001E: o
kopano/cfg/ldap.propmap/0x3A17001E: title
kopano/cfg/ldap.propmap/0x3A18001E: departmentNumber
kopano/cfg/ldap.propmap/0x3A19001E: roomNumber
kopano/cfg/ldap.propmap/0x3A1C001E: mobile
kopano/cfg/ldap.propmap/0x3A21001E: pager
kopano/cfg/ldap.propmap/0x3A27001E: l
kopano/cfg/ldap.propmap/0x3A29001E: street
kopano/cfg/ldap.propmap/0x3A2A001E: postalCode
kopano/cfg/ldap.propmap/0x8005001E: secretary
kopano/cfg/ldap/ldap_authentication_method: bind
kopano/cfg/ldap/ldap_bind_passwd: @&@/etc/kopano-ldap.secret@&@
kopano/cfg/ldap/ldap_bind_user: @%@ldap/hostdn@%@
kopano/cfg/ldap/ldap_emailaddress_attribute: mailPrimaryAddress
kopano/cfg/ldap/ldap_emailaliases_attribute: mailAlternativeAddress
kopano/cfg/ldap/ldap_group_search_filter: (&(kopanoAccount=1)(objectClass=kopano-group))
kopano/cfg/ldap/ldap_groupmembers_attribute: uniqueMember
kopano/cfg/ldap/ldap_groupmembers_attribute_type: dn
kopano/cfg/ldap/ldap_groupmembers_relation_attribute:
kopano/cfg/ldap/ldap_nonactive_attribute: kopanoSharedStoreOnly
kopano/cfg/ldap/ldap_quota_multiplier: 1048576
kopano/cfg/ldap/ldap_search_base: @%@ldap/base@%@
kopano/cfg/ldap/ldap_sendas_relation_attribute: uidNumber
kopano/cfg/ldap/ldap_uri: ldap://@%@ldap/server/name@%@:@%@ldap/server/port@%@/
kopano/cfg/ldap/ldap_user_search_filter: (kopanoAccount=1)
kopano/cfg/ldap/ldap_user_type_attribute_value: kopano-user
kopano/cfg/ldap/ldap_user_unique_attribute: entryUUID
kopano/cfg/server/createcompany_script: /usr/lib/kopano/userscripts/createcompany
kopano/cfg/server/creategroup_script: /usr/lib/kopano/userscripts/creategroup
kopano/cfg/server/createuser_script: /usr/lib/kopano/userscripts/createuser
kopano/cfg/server/deletecompany_script: /usr/lib/kopano/userscripts/deletecompany
kopano/cfg/server/deletegroup_script: /usr/lib/kopano/userscripts/deletegroup
kopano/cfg/server/deleteuser_script: /usr/lib/kopano/userscripts/deleteuser
kopano/cfg/server/local_admin_users: root kopano
kopano/cfg/server/mysql_database: kopano
kopano/cfg/server/mysql_host: localhost
kopano/cfg/server/mysql_password: @&@/etc/kopano-mysql.secret@&@
kopano/cfg/server/mysql_port: 3306
kopano/cfg/server/mysql_user: kopanoDbUser
kopano/cfg/server/run_as_group: kopano
kopano/cfg/server/run_as_user: kopano
kopano/cfg/server/server_listen: *:236
kopano/cfg/server/server_listen_tls: *:237
kopano/cfg/server/server_name: kpsrv03
kopano/cfg/server/server_ssl_ca_file: /etc/univention/ssl/ucsCA/CAcert.pem
kopano/cfg/server/server_ssl_key_file: /etc/kopano/ssl/server.pem
kopano/cfg/server/sync_gab_realtime: no
kopano/cfg/server/user_plugin: ldap

In fact, we have a subscription, I might need to get to the support.

Hier is a grep for timezone in /etc

grep -nrw /etc -e timezone
/etc/univention/base.conf.bak:226:kopano/cfg/ical/server_timezone: @&@/etc/timezone@&@
/etc/univention/registry.info/variables/univention-saml.cfg:49:[saml/idp/timezone]
/etc/univention/base.conf:226:kopano/cfg/ical/server_timezone: @&@/etc/timezone@&@
/etc/univention/templates/info/univention-saml.info:25:Variables: saml/idp/timezone
/etc/univention/templates/files/etc/postgresql/9.6/main/postgresql.conf:528:timezone = 'localtime'
/etc/univention/templates/files/etc/simplesamlphp/config.php:17:print " 'timezone'              => '%s'," % configRegistry.get('saml/idp/timezone', 'Europe/Berlin')
/etc/univention/templates/files/etc/simplesamlphp/config.php:115:        * The timezone of the server. This option should be set to the timezone you want
/etc/univention/templates/files/etc/simplesamlphp/config.php:116:        * simpleSAMLphp to report the time in. The default is to guess the timezone based
/etc/univention/templates/files/etc/simplesamlphp/config.php:117:        * on your system timezone.
/etc/univention/templates/files/etc/simplesamlphp/config.php:121:#      'timezone' => 'Europe/Berlin',
/etc/postgresql/9.6/main/postgresql.conf:534:timezone = 'localtime'
/etc/postgresql/9.6/main/postgresql.conf.debian:556:timezone = 'localtime'
/etc/php5/apache2/php.ini:892:; Defines the default timezone used by the date functions
/etc/php5/apache2/php.ini:893:; http://php.net/date.timezone
/etc/php5/apache2/php.ini:894:;date.timezone =
/etc/php5/cli/php.ini:892:; Defines the default timezone used by the date functions
/etc/php5/cli/php.ini:893:; http://php.net/date.timezone
/etc/php5/cli/php.ini:894:;date.timezone =
/etc/kopano/ical.cfg:87:# The timezone of the system clock
/etc/kopano/ical.cfg.dpkg-dist:86:# The timezone of the system clock
/etc/kopano/webapp/config.php:219:      if(!ini_get('date.timezone')) {
/etc/kopano/webapp/config.php.dpkg-dist:271:    if(!ini_get('date.timezone')) {
/etc/init.d/hwclock.sh:35:# We only want to use the system timezone or else we'll get
/etc/init.d/hwclock.sh:76:              # timezone for hardware clocks in local time, and sets kernel
/etc/init.d/hwclock.sh:77:              # timezone. DO NOT REMOVE.
/etc/init.d/cron:54:# Get the timezone set.
/etc/init.d/cron:55:    if [ -z "$TZ" -a -e /etc/timezone ]; then
/etc/init.d/cron:56:        TZ=`cat /etc/timezone`
/etc/simplesamlphp/config.php:20:       'timezone'              => 'Europe/Berlin',
/etc/simplesamlphp/config.php:117:       * The timezone of the server. This option should be set to the timezone you want
/etc/simplesamlphp/config.php:118:       * simpleSAMLphp to report the time in. The default is to guess the timezone based
/etc/simplesamlphp/config.php:119:       * on your system timezone.
/etc/simplesamlphp/config.php:123:#     'timezone' => 'Europe/Berlin',
/etc/simplesamlphp/config.php.debian:88:     * The timezone of the server. This option should be set to the timezone you want
/etc/simplesamlphp/config.php.debian:89:     * SimpleSAMLphp to report the time in. The default is to guess the timezone based
/etc/simplesamlphp/config.php.debian:90:     * on your system timezone.
/etc/simplesamlphp/config.php.debian:94:    'timezone' => null,
/etc/lvm/lvm.conf:1831: #     The +hhmm or -hhmm numeric timezone (that is, the hour and minute
/etc/lvm/lvm.conf:1834: #     The timezone name or abbreviation.
/etc/php/7.0/apache2/php.ini:922:; Defines the default timezone used by the date functions
/etc/php/7.0/apache2/php.ini:923:; http://php.net/date.timezone
/etc/php/7.0/apache2/php.ini:924:;date.timezone =
/etc/php/7.0/cgi/php.ini:922:; Defines the default timezone used by the date functions
/etc/php/7.0/cgi/php.ini:923:; http://php.net/date.timezone
/etc/php/7.0/cgi/php.ini:924:;date.timezone =
/etc/php/7.0/cli/php.ini:922:; Defines the default timezone used by the date functions
/etc/php/7.0/cli/php.ini:923:; http://php.net/date.timezone
/etc/php/7.0/cli/php.ini:924:;date.timezone =

fbartels · February 7, 2020, 8:21am

This is then just using Europe/London if no value is set for the timezone in php afaik.

Yes, please do so.