[SOGo] All-day events created in MS Outlook go one day back - SOGo 2.0, MS Exchange connectivity
I have configured MS Outlook with the native MS Exchange connectivity to SOGo. If I create an all-day event in MS Outlook it is correctly displayed in its calendar but in SOGo and in Thunderbird it is displayed one day back. I have the same timezone in SOGo SOGoTimeZone Europe/Prague under the user in SOGo in his Preferences and in Windows. Raw source from SOGo: BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Inverse inc.//OpenChange+SOGo//EN BEGIN:VEVENT CREATED:20121001T133808Z UID:E96-5069B900-29-16AF6D00 CLASS:PUBLIC LAST-MODIFIED:20121001T133808Z SUMMARY:all day event that should happen on 4th October DTSTART;VALUE=DATE:20121003 DTEND;VALUE=DATE:20121004 PRIORITY:5 TRANSP:TRANSPARENT DESCRIPTION:Asdfghjklzxcvbnm\n\n\n END:VEVENT END:VCALENDAR in the corresponding table with _quick suffix I have c_startdate 1349222400 which means Wed, 03 Oct 2012 00:00:00 GMT c_enddate 1349308799 which means Wed, 03 Oct 2012 23:59:59 GMT I created another event in MS Outlook but in different profile where I have a Funambol sync working. In MS Outlook it is displayed correctly (both profiles - MS Exchange and IMAP account with Funambol calendar sync) but in SOGo it is again one day back but Thunderbird displays the event correctly. Raw source from SOGo: BEGIN:VCALENDAR VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Prague BEGIN:DAYLIGHT DTSTART:20110327T02 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3 TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:Europe/Prague END:DAYLIGHT BEGIN:STANDARD DTSTART:20111030T03 RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10 TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:Europe/Prague END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:72B723FE7C337E4CA133C8A746793178A4032000 SUMMARY:all day event that should happen on 4th October through Funambol DESCRIPTION:aaa LOCATION: CATEGORIES: CLASS:PUBLIC DTSTART;VALUE=DATE:20121004 DTEND;VALUE=DATE:20121005 PRIORITY:5 STATUS:0 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-FUNAMBOL-ALLDAY:1 X-FUNAMBOL-FOLDER:DEFAULT_FOLDER X-MICROSOFT-CDO-BUSYSTATUS:0 X-MICROSOFT-CDO-REPLYTIME: X-FUNAMBOL-BILLINGINFO: X-FUNAMBOL-COMPANIES: X-FUNAMBOL-MILEAGE: X-FUNAMBOL-NOAGING:0 END:VEVENT END:VCALENDAR c_startdate = c_enddate 1349301600 which means Wed, 03 Oct 2012 22:00:00 GMT Is it a bug or do I miss something in my configuration? Thank you Michal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: SOLVED [SOGo] Problems with synchronization between SOGo and Outlook using Funambol – national characters
Finally I got it. Although everything in MySQL was in UTF8 I forgot to add the following into my.cnf [mysqld] ... character_set_server=utf8 character_set_client=utf8 [client] default-character-set=utf8 [mysql] default-character-set=utf8 It's in the manual and I didn't update my.cnf - my mistake. Now it is OK. Michal -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problems with synchronization between SOGo and Outlook using Funambol – national characters
Hello, I made several new attempts to solve the "quoted printable" problem. I updated Funambol with the new Funambol SOGo Connector v1.0.9 but I still face the same problem. I even tried to replace the embeded Java runtime with the latest System version(on Cent OS 6.3) but the problem remains. Just shortly describe the problem. The problem appears when using the built-in calendar on Windows Mobile device or in MS Outlook in conjuction with funambol sync. If I create an event containing some national chracters(from Czech language) and synchronize it using Funambol to SOGo I can see in ds-server.log SUMMARY;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:=C5=A1=C4=8D=C5=99 =C5=A1 =C4=8D =C5=99 are š č ř after synchronization I can see in the database š??, last two characters were not correctly converted and were replaced by ? If I again synchronize the calendar the damaged event gets back, ds-server.log shows: SUMMARY;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:=C5=A1?? ? remains ?, last two national characters are lost. It's weird because some characters are correctly converted and some don't Can you help me where the conversion between Quoted Printable and UTF-8 is done before inserting into database ? Is it the Funambol SOGo Connector or any other Funambol part. Just to mention - I don't program in Java. Thanks Michal Kminek -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo 2.0rc5: Problems with openchange-ocsmanager on CentOS 6.3, python-simplejson version problem
I installed and configured the latest 2.0 SOGo release. Everything works correctly except the openchange-ocsmanager. The OpenChange web service immediatelly stops after start. I found in the log: File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 648, in require needed = self.resolve(parse_requirements(requirements)) File "/usr/lib/python2.6/site-packages/pkg_resources.py", line 550, in resolve raise VersionConflict(dist,req) # XXX put more info here pkg_resources.VersionConflict: (simplejson 2.0.9 (/usr/lib/python2.6/site-packages), Requirement.parse('simplejson>=2.2.1')) Removing PID file /var/run/ocsmanager/ocsmanager.pid There is no package python-simplejson with version >=2.2.1. The only package I found is python-simplejson-2.0.9-3.1.el6.i686.rpm from the "base" CentOS repository. I tried to install the package from tar using easy_install but I didn't succeed and I'd prefer a rpm version to simplify maintenance. Can you help me, please? Thank you Michal -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Unable to subscribe user to a calendar
I experienced the problem in the web interface. If I invoke the menu on an existing calendar and click on Sharing... I immediately get "WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!:" in sogo.log. Regardless the message in the log a new window appears and I can find users and grant various rights. Then I check Subscribe User box and close the window. If I again open the "Sharing" window the Subscribe User box is unchecked. I also get the error message each time I open the "Sharing" window. The sharing doesn't work. I can add the shared calendar as the subcribed user but the calendar is in red italics and I can't see any events and next login (as the subcribed user) the shared calendar disappears from the menu. I tried to share the calendar using SOGo Integrator in Thunderbird and there is no checkbox Subscribe user in the "Sharing" window nevertheless the sharing doesn't work too. I installed fresh CentOS 6.2 32bit on my testing server, then I installed 389 Directory Server with ldap and ldaps support. Authentication works well in the system. Then I installed SOGo - I used epel and inverse repos and yum, no manual compilations. After that I followed the official manual, sogod and memcached are running, everything works well except the sharing issue. I can log into SOGo and work. Hostname correctly resolves to IP address. MySQL db works well too. Perhaps I miss some component or a piece of configuration. Can you help me where to look for a detailed report on what happens? Can you recheck my config? Thank you Michal Details: [root@fs sogo]# rpm -qa | grep sope sope49-gdl1-4.9-20120601_1664.el6.1.i686 sope49-sbjson-2.3.1-20120601_1664.el6.1.i686 sope49-gdl1-mysql-4.9-20120601_1664.el6.1.i686 sope49-gdl1-contentstore-1.3.16-1.centos6.i686 sope49-appserver-4.9-20120601_1664.el6.1.i686 sope49-mime-4.9-20120601_1664.el6.1.i686 sope49-xml-4.9-20120601_1664.el6.1.i686 sope49-cards-1.3.16-1.centos6.i686 sope49-core-4.9-20120601_1664.el6.1.i686 sope49-ldap-4.9-20120601_1664.el6.1.i686 [root@fs sogo]# rpm -qa | grep sogo sogo-1.3.16-1.centos6.i686 [root@fs sogo]# rpm -qa | grep gnustep gnustep-make-2.6.1-1.i686 gnustep-base-1.23.0-1.i686 [root@fs sogo]# rpm -qa | grep memcached libmemcached-0.49-1.i686 memcached-1.4.4-3.el6.i686 ==.GNUstepDefaults== http://www.gnustep.org/plist-0_9.xml";> NSGlobalDomain sogod OCSFolderInfoURL mysql://sogo:aa@localhost:3306/sogo/sogo_folder_info OCSSessionsFolderURL mysql://sogo:aa@localhost:3306/sogo/sogo_sessions_folder SOGoACLsSendEMailNotifications YES SOGoAppointmentSendEMailNotifications YES SOGoDraftsFolderName Drafts SOGoFoldersSendEMailNotifications YES SOGoForwardEnabled YES SOGoIMAPServer localhost SOGoLanguage English SOGoMailDomain getnet.cz SOGoMailingMechanism smtp SOGoProfileURL mysql://sogo:aa@localhost:3306/sogo/sogo_user_profile SOGoSMTPServer localhost SOGoSentFolderName Sent SOGoSuperUsernames sogo SOGoTimeZone Europe/Prague SOGoTrashFolderName Trash SOGoUserSources CNFieldName cn IDFieldName uid UIDFieldName uid baseDN ou=People,dc=getnet,dc=cz bindDN uid=sogo,ou=People,dc=getnet,dc=cz bindPassword aa canAuthenticate YES displayName Shared Addresses hostname localhost id public isAddressBook YES port 389 SOGoVacationEnabled YES LDAP query - example user === [root@fs Defaults]# ldapsearch -x '(uid=pdobes)' # extended LDIF # # LDAPv3 # base (default) with scope subtree # filter: (uid=pdobes) # requesting: ALL # # pdobes, People, getnet.cz dn: uid=pdobes,ou=People,dc=getnet,dc=cz givenName: Pavel sn: Dobes loginShell: /bin/bash gidNumber: 501 uidNumber: 501 mail: pdo...@getnet.cz objectClass: top objectClass: person objectClass: organizationalPerson objectClass: inetorgperson objectClass: posixAccount objectClass: posixgroup uid: pdobes cn: pdobes homeDirectory: /home/pdobes # search result search: 2 result: 0 Success # numResponses: 2 # numEntries: 1 -- users@sogo.nu https://inverse.ca/sogo/lists